Error Number : 145 Database error in vBulletin 3.6.8

[tunistunis]

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

[Marco van Herwaarden]

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.

[tunistunis]

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

[Marco van Herwaarden]

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.