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: [email protected]
ReportedBy: [email protected]
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
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
