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?(a)?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
> You should be able to use tooltip-n-* messages.
>
> ie:
> MediaWiki:Sidebar has something like:
> ** mypage-url|mypage
>
> And you have a page title in MediaWiki:Mypage-url and "My Page" in
> MediaWiki:Mypage
> You should then be able to create MediaWiki:Tooltip-n-mypage with the text
> of the tooltip.
>
> --
> ~Daniel Friesen (Dantman, Nadir-Seen-Fire) [http://daniel.friesen.name]
I have tried doing as described, however, I must be doing something
wrong. For instance, in mediawiki:sidebar we have a line:
** Teaching|Teaching
I can easily create the page MediaWiki:Tooltip-n-teaching, and fill it
with something: "An overview of teaching-related information",
however, no tooltip-n-teaching appears in special:allmessages, and no
tooltip appears in the sidebar either, so that had no effect.
Thanks in advance
Kaare Mikkelsen
I just installed MediaWiki 1.18.1 (from 1.17.1) and am getting this error when I hit any page: "CACHE_ACCEL requested but no suitable object cache is present. You may want to install APC." We run eAccelerator 0.9.6.1 and it worked perfectly in this configuration with 1.17.1. CACHE_ACCEL is documented as working with eAccelerator at http://www.mediawiki.org/wiki/$wgMainCacheType.
Setting $wgMainCacheType = CACHE_NONE makes the site run correctly. Any ideas why MediaWiki isn't detecting eAccelerator after the update?
Backtrace:
#0 [internal function]: ObjectCache::newAccelerator(Array)
#1 /var/www/html/w/includes/objectcache/ObjectCache.php(62): call_user_func('ObjectCache::ne...', Array)
#2 /var/www/html/w/includes/objectcache/ObjectCache.php(50): ObjectCache::newFromParams(Array)
#3 /var/www/html/w/includes/objectcache/ObjectCache.php(23): ObjectCache::newFromId(3)
#4 /var/www/html/w/includes/GlobalFunctions.php(3600): ObjectCache::getInstance(3)
#5 /var/www/html/w/includes/Setup.php(402): wfGetMainCache()
#6 /var/www/html/w/includes/WebStart.php(157): require_once('/var/www/html/w...')
#7 /var/www/html/w/index.php(53): require('/var/www/html/w...')
#8 {main}
Thanks,
DanB
Hi, I am having difficulty adding tooltips to the menu items in the
sidebar. I have previously been redirected to Special:AllMessages,
which works great for changing the tooltips already present. However,
it appears that for some items the tootltips are "switched off",
meaning that the values shown in Special:AllMessages have no effect
(for instance, "Main Page" has no tooltip, while "Help" does). Hence,
changing them changes nothing on the wiki. Furthermore, there are
several menu items in the sidebar not represented in
Special:AllMessages, so I would need a way to either add new messages
to be edited in Special:AllMessages, or some other way to add tooltips
to sidebar menu items.
In short: how do I turn on and edit tooltips for all sidebar menu items?
The version-info for the wiki is
MediaWiki 1.17.0
PHP 5.2.17 (cgi)
MySQL 5.1.56-community-log
and the url of the wiki is www.phaust.dk/wiki
I hope all is clear.
Thank you in advance
Kaare Mikkelsen
Our community wishes to understand the access patterns of our wiki. There
seems to be quite a few special pages and extensions that tell us how
many edits occur (both globally and individually). However, after looking
around a little bit, I could find no software that would analyze how many
pages are accessed on a daily basis by readers (not editors).
Software such as Webalizer count web page access using the squid/apache
log files. But those logs include entries that cannot be considered
actual content accesses. For example, our apache logs are densely
littered with lines such as:
... "GET /skins/common/commonPrint.css?270 HTTP/1.0" ...
... "GET /skins/common/shared.css?270 HTTP/1.0" ...
... "GET /skins/Pinkwich5/main.css?270 HTTP/1.0" ...
... "GET /skins/common/mwsuggest.js?270 HTTP/1.0" ...
... "GET /skins/common/ajax.js?270 HTTP/1.0" ...
...
...
... "GET /wiki?title=MediaWiki:Common.css ...
... "GET /wiki?title=MediaWiki:Pinkwich5.css ...
... "GET /wiki?title=MediaWiki:Print.css
These GET requests do not represent content page accesses.
I am looking for software that counts page accesses and has the
capability to eliminate page edits and perhaps even limit counts to non-
logged in users. I also need software that will automatically generate
reports that are (automatically) embedded in the wiki (using a Special
page or other approach).
--
-- Dan Nessett
Hi!
I still haven't found a solution for getting the output of a parser
function or a php function that is run after the parser functions in an
article into the sitenotice. I tried /$wgHooks['SiteNoticeAfter'][]/,
but this function is invoked before the article, thus, before my parser
functions in the article are invoked. This parser functions fill a
global array that should be displayed in the sitenotice.
Is there any way to get this working?
Most of you by now will know about the SOPA protest of Wikimedia [1].
My question is simple:
If I am running MediaWiki sites, and if I want to join that protest (to
raise awareness among my readers), what is the recommended *simple*
technical way of doing this? It would help if somebody who cared about
this could make a simple documentation on this (I guess one could simply
exchange index.php on typical small sites?). I am aware of
http://sopastrike.com/
but I wondered if there is a more wiki-specific message to use that
anybody might have prepared.
Also, as was noted at wikitech-l:
> It seems Google has advised to serve a 503 (Service unavailable) HTTP
> code during blackouts to avoid them influencing their search engine.
How would one do this in the easiest way?
Thanks,
Markus
[1]
https://wikimediafoundation.org/wiki/English_Wikipedia_anti-SOPA_blackout
On 01/17/2012 07:18 PM, mediawiki-l-request(a)lists.wikimedia.org wrote:
> Date: Tue, 17 Jan 2012 22:52:36 +0000 From: Gordon Joly
> <gordon.joly(a)pobox.com> Subject: Re: [Mediawiki-l] SOPA blackout:
> technical advice on how to join? To: mediawiki-l(a)lists.wikimedia.org
> Message-ID: <4F15FBB4.8060608(a)pobox.com> Content-Type: text/plain;
> charset=ISO-8859-1; format=flowed On 17/01/2012 15:05, Markus Kr?tzsch
> wrote:
>> > but I wondered if there is a more wiki-specific message to use that
>> > anybody might have prepared.
>> >
>> > Also, as was noted at wikitech-l:
>> >
>> > > It seems Google has advised to serve a 503 (Service unavailable) HTTP
>> > > code during blackouts to avoid them influencing their search engine.
>> >
> Maybe just a redirect to en.wikipedia.org in the server conf or .htaccess???
>
> Gordo
How the Wikimedia Foundation is doing it:
https://meta.wikimedia.org/wiki/English_Wikipedia_SOPA_blackout/Technical_F…
An extension for your wiki to let you do the same:
https://www.mediawiki.org/wiki/Extension:Blackout
--
Sumana Harihareswara
Volunteer Development Coordinator
Wikimedia Foundation
On 01/16/2012 11:12 PM, mediawiki-l-request(a)lists.wikimedia.org wrote:
> Date: Tue, 17 Jan 2012 12:41:58 +0530
> From: Shivam Oberoi <shivam.oberoi(a)netedgetelesolutions.com>
> Subject: [Mediawiki-l] Looking for an Api
> To: mediawiki-l(a)lists.wikimedia.org
> Message-ID:
> <CAPUgKraaQqYbOg63W-DYPUs4PTYOaGGhE-xwV3P1ehe2=M7hSQ(a)mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Hi,
> I am Shivam Oberoi working in Netedgetelesolutions pvt ltd. We want to
> design an application for which we would require your Search Api .
> We want to know how to get an Api from your side and what are its prices.
> Please suggest us.
>
> Regards
I am guessing that you would like to use MediaWiki's web service API,
possibly in order to access English Wikipedia and other Wikimedia sites
that run MediaWiki.
You do not have to pay money to use the MediaWiki API to access
Wikimedia sites. A guide:
http://www.mediawiki.org/wiki/API
The mailing list:
https://lists.wikimedia.org/mailman/listinfo/mediawiki-api
Best,
--
Sumana Harihareswara
Volunteer Development Coordinator
Wikimedia Foundation
https://www.mediawiki.org/wiki/Extension:Blackout
This is NOT the code that the Wikimedia Foundation is using for the
SOPA/PIPA blackout. (We'll be putting up a technical guide sometime in
the next 6 hours explaining how we're implementing this, mentioning that
you can't edit via the API, etc.) This is an extension developed by
Gregory Varnum and John Du Hart to help other MediaWiki sites black out.
The code's at:
http://svn.wikimedia.org/viewvc/mediawiki/trunk/extensions/Blackout/
That page also links to other resources and methods for anti-SOPA
JavaScript and so on.
--
Sumana Harihareswara
Volunteer Development Coordinator
Wikimedia Foundation