Author: liamzebedee

Description:
I've recently had to recover an SQLite database after I did some crazy stuff to it (I have no idea what I did). Long story short, I ended up dumping the DB into XML, reinstalling, then reimporting it. I then ran maintenance/update.php and now I am in a situation where I receive the following error when trying to access the page "Category:Maths":

Function: Category::refreshCounts
Error: 1 near "LOCK": syntax error

I also receive this error when running maintenance/populateCategory.php, in more detail:

Query: SELECT COUNT(*) AS pages,COUNT( (CASE WHEN page_namespace = '14' THEN 1 ELSE NULL END) ) AS subcats,COUNT( (CASE WHEN page_namespace = '6' THEN 1 ELSE NULL END) ) AS files FROM categorylinks,page WHERE cl_to = 'Biological_Level_of_Analysis' AND (page_id = cl_from) LIMIT 1 LOCK IN SHARE MODE

Function: Category::refreshCounts
Error: 1 near "LOCK": syntax error

I'm unsure as how to reproduce the error, but I think it may lie in the XML dump. I dumped the XML as of an earlier 1.21-git revision, and imported it later at a newer 1.21-git revision.

Version: 1.21.x
Severity: major
See Also:
https://bugzilla.wikimedia.org/show_bug.cgi?id=39635