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
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
