No announcement yet.

Site just stopped working all of a sudden, getting a database error...

  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] Site just stopped working all of a sudden, getting a database error...

    Not sure what the heck happened but all of a sudden the vbulletin part of my site just stopped working and I get a database error message. Database is working, I can connect to it through sequel pro. Nothing on the site changed. Any ideas? This is really, really frustrating.

  • #2
    Getting this in the email message:

    mysql_connect(): Access denied for user 'ohiochatter'@'localhost' (using password: YES)
    But I can connect using the same credentials.


    • #3
      This makes absolutely no sense. I can connect from the command line on localhost with the credentials in the config file, why in the world would this be throwing an error?


      • #4 I just out of luck here? I am seriously at a loss. Every other website I host on the server is up and working just fine so I can't imagine there is a server issue. Especially since I can connect to the database from the command line giving the username and password from the config.php file.


        • #5
          I just randomly did a view source and saw this:

          Database error in vBulletin 4.1.5:

          Invalid SQL:

          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_holiday AS phrasegroup_holiday,
          language.phrasegroupinfo AS lang_phrasegroupinfo,
          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 vb_user AS user
          LEFT JOIN vb_userfield AS userfield ON (user.userid = userfield.userid)
          LEFT JOIN vb_usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN vb_language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))

          WHERE user.userid = 2;

          MySQL Error : Table './ohiochatter/vb_user' is marked as crashed and last (automatic?) repair failed
          Error Number : 144
          Request Date : Friday, November 18th 2011 @ 07:17:01 PM
          Error Date : Friday, November 18th 2011 @ 07:17:01 PM
          Script :
          Referrer :
          IP Address :
          Username :
          Classname : vB_Database
          MySQL Version :


          • #6
            Site is back. Thanks for letting my type out frustrations on here. It tends to help me for some reason.


            • #7
              What did you do to fix?


              • #8
                Make sure that you have got the right name for your database as well as the host.

                New Site New forum
                Come and talk sports all day long


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