[Mediawiki-l] Fwd: Dealing with corrupt pages

Tom Hutchison 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
> back.
> MediaWiki: 1.18.0, PHP: 5.2.17 (cgi-fcgi), MySQL: 5.1.56, Apache: 2.2.x,
> CentOS
>
> http://gz.equoria.net/index.php?title=Main_Page
>
> They left behind hundreds of pages with corrupt titles;
>
> http://gz.equoria.net/index.php?title=Special:UncategorizedPages
>
> 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>
>   help?
>
> 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 
worse.

Soapbox out --- backup, backup, backup --- soapbox put away. If you had 
a backup of your database, you could just restore it.

Tom



More information about the MediaWiki-l mailing list