[Mediawiki-l] Invalid job command `refreshLinks

[Brion Vibber]

-----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-----