undertable99
Customer
Hi there,
I have install superpm into my 4.2 vb site and after looks fine but when i do my moderating posts work in my ACP it gave me this error.
When i disable it everything turn normal. Error happens in the script modcp and i have .htaccess password protected for my admincp and modcp.
PS: i tried disabled all other mods except for "superpm", still the same error.
I have install superpm into my 4.2 vb site and after looks fine but when i do my moderating posts work in my ACP it gave me this error.
Database error in vBulletin 4.2.0:
Invalid SQL:
UPDATE vb4user
SET posts = posts +
CASE
WHEN userid IN (0,) THEN 1
ELSE 0
END
WHERE userid IN (0,);
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 ') THEN 1
ELSE 0
END
WHERE userid IN (0,)' at line 4
Error Number : 1064
Request Date : Sunday, October 13th 2013 @ 03:25:44 PM
Error Date : Sunday, October 13th 2013 @ 03:25:44 PM
Script : http://website.com/modcp/moderate.php?do=doposts
Referrer : http://website.com
IP Address : 183.90.103.155
Username : *******
Classname : vB_Database
MySQL Version : 5.1.56-log
When i disable it everything turn normal. Error happens in the script modcp and i have .htaccess password protected for my admincp and modcp.
PS: i tried disabled all other mods except for "superpm", still the same error.