**** I am using the latest 3.7.5 version ****
If you try to phisically delete thread/post with Thanks received on it, you will get the following error:
Code:
Database error in vBulletin 3.8.1:
Invalid SQL:
UPDATE user
SET thankedcount = thankedcount - 1
WHERE userid =
LIMIT 1;
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 'LIMIT 1' at line 4
Error Number : 1064
Request Date : Friday, June 5th 2009 @ 09:59:15 AM
Error Date : Friday, June 5th 2009 @ 09:59:15 AM
Script : http://zonablackberry.com.ve/forum/inlinemod.php?t=2722&p=&postids=152213
Referrer : http://zonablackberry.com.ve/forum/inlinemod.php?threadid=2722&p=
IP Address :
Username : Master Chief
Classname : vB_Database
MySQL Version : 5.0.77-community-log
How to reproduce it?
Well you can take a reply in any thread with thanks received and try to phisically delete it... it will give you that error, if you choose flexible delete it will not give an error or if you manually delete the thanks given then you will be able to delete it phisically
