[yingzhou]

I have this error when I delete a thread:

Database error in vBulletin 3.6.7:

Invalid SQL:

UPDATE user SET
credits = CASE WHEN userid IN (0,1) THEN credits + -6.8
WHEN userid IN (0,3) THEN credits + -16.5
, posts = CASE WHEN userid IN (0,1,3) AND posts > 1 THEN posts - 1
ELSE 0 END
WHERE userid IN (0,1,3);

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 ' posts = CASE WHEN userid IN (0,1,3) AND posts > 1 THEN posts - 1
ELSE 0 END
' at line 4
Error Number : 1064
Date : Sunday, July 15th 2007 @ 06:07:37 PM
Script : http://pltho.net/forum/inlinemod.php...46,47,43,45,44
Referrer : http://pltho.net/forum/inlinemod.php?forumid=31
IP Address : 61.163.92.190
Username : yingzhou
Classname : vb_database