It seems that we are receiving the following error emails on a weekly basis, if not more frequently. This morning, logging into the server and running the optimize command in the MySQL Administrator seemed to fix the problem. Prior to running the optimization the board was completely inaccessible and I've since tested and can login and post as well as access the admin area.
Our database is up to 195mb, doesn't seem like it's too big to me but I'd like to figure out why this continues to happen on a regular basis. Any thoughts?
Last week when this happened all the data was lost from the "post" table and we had to restore back to the backup we had from the previous night. Anything I can do to prevent this from continuing to happen would be great, we really want to avoid losing any data.
Thanks in advance.
-Scott
Our database is up to 195mb, doesn't seem like it's too big to me but I'd like to figure out why this continues to happen on a regular basis. Any thoughts?
Last week when this happened all the data was lost from the "post" table and we had to restore back to the backup we had from the previous night. Anything I can do to prevent this from continuing to happen would be great, we really want to avoid losing any data.
Thanks in advance.
-Scott
Database error in vBulletin 3.8.4:
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_forumdisplay AS phrasegroup_forumdisplay,
language.phrasegroup_inlinemod AS phrasegroup_inlinemod,
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))
WHERE user.userid = 16094;
MySQL Error : Table '.\vbulletin\user' is marked as crashed and should be repaired
Error Number : 145
Request Date : Monday, November 15th 2010 @ 06:16:24 AM
Error Date : Monday, November 15th 2010 @ 06:16:24 AM
Script : http://www.******.org/vbulletin/forumdisplay.php?f=45
Referrer :
IP Address : **.**.**.**
Username :
Classname : vB_Database
MySQL Version :
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_forumdisplay AS phrasegroup_forumdisplay,
language.phrasegroup_inlinemod AS phrasegroup_inlinemod,
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))
WHERE user.userid = 16094;
MySQL Error : Table '.\vbulletin\user' is marked as crashed and should be repaired
Error Number : 145
Request Date : Monday, November 15th 2010 @ 06:16:24 AM
Error Date : Monday, November 15th 2010 @ 06:16:24 AM
Script : http://www.******.org/vbulletin/forumdisplay.php?f=45
Referrer :
IP Address : **.**.**.**
Username :
Classname : vB_Database
MySQL Version :
Comment