Getting this SQL error when viewing the control panel in the friends online section:
SQL ERROR: Unable to do_query: DELETE FROM w3t_Online WHERE O_Last <
You have an error in your SQL syntax near '' at line 4: 2000
Do not get this error when viewing the Who's Online page though.
Here's the section in online.php in question:
// -------------------------
// Delete the inactive users
$html = new html;
$Outdated = $html -> get_date() - 600;
$query = "
DELETE FROM w3t_Online
WHERE O_Last < $Outdated
";
$dbh -> do_query($query);
Looks good to me...anyone see the error or have an idea where to check to fix this?
Here's the URL to the board to see for yourself:
http://www.sweetleaf.cc/wwwthreads/wwwthreads.php