That fixed it! Thanks! ----- Original Message ----- From: "Darren VanBuren" <[email protected]> To: "MediaWiki announcements and site admin list" <[email protected]> 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" <[email protected]> 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 > [email protected] > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l > _______________________________________________ MediaWiki-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-l _______________________________________________ MediaWiki-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
