Error Number : 145 Database error in vBulletin 3.6.8
 

Error Number : 145 Database error in vBulletin 3.6.8




Invalid SQL:

SELECT access.*, forum.forumid,
FIND_IN_SET(access.forumid, forum.parentlist) AS ordercontrol
FROM xxxforum AS forum
INNER JOIN xxxaccess AS access ON (access.userid = 2 AND FIND_IN_SET(access.forumid, forum.parentlist))
ORDER BY ordercontrol DESC;

MySQL Error : Table './xxxxxx/xxxforum' is marked as crashed and should be repaired
Error Number : 145


Please Help ME Thanks

To fix this run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

Admin CP -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

If you can not access your AdminCP, then you can upload the tools.php file from the vbulletin .zip file do_not_upload/ folder into your forumdir/admincp/ directory and run it through the browser, there's a switch there to run optimize and repair. Run it a few times for best result.

If you cannot access either the Admin CP or tools.php you can also use a tool like phpMyAdmin to repair tables.

AdminCP not works

i have this file backup for my forum
(forumbackup-10-21-2007-xxxx.sql)

how to restore my forum

help me Please thanks

No need to restore if that is the only error you get.

Please read my post again, there are also instruction for when you can not access the AdminCP anymore.