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

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T14322, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 12322 - r28534 does not properly create PostgreSQL tables
r28534 does not properly create PostgreSQL tables
Status: RESOLVED FIXED
Product: MediaWiki
Classification: Unclassified
Database (Other open bugs)
1.12.x
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: ---


Attachments

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

===
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() [function.pg-query]: Query failed: ERROR: relation "protected_titles" does not exist in /home/wiki/includes/DatabasePostgres.php on line 531
====

Backtrace:

===
Backtrace:

#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.


Navigation
Links