Merge Users - database error inserting into blog_user

[Spinball]

So I get an error like this when I merge users.
Only recently started happening, but then it could be that I only recently started merging users with blogs.

Database error in vBulletin 3.8.2:

Invalid SQL:
INSERT INTO blog_user
(bloguserid, memberblogids, options, options_buddy, options_ignore, options_member, options_guest, subscribeown, subscribeothers, memberids)
VALUES
(597759, '597759', 0, 0, 0, 0, 0, 'none', 'none', '597759');

MySQL Error : Duplicate entry '597759' for key 1
Error Number : 1062
Request Date : Monday, August 13th 2012 @ 10:00:24 AM
Error Date : Monday, August 13th 2012 @ 10:00:52 AM
Script : http://www.avforums.com/forums/admin...=reallydomerge
Referrer : http://www.avforums.com/forums/admin...php?do=domerge
IP Address : 78.129.246.10
Username : Stuart Wright
Classname : vB_Database_Slave
MySQL Version : 5.0.95-log

We're on vB 3.8.2 and vBlog 2.0.2
Help!

[Paul M]

Is that on just one particular user, on merging any users.

[Spinball]

Any users. Well twice it has happened. But it seems to me that each time both users had blogs, and there is a bug in the merge process under these conditions.

[Paul M]

Given thats an older version of both vB and the blogs thats quite possible.

The quickest (tho possibly not ideal) fix would be to simply change that INSERT to an INSERT IGNORE.