vbulletin database has encountered a problem.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • dprundle
    New Member
    • Aug 2006
    • 23

    vbulletin database has encountered a problem.

    This forum has been running perfectly and I just woke up this morning to receive the "database has encountered a problem. please refresh your page".

    I have made no changes to the forum at all.

    URL: http://www.wvutalk.com

    Any help is appreciated.
    Oklahoma Sports | Warhammer Blog | Vanguard SOH Faces | WVU Message Board
  • dprundle
    New Member
    • Aug 2006
    • 23

    #2
    The only change I can think that I've made is I recently went into my vbulletin.com membership panel and changed the license code I was using for the forum. Would that cause this problem?
    Oklahoma Sports | Warhammer Blog | Vanguard SOH Faces | WVU Message Board

    Comment

    • peterska2
      Senior Member
      • Oct 2003
      • 8869
      • 3.7.x

      #3
      What is the actual error that you are receiving? Right click on the error page and there will be a section that begins with Database Error In vBulletin or vBulletin Database Error

      Copy that section and paste it here.

      Comment

      • dprundle
        New Member
        • Aug 2006
        • 23

        #4
        <!--
        Database error in vBulletin 3.6.7:

        Invalid SQL:

        SELECT
        userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
        IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
        language.phrasegroup_calendar AS phrasegroup_calendar,
        language.phrasegroup_adv_portal AS phrasegroup_adv_portal,
        language.phrasegroup_postbit AS phrasegroup_postbit,
        language.phrasegroup_photoplog AS phrasegroup_photoplog,
        language.phrasegroup_global AS phrasegroup_global,
        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 = 725;

        MySQL Error : Table './dprundle_vb/user' is marked as crashed and should be repaired
        Error Number : 145
        Date : Friday, December 21st 2007 @ 08:50:06 AM
        Script : http://www.wvutalk.com/
        Referrer :
        IP Address : 68.229.211.213
        Username :
        Classname : vB_Database
        -->
        Oklahoma Sports | Warhammer Blog | Vanguard SOH Faces | WVU Message Board

        Comment

        • peterska2
          Senior Member
          • Oct 2003
          • 8869
          • 3.7.x

          #5
          Run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

          Admin Control Panel -> Import & Maintenance -> Repair/Optimize Tables -> Check All -> Continue

          If you cannot access the Admin CP, then you can use phpMyAdmin to repair tables.

          Comment

          • dprundle
            New Member
            • Aug 2006
            • 23

            #6
            okay admincp is not accessible. I have phpmyadmin but don't see a 'repair' option.
            Oklahoma Sports | Warhammer Blog | Vanguard SOH Faces | WVU Message Board

            Comment

            • dprundle
              New Member
              • Aug 2006
              • 23

              #7
              Thanks I got it fixed with the following SQL command:

              Repair Table User;
              Oklahoma Sports | Warhammer Blog | Vanguard SOH Faces | WVU Message Board

              Comment

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