I updated my version of this plugin yesterday and starting seeing db errors in my email this morning when the cron ran:
Invalid SQL:
DELTE FROM lgv
WHERE (lastactivity + ( * 86400)) < 1228892404;
I looked at the lgvdb.php in /includes/cron and the sql is incorrect:
// actually do the kill
$vbulletin->db->query_write("
DELTE FROM " . TABLE_PREFIX . "lgv
WHERE (lastactivity + (". $lgvcleardays ." * 86400)) < ". TIMENOW ."
Note the DELTE. I know it's just a typo and I have corrected it on my system.
Thanks for the mod!
|