Brion,
I do not have a table 'jobs.' I do however have a table 'job' which has
the
job_cmd column. And that column is already set to varbinary(60) NOT NULL
with default ''
I have ZERO ROWS in job.
I originally installed mediaWiki prob. 2 yrs ago (version unknown). So I
have been through a few upgrades.
-----Original Message-----
From: mediawiki-l-bounces(a)lists.wikimedia.org
[mailto:mediawiki-l-bounces@lists.wikimedia.org] On Behalf Of Brion Vibber
Sent: Tuesday, November 25, 2008 5:23 PM
To: MediaWiki announcements and site admin list
Subject: Re: [Mediawiki-l] Invalid job command `refreshLinks
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Momma wrote:
I get the following error after I import certain
pages/templates from
Wikipedia. After the import, no matter what link in my wiki I try to
execute, I get the following error.
Invalid job command `refreshLinks
Backtrace:
#0 /home/wiki/public_html/includes/JobQueue.php(163):
Job::factory('refreshLinks???...', Object(Title), '', '122')
Looks like your jobs.job_cmd column has somehow ended up as a binary
fixed-length column. This ends up padding strings with nulls, which
don't get removed, and things don't quite match up anymore.
Try this SQL command to fix it back to a variable-length column:
ALTER TABLE jobs
CHANGE COLUMN job_cmd job_cmd varbinary(60) NOT NULL default '';
You'll then need to remove the old entries:
TRUNCATE TABLE jobs;
New ones should be entered correctly.
(The bug may have been from installation of an older version of
MediaWiki where the binary schema mode wasn't quite right yet...)
- -- brion
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.8 (Darwin)
Comment: Using GnuPG with Mozilla -
http://enigmail.mozdev.org
iEYEARECAAYFAkksetsACgkQwRnhpk1wk453qwCeO8wBOw5CKJO4BZZbv05Tl06r
YLoAoN1NeFMJzFxtOQcG4xITskAoB0ji
=R6Ed
-----END PGP SIGNATURE-----
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l