Announcement

Collapse
No announcement yet.

I can't merge

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] I can't merge

    Hello,

    I'm trying from a long time to merge tow users together, but I can't and there a message show.

    Database error in vBulletin 4.1.5:


    Invalid SQL:
    UPDATE user SET
    posts = posts + 149,
    usertitle = '<font color=\"#000000\">VIP</font>',
    reputation = reputation + 1476 - 10,
    lastvisit = IF(lastvisit < 1314048613, 1314048613, lastvisit),
    lastactivity = IF(lastactivity < 1314048613, 1314048613, lastactivity),
    lastpost = IF(lastpost < 1314047932, 1314047932, lastpost),
    pmtotal = pmtotal + 8,
    pmunread = pmunread + 0,
    gmmoderatedcount = gmmoderatedcount + ,
    joindate = IF(joindate > 1307178185, 1307178185, joindate),
    ipoints = ipoints + 0,
    warnings = warnings + 0,
    infractions = infractions + 0,
    friendcount = 0
    WHERE userid = 938;


    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 > 1307178185, 1307178185, joindate),
    ipoints = ipoin' at line 10
    Error Number : 1064
    Request Date : Monday, August 22nd 2011 @ 08:28:17 PM
    Error Date : Monday, August 22nd 2011 @ 08:28:18 PM
    Script : http://www.xxxxx.com/vb/admincp/user...=reallydomerge
    Referrer : http://www.xxxxx.com/vb/admincp/user...php?do=domerge
    IP Address :
    Username :
    Classname : vB_Database
    MySQL Version : 5.0.92-community

    could help me please

    Thank you
    http://www.albrens.com

  • #2
    The user table should not have a field called ipoints. I suspect you have or had a plugin that deals with ipoints. I suspect correcting the problem you are experiencing will require removing said plugin and deleting any fields in the user table which were added by the plugin.

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X