[Mediawiki-l] Fwd: Dealing with corrupt pages
tom at hutch4.us
Thu Mar 8 03:11:09 UTC 2012
On 3/7/2012 9:59 PM, Sakshale eQuorian wrote:
> I have a hobby site that was attacked by Chinese language spammers awhile
> MediaWiki: 1.18.0, PHP: 5.2.17 (cgi-fcgi), MySQL: 5.1.56, Apache: 2.2.x,
> They left behind hundreds of pages with corrupt titles;
> The MediaWiki delete function can't work on pages that can't be accessed,
> so how can I clean up this mess?
> Will cleanupTitles.php<http://www.mediawiki.org/wiki/Manual:CleanupTitles.php>
> How about using *phpMyAdmin*? I looked at the *page *table. Starting
> around *page_id 442* you see hundreds of page titles that are massively
> long numbers. I could delete each record, but am concerned that would
> leave pointers and corrupt the database.
> Any pointers would be appreciated.
Install the Nuke extension and go to town. You can delete by user or IP.
I wouldn't play with the tables directly, you could make a bad situation
Soapbox out --- backup, backup, backup --- soapbox put away. If you had
a backup of your database, you could just restore it.
More information about the MediaWiki-l