Last modified: 2010-05-15 15:33:13 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 T3391, the corresponding Phabricator task for complete and up-to-date bug report information.
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)
1.4.x
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: ---


Attachments

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"
(log_type,log_action,log_timestamp,log_user,log_namespace,log_title,log_comment,log_params)
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

Backtrace:

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


Navigation
Links