Hi,
When I want merge two user I got the problem.
Please how can I fix the problem?
Regards,
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/usertools.php?do=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
Regards,
Comment