Quote:
Originally Posted by janslu
I have it installed but I got php errors when my database had too many connections. The error logged was:
Code:
[10-Sep-2009 23:35:50] PHP Warning: SQLiteDatabase::unbufferedQuery() [<a href='sqlitedatabase.unbufferedquery'>sqlitedatabase.unbufferedquery</a>]: near "ORDER": syntax error in forum/includes/class_core.php on line 1015
[10-Sep-2009 23:35:50] PHP Fatal error: Call to a member function fetch() on a non-object in forum/includes/class_core.php on line 1017
Any idea what might be the problem?
Line 1015 of modified class_core.php is:
Code:
$sqlitequery = $sqlitedb->unbufferedQuery("SELECT * FROM dberrors WHERE time > ".(TIMENOW - $timebetweenerrors)." AND errorcode = ".$this->errno." ORDER BY time DESC");
|
Try to change that line to
Code:
$sqlitequery = $sqlitedb->unbufferedQuery("SELECT * FROM dberrors WHERE time > ".(TIMENOW - $timebetweenerrors)." AND errorcode = '".$this->errno."' ORDER BY time DESC");
I wish it gave more details about the syntax error so I could see exactly what its problem is.