hey can you make the script so the database username doesnt have to be the same, i got plesk control pannel. and it wont let me put the same user name :(

i have 2 board version 2.2.9
now i want to merge and i received the following error

Database error in vBulletin Control Panel 2.2.9:

Invalid SQL: INSERT INTO userfield
(userid,field1,field2,field3,field4,importuserid,i snew)
VALUES
('2475',
'',
'',
'',
'',
'8',1
)
mysql error: Unknown column 'field1' in 'field list'

mysql error number: 1054

It is possible like when the two database merge if the user using same email then they merge if not use as username[imported] ?

This is exactly what I needed. I was going to write a script of my own, but this seems like it will do everything.

I just hope it works.

Uhmm Looks like it doesn't work if you've deleted the user fields that comes with vbulletin. You can however replace this:

with this:

and hopefully it will work, however, you will lose the userfields data when you merge the databases.

ok I need some help here.

I've enhaced the script a little bit. Now you can choose if you want to auto merge users with the same username, and you can choose a database to merge with a different password and a different hostname.

Please tell me if you encounter any problems, so I can update the first post.

Great.

Maybe I'll try this hack with 2 forums each many thousands posts, user and threads ;)

Regards.

When I go to start the import, I get:

Warning: Access denied for user: 'apache@localhost' (Using password: NO) in /usr/local/psa/home/vhosts/nintendonet.com/httpdocs/forums/admin/db_mysql.php on line 32

Are you sure you typed the login information for the second database?

No, it wouldn't let me. As soon as I selected the vB Merge tool from the list, and clicked submit, it gave me an error..