Last modified: 2011-04-04 21:28:22 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 T16138, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 14138 - page deletion throws database error on postgresql
page deletion throws database error on postgresql
Status: RESOLVED FIXED
Product: MediaWiki
Classification: Unclassified
Database (Other open bugs)
1.13.x
Other Solaris
: Normal major (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  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: ---


Attachments

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.


Navigation
Links