PRODUCT VERSION:
MediaWiki 1.24.2
PHP 5.3.16 (cgi-fcgi)
MySQL 5.1.63-cll
SMW 2.1.3
Hi everyone.
After 1.24 upgrade, I randomly get the error in the subject of this e-mail.
A check in the database says that the following tables (but not only and
not always the same tables) have some issue:
[tunearch_wikidb.job] warning: 2 clients are using or haven't closed the
table properly
[tunearch_wikidb.l10n_cache] warning: 2 clients are using or haven't closed
the table properly
[tunearch_wikidb.msg_resource] warning: 2 clients are using or haven't
closed the table properly
[tunearch_wikidb.msg_resource_links] warning: 2 clients are using or
haven't closed the table properly
[tunearch_wikidb.objectcache] warning: 2 clients are using or haven't
closed the table properly
[tunearch_wikidb.page] warning: 2 clients are using or haven't closed the
table properly
The quick and dirty solution to the problem is to make a "*repair DB*"
using a feature of the control panel provided by my ISP.
Following is a list of the MW and SMW extensions installed.
Any idea?
*Semantic Drilldown 2.0 *
*Semantic Forms 2.8 GPL-2.0+ *
*Semantic Forms Inputs 0.7 *
*Semantic MediaWiki 2.1.3 *
*Semantic Result Formats 1.8 *
*SMWAskAPI 0.9 alpha *
*Confirm User Accounts – *
*Flagged Revisions – (d32a612) 19:50, 14 April 2015 *
*Replace Text 1.0.1 (d31924e) 14:56, 12 April 2015 *
*User Merge and Delete 1.9.0 *
*Parser hooks*
*Header Tabs 1.0.1 (4f57b96) 15:55, 23 March 2015 *
*HTMLets – *
*ParserFunctions 1.6.0 *
*SidebarDonateBox 1.2.0 *
*Spam prevention*
*ConfirmEdit 1.3 *
*DataValues 1.0 GPL-2.0+ *
*DataValues Common 0.2.3 GPL-2.0+ *
*DataValues Interfaces 0.1.5 GPL-2.0+ *
*DataValues Validators 0.1.2 GPL-2.0+ *
*HidePrefix 0.0.1+ (cc7a1a7) 15:55, 23 March 2015 *
*Lockdown – *
*Mantle – *
*MobileFrontend – *
*News – *
*Preloader 1.1.1 *
*redirectAfterLogout 1.0 *
*redirectOnLogin 1.1 *
*Score 0.3.0 *
*SphinxSearch 0.9.0 *
*Validator 2.0.4 *
*WikiEditor 0.3.0*
Thanks,
Valerio
We have a serious problem with the Job Queue. I believe there may be a
circular references in one or more nested templates. Tracking down the
problem is complicated by having run the wiki for an extended period
during which a considerable amount of MW and SMW template development
was undertaken, the upshot of which was that the number of jobs placed
in the jobs queue far exceeded the clearing of them through the normal
mechanism. The highest ID number in the job table is around 3 million
(that's over about 3 years) and the table currently contains some 80,000
records.
I have run runJobs.php for over 12 hours and the reduction in the number
of records is painfully slow. Observing the table contents during script
execution reveals that certain jobs actually add more jobs to the table
such that it is reducing at the rate of maybe 10 records per minute on
average at most, in spite watching the terminal window disposing of them
at maybe 10 times that rate. I clearly have to get to the bottom of this
issue and would like to empty the job table manually, then edit each of
the potentially offending templates in turn to see how many jobs they
produce and how those jobs are cleared by runJobs.php.
My questions are:
1. Is there an index table and any other tables which need to be emptied
to effectively clear the queue but not damage anything?
2. Is there any possibility of data damage in proceeding in this manner
apart from fat fingers?
Once sorted I intend to confine template development to a non-production
server and to run runJobs.php from a scheduled cron job at least once
per day.
The wiki can be viewed here: https://wikispooks.com/wiki/Main_Page
and any help or suggestions etc would be very much appreciated
Hi everyone!
Is it possible to load jQuery from google library?
Currently, for MW 1.24 the jQuery 1.11.1 were loaded by ResourceLoader. I
want to replace it with
https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js wich
should increase site speed.
Any comment will be helpful.
Thank you!
--
Bask Ice
E-mail ice(a)moegirl.org
Moegirlpedia
2290 3rd Avenue Basement, New York, United States
T43345 <https://phabricator.wikimedia.org/T43345>is classified as a high
priority, and hasn't been fixed for three years. Getting a column added to
indicate that a language link is stored in a foreign repo shouldn't be this
hard. I can think of quite a few cases where this data could be leveraged
in one way or another. Wikidata is extremely widely used, and we still dont
have this basic feature implemented, who needs pressured to get progress
made on this? this should be a fairly straight up and trivial feature to
get going.
Hello!
I've recently rewritten my web based MediaWiki benchmark tool.
You'll find it online at http://fannon.de/p/mediawiki-benchmark/
The Sources at GitHub: https://github.com/Fannon/MediaWiki-Benchmarker
It's a simple tool that allows to benchmark MediaWiki Installations through
the API. It is now possible to add / append new benchmarks, so it's easy to
compare different settings or envirionments - not only pages.
The resulting data can be downloaded as CSV and JSON, the charts as SVG
vector graphics.
Hope you like it!
Simon
PRODUCT VERSION:
MediaWiki 1.24.2
PHP 5.3.16 (cgi-fcgi)
MySQL 5.1.63-cll
SMW 2.1.3
SphinxSearch 0.9.0 (Aug, 17 2014)
The latest SphinxSearch Extension return this error
Cannot call constructor in
...../w/extensions/SphinxSearch/SphinxMWSearch.php on line 549
Does anyone faced the same problem?
PRODUCT VERSION:
MediaWiki 1.24.2
PHP 5.3.16 (cgi-fcgi)
MySQL 5.1.63-cll
SMW 2.1.3
Hi,
after upgrading MW from 1.21 to 1.24 and (among other extensions) to the
newest ConfirmAccount Extension, when I run the update script from the
command line I get the following error:
*Adding acr_agent field to table account_requests ...A database query error
has o ccurred.*
*Query: ALTER TABLE `account_requests`*
* ADD acr_xff VARCHAR(255) NULL default '',*
* ADD acr_agent VARCHAR(255) NULL default ''*
*Function: DatabaseBase::sourceFile(
/home/tunearch/public_html/w/extensions/Conf
irmAccount/backend/schema/mysql/patch-acr_agent.sql )*
*Error: 1170 BLOB/TEXT column 'acr_email' used in key specification without
a key length
(localhost)*
*<br />*
*<b>Notice</b>: Uncommitted DB writes (transaction from
DatabaseUpdater::doUpdat
es). in <b>/home/tunearch/public_html/w/includes/db/Database.php</b> on
line <b> 4266</b><br />*
*es). in <b>/home/tunearch/public_html/w/includes/db/Database.php</b> on
line <b> *
I had to comment out ConfirmAccount in LocalSettings and re-run the update
script to get the site up and running.
Any other encountered a similar problem with ConfirmAccount?
Any suggestion to work around the problem?
Thank you.
--
Valerio M. Pelliccioni
Hi there,
I have MW 1.24.1 installed on CentOs7 with nGinx and PHP-FPM 5.4.16. I am
not using ImageMagick.
With that stated, I am having an issue where thumbs are not being created
for files when they are used in articles with a specific width defined.
Image uploads work fine, and a thumb gets made when a file is uploaded (I
assume it's what is displayed on the File:) page. However, attempting to
use the image with a new size ends up with a 404 due to the thumb not being
there. I am not getting any PHP errors, there is nothing in my system log
or my web server logs that would indicate a permission issue.
I enabled debugging on a page that attempted to use a resized image, and
the log can be found at http://pastebin.com/yeif2YHw
I don't know enough PHP to understand what the TransformationalImageHandler
is doing, but I have a strong feeling that...
TransformationalImageHandler::doTransform: creating 150x200 thumbnail at
mwstore://shared-backend/shared-thumb/6/67/BFZLogo.png/150px-BFZLogo.png
using scaler gd
TransformationalImageHandler::doTransform: Transforming later per flags.
File::transform transformation deferred.
(this appears for 3 different thumbnail sizes)
...isn't a good thing. The specific page that I am using to test this on
(and which generated the above debug output) is
http://wiki.magicjudges.org/en/w/User:Mumbles
I appreciate in advance any assistance you can give, and will provide
whatever information I am able to if there's something that would help
diagnose this issue.
Cheers,
Adam
Greetings,
I am pleased to announce that nominations are now being accepted for the
2015 Wikimedia Foundation Elections. This year the Board and the FDC Staff
are looking for a diverse set of candidates from regions and projects that
are traditionally under-represented on the board and in the movement as
well as candidates with experience in technology, product or finance. To
this end they have published letters
<https://meta.wikimedia.org/wiki/Wikimedia_Foundation_elections_2015/Call_fo…>
describing
what they think is needed and, recognizing that those who know the
community the best are the community themselves, the election
committee is accepting
nominations
<https://meta.wikimedia.org/wiki/Wikimedia_Foundation_elections_2015#Informa…>
for
community members you think should run and will reach out to those
nominated to provide them with information about the job and the election
process.
This year, elections are being held for the following roles:
*Board of Trustees*
The Board of Trustees is the decision-making body that is ultimately
responsible for the long term sustainability of the Foundation, so we value
wide input into its selection. There are three positions being filled.
More information about this role can be found at
https://meta.wikimedia.org/wiki/Wikimedia_Foundation_elections_2015/Board_e….
*Funds Dissemination Committee (FDC)*
The Funds Dissemination Committee (FDC) makes recommendations about how to
allocate Wikimedia movement funds to eligible entities. There are five
positions being filled. More information about this role can be found at
https://meta.wikimedia.org/wiki/Wikimedia_Foundation_elections_2015/FDC_ele…
.
*Funds Dissemination Committee (FDC) Ombud*
The FDC Ombud receives complaints and feedback about the FDC process,
investigates complaints at the request of the Board of Trustees, and
summarizes the investigations and feedback for the Board of Trustees on an
annual basis. One position is being filled. More information about this
role can be found at
https://meta.wikimedia.org/wiki/Wikimedia_Foundation_elections_2015/FDC_Omb…
.
The candidacy submission phase lasts from 00:00 UTC April 20 to 23:59 UTC
May 5 for the Board and from 00:00 UTCApril 20 to 23:59 UTC April 30 for
the FDC and FDC Ombudsperson. This year, we are accepting both
self-nominations and nominations of others. More information on this
election and the nomination process can be found at
https://meta.wikimedia.org/wiki/Wikimedia_Foundation_elections_2015.
Please feel free to post a note about the election on your project's
village pump. Any questions related to the election can be posted on the
talk page on Meta, or sent to the election committee's mailing list,
board-elections(a)wikimedia.org
On behalf of the Elections Committee,
-Gregory Varnum (User:Varnent)
Coordinator, 2015 Wikimedia Foundation Elections Committee
Hi,
Thank you all for helping with the previous questions.
I would need help with the below:
I am working as a Tech Writer and maintaining Wiki for our project. There
was a question if there is a scroller which gives latest news/ updates on
homepage in any corner.
Is this feasible in Media wiki?
Thank you,
Vinodini Arya