Last modified: 2011-04-04 21:28:22 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 14138 - page deletion throws database error on postgresql
page deletion throws database error on postgresql
Product: MediaWiki
Classification: Unclassified
Database (Other open bugs)
Other Solaris
: Normal major (vote)
: ---
Assigned To: Nobody - You can work on this!
Depends on:
  Show dependency treegraph
Reported: 2008-05-15 14:08 UTC by River Tarnell
Modified: 2011-04-04 21:28 UTC (History)
2 users (show)

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


Description River Tarnell 2008-05-15 14:08:08 UTC
running r34858 on postgres 8.2.6, deleting a page gives this error:

MediaWiki internal error.

Original exception: exception 'DBUnexpectedError' with message 'A database error has occurred
Query: INSERT INTO archive (ar_namespace,ar_title,ar_comment,ar_user,ar_user_text,ar_timestamp,ar_minor_edit,ar_rev_id,ar_text_id,ar_text,ar_flags,ar_len,ar_page_id,ar_deleted) SELECT page_namespace,page_title,rev_comment,rev_user,rev_user_text,rev_timestamp,rev_minor_edit,rev_id,rev_text_id,'','',rev_len,page_id,rev_deleted FROM page,revision WHERE page_id = '405' AND (page_id = rev_page) 
Function: Article::doDeleteArticle
Error: 1 ERROR: column "ar_deleted" is of type smallint but expression is of type character
LINE 1: ..._id,ar_text_id,ar_text,ar_flags,ar_len,ar_page_id,ar_deleted...
HINT: You will need to rewrite or cast the expression.
' in /int/home/mediawiki/wiki/includes/DatabasePostgres.php:978
Stack trace:
#0 /int/home/mediawiki/wiki/includes/Database.php(541): DatabasePostgres->reportQueryError('ERROR: column ...', 1, 'INSERT INTO ar...', 'Article::doDele...', false)
#1 /int/home/mediawiki/wiki/includes/Database.php(1707): Database->query('INSERT INTO ar...', 'Article::doDele...')
#2 /int/home/mediawiki/wiki/includes/Article.php(2325): Database->insertSelect('archive', Array, Array, Array, 'Article::doDele...')
#3 /int/home/mediawiki/wiki/includes/Article.php(2242): Article->doDeleteArticle('content was: 'k...', false)
#4 /int/home/mediawiki/wiki/includes/Article.php(2052): Article->doDelete('content was: 'k...', false)
#5 /int/home/mediawiki/wiki/includes/Wiki.php(449): Article->delete()
#6 /int/home/mediawiki/wiki/includes/Wiki.php(59): MediaWiki->performAction(Object(OutputPage), Object(Article), Object(Title), Object(User), Object(WebRequest))
#7 /int/home/mediawiki/wiki/index.php(92): MediaWiki->initialize(Object(Title), Object(Article), Object(OutputPage), Object(User), Object(WebRequest))
#8 /int/docroots/mediawiki/w/index.php(3): include_once('/int/home/media...')
#9 {main}
Comment 1 Aaron Schulz 2008-05-15 14:40:58 UTC
I remember setting those chars to integers, not sure if greg made an updater script for that.
Comment 2 Greg Sabino Mullane 2008-05-15 21:32:38 UTC
Please try out r34893 and see if that does the trick once you run update.php
Comment 3 River Tarnell 2008-05-15 21:36:20 UTC
yes, this fixes the problem.  thanks!

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