Bug SQL error every hours in 1.1 beta PRO when running cron job?

[Badger]

From vBulletin error logs ...

I just cut-n-pasted the last three errors, as they are all essentially the same and seem to be occurring every hour for the last several days, generated by vbmail ..

Database error in vBulletin 4.1.3:

Invalid SQL:

UPDATE dbtech_vbmail_subscription
SET subscribed = '0'
WHERE userid = 19588
AND mailinglistid NOT IN();

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 ')' at line 4
Error Number : 1064
Request Date : Wednesday, July 20th 2011 @ 02:45:07 PM
Error Date : Wednesday, July 20th 2011 @ 02:45:07 PM
Script : http://www.milsurps.com/cron.php?rand=1311187505
Referrer : http://www.milsurps.com/search.php?searchid=602023
IP Address : 184.66.39.166
Username : Unregistered
Classname : vB_Database
MySQL Version :
=====================================================

Database error in vBulletin 4.1.3:

Invalid SQL:

UPDATE dbtech_vbmail_subscription
SET subscribed = '0'
WHERE userid = 19588
AND mailinglistid NOT IN();

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 ')' at line 4
Error Number : 1064
Request Date : Wednesday, July 20th 2011 @ 03:45:22 PM
Error Date : Wednesday, July 20th 2011 @ 03:45:22 PM
Script : http://www.milsurps.com/cron.php?rand=1311191114
Referrer : http://www.milsurps.com/showthread.php?t=2355
IP Address : 96.37.251.196
Username : Unregistered
Classname : vB_Database
MySQL Version :
=====================================================

Database error in vBulletin 4.1.3:

Invalid SQL:

UPDATE dbtech_vbmail_subscription
SET subscribed = '0'
WHERE userid = 19588
AND mailinglistid NOT IN();

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 ')' at line 4
Error Number : 1064
Request Date : Wednesday, July 20th 2011 @ 04:45:05 PM
Error Date : Wednesday, July 20th 2011 @ 04:45:05 PM
Script : http://www.milsurps.com/cron.php?rand=1299968700
Referrer :
IP Address : 66.249.71.197
Username : Unregistered
Classname : vB_Database
MySQL Version :
=====================================================

 

[Fillip H.]

That has been fixed in v1.1.1

 

[Badger]

Darn ... I missed that personal telephone call that there had been an update ...

... and I thought for sure I would win a prize for discovering this bug and all my beta work ...

I've download it ..

Regards,
Doug

 

[Ozzy47]

xD ok thanks Doug, hopefully that solves your issues!!

 

[Fillip H.]

If it doesn't, try deleting all existing downloaded vBMail zips and re-download it fresh, then re-upload the files.

We've had scattered reports of unzipping programs not liking existing zips being in the download directory.


You can test to see if it's fixed by going to the Scheduled Task Manager and manually running the Bounced Mail Threshold task