MySQL error while merging users Issue Tools
issueid=22031 Sun 13th May '07 9:23am
vBG.com Team
MySQL error while merging users
You get this error when you try to merge two users in 3.6.6:
Code:
Invalid SQL:

INSERT IGNORE INTO userlist (userid, relationid, type) VALUES(9284, CONCAT(buddylist,, 'buddy'),
(9284, ''), 'buddy');

MySQL-Fehler : 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 ' 'buddy'),
(9284, ''), 'buddy')' at line 1
Fehler-Nr.   : 1064
Issue Details
Issue Type Bug
Project vBulletin
Category Admin Control Panel
Status Fixed (Closed)
Priority 5 - Medium
Affected Version 3.6.6
Fixed Version 3.6.7
Users able to reproduce bug 5
Users unable to reproduce bug 0
Attachments 0
Assigned Users (none)
Tags (none)

Mon 14th May '07 1:11pm
Former vBulletin Developer
  
Fixed in the package for those experiencing it, you just need to re-upload includes/class_dm_user.php to fix it.
Reply
Wed 16th May '07 4:31am
New Member
  
I probably didn't understand your instructions.

I re-uploaded the file from the vb 3.6.6 that I initially downloaded from my member account. The problem hasn't been fixed.

Should I download this file from somewhere else?
Reply
Wed 16th May '07 5:32am
New Member
  
OK. Downloaded v3.6.7, which solved the problem.

Thank you!
Reply
This petition for a change to Working as Designed was rejected
Wed 16th May '07 5:33am
New Member
  
Applied "Petition for status change".
Reply