Last modified: 2010-05-15 15:33:13 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 1391 - PostgreSQL Logging table has old column definitions
PostgreSQL Logging table has old column definitions
Status: RESOLVED DUPLICATE of bug 1295
Product: MediaWiki
Classification: Unclassified
Database (Other open bugs)
PC Linux
: Normal major (vote)
: ---
Assigned To: Nobody - You can work on this!
Depends on:
Blocks: postgres
  Show dependency treegraph
Reported: 2005-01-23 19:33 UTC by Matt Adam
Modified: 2010-05-15 15:33 UTC (History)
0 users

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


Description Matt Adam 2005-01-23 19:33:16 UTC
(Using 1.4b5):

When I try to upload a file, I get the following error.  The pg table definition
is probably outdated:

Warning: pg_query(): Query failed: ERROR: column "log_params" of relation
"logging" does not exist . in /home/www/zenko/includes/DatabasePostgreSQL.php on
line 99
A database error has occurred Query: INSERT INTO "logging"
VALUES ('upload','upload','2005-01-23
19:43:43','4','6','Bubblebobble.png','BubBob','') Function: LogPage::saveContent
Error: 1 ERROR: column "log_params" of relation "logging" does not exist


    * DatabasePostgreSQL.php line 419 calls wfdebugdiebacktrace()
    * Database.php line 297 calls databasepostgresql::reportqueryerror()
    * Database.php line 873 calls databasepostgresql::query()
    * DatabasePostgreSQL.php line 223 calls database::insert()
    * LogPage.php line 64 calls databasepostgresql::insert()
    * LogPage.php line 189 calls logpage::savecontent()
    * Image.php line 790 calls logpage::addentry()
    * SpecialUpload.php line 270 calls wfrecordupload()
    * SpecialUpload.php line 112 calls uploadform::processupload()
    * SpecialUpload.php line 19 calls uploadform::execute()
    * SpecialPage.php line 309 calls wfspecialupload()
    * SpecialPage.php line 220 calls specialpage::execute()
    * index.php line 94 calls specialpage::executepath()
Comment 1 Matt Adam 2005-01-23 19:43:16 UTC
The fix for this is pretty simple, add this line to the logging table definition:

    log_params text DEFAULT ''::text NOT NULL

(sorry, I don't have a CVS tree checked out so I can't give you a patch)
Comment 2 Greg Sabino Mullane 2006-04-12 00:37:38 UTC

*** This bug has been marked as a duplicate of 1295 ***

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