Paid subscriptions not expiring

[kontrabass]

After upgrading from 3.0.7 to 3.5.3, my paid subscriptions no longer expire. For example I have subscriptions whos end-date was January 10th, and yet they're still listed as having 'active' subscriptions.

Got a database error email, not sure if it's related:

Invalid SQL:

DELETE FROM access
WHERE forumid IN (N;) AND
userid = 51416;

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 ';) AND
userid = 51416' at line 2
Error Number : 1064
Date : Thursday, January 12th 2006 @ 12:00:03 AM
Script : http://www.talkbass.com/forum/cron.php?&rand=325590
Referrer : http://www.talkbass.com/forum/forumdisplay.php?f=44
IP Address : 141.154.xxxxx
Username : Unregistered
Classname : vb_database

[kontrabass]

Ran the task manually and yes it does result in a database error. Hmm.

Database error in vBulletin 3.5.3:

Invalid SQL:

DELETE FROM access
WHERE forumid IN (N;) AND
userid = 842;

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 ';) AND
userid = 842' at line 2
Error Number : 1064
Date : Thursday, January 12th 2006 @ 11:59:52 AM
Script : http://www.talkbass.com/forum/admincp/cronadmin.php?do=runcron&cronid=7
Referrer : http://www.talkbass.com/forum/admincp/cronadmin.php?do=modify
IP Address : 66.xxxxxxxx
Username : paul
Classname : vb_database

[kontrabass]

Ok, I dug up the bug for this issue and applied the 'patched file'.

http://www.vbulletin.com/forum/showthread.php?p=1032024#post1032024

I've triple-checked that the file is uploaded and replaced the old, but I still get the exact same error... Am I going nuts?

[Steve Machol]

I'm wondering where this is coming from:

WHERE forumid IN (N; ) AND

To troubleshoot this, remove any hacks and disable your plugins, then see if you still have this problem.

If so, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.

[kontrabass]

Steve,

I don't have any hacks/plugins installed on my fresh upgrade yet. It's the same error experienced by this user, who got it to work by deleting a string "N;" from his subscriptions table, forums field:

http://www.vbulletin.com/forum/showpost.php?p=1052082&postcount=34

Sorry for cross-posting - didn't find the other thread till after I started this one. Feel free to wipe this thread.