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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-l _______________________________________________ MediaWiki-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
