Author: brad.lhotsky
Description:
Installing database to a Postgresql 9.0 Server, remotely.
MediaWiki running on CentOS 6, PHP 5.3.2
During the install the DB Schema defaulted to 'mediawiki'. The install completed successfully, but upon viewing the site, there was an exception. Enabling exceptions, I saw that all the SQL statements that were tried were failing. None of the queries specified the schema.
IE:
SELECT * FROM table where column='value';
There should be an option in the PG DB connection to set the default schema, but that may not be working on CentOS 6's php-pgsql.
Without the proper setting of default schema, all table, view, and procedure names would need to specify their schema expressly, as in:
SELECT * FROM mediawiki.table where column='value';
Going to test against SVN HEAD tomorrow.
Version: 1.17.x
Severity: major