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

Hello again, I ended up checking the job table to discover that mysql reported many tables needed to be upgraded. After running mysql repair on the complete database, all seems well.

Your guidance put me in the right location.

Thanks!

On Tue, Nov 25, 2008 at 3:37 PM, Momma mommahatesspam@gmail.com wrote:

Hello,

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') #1 /home/wiki/public_html/includes/Wiki.php(388): Job::pop() #2 /home/wiki/public_html/includes/Wiki.php(333): MediaWiki->doJobs() #3 /home/wiki/public_html/index.php(94): MediaWiki->finalCleanup(Array, Object(OutputPage)) #4 {main}

I eventually used the batchDelete.php to remove the pages that were just imported and all went back to normal. I googled this error and could find nothing.

One specific example: I was following the instructions at http://www.mediawiki.org/wiki/Help:Copying. Right after importing the XML file, I received the aforementioned error. I used delateBatch.php to remove all Help:* files and it removed the error.

Second example: I copied the source from http://en.wikipedia.org/w/index.php?title=Template:Fact&action=edit into Template:Fact on my wiki and boom. Deleting the template fixed the problem.

System Specs: MediaWiki 1.13.2 PHP 5.2.5 (apache2handler) MySQL 5.0.67-community OS RHE 3 Intel 32-bit

Appreciate any guidance....