deleting users and posts...

[candymanjl]

I'm using the user move/prune feature and I get the following error...


Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: UPDATE post SET userid=0, username='Gundam-GSR' WHERE userid=2189
mysql error: Incorrect key file for table: 'post'. Try to repair it

mysql error number: 1034




and I can't delete any more posts/users now, it was working fine.

[Steve Machol]

Upload repair.php (it's in the 'extras' folder of the zip file) to your admin directory. Close your forums, then run it from your browser with this syntax:

http://www.yourdomain.com/forum/admin/repair.php?html=1&check=1

[Of course change the exact URL as appropriate for your forums.]

If everything reports 'Ok' then reopen your forums. If not, then run it again. The second time everything should report Ok (except the session table which you can ignore.)

[candymanjl]

you're da man! it worked and it's all happy now, thanks!