Sudden Breakdown

Everything was running fine and then all of a sudden this morning my forums stopped working. As far as I can tell there's no difference between my backups and what I have now. I just don't know where to start looking! Here's the gazillion error messages. Any ideas of where to start? Thank you!! Aaron Notice: Undefined index: Discussion in /usr/home/html/iago/HTML/forums/library/Framework/Framework.Functions.php on line 549 Notice: Undefined index: Discussion in /usr/home/html/iago/HTML/forums/library/Framework/Framework.Class.SqlBuilder.php on line 129 ... Notice: Undefined index: User in /usr/home/html/iago/HTML/forums/library/Framework/Framework.Class.SqlBuilder.php on line 80 ... Notice: Undefined index: DiscussionUserWhisperTo in /usr/home/html/iago/HTML/forums/library/Framework/Framework.Functions.php on line 549 ... A fatal, non-recoverable error has occurred Technical information (for support personel): Error Message An error occurred while retrieving discussions. Affected Elements DiscussionManager.GetDiscussionList(); The error occurred on or near: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as DiscussionID, t. as FirstCommentID, t. as AuthUserID, t. as WhisperUserID,' at line 1 Here's my database.php: <?php // Database Configuration Settings $Configuration['DATABASE_HOST'] = 'xxx'; $Configuration['DATABASE_NAME'] = 'xxx'; $Configuration['DATABASE_USER'] = 'xxx'; $Configuration['DATABASE_PASSWORD'] = 'xxx'; $Configuration['DATABASE_CHARACTER_ENCODING'] = 'utf8'; $DatabaseTables['User'] = 'LUM_User'; $Configuration['DATABASE_TABLE_PREFIX'] = 'LUM_'; // Attachments Table Structure $DatabaseTables['Attachment'] = 'Attachment'; $DatabaseColumns['Attachment']['AttachmentID'] = 'AttachmentID'; $DatabaseColumns['Attachment']['UserID'] = 'UserID'; $DatabaseColumns['Attachment']['DiscussionID'] = 'DiscussionID'; $DatabaseColumns['Attachment']['CommentID'] = 'CommentID'; $DatabaseColumns['Attachment']['Title'] = 'Title'; $DatabaseColumns['Attachment']['Description'] = 'Description'; $DatabaseColumns['Attachment']['Name'] = 'Name'; $DatabaseColumns['Attachment']['Path'] = 'Path'; $DatabaseColumns['Attachment']['Size'] = 'Size'; $DatabaseColumns['Attachment']['MimeType'] = 'MimeType'; $DatabaseColumns['Attachment']['DateCreated'] = 'DateCreated'; $DatabaseColumns['Attachment']['DateModified'] = 'DateModified'; ?>

fysicsluvr

Just an idea: Your MySQL database may have had a limit that was reached, and so now your host has denied access to it.

If it happened spontaneously, then it's either caused by a cron job, time sensitive php, or an overflowed MySQL db, among a few other things.

Striton

What appears to be happening is the SQL statement is not being built properly. The message is: 'as DiscussionID, t. as FirstCommentID, t. as AuthUserID, t. as WhisperUserID,' AFAIK, "t." is not valid. It should be "t.X", but what X is and why it's not being substituted all of a sudden, I don't know. My other mysql sites are working fine.

WallPhone

Make sure your appg/database.php is intact?

fysicsluvr

wouldn't it be conf/database.php ?

Striton

appg/database.php and conf/database.php are identical and as posted above.

WallPhone

Then thats your problem--appg/database.php should look like this: http://lussumo.com/svn/vanilla/trunk/src/appg/database.php appg contains all the defaults--among those the default names for each table.

Striton

Hoh boy. Thank you so much! I have no idea how on earth that file got altered. I'll have to check with my co-admin. Thank you for your help!