No announcement yet.

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

  • Filter
  • Time
  • Show
Clear All
new posts

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

    Leave a comment:

  • melbo
    What did you do to fix?

    Leave a comment:

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

    Leave a comment:

  • justinnethers
    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 :

    Leave a comment:

  • justinnethers
    replied 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.

    Leave a comment:

  • justinnethers
    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?

    Leave a comment:

  • justinnethers
    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.

    Leave a comment:

  • 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.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.