2011-02-24, 07:51 AM
So I haven't been on my board for 2 days and got a spammer who managed to make over 5,000 posts. I went to prune his posts from admin's interface but it started working, worked for a while and resulted in a blank page. I went to check, now his post count only showed a little over 2,000 posts but when I went to prune them again, I got the following error message:
What can I do now?
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1062 - Duplicate entry '3215' for key 1
Query:
INSERT INTO mybb_backup_posts (`pid`,`tid`,`replyto`,`fid`,`subject`,`icon`,`uid`,`username`,`dateline`,`message`,`ipaddress`,`longipaddress`,`includesig`,`smilieoff`,`edituid`,`edittime`,`visible`,`posthash`) VALUES ('3215','3198','0','6','subaction showcomments viagra archive older','0','50','fezwjc','1296234174','[url=http://zyban.freeforums.org/buy-zyban-no-prescription-online-t3.html]zyban united kingdom[/url] , drung interactions on imitrex nasal spray\r [url=http://accutane13.blog.igg.com]buy accutane[/url] , better cholesteral medicine than lipitor\r [url=http://zetia.blog.igg.com]buy zetia[/url] , tramadol no prescription required 200 tablets\r [url=http://zetia.blog.igg.com]buy zetia no prescription[/url] , can premarin cause weight gain\r ','87.236.26.5','1475090949','0','0','0','0','1','d7bc8a2ef3229499506143e249305669')What can I do now?