On Tue, Sep 21, 2010 at 04:53, Adam Meyer meyer7@mindspring.com wrote:
I tried moving the folder, and making a new math folder. The math just showed as a missing image. If I did a null save on the page it then created them. But then I need to know all the pages with math on them to do a null edit.
Is there a maintenance to just touch every page so it would recreate them?
I'm not aware of a maintenance script to handle this task – however, that doesn't mean that there isn't one.
I asked about this issue on irc://irc.freenode.net/#mediawiki and received a suggestion that it might be fastest to do with a pywikipediabot script (http://meta.wikimedia.org/wiki/Using_the_python_wikipediabot)
You could grab a list of the last version of all pages and then search through the text for '<math>'. This sounds simple, but probably has one small difficulty – the text of the revision is likely gzipped, meaning that you can't search for the tag directly in the database.
You can grab the text with this query:
SELECT p.page_title AS "Page Title", t.old_text AS "Page Text" FROM wikidb.page p inner join wikidb.revision r ON p.page_latest = r.rev_id inner join wikidb.text t ON r.rev_text_id = t.old_id;
Once you've got the text, use PHP's gzinflate() function to get the plain text back out.
A more expert user of MediaWiki will likely have a more elegant solution.