database error no error number to be found / no forum / no admincp Help please

محروم.كوم · #1 03-12-2010, 09:50 PM

Server rebooted unexpectedly, forum came back up okay then 20 minutes later I get a DB error when I try to access any forum page, including admincp.

I have restarted mysql and rebooted the server again to no avail. I run other forums on the same server and they are all okay, no db errors on them.

Help please, i have no idea where to go from here to fix this.

edit to add:
Here is the db error generated and emailed to be by the forum software:

Database error in vBulletin 3.8.2:

Invalid SQL:

SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_global AS phrasegroup_global,
language.phrasegroup_adv_portal AS phrasegroup_adv_portal,
language.phrasegroup_calendar AS phrasegroup_calendar,
language.phrasegroup_postbit AS phrasegroup_postbit,
language.phrasegroup_prefix AS phrasegroup_prefix,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep

FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))

Edit one more time to add:

WHERE user.userid = 1;

MySQL Error : Table './forumsforums/user' is marked as crashed and should be repaired
Error Number : 145
Request Date : Friday, March 12th 2010 @ 1219 PM

Any idea how I can repair the */user table? __DEFINE_LIKE_SHARE__