That fixed it! Thanks!
----- Original Message -----
From: "Darren VanBuren" <onekopaka(a)gmail.com>
To: "MediaWiki announcements and site admin list"
<mediawiki-l(a)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(a)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(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)lists.wikimedia.org