No announcement yet.

deleting users and posts...

  • Filter
  • Time
  • Show
Clear All
new posts

  • deleting users and posts...

    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.

  • #2
    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:

    [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.)
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography

    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


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


      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.