https://bugzilla.wikimedia.org/show_bug.cgi?id=30787
Web browser: --- Bug #: 30787 Summary: PostgreSQL 9.0 default 'mediawiki' schema causes failure, use 'public' instead. Product: MediaWiki Version: 1.17.0 Platform: All OS/Version: All Status: NEW Severity: major Priority: Unprioritized Component: Database AssignedTo: wikibugs-l@lists.wikimedia.org ReportedBy: brad.lhot...@gmail.com Classification: Unclassified 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. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l