I have been having an issue with MySQL errors during various subscription functions. The Subscriptions scheduled task no longer runs and I am also unable to deactivate/modify any existing subscription.
The following is the error I get running the Subscriptions task.
I have disabled ALL installed products and this error remains.
I tried executing the MySQL code directly in the MySQL engine and also get an error message about the code being invalid:
DELETE FROM access
WHERE forumid IN (0,) AND
userid = 4160;
Any ideas/help desperately needed.
The following is the error I get running the Subscriptions task.
Code:
Database error in vBulletin 3.5.2: Invalid SQL: DELETE FROM access WHERE forumid IN (0,) AND userid = 4160; 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 = 4160' at line 2 Error Number : 1064 Date : Friday, December 9th 2005 @ 06:56:14 PM Script : [URL="http://www.tacticalgamer.com/admincp/cronadmin.php?do=runcron&cronid=7"]http://www.tacticalgamer.com/admincp/cronadmin.php?do=runcron&cronid=7[/URL] Referrer : [URL="http://www.tacticalgamer.com/admincp/"]http://www.tacticalgamer.com/admincp/[/URL] IP Address : <removed> Username : <removed> Classname : vb_database
I tried executing the MySQL code directly in the MySQL engine and also get an error message about the code being invalid:
DELETE FROM access
WHERE forumid IN (0,) AND
userid = 4160;
Any ideas/help desperately needed.
Comment