Author: s_angelov
Description:
update.php output (1.11.0 to 1.13.0)
after upgrade from 1.11.0 to 1.13.0 i get the following error when trying to open any of the content pages:
A database error has occurred Query: SELECT rev_id,rev_page,rev_text_id,rev_timestamp,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,page_namespace,page_title,page_latest FROM page,revision WHERE (page_id=rev_page) AND rev_id = '581' LIMIT 1 Function: Revision::fetchRow Error: 1 ERROR: column "rev_parent_id" does not exist
Backtrace:
#0 /my-dir-tree/wiki/includes/db/Database.php(561): DatabasePostgres->reportQueryError('ERROR: column ...', 1, 'SELECT rev_id,...', 'Revision::fetch...', false)
#1 /my-dir-tree/wiki/includes/db/Database.php(969): Database->query('SELECT rev_id,...', 'Revision::fetch...')
#2 /my-dir-tree/wiki/includes/Revision.php(236): Database->select(Array, Array, Array, 'Revision::fetch...', Array)
#3 /my-dir-tree/wiki/includes/Revision.php(165): Revision::fetchFromConds(Object(DatabasePostgres), Array)
#4 /my-dir-tree/wiki/includes/Revision.php(146): Revision::loadFromConds(Object(DatabasePostgres), Array)
#5 /my-dir-tree/wiki/includes/Revision.php(27): Revision::newFromConds(Array)
#6 /my-dir-tree/wiki/includes/Article.php(430): Revision::newFromId('581')
#7 /my-dir-tree/wiki/includes/Article.php(300): Article->fetchContent(0)
#8 /my-dir-tree/wiki/includes/Article.php(218): Article->loadContent()
#9 /my-dir-tree/wiki/includes/Article.php(803): Article->getContent()
#10 /my-dir-tree/wiki/includes/Wiki.php(437): Article->view()
#11 /my-dir-tree/wiki/includes/Wiki.php(59): MediaWiki->performAction(Object(OutputPage), Object(Article), Object(Title), Object(User), Object(WebRequest))
#12 /my-dir-tree/wiki/index.php(93): MediaWiki->initialize(Object(Title), Object(Article), Object(OutputPage), Object(User), Object(WebRequest))
#13 {main}
the database postmaster.log also shows the error:
ERROR: column "rev_parent_id" does not exist
postgresql is version 8.1.11. update.php completed with no errors - i am attaching the output for reference.
i have reverted back to 1.11.0 and restored the database from backup.
Version: 1.13.x
Severity: major
OS: Solaris
Platform: Other
Attached: