Last modified: 2012-08-04 20:48:53 UTC

Wikimedia Bugzilla is closed!

Wikimedia has migrated from Bugzilla to Phabricator. Bug reports should be created and updated in Wikimedia Phabricator instead. Please create an account in Phabricator and add your Bugzilla email address to it.
Wikimedia Bugzilla is read-only. If you try to edit or create any bug report in Bugzilla you will be shown an intentional error message.
In order to access the Phabricator task corresponding to a Bugzilla report, just remove "static-" from its URL.
You could still run searches in Bugzilla or access your list of votes but bug reports will obviously not be up-to-date in Bugzilla.
Bug 12322 - r28534 does not properly create PostgreSQL tables
r28534 does not properly create PostgreSQL tables
Product: MediaWiki
Classification: Unclassified
Database (Other open bugs)
All All
: Normal critical (vote)
: ---
Assigned To: Nobody - You can work on this!
Depends on:
Blocks: postgres
  Show dependency treegraph
Reported: 2007-12-16 09:39 UTC by OverlordQ
Modified: 2012-08-04 20:48 UTC (History)
1 user (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Description OverlordQ 2007-12-16 09:39:33 UTC

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

    * PHP 5.2.4-2 installed
    * Found database drivers for: MySQL PostgreSQL
    * 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/php5) appears to be valid.
    * PHP's memory_limit is 128M.
    * Couldn't find Turck MMCache, 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: /home/wiki
    * 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 "postgres" as superuser "ovrlrdq"...
    * Checking the version of Postgres...version 8.2 is OK.
    * User "wikiuser" already exists, skipping account creation.
    * Database "wikidb" already exists, skipping database creation.
    * Connecting to "wikidb" as superuser "ovrlrdq" to check rights...OK
    * Checking that tsearch2 is installed in the database "wikidb"...OK
    * Ensuring that user "wikiuser" has select rights on the tsearch2 tables...OK
    * Schema already exists, explicitly granting rights... OK
    * Attempting to connect to database "wikidb" as "wikiuser"...
    * Checking the version of Postgres...version 8.2 is OK.
    * Checking for tsearch2 in the schema "public"...OK
    * Checking tsearch2 permissions...OK
    * Verifying tsearch2 locale with C...OK
    * Checking for Pl/Pgsql ...OK
    * Schema "mediawiki" exists and is owned by "wikiuser". Excellent.
    * Setting the timezone to GMT for user "wikiuser" ...OK
    * Setting the datestyle to ISO, YMD for user "wikiuser" ...OK
    * Setting the search path for user "wikiuser" ...OK
    * Connected to PostgreSQL 8.2.5 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.2.3 20071123 (prerelease) (Debian 4.2.2-4)
    * Creating tables... (table interwiki successfully populated)... done.
    * Initializing statistics...
    * Checking the version of Postgres...version 8.2 is OK.
    * Created sysop account OverlordQ.

      Creating LocalSettings.php...

Trying to view any page that needs to lookup anything in the protected_titles table:

Warning: pg_query() []: Query failed: ERROR: relation "protected_titles" does not exist in /home/wiki/includes/DatabasePostgres.php on line 531



#0 /home/wiki/includes/Database.php(795): DatabasePostgres->reportQueryError('ERROR: relatio...', 1, 'SELECT * FROM...', 'Database::selec...', false)
#1 /home/wiki/includes/Database.php(1240): Database->query('SELECT * FROM...', 'Database::selec...')
#2 /home/wiki/includes/Title.php(1262): Database->select('protected_title...', '*', Array)
#3 /home/wiki/includes/Title.php(1710): Title->getTitleProtection()
#4 /home/wiki/includes/Title.php(1753): Title->loadRestrictions()
#5 /home/wiki/includes/Title.php(1181): Title->getRestrictions('edit')
#6 /home/wiki/includes/Title.php(1024): Title->getUserPermissionsErrorsInternal('edit', Object(User), false)
#7 /home/wiki/includes/Title.php(996): Title->userCan('edit', false)
#8 /home/wiki/includes/ParserCache.php(33): Title->quickUserCan('edit')
#9 /home/wiki/includes/ParserCache.php(46): ParserCache->getKey(Object(Article), Object(User))
#10 /home/wiki/includes/Article.php(690): ParserCache->getETag(Object(Article), Object(User))
#11 /home/wiki/includes/Wiki.php(380): Article->view()
#12 /home/wiki/includes/Wiki.php(48): MediaWiki->performAction(Object(OutputPage), Object(Article), Object(Title), Object(User), Object(WebRequest))
#13 /home/wiki/index.php(89): MediaWiki->initialize(Object(Title), Object(OutputPage), Object(User), Object(WebRequest))
#14 {main}
Comment 1 Greg Sabino Mullane 2007-12-16 15:33:42 UTC
Table was added in r28541, thanks for the report.

Note You need to log in before you can comment on or make changes to this bug.