[tamarian]

Originally Posted by gbechtel

When trying to run vbouncer-clean.php via the Scheduled Task Manager I get the following....


Database error in vBulletin 3.0.8:

Invalid SQL: DELETE FROM vb3_vbouncer WHERE vbouncer.dateline < 1124683668
mysql error: Unknown table 'vbouncer' in where clause

mysql error number: 1109


Can someone point me in the right direction on what to edit to cure this?

Thanks,
Gil

In vbouncer-clean.php find:

PHP Code:

$DB_site->query("DELETE FROM " . TABLE_PREFIX . "vbouncer WHERE vbouncer.dateline < $TestPeriod"); 


Replace with:

PHP Code:

$DB_site->query("DELETE FROM " . TABLE_PREFIX . "vbouncer WHERE  dateline < $TestPeriod");