Hello,
I updated one of my wikis today from f2138b1 to 9299bab032a85c1a421436da04a595b79f2b9d6c (git master as I write this) and after running update.php I get this:
A database error has occurred. Did you forget to run maintenance/update.php after upgrading? See: https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script Query: SELECT page_id,page_len,page_is_redirect,page_latest,page_content_model FROM "page" WHERE page_namespace = '0' AND page_title = 'Test11' LIMIT 1 Function: LinkCache::addLinkObj Error: 42703 ERROR: column "page_content_model" does not exist LINE 1: ...*/ page_id,page_len,page_is_redirect,page_latest,page_conte... ^
Backtrace:
#0 /usr/home/saper/public_html/pg/w/includes/db/DatabasePostgres.php(477): DatabaseBase->reportQueryError('ERROR: column ...', '42703', 'SELECT page_id...', 'LinkCache::addL...', false) #1 /usr/home/saper/public_html/pg/w/includes/db/Database.php(942): DatabasePostgres->reportQueryError('ERROR: column ...', '42703', 'SELECT page_id...', 'LinkCache::addL...', false) #2 /usr/home/saper/public_html/pg/w/includes/db/Database.php(1367): DatabaseBase->query('SELECT page_id...', 'LinkCache::addL...') #3 /usr/home/saper/public_html/pg/w/includes/db/Database.php(1458): DatabaseBase->select('page', Array, Array, 'LinkCache::addL...', Array, Array) #4 /usr/home/saper/public_html/pg/w/includes/cache/LinkCache.php(222): DatabaseBase->selectRow('page', Array, Array, 'LinkCache::addL...', Array) #5 /usr/home/saper/public_html/pg/w/includes/Title.php(2895): LinkCache->addLinkObj(Object(Title)) #6 /usr/home/saper/public_html/pg/w/includes/Title.php(4320): Title->getArticleID() #7 /usr/home/saper/public_html/pg/w/includes/WikiPage.php(416): Title->exists() #8 /usr/home/saper/public_html/pg/w/includes/WikiPage.php(465): WikiPage->exists() #9 /usr/home/saper/public_html/pg/w/includes/WikiPage.php(204): WikiPage->getContentModel() #10 /usr/home/saper/public_html/pg/w/includes/WikiPage.php(190): WikiPage->getContentHandler() #11 /usr/home/saper/public_html/pg/w/includes/Action.php(92): WikiPage->getActionOverrides() #12 /usr/home/saper/public_html/pg/w/includes/Action.php(139): Action::factory('view', Object(WikiPage)) #13 /usr/home/saper/public_html/pg/w/includes/Wiki.php(144): Action::getActionName(Object(RequestContext)) #14 /usr/home/saper/public_html/pg/w/includes/Wiki.php(528): MediaWiki->getAction() #15 /usr/home/saper/public_html/pg/w/includes/Wiki.php(447): MediaWiki->main() #16 /usr/home/saper/public_html/pg/w/index.php(59): MediaWiki->run() #17 {main}
Look like LinkCache.
Can this be quickly fixed or do we need to revert this?
//Saper
On 10/10/12 09:02, Marcin Cieslak wrote:
Hello,
I updated one of my wikis today from f2138b1 to 9299bab032a85c1a421436da04a595b79f2b9d6c (git master as I write this) and after running update.php I get this:
A database error has occurred. Did you forget to run maintenance/update.php after upgrading? See: https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script Query: SELECT page_id,page_len,page_is_redirect,page_latest,page_content_model FROM "page" WHERE page_namespace = '0' AND page_title = 'Test11' LIMIT 1 Function: LinkCache::addLinkObj Error: 42703 ERROR: column "page_content_model" does not exist LINE 1: ...*/ page_id,page_len,page_is_redirect,page_latest,page_conte... ^
(...)
Look like LinkCache.
Can this be quickly fixed or do we need to revert this?
//Saper
Seems the files of maintenance/archives/patch-*content* could need to be copied to maintenance/postgres/archives
It works for me on mysql, but it is inconsistent in that the db is still used a varbinary but the description uses an integer.
Platonides Platonides@gmail.com wrote:
On 10/10/12 09:02, Marcin Cieslak wrote:
Hello,
I updated one of my wikis today from f2138b1 to 9299bab032a85c1a421436da04a595b79f2b9d6c (git master as I write this) and after running update.php I get this:
A database error has occurred. Did you forget to run maintenance/update.php after upgrading? See: https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script Query: SELECT page_id,page_len,page_is_redirect,page_latest,page_content_model FROM "page" WHERE page_namespace = '0' AND page_title = 'Test11' LIMIT 1 Function: LinkCache::addLinkObj Error: 42703 ERROR: column "page_content_model" does not exist LINE 1: ...*/ page_id,page_len,page_is_redirect,page_latest,page_conte... ^
(...)
Look like LinkCache.
Can this be quickly fixed or do we need to revert this?
//Saper
Seems the files of maintenance/archives/patch-*content* could need to be copied to maintenance/postgres/archives
It works for me on mysql, but it is inconsistent in that the db is still used a varbinary but the description uses an integer.
Yes, the updater needs to be fixed (it is normally enough to update "includes/installer/DatabaseUpdater.php" for smaller changes).
I remember mentioning it in code review somewhere, finding the "right" data type was an issue to be addressed by developers...
//Saper
On 10.10.2012 11:03, Marcin Cieslak wrote:
Seems the files of maintenance/archives/patch-*content* could need to be copied to maintenance/postgres/archives
It works for me on mysql, but it is inconsistent in that the db is still used a varbinary but the description uses an integer.
Yes, the updater needs to be fixed (it is normally enough to update "includes/installer/DatabaseUpdater.php" for smaller changes).
I remember mentioning it in code review somewhere, finding the "right" data type was an issue to be addressed by developers...
I'll try to look into this today, but I need to find help from someone knowledgable about postrtges (and especially about the postgres updater. it's... different).
-- daniel
Daniel Kinzler daniel@brightbyte.de wrote:
I'll try to look into this today, but I need to find help from someone knowledgable about postrtges (and especially about the postgres updater. it's... different).
Sure, feel free to ask, I will be travelling starting tomorrow but today we can try to fix it. To add simple fields you don't usually need to create a patch file, a simple array ('addPgField', ... ) should do.
Thanks!
//Saper
Marcin Cieslak saper@saper.info wrote:
Daniel Kinzler daniel@brightbyte.de wrote:
I'll try to look into this today, but I need to find help from someone knowledgable about postrtges (and especially about the postgres updater. it's... different).
Thank you everyone - the working fix is now in Gerrit https://gerrit.wikimedia.org/r/#/c/27413/
//Saper
wikitech-l@lists.wikimedia.org