[Mediawiki-l] DeleteOldRevisions : mysql query too long

Sylvain Machefert iubito at gmail.com
Wed May 21 15:43:26 UTC 2008


Hello,

using MW 1.12 and latest Special:DeleteOldRevisions (1.3)

When I test before deletion (and I suppose when I'll delete), I always get a
SQL error
SELECT old_id FROM `wiki_text` WHERE old_id NOT IN (
1444,1445,1453,1574,6066,1634,1635,.......... really long list .....)
MySQL returned error « 1064 : You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server version for the right
syntax to use near
'4415,4416,3480,4422,4423,4424,4425,4426,4427,4428,1566,3475,4429,4431,4432,4433,'
at line 1 ».

I tried to restrict to a small namespace, it's still the same.
How can I delete old revisions ?

My DB is still growing and I don't need to keep really old revisions.

-- 
Sylvain Machefert

Tous aux Balkans !
http://www.tousauxbalkans.net


More information about the MediaWiki-l mailing list