[BadgerDog]

Originally Posted by Ted S

Open the file lgvdb.php and replace

$vbulletin->db->query_write("
  DELETE FROM " . TABLE_PREFIX . "lgv
  WHERE (lastactivity + (". $vbulletin->options['lgvcleardays'] ." * 86400)) < ". TIMENOW ."
 ");

With code

$vbulletin->db->query_write("
  DELETE FROM " . TABLE_PREFIX . "lgv
  WHERE (lastactivity + (30 * 86400)) < ". TIMENOW ."
 ");

Hi Ted ...

Just checked the vBulletin error logs and it's showing me lots of SQL errors (same ones) when LGV executes the 30 day patch, at least I think that's what it's trying to tell me?

Database error in vBulletin 4.1.3:

Invalid SQL:

DELETE FROM lgv
WHERE (lastactivity + (*30* * 86400)) < 1311049245;

MySQL Error : 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 '*30* * 86400)) < 1311049245' at line 2
Error Number : 1064
Request Date : Tuesday, July 19th 2011 @ 12:20:45 AM
Error Date : Tuesday, July 19th 2011 @ 12:20:45 AM
Script : http://www.xxxxxx.com/cron.php?rand=1311049242
Referrer : http://www.xxxxxx.com/showthread.php?t=12345
IP Address : xx.xx.xx.xx
Username : Unregistered
Classname : vB_Database
MySQL Version :

Did I enter the code change incorrectly?

Regards,
Doug