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';
?>
0
This discussion has been closed.
Comments
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.