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
