Vanilla 1 is no longer supported or maintained. If you need a copy, you can get it here.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

Sudden Breakdown

edited May 2008 in Vanilla 1.0 Help
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'; ?>

Comments

  • 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.
  • 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.
  • Make sure your appg/database.php is intact?
  • wouldn't it be conf/database.php ?
  • appg/database.php and conf/database.php are identical and as posted above.
  • 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.
  • 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!
This discussion has been closed.