Hello,
I've just installed a media wiki on one of my servers and imported my old media wiki database (I don't recall the version the original media wiki was running under).
I notice that whenever I go to save an entry in my media wiki I get this error:
Database error A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:
(SQL query hidden)
from within function "LinksUpdate::getExistingCategories". Database returned error "1054: Unknown column 'cl_sortkey_prefix' in 'field list' (localhost)".
It's deceptive because the entry actually does get saved and otherwise works. However this is an annoying error I'd like to get rid of.
Here is what's going on in the MySQL logs when this happens:
14 Query INSERT /* RecentChange::save 66.192.34.62 */ INTO `recentchanges` (rc_timestamp,rc_cur_time,rc_namespace,rc_title,rc_type,rc_minor,rc_cur_id,rc_user,rc_user_text,rc_comment,rc_this_oldid,rc_last_oldid,rc_bot,rc_moved_to_ns,rc_moved_to_title,rc_ip,rc_patrolled,rc_new,rc_old_len,rc_new_len,rc_deleted,rc_logid,rc_log_type,rc_log_action,rc_params,rc_id) VALUES ('20120121182026','20120121182026','0','ZVIDEO','0','0','95','0','66.192.34.62','','14721','14720','0','0','','66.192.34.62','0','0','587','640','0','0',NULL,'','',NULL) 14 Query SELECT /* EmailNotification::notifyOnPageChange 66.192.34.62 */ wl_user FROM `watchlist` WHERE wl_title = 'ZVIDEO' AND wl_namespace = '0' AND (wl_user != 0) AND (wl_notificationtimestamp IS NULL) 14 Query COMMIT 15 Query BEGIN 15 Query REPLACE /* SqlBagOStuff::set 66.192.34.62 */ INTO `objectcache` (keyname,value,exptime) VALUES ('jfwiki:pcache:idhash:95-0!*!*!*!*!*!*','?Umo?6?g?4?\0Y/v?d?@?M?$6#Z?%?-.?(?Tl'?~?T?I? ??s??$?О2?PN*]V??A?????g???P??w??Ϥ??U*???x?"?Fn9&??t????????R\n??%?髍?5*%?-\??ד??\_}?W??????X$(]÷???6D????" ??a?r?b kQ?Ĉ?JdL?|?s(??ӎO*?t"?8kp?8ﵥKQ??3?W??V????x??ևLͦ=?6:????2?.???`w??wr?x???DJ?.???o??ѵ???3????N???=,?&?3?b?0??-t?vob??L?|ڵy??ٰ)?i??t??[??t??lk???8??)??{-5??%\b??l?W?x???Q???v!?"??҆8cJ}?Mt?`h?ϐJ??S???u;t?<??Y???=<??w??F?Q?̴?1?M?\Z?w??p9?B?s?ɁRP?SzK?R4??)~???gM???JV$W?U???#?แw|???5*k?y?1????M???;]?X(??P?\r?5Ek?3?-?i]?ah???1??Ò??q\r͗?e-y?2????????????HE?<?<?x?٪O?'?XTl???W?^??L?O? ŷ?c???u??At??oϩy???%U??IWWt??I9$?<'??ڃV8?????K?i?_?}sb???uՐ??А?C? 2???B?u?u\r?az?f??????J|cY?r??#=C??k?;?G$?I??\n}#??%/u?o1??ݶ?????N????r&D7?c?aW?D?e1??&\7?Lܣ?#Je???%??/??MN?f??g(?P???z? ??"????^)~??\c2)_xhLݢTuE????v[?3F??ځ؝?Z\Z?z4?????HM???B3^?I?\??w?;k?￨??','20120122182026') 15 Query COMMIT 15 Query BEGIN 15 Query REPLACE /* SqlBagOStuff::set 66.192.34.62 */ INTO `objectcache` (keyname,value,exptime) VALUES ('jfwiki:pcache:idoptions:95','E?A\n?0E?2(?c?,ťd??c??ӅRzw?????@p??3]?O@;Z?AK???Ka?\Zۘ???W4?zJ9?????z????<????}uC?#g ??܂?në?.?s?/?#!-??','20120122182026') 15 Query COMMIT 14 Query BEGIN 14 Query SELECT /* LinksUpdate::getExistingLinks 66.192.34.62 */ pl_namespace,pl_title FROM `pagelinks` WHERE pl_from = '95' FOR UPDATE 14 Query SELECT /* LinksUpdate::getExistingImages 66.192.34.62 */ il_to FROM `imagelinks` WHERE il_from = '95' FOR UPDATE 14 Query SELECT /* LinksUpdate::getExistingExternals 66.192.34.62 */ el_to FROM `externallinks` WHERE el_from = '95' FOR UPDATE 14 Query INSERT /* LinksUpdate::incrTableUpdate 66.192.34.62 */ IGNORE INTO `externallinks` (el_from,el_to,el_index) VALUES ('95','http://webdirector.mm.mlbam.com:8080/%27,%27http://com.mlbam.mm.webdirector....') 14 Query SELECT /* LinksUpdate::getExistingInterlangs 66.192.34.62 */ ll_lang,ll_title FROM `langlinks` WHERE ll_from = '95' FOR UPDATE 14 Query SELECT /* LinksUpdate::getExistingInterwikis 66.192.34.62 */ iwl_prefix,iwl_title FROM `iwlinks` WHERE iwl_from = '95' FOR UPDATE 14 Query SELECT /* LinksUpdate::getExistingTemplates 66.192.34.62 */ tl_namespace,tl_title FROM `templatelinks` WHERE tl_from = '95' FOR UPDATE 14 Query SELECT /* LinksUpdate::getExistingCategories 66.192.34.62 */ cl_to,cl_sortkey_prefix FROM `categorylinks` WHERE cl_from = '95' FOR UPDATE 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:databaseerror' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:sqlhidden' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:dberrortext' LIMIT 1 14 Query SELECT /* LinkBatch::doQuery (for Skin::preloadExistence) 66.192.34.62 */ page_id,page_namespace,page_title,page_len,page_is_redirect,page_latest FROM `page` WHERE (page_namespace = '2' AND page_title = '66.192.34.62') OR (page_namespace = '3' AND page_title = '66.192.34.62') OR (page_namespace = '1' AND page_title = 'ZVIDEO') 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'rtl' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'capitalizeAllNouns' LIMIT 1 14 Query SELECT /* User::checkNewtalk 66.192.34.62 */ user_ip FROM `user_newtalk` WHERE user_ip = '66.192.34.62' LIMIT 1 14 Query SELECT /* ResourceLoaderWikiModule::getTitleMtimes 66.192.34.62 */ page_namespace,page_title,page_touched FROM `page` WHERE (page_namespace = '8' AND page_title IN ('Common.js','Common.css','Vector.js','Vector.css','Print.css') ) 15 Query SELECT /* SqlBagOStuff::get 66.192.34.62 */ value,exptime FROM `objectcache` WHERE keyname = 'jfwiki:resourceloader:filter:minify-js:4:19a4b18a9ac79a6b8c60b24af4668814' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:anontalk' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:nstab-talk' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:vector-view-view' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:vector-view-edit' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:vector-view-history' LIMIT 1 14 Query SELECT /* ResourceLoaderWikiModule::getTitleMtimes 66.192.34.62 */ page_namespace,page_title,page_touched FROM `page` WHERE (page_namespace = '8' AND page_title IN ('Common.js','Common.css','Vector.js','Vector.css','Print.css') ) 14 Query SELECT /* ResourceLoaderWikiModule::getTitleMtimes 66.192.34.62 */ page_namespace,page_title,page_touched FROM `page` WHERE (page_namespace = '8' AND page_title = 'Noscript.css') 15 Query SELECT /* SqlBagOStuff::get 66.192.34.62 */ value,exptime FROM `objectcache` WHERE keyname = 'jfwiki:resourceloader:filter:minify-css:4:c88e2bcd56513749bec09a7e29cb3ffa' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:tooltip-ca-view' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:accesskey-ca-view' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:tooltip-pt-anonuserpage' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:accesskey-pt-anonuserpage' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:tooltip-pt-anontalk' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:accesskey-pt-anontalk' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:tooltip-pt-anonlogin' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:accesskey-pt-anonlogin' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:namespaces' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:variants' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:actions' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:tooltip-p-tb' LIMIT 1 14 Quit 15 Quit
Does anybody out there have any advice on how I can get rid of this error message?
thanks! tim
Just run mediawiki/maintenance/update.php on the server. On Jan 21, 2012 10:33 AM, "Tim Dunphy" bluethundr@jokefire.com wrote:
Hello,
I've just installed a media wiki on one of my servers and imported my old media wiki database (I don't recall the version the original media wiki was running under).
I notice that whenever I go to save an entry in my media wiki I get this error:
Database error A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:
(SQL query hidden)
from within function "LinksUpdate::getExistingCategories". Database returned error "1054: Unknown column 'cl_sortkey_prefix' in 'field list' (localhost)".
It's deceptive because the entry actually does get saved and otherwise works. However this is an annoying error I'd like to get rid of.
Here is what's going on in the MySQL logs when this happens:
14 Query INSERT /* RecentChange::save 66.192.34.62 */ INTO `recentchanges` (rc_timestamp,rc_cur_time,rc_namespace,rc_title,rc_type,rc_minor,rc_cur_id,rc_user,rc_user_text,rc_comment,rc_this_oldid,rc_last_oldid,rc_bot,rc_moved_to_ns,rc_moved_to_title,rc_ip,rc_patrolled,rc_new,rc_old_len,rc_new_len,rc_deleted,rc_logid,rc_log_type,rc_log_action,rc_params,rc_id) VALUES ('20120121182026','20120121182026','0','ZVIDEO','0','0','95','0','66.192.34.62','','14721','14720','0','0','','66.192.34.62','0','0','587','640','0','0',NULL,'','',NULL) 14 Query SELECT /* EmailNotification::notifyOnPageChange 66.192.34.62 */ wl_user FROM `watchlist` WHERE wl_title = 'ZVIDEO' AND wl_namespace = '0' AND (wl_user != 0) AND (wl_notificationtimestamp IS NULL) 14 Query COMMIT 15 Query BEGIN 15 Query REPLACE /* SqlBagOStuff::set 66.192.34.62 */ INTO `objectcache` (keyname,value,exptime) VALUES ('jfwiki:pcache:idhash:95-0!*!*!*!*!*!*','?Umo?6?g?4?\0Y/v?d?@?M?$6#Z?%?-.?(?Tl'?~?T?I? ??s??$?О2?PN*]V??A?????g???P??w??Ϥ??U*???x?"?Fn9&??t????????R\n??%?髍?5*%?-\??ד??\_}?W??????X$(]÷???6D????" ??a?r?b kQ?Ĉ?JdL?|?s(??ӎO*?t"?8kp?8ﵥKQ??3?W??V????x??ևLͦ=?6:????2?.???`w??wr?x???DJ?.???o??ѵ???3????N???=,?&?3?b?0??-t?vob??L?|ڵy??ٰ)?i??t??[??t??lk???8??)??{-5??%\b??l?W?x???Q???v!?"??҆8cJ}?Mt?`h?ϐJ??S???u;t?<??Y???=<??w??F?Q?̴?1?M?\Z?w??p9?B?s?ɁRP?SzK?R4??)~???gM???JV$W?U???#?แw|???5*k?y?1????M???;]?X(??P?\r?5Ek?3?-?i]?ah???1??Ò??q\r͗?e-y?2????????????HE?<?<?x?٪O?'?XTl???W?^??L?O? ŷ?c???u??At??oϩy???%U??IWWt??I9$?<'??ڃV8?????K?i?_?}sb???uՐ??А?C? 2???B?u?u\r?az?f??????J|cY?r??#=C??k?;?G$?I??\n}#??%/u?o1??ݶ?????N????r&D7?c?aW?D?e1??&\7?Lܣ?#Je???%??/??MN?f??g(?P???z?
??"????^)~??\c2)_xhLݢTuE????v[?3F??ځ؝?Z\Z?z4?????HM???B3^?I?\??w?;k?￨??','20120122182026') 15 Query COMMIT 15 Query BEGIN 15 Query REPLACE /* SqlBagOStuff::set 66.192.34.62 */ INTO `objectcache` (keyname,value,exptime) VALUES ('jfwiki:pcache:idoptions:95','E?A\n?0E?2(?c?,ťd??c??ӅRzw?????@p??3]?O@;Z?AK???Ka?\Zۘ???W4?zJ9?????z????<????}uC?#g ??܂?në?.?s?/?#!-??','20120122182026') 15 Query COMMIT 14 Query BEGIN 14 Query SELECT /* LinksUpdate::getExistingLinks 66.192.34.62 */ pl_namespace,pl_title FROM `pagelinks` WHERE pl_from = '95' FOR UPDATE 14 Query SELECT /* LinksUpdate::getExistingImages 66.192.34.62 */ il_to FROM `imagelinks` WHERE il_from = '95' FOR UPDATE 14 Query SELECT /* LinksUpdate::getExistingExternals 66.192.34.62 */ el_to FROM `externallinks` WHERE el_from = '95' FOR UPDATE 14 Query INSERT /* LinksUpdate::incrTableUpdate 66.192.34.62 */ IGNORE INTO `externallinks` (el_from,el_to,el_index) VALUES ('95','http://webdirector.mm.mlbam.com:8080/',' http://com.mlbam.mm.webdirector.:8080/') 14 Query SELECT /* LinksUpdate::getExistingInterlangs 66.192.34.62 */ ll_lang,ll_title FROM `langlinks` WHERE ll_from = '95' FOR UPDATE 14 Query SELECT /* LinksUpdate::getExistingInterwikis 66.192.34.62 */ iwl_prefix,iwl_title FROM `iwlinks` WHERE iwl_from = '95' FOR UPDATE 14 Query SELECT /* LinksUpdate::getExistingTemplates 66.192.34.62 */ tl_namespace,tl_title FROM `templatelinks` WHERE tl_from = '95' FOR UPDATE 14 Query SELECT /* LinksUpdate::getExistingCategories 66.192.34.62 */ cl_to,cl_sortkey_prefix FROM `categorylinks` WHERE cl_from = '95' FOR UPDATE 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:databaseerror' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:sqlhidden' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:dberrortext' LIMIT 1 14 Query SELECT /* LinkBatch::doQuery (for Skin::preloadExistence) 66.192.34.62 */ page_id,page_namespace,page_title,page_len,page_is_redirect,page_latest FROM `page` WHERE (page_namespace = '2' AND page_title = '66.192.34.62') OR (page_namespace = '3' AND page_title = '66.192.34.62') OR (page_namespace = '1' AND page_title = 'ZVIDEO') 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'rtl' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'capitalizeAllNouns' LIMIT 1 14 Query SELECT /* User::checkNewtalk 66.192.34.62 */ user_ip FROM `user_newtalk` WHERE user_ip = '66.192.34.62' LIMIT 1 14 Query SELECT /* ResourceLoaderWikiModule::getTitleMtimes 66.192.34.62 */ page_namespace,page_title,page_touched FROM `page` WHERE (page_namespace = '8' AND page_title IN ('Common.js','Common.css','Vector.js','Vector.css','Print.css') ) 15 Query SELECT /* SqlBagOStuff::get 66.192.34.62 */ value,exptime FROM `objectcache` WHERE keyname = 'jfwiki:resourceloader:filter:minify-js:4:19a4b18a9ac79a6b8c60b24af4668814' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:anontalk' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:nstab-talk' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:vector-view-view' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:vector-view-edit' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:vector-view-history' LIMIT 1 14 Query SELECT /* ResourceLoaderWikiModule::getTitleMtimes 66.192.34.62 */ page_namespace,page_title,page_touched FROM `page` WHERE (page_namespace = '8' AND page_title IN ('Common.js','Common.css','Vector.js','Vector.css','Print.css') ) 14 Query SELECT /* ResourceLoaderWikiModule::getTitleMtimes 66.192.34.62 */ page_namespace,page_title,page_touched FROM `page` WHERE (page_namespace = '8' AND page_title = 'Noscript.css') 15 Query SELECT /* SqlBagOStuff::get 66.192.34.62 */ value,exptime FROM `objectcache` WHERE keyname = 'jfwiki:resourceloader:filter:minify-css:4:c88e2bcd56513749bec09a7e29cb3ffa' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:tooltip-ca-view' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:accesskey-ca-view' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:tooltip-pt-anonuserpage' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:accesskey-pt-anonuserpage' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:tooltip-pt-anontalk' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:accesskey-pt-anontalk' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:tooltip-pt-anonlogin' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:accesskey-pt-anonlogin' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:namespaces' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:variants' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:actions' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:tooltip-p-tb' LIMIT 1 14 Quit 15 Quit
Does anybody out there have any advice on how I can get rid of this error message?
thanks! tim
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
That fixed it! Thanks!
----- Original Message ----- From: "Darren VanBuren" onekopaka@gmail.com To: "MediaWiki announcements and site admin list" mediawiki-l@lists.wikimedia.org Sent: Saturday, January 21, 2012 2:57:57 PM Subject: Re: [Mediawiki-l] database problem on mediawiki 1.18
Just run mediawiki/maintenance/update.php on the server. On Jan 21, 2012 10:33 AM, "Tim Dunphy" bluethundr@jokefire.com wrote:
Hello,
I've just installed a media wiki on one of my servers and imported my old media wiki database (I don't recall the version the original media wiki was running under).
I notice that whenever I go to save an entry in my media wiki I get this error:
Database error A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:
(SQL query hidden)
from within function "LinksUpdate::getExistingCategories". Database returned error "1054: Unknown column 'cl_sortkey_prefix' in 'field list' (localhost)".
It's deceptive because the entry actually does get saved and otherwise works. However this is an annoying error I'd like to get rid of.
Here is what's going on in the MySQL logs when this happens:
14 Query INSERT /* RecentChange::save 66.192.34.62 */ INTO `recentchanges` (rc_timestamp,rc_cur_time,rc_namespace,rc_title,rc_type,rc_minor,rc_cur_id,rc_user,rc_user_text,rc_comment,rc_this_oldid,rc_last_oldid,rc_bot,rc_moved_to_ns,rc_moved_to_title,rc_ip,rc_patrolled,rc_new,rc_old_len,rc_new_len,rc_deleted,rc_logid,rc_log_type,rc_log_action,rc_params,rc_id) VALUES ('20120121182026','20120121182026','0','ZVIDEO','0','0','95','0','66.192.34.62','','14721','14720','0','0','','66.192.34.62','0','0','587','640','0','0',NULL,'','',NULL) 14 Query SELECT /* EmailNotification::notifyOnPageChange 66.192.34.62 */ wl_user FROM `watchlist` WHERE wl_title = 'ZVIDEO' AND wl_namespace = '0' AND (wl_user != 0) AND (wl_notificationtimestamp IS NULL) 14 Query COMMIT 15 Query BEGIN 15 Query REPLACE /* SqlBagOStuff::set 66.192.34.62 */ INTO `objectcache` (keyname,value,exptime) VALUES ('jfwiki:pcache:idhash:95-0!*!*!*!*!*!*','?Umo?6?g?4?\0Y/v?d?@?M?$6#Z?%?-.?(?Tl'?~?T?I? ??s??$?О2?PN*]V??A?????g???P??w??Ϥ??U*???x?"?Fn9&??t????????R\n??%?髍?5*%?-\??ד??\_}?W??????X$(]÷???6D????" ??a?r?b kQ?Ĉ?JdL?|?s(??ӎO*?t"?8kp?8ﵥKQ??3?W??V????x??ևLͦ=?6:????2?.???`w??wr?x???DJ?.???o??ѵ???3????N???=,?&?3?b?0??-t?vob??L?|ڵy??ٰ)?i??t??[??t??lk???8??)??{-5??%\b??l?W?x???Q???v!?"??҆8cJ}?Mt?`h?ϐJ??S???u;t?<??Y???=<??w??F?Q?̴?1?M?\Z?w??p9?B?s?ɁRP?SzK?R4??)~???gM???JV$W?U???#?แw|???5*k?y?1????M???;]?X(??P?\r?5Ek?3?-?i]?ah???1??Ò??q\r͗?e-y?2????????????HE?<?<?x?٪O?'?XTl???W?^??L?O? ŷ?c???u??At??oϩy???%U??IWWt??I9$?<'??ڃV8?????K?i?_?}sb???uՐ??А?C? 2???B?u?u\r?az?f??????J|cY?r??#=C??k?;?G$?I??\n}#??%/u?o1??ݶ?????N????r&D7?c?aW?D?e1??&\7?Lܣ?#Je???%??/??MN?f??g(?P???z?
??"????^)~??\c2)_xhLݢTuE????v[?3F??ځ؝?Z\Z?z4?????HM???B3^?I?\??w?;k?￨??','20120122182026') 15 Query COMMIT 15 Query BEGIN 15 Query REPLACE /* SqlBagOStuff::set 66.192.34.62 */ INTO `objectcache` (keyname,value,exptime) VALUES ('jfwiki:pcache:idoptions:95','E?A\n?0E?2(?c?,ťd??c??ӅRzw?????@p??3]?O@;Z?AK???Ka?\Zۘ???W4?zJ9?????z????<????}uC?#g ??܂?në?.?s?/?#!-??','20120122182026') 15 Query COMMIT 14 Query BEGIN 14 Query SELECT /* LinksUpdate::getExistingLinks 66.192.34.62 */ pl_namespace,pl_title FROM `pagelinks` WHERE pl_from = '95' FOR UPDATE 14 Query SELECT /* LinksUpdate::getExistingImages 66.192.34.62 */ il_to FROM `imagelinks` WHERE il_from = '95' FOR UPDATE 14 Query SELECT /* LinksUpdate::getExistingExternals 66.192.34.62 */ el_to FROM `externallinks` WHERE el_from = '95' FOR UPDATE 14 Query INSERT /* LinksUpdate::incrTableUpdate 66.192.34.62 */ IGNORE INTO `externallinks` (el_from,el_to,el_index) VALUES ('95','http://webdirector.mm.mlbam.com:8080/',' http://com.mlbam.mm.webdirector.:8080/') 14 Query SELECT /* LinksUpdate::getExistingInterlangs 66.192.34.62 */ ll_lang,ll_title FROM `langlinks` WHERE ll_from = '95' FOR UPDATE 14 Query SELECT /* LinksUpdate::getExistingInterwikis 66.192.34.62 */ iwl_prefix,iwl_title FROM `iwlinks` WHERE iwl_from = '95' FOR UPDATE 14 Query SELECT /* LinksUpdate::getExistingTemplates 66.192.34.62 */ tl_namespace,tl_title FROM `templatelinks` WHERE tl_from = '95' FOR UPDATE 14 Query SELECT /* LinksUpdate::getExistingCategories 66.192.34.62 */ cl_to,cl_sortkey_prefix FROM `categorylinks` WHERE cl_from = '95' FOR UPDATE 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:databaseerror' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:sqlhidden' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:dberrortext' LIMIT 1 14 Query SELECT /* LinkBatch::doQuery (for Skin::preloadExistence) 66.192.34.62 */ page_id,page_namespace,page_title,page_len,page_is_redirect,page_latest FROM `page` WHERE (page_namespace = '2' AND page_title = '66.192.34.62') OR (page_namespace = '3' AND page_title = '66.192.34.62') OR (page_namespace = '1' AND page_title = 'ZVIDEO') 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'rtl' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'capitalizeAllNouns' LIMIT 1 14 Query SELECT /* User::checkNewtalk 66.192.34.62 */ user_ip FROM `user_newtalk` WHERE user_ip = '66.192.34.62' LIMIT 1 14 Query SELECT /* ResourceLoaderWikiModule::getTitleMtimes 66.192.34.62 */ page_namespace,page_title,page_touched FROM `page` WHERE (page_namespace = '8' AND page_title IN ('Common.js','Common.css','Vector.js','Vector.css','Print.css') ) 15 Query SELECT /* SqlBagOStuff::get 66.192.34.62 */ value,exptime FROM `objectcache` WHERE keyname = 'jfwiki:resourceloader:filter:minify-js:4:19a4b18a9ac79a6b8c60b24af4668814' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:anontalk' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:nstab-talk' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:vector-view-view' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:vector-view-edit' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:vector-view-history' LIMIT 1 14 Query SELECT /* ResourceLoaderWikiModule::getTitleMtimes 66.192.34.62 */ page_namespace,page_title,page_touched FROM `page` WHERE (page_namespace = '8' AND page_title IN ('Common.js','Common.css','Vector.js','Vector.css','Print.css') ) 14 Query SELECT /* ResourceLoaderWikiModule::getTitleMtimes 66.192.34.62 */ page_namespace,page_title,page_touched FROM `page` WHERE (page_namespace = '8' AND page_title = 'Noscript.css') 15 Query SELECT /* SqlBagOStuff::get 66.192.34.62 */ value,exptime FROM `objectcache` WHERE keyname = 'jfwiki:resourceloader:filter:minify-css:4:c88e2bcd56513749bec09a7e29cb3ffa' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:tooltip-ca-view' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:accesskey-ca-view' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:tooltip-pt-anonuserpage' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:accesskey-pt-anonuserpage' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:tooltip-pt-anontalk' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:accesskey-pt-anontalk' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:tooltip-pt-anonlogin' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:accesskey-pt-anonlogin' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:namespaces' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:variants' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:actions' LIMIT 1 14 Query SELECT /* LCStore_DB::get 66.192.34.62 */ lc_value FROM `l10n_cache` WHERE lc_lang = 'en' AND lc_key = 'messages:tooltip-p-tb' LIMIT 1 14 Quit 15 Quit
Does anybody out there have any advice on how I can get rid of this error message?
thanks! tim
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
_______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
mediawiki-l@lists.wikimedia.org