Announcement

Collapse
No announcement yet.

Database errors weekly

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Database errors weekly

    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

    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 :

  • #3
    Thanks but that's not exactly possible as it's running on our dedicated server.

    The version we are running is 5.0.51b-community-nt

    Any chance upgrading to the latest version of MySQL would fix this problem? Looks like my options are 5.5 or 5.1.52.

    Comment


    • #4
      There is no reason for a table to crash on a regular basis like that. This is a sign in a misconfigured server. I doubt a simple MySQL upgrade will fix this. However please see this thread for help with optimizing your server:

      http://www.vbulletin.com/forum/showt...threadid=70117

      Then post the requested info in a new thread in that forum.

      Also please note that we do this as a courtesy but optimizing servers is not really a part of vBulletin support.
      Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
      Change CKEditor Colors to Match Style (for 4.1.4 and above)

      Steve Machol Photography


      Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X