|
إنضمامك إلي منتديات استراحات زايد يحقق لك معرفة كل ماهو جديد في عالم الانترنت ...
انضم الينا
#1
| ||
| ||
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__ |
مواقع النشر (المفضلة) |
أدوات الموضوع | |
انواع عرض الموضوع | |
| |