Thread:Project:Support desk/Installation error: Setting the search path for use

The system is Fedora 14, the error is reproducible with database users, postgres and postgresuser. There are not errors reported in either /var/log/messages or /secure.

The error is: Setting the search path for user "postgresuser" ... Warning: pg_query: Query failed: ERROR: zero-length delimited identifier at or near """" LINE 1: ...USER "postgresuser" SET search_path = "postgres", "", public ^ in /usr/share/mediawiki/includes/db/DatabasePostgres.php on line 518 FAILED.

The full install output is:

MediaWiki 1.16.5 Installation

* Don't forget security updates! Keep an eye on the low-traffic release announcements mailing list.

Checking environment...

Please include all of the lines below when reporting installation problems.

* PHP 5.3.6 installed * Found database drivers for: MySQL PostgreSQL SQLite * PHP server API is apache2handler; ok, using pretty URLs (index.php/Page_Title) * Have XML / Latin1-UTF-8 conversion support. * Session save path (/var/lib/php/session) appears to be valid. * PHP's memory_limit is 128M bytes. * Couldn't find eAccelerator, APC or XCache; cannot use these for object caching. * Found GNU diff3: /usr/bin/diff3. * Found ImageMagick: /usr/bin/convert; image thumbnailing will be enabled if you enable uploads. * Found GD graphics library built-in. * Installation directory: /usr/share/mediawiki * Script URI path: /wiki * Installing MediaWiki with php file extensions * Environment checked. You can install MediaWiki. *

Generating configuration file... * Database type: PostgreSQL * Loading class: DatabasePostgres * Attempting to connect to database "wikidb" as "postgresuser"...   * Checking the version of Postgres...version 8.4.8 is OK. * Checking for Pl/Pgsql ...not installed. Attempting to install Pl/Pgsql ...OK   * Creating schema postgres ...OK    * Setting the timezone to GMT for user "postgresuser" ...OK    * Setting the datestyle to ISO, YMD for user "postgresuser" ...OK    * Setting the search path for user "postgresuser" ... Warning: pg_query: Query failed: ERROR: zero-length delimited identifier at or near """" LINE 1: ...USER "postgresuser" SET search_path = "postgres", "", public ^ in /usr/share/mediawiki/includes/db/DatabasePostgres.php on line 518 FAILED.

Below are the postgres db: wikidb-> \l List of databases Name   |    Owner     | Encoding |  Collation  |    Ctype    |   Access privileges ---+--+--+-+-+--- postgres | postgres     | UTF8     | en_US.UTF-8 | en_US.UTF-8 | template0 | postgres    | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres : postgres=CTc/postgres template1 | postgres    | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres : postgres=CTc/postgres wikidb   | postgresuser | UTF8     | en_US.UTF-8 | en_US.UTF-8 | (4 rows)

Below are the schemas: wikidb-> \dn List of schemas Name       |    Owner +-- information_schema | postgres pg_catalog        | postgres pg_toast          | postgres pg_toast_temp_1   | postgres postgres          | postgresuser public            | postgres (6 rows)