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

[justinnethers]

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.

http://www.ohiochatter.com/forum/

[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.

[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?

[justinnethers]

Sooooo...am 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.

[justinnethers]

I just randomly did a view source and saw this:

<!--
Database error in vBulletin 4.1.5:


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_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 : http://www.ohiochatter.com/forum/
Referrer :
IP Address : 173.245.55.89
Username :
Classname : vB_Database
MySQL Version :
-->

[justinnethers]

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

[melbo]

What did you do to fix?

[aussiefooty]

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