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