Forum Tool merge users
 

Hi,

When I want merge two user I got the problem.

Code:
Database error in vBulletin 4.0.0:

Invalid SQL:
UPDATE user SET
posts = posts + 27,
reputation = reputation + 41 - 10,
lastvisit = IF(lastvisit < 1262428817, 1262428817, lastvisit),
lastactivity = IF(lastactivity < 1262444501, 1262444501, lastactivity),
lastpost = IF(lastpost < 1262444500, 1262444500, lastpost),
pmtotal = pmtotal + 2,
pmunread = pmunread + 0,
gmmoderatedcount = gmmoderatedcount + ,
joindate = IF(joindate > 1252109233, 1252109233, joindate),
ipoints = ipoints + 0,
warnings = warnings + 0,
infractions = infractions + 0,
friendcount = 1
WHERE userid = 14960;

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 '
joindate = IF(joindate > 1252109233, 1252109233, joindate),
ipoints = ipoin' at line 9
Error Number : 1064
Request Date : Saturday, January 2nd 2010 @ 10:03:39 AM
Error Date : Saturday, January 2nd 2010 @ 10:03:39 AM
Script : http://www.xx.com/vb/admincp/usertoo...=reallydomerge
Referrer : http://www.xx.com/vb/admincp/usertools.php?do=domerge
IP Address :
Username : admin
Classname : vB_Database
MySQL Version : 5.0.87-community
Please how can I fix the problem?

Regards,

:)