vBulletin Merge Tool for v2.2.x [Archive]

JulianD

11-17-2002, 10:00 PM

Well, I did this for a friend and I saw some request for this tool before, so here you got.

My code is based on the import scripts that you found on vbulletin.com.

What it does?
- Merge: users, forums, threads, posts, polls, PMs and attachments of two vBulletin databases.
- It allows to associate usernames with current vBulletin users, to prevent duplication

Both databases should be in the same server, and use the same password.

If there's a duplicated name in both databases, the script will postfix the username from the database you're merging with something like: [imported]. So you probably will find users that looks like username[imported] after the merge. To solve this problem of two usernames being one person, there's a tool in the script to merge users individually.

New version
- The database to merge can now have a different host/username/password. *
- Ability to auto merge users with the same username (to avoid 4000 users with the [imported] thing. :p) *
- You can now skip the forum merging, and use the tool only to merge users.
- The poll bug seems to be fixed now. Post your feedback.

Installation:

Simply upload the attached file to /forum/importers/ and go to your Admin CP > BB Import Systems and choose vBulletin Merge Tool for v2.2.x.

Note that this script requires vBulletin 2.2.7 (or newer) to work. I have tested it with 2.2.6 but you need to upgrade the file /forum/admin/bbimport.php to the version you found on vBulletin 2.2.7 or newer.

Important Information:
This merger is beta! You should backup everything before starting. Use it under your own risk!

I decided to reopen this thread with a new version of this merger. I hope it fixes all the problems with previous versions.

REMEMBER:

If you're going to merge two database that are located on the same host, you SHOULD use a different hostname for both database.

For example:

If you have 'localhost' configured as your $servername variable on the admin/config.php file, and you want to merge a database stored on the same server, you should use something like '127.0.0.1'. Another example... If you have $servername configured to 'vbulletin.org', and you want to merge a database located on vbulletin.org, use the IP address for that server instead... In this case '205.214.66.221'. Get it?

Sorry, I'm not very good with english and it's very hard to explain this. I hope you've understood this.

ZiRu$

11-17-2002, 10:55 PM

Nice Idea....useful for users that join under multiple names....but i wont be having that problem on my new board

JulianD

11-17-2002, 11:00 PM

Thanks for your comments, but that's not the main purpose of the merger. You can merge two vBulletin installations into one.

zachb

11-17-2002, 11:04 PM

That is awesome! I know many people have been waiting for this. Great job!

Erwin

11-17-2002, 11:07 PM

Well done! :) A vB to vB importer has been requested for a looooooong time.

Brad

11-17-2002, 11:14 PM

w00t, this will be useful! :)

[email protected] vbmenu_register("postmenu_323249", true);

11-17-2002, 11:40 PM

Anyone used this yet? Outcome?

Mystic Gohan

11-18-2002, 12:01 AM

I will test this right now I have two different databases on my HD so I will test quick

JulianD

11-18-2002, 12:22 AM

Please post your results here :D Any comments/feedback/bug reports is appreciated.

Mystic Gohan

11-18-2002, 12:42 AM

I got it to work w00t! I accually did it. wow this is so kool thanks much for the great hack

JulianD

11-18-2002, 01:31 AM

Nice to hear that :)

ManagerJosh

11-18-2002, 03:35 AM

This is superb! I think this will be made into an official import script sometime soon :p

JohnWoo

11-18-2002, 06:08 AM

great work... I w8 this hack a long time.... Thanks one more...

Marshalus

11-18-2002, 07:24 AM

OH SWEET MOTHER OF EVERYTHING HOLY!

Exactly what I've been needing for a long time.

Marshalus

11-18-2002, 08:13 AM

Worked like a charm, the whole thing went off without a hitch.

Edit: The poll import is messed up, it doesn't apply to the right thread. Not a horrible thing, but kind of annoying.

JulianD

11-18-2002, 12:09 PM

Originally posted by Marshalus
Worked like a charm, the whole thing went off without a hitch.

Edit: The poll import is messed up, it doesn't apply to the right thread. Not a horrible thing, but kind of annoying.

I'll take a look :)

Dean C

11-18-2002, 05:42 PM

Looks awesome..

Excellent idea and its great at last that this has been done

Much credit to you sir

Touché

- miSt

FleaBag

11-19-2002, 11:59 PM

Any luck on the polls front?

JulianD

11-20-2002, 12:37 AM

I'll work on the polls tonight.... I only have two databases, one of 16MB and another of 60MB..... I'll try to play with both databases and see how the polls are merged.....

hypedave

11-20-2002, 05:00 AM

I cant believe this was to easy to run. I have been trying to write something like this for almost a year now, only thing I came close to was user to user merge. Great job you have done man,

Merjawy

11-20-2002, 08:03 AM

better late than never.. thanks dude for this script

Mr L

11-20-2002, 11:18 AM

Fantastic work!!!!

I have run it on my test board and it worked like a dream. Thank you for this.

ModshackUK

11-20-2002, 02:36 PM

I would love a script that would allow me to import the posts from one user to another user on the same forum ?

HM

JulianD

11-20-2002, 05:45 PM

Originally posted by ModshackUK
I would love a script that would allow me to import the posts from one user to another user on the same forum ?

HM

You can do this with my script... Do not start the merge, instead, use the utility you found at the bottom of the start page.

Check the attachment.

ModshackUK

11-20-2002, 10:33 PM

Yeah I figured that bit out shortly after posting :) nice work.

Would be nice if you could choose which forums got imported etc.

One thing I did notice was that my post count never increased even though I have more posts now ?

HM

JulianD

11-20-2002, 11:18 PM

Originally posted by ModshackUK
One thing I did notice was that my post count never increased even though I have more posts now ?

Umh... My post count is increasing normally in some merged forums. If you mean that your post count was not increased after the merge, maybe it's because you didn't run Update Counters.

Storm

11-21-2002, 02:26 AM

You should put a big red disclaimer on this hack, someone I know is planning to do this:

There's a new hack that allows Database mergers from multiple vBulletins, and I JUST happen to have an old back up of the old site's database from when there was about 30,000 to 40,000 posts...So what do you think?? I think we oldies deserve this, we EARNED those posts there, and bumping up the site to almost 150,000 posts would be a nice bonus...

PLUS, all of those old members who don't even know about this NEW Game Quest that joined the OLD Game Quest can be updated on the new situation...

Bonus, eh?? I just hope the hack goes smoothly...

EDIT: Plus, your old accounts can be merged with your NEW accounts, meaning I legitimately get back about 5,500 lost posts...

Storm can not sue for that, it\'s all of YOUR intellectual property...Imagine the size of post about the post above you after the merger?!?! Some stuff will have to be merged manually, but that\'s why we got staff
He was my co-admin way back, he recently got upset with me and left the forum to start his own, now he's going to merge my old database with his current one...

I'm not 100% sure how this hack works, but if it can do this, you can count on trouble...

hypedave

11-21-2002, 12:18 PM

Hey I created a new poll, then when I voted on the new poll, the new poll results showed up in an old poll.

JulianD

11-21-2002, 03:11 PM

Yes. This problem has been reported, and I'm working on it... I've been really busy lately with almost no-time for this script.

I'll try to fix the problem as soon as possible!

hypedave

11-21-2002, 07:06 PM

oh ok, thanks I just wanted to make sure I wasnt going crazy or anything, could it be the way polls are being imported post id's are being associated with the current post id's

Mr L

11-21-2002, 07:32 PM

I have just used this in a live setup. Merging a sister forum to the one that I currently have. The seconary forum only had about 600 users and 8000 posts compared to the current one that had 80000 odd posts.

The results, 100% perfect.

The user merger is a God send with multiple ID's.

I cannot rate this hack high enough 10/10.

JulianD

11-22-2002, 02:14 AM

I'm glad to hear that.

Right now, the script is in beta, so please, check your forums... Currently, there seems to be a bug with the poll merger.

I have reproduced the problem in my localhost forums, and I'm hunting for the bug right now!

kmfdm_kid2000

11-22-2002, 11:52 AM

Originally posted by Storm
[B]He was my co-admin way back, he recently got upset with me and left the forum to start his own, now he's going to merge my old database with his current one...

Actually, you unfairly De-Admined me, and that's when all of the users saw that and crossed over...Now they can get back all that they worked for...But let's not get into that here, I just wanted to clear the air, since you love to lie...

I'm not 100% sure how this hack works, but if it can do this, you can count on trouble...

Hopefully it DOES work...It's our intellectual Property, WE wrote it, your stuff's gonna just get deleted...

Anyway...

I applaud you for this hack...You've done us a great service in gaining back our lost history...I thank you, and my community thanks you...We worked hard for those posts, only to have that guy take it all away from us in the end...He's upset because we started a new site, and abandoned his...I will be implimenting this hack soon, and I'll let you know how it goes...Considering I paid for part of the old license, and none of his intellectual property will be carried over, I think whatever transpires will be nothing illegal...

He didn't post that stuff, WE did...Nothing in the License agreement states anything against any of this, and most of the old stuff is just going into archives anyway...

Ahhh, to relive the good ol' days once again ;)

ModshackUK

11-22-2002, 12:44 PM

Actualy the posts remain the property of the site and its owner so if you do decide to merge his database into yours then you are breaking the copyright laws, and I would recomend he takes it to a court to sort out.

I had this a while back and was advised I had grounds to take legal action against the person(s) who did it. the site in question was imediately removed from the server it was hosted on.

The domain name owner provides the site on the understanding that all the content of the site is the property of him regardless of who posted it.

You were just an admin and not holding the position of owning the domain and so if you do this then he can simply contact your domain host and have your site removed for theft of content.

Its the same as me importing my posts from here into my own bulletin board, it just aint going to happen.

BTW you also import his members who may not want to go to your site, this also includes all thier PRIVATE MESSAGES as well as other personal info that they may not wish YOU to have access to. Each of them can activly prosecute you for theft of their intelectual property as the importer imports all the threads and members and does not distinguish them, this means that you have already done the dead before you delete them so the crime has already been commited.

By holding a copy of his database he has grounds enough there to prosecute you for unlawfull theft of his property.

So dont break out the champagne out yet m8

HM

FleaBag

11-22-2002, 03:58 PM

I had this situation about a year ago. About 1000 members on my site were from a UBB, before I converted to vBulletin. An admin of my site [who paid for neither the UBB, vB, hosting or domains] left the site in protest over banner ads, and when he later decided to return found he wasn't an admin, started threatening to start his own site with the UBB backup. He had no legal basis to stand on, not that I'm saying law and morality are always the same thing.

FleaBag

11-22-2002, 04:35 PM

Whoa installed this just now, excellent for merging users accounts. :D Thanks!

FASherman

11-23-2002, 02:05 AM

Do the two database schemas have to be identical?

For instance, a highly hacked production forum with extra fields in tables and a plain, unhacked out-of-the-box test forum. How does this util handle that situation, if it does at all?

JulianD

11-23-2002, 02:17 AM

I haven't tested it with hacked databases, but it should work fine.

Let me know if you have any problem running the script with hacked databases.

Mr L

11-23-2002, 08:48 AM

Originally posted by FASherman
Do the two database schemas have to be identical?

For instance, a highly hacked production forum with extra fields in tables and a plain, unhacked out-of-the-box test forum. How does this util handle that situation, if it does at all?

I can answer this one... :)

The database I merged with a hacked one, but with different hacks then the destinaton database. It was also a couple of revisions of vBulletin earlier.

I merged it into a hacked database as well. As an example, not active as I have removed the PHP, the database they were merged into had stuff like the Quiz and the Store installed. They also have the Awards installed and the user accounts that were merged worked fine with the active destination accounts that were award enabled.

Harvey.

FASherman

11-23-2002, 10:33 AM

Your answer would seem to indicate it works, but how? Does it drop the extra fields when populating the target database? And if the target has extra fields itself, does it populate them based on the field default values?

JulianD

11-23-2002, 10:56 AM

No, the script will only import known data from the database. If you have another tables/fields in the database, the script will be unable to see those fields or tables..

Mr L

11-23-2002, 11:49 AM

Apoligies! I read this as will it work on the import if you had hacked a database and were using a non "out of the box" version of vBulletin.

hypedave

11-23-2002, 01:47 PM

any update on the Polls bug?

JulianD

11-23-2002, 03:38 PM

Originally posted by hypedave
any update on the Polls bug?

I think I got it....

Test the new version you found in the first post and tell me your comments.

hypedave

11-23-2002, 04:05 PM

You wouldnt by any chance have a seperate fix for the polls bug would you??

JulianD

11-23-2002, 04:45 PM

You mean, a script to fix a merged database with the poll bug?

No, that´s not possible, i´m afraid.

You should remerge the databases. Sorry for the disadvantage.

freeshares1

11-25-2002, 12:56 AM

i am getting the following any thoughts??? I have changed the file to 2.28 as well.

Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: SELECT COUNT(*) AS count FROM 231102.sql.user
mysql error: You have an error in your SQL syntax near '231102.sql.user' at line 1

mysql error number: 1064

Date: Sunday 24th of November 2002 10:06:31 PM
Script: http://www.jokersrewards.com/forum/forum/importers/bbimport_vb2.php
Referer: http://www.jokersrewards.com/forum/importers/bbimport_vb2.php

JulianD

11-25-2002, 01:17 AM

You must have the vb database as a real database, not as a dump file. Load the dump to mysql and use the database name instead.

Omar_2002

11-25-2002, 07:39 AM

Does this script allow us to merge only the users from the second database?

Thanks

- Omar

JulianD

11-25-2002, 05:26 PM

Users, forums, threads, posts, polls and attachments.

Omar_2002

11-25-2002, 05:39 PM

Sorry if I didn't understand your reply correctly.

Does that mean that the script allows you to select which of those things (Users, forums, threads, posts, polls and attachments) to import, or do we "have-to" merge all of them?

Basically what our forum users want is *only* to merge members from the second forum.

Please could you tell me if the script supports that.

Thanks again :)

- Omar

JulianD

11-25-2002, 05:46 PM

Yeah.... Basically, the script will merge everything, but it won't let you choose what to merge...

PM me and I will made a custom version for you, that only merge users (with PMs, right?).

It's something really easy to do... you just have to comment the rest of the merge process, like forums, threads, posts and attachments, and finally, do the DB clean process.

hypedave

11-25-2002, 10:26 PM

Originally posted by JulianD
PM me and I will made a custom version for you, that only merge users (with PMs, right?).

could you possiblt throw that in your next release by anychance?

JulianD

11-25-2002, 10:57 PM

Well... You want it too? Let me see what can I do :)

hypedave

11-25-2002, 11:52 PM

sure would be nice, also hey what about like when merging an old forum to a new forum, specifying a forum location for the old forum to be merge. Like I noticed on the hack, it puts the merge forums on the forum, but it makes everything all out of order then you have to like rearrange your forums back in order, hope can kinda understand what im trying to say, lol ... got to many things going at one time at the moment

JulianD

11-26-2002, 12:27 AM

Originally posted by hypedave
sure would be nice, also hey what about like when merging an old forum to a new forum, specifying a forum location for the old forum to be merge. Like I noticed on the hack, it puts the merge forums on the forum, but it makes everything all out of order then you have to like rearrange your forums back in order, hope can kinda understand what im trying to say, lol ... got to many things going at one time at the moment

Hi, I just added a piece of code to skip the forum merging... That means, you can now use the merger, only for the users, and not the forums, threads, posts and attachments.
Check the first post.

About your second request, well... It is possible, but it would require some modifications to the script, and I don't have enough time right now to do it... sorry :( ... anyway, it's not too difficult to re arrange the forums and re apply some permissions :)

hypedave

11-26-2002, 12:48 AM

did you update the zip file in the first post? If so I havent received my hack update email yet.

Originally posted by JulianD
it's not too difficult to re arrange the forums and re apply some permissions :)

Yeah it aint difficult at all, but when you have database A has bout oh lets say 100 forums and needs to be merged with database b that has about 120, that can get very time consuming moving 100 forums around if you get the point, lol anyways it was jus a suggestion, you've done good so far, keep up the good work

JulianD

11-26-2002, 12:56 AM

Oh, yes... I updated the ZIP in the 1st post, but I didn't send an update to the hack. :)

Raptor

11-27-2002, 06:14 AM

do BOTH have to be 2.2.x or just the forum you are running the script from (importing to)

JulianD

11-27-2002, 03:16 PM

Yeah, only the forum where you're running the script. As long as the original database structure is fine, the script should run without any problem.

Let me know if you have any problem.

Neo

11-27-2002, 09:09 PM

It would be nice if you could transfer from one server to another.

JulianD

11-27-2002, 10:28 PM

Yeah, i've been thinking about it... Maybe I can do it for the next weekend.

Neo

11-27-2002, 11:13 PM

Guess im screwed.. I need it tonight >__<

Anyways do you know a good way to tranfer one db to another that arnt on the same server?

freeshares1

12-01-2002, 08:16 AM

I cant make both usernames the same. using the plesk control panel.

Is ideas?

JulianD

12-01-2002, 03:57 PM

Originally posted by freeshares1
I cant make both usernames the same. using the plesk control panel.

Is ideas?

I guess you're asking if you can merge two users into one with the hack.... Yes, you can :) See this post (https://vborg.vbsupport.ru/showthread.php?postid=324027#post324027).

freeshares1

12-01-2002, 04:30 PM

Originally posted by JulianD

I guess you're asking if you can merge two users into one with the hack.... Yes, you can :) See this post (https://vborg.vbsupport.ru/showthread.php?postid=324027#post324027).

No,

What i have is 2 database

1/ the new one jokersnetwork
2/ the old one i want to merge into the above called old

The problem i have is that according my my host says that both databases cannot have the same username. So database 1 has username "jokers" which is what is in the config.php file and database no.2 has a username in phpadmin of "joker"

My question is how can i make this migration work? because my host says that using pleask (control panel) i cannot have the same database username for 2 different databases.

Below is the error i get

Database error in vBulletin Control Panel 2.2.7:

Invalid SQL: SELECT COUNT(*) AS count FROM old.user
mysql error: Access denied for user: 'jokers@localhost' to database 'old'

mysql error number: 1044

Date: Sunday 01st of December 2002 01:47:32 PM
Script: http://www.jokersrewards.com/forum/forum/importers/bbimport_vb2.php
Referer: http://www.jokersrewards.com/forum/importers/bbimport_vb2.php

Any idea's or suggestions?

Raptor

12-01-2002, 08:49 PM

could you make a mass user merge for those names that have the [imported] tag

im asking cus I have 3500 members that have [imported] and i'll be sitting here for weeks doing it manually :)

thanks

JulianD

12-02-2002, 01:13 AM

Originally posted by Raptor
could you make a mass user merge for those names that have the [imported] tag

im asking cus I have 3500 members that have [imported] and i'll be sitting here for weeks doing it manually :)

thanks

Well... That's why you have to associate usernames before starting the users merge. It's a complicated process, but it's required...

Another option is to modify the script to automatically merge two users when they have identical usernames... It's possible, but it's not recommended because it could merge two different users into one.... tell me if this solution could work for you.

JulianD

12-02-2002, 01:15 AM

Originally posted by freeshares1

No,

What i have is 2 database

1/ the new one jokersnetwork
2/ the old one i want to merge into the above called old

The problem i have is that according my my host says that both databases cannot have the same username. So database 1 has username "jokers" which is what is in the config.php file and database no.2 has a username in phpadmin of "joker"

My question is how can i make this migration work? because my host says that using pleask (control panel) i cannot have the same database username for 2 different databases.

Below is the error i get

Database error in vBulletin Control Panel 2.2.7:

Invalid SQL: SELECT COUNT(*) AS count FROM old.user
mysql error: Access denied for user: 'jokers@localhost' to database 'old'

mysql error number: 1044

Date: Sunday 01st of December 2002 01:47:32 PM
Script: http://www.jokersrewards.com/forum/forum/importers/bbimport_vb2.php
Referer: http://www.jokersrewards.com/forum/importers/bbimport_vb2.php

Any idea's or suggestions?

Ohhh sorry.... Now I understand you...

Unfortunately at this time it's not possible to merge two database without the same user and password. I'll try to release a new version with this ability for you guys.

Raptor

12-02-2002, 08:13 PM

Originally posted by JulianD

Well... That's why you have to associate usernames before starting the users merge. It's a complicated process, but it's required...

Another option is to modify the script to automatically merge two users when they have identical usernames... It's possible, but it's not recommended because it could merge two different users into one.... tell me if this solution could work for you.

i've already imported and have just over 3000 *[imported] users

could you right a script so merge all these automatically AFTER all the importing and merging has been done

the *[imported] needs to be source and * needs to be destination

-=dm=-

12-03-2002, 11:02 PM

hey Thanx man :):):)

Now I got a clean install of 2.2.9 and imported everything from 2.2.4 in no time :)

this is one of the best hack!!!!!

drives fast

12-17-2002, 07:15 PM

yea....I am looking at the same situation....I have over 35,000 members and I want to merge another database that has say 26,000 and I know there are duplicates. I cannot do 355 pages of setting user ID's....can you make this auto associate by username and case matters?

I have no need for posts, threads and stuff like that.....just members.

also...what happens if there are members in special usergroups? on the two forums there are the same usergroups but they are different usergroup ID's

I know....can it import and auto associate by usergroup alone? because I really only need the people from one specific usergroup to merge into the other database.

JulianD

12-17-2002, 11:12 PM

OK I have some free time today... I'll do the modification right now to the script, to allow you to merge users with the same username.

Now, if there are users in special usergroups, they will be set to the Registered usergroup. But it's easy to modify the script to add special usergroups :) I'll teach you how, if you wish.

drives fast

12-18-2002, 02:34 AM

you are most kind...I would appreciate you teaching me how.

94supratt

01-22-2003, 08:15 PM

Originally posted by JulianD

Ohhh sorry.... Now I understand you...

Unfortunately at this time it's not possible to merge two database without the same user and password. I'll try to release a new version with this ability for you guys.

I have 2 databases. One for my forum and one from a forum I am importing. I know the user names match for some users but I DO NOT know if the passwords do. Will this be a problem?

JulianD

01-22-2003, 09:25 PM

If the passwords for both databases are different, yes... there will be a problem... Sorry, I don't have time right now to enhance this script :( i've been very busy with my site right now.

94supratt

01-22-2003, 09:28 PM

Originally posted by JulianD
If the passwords for both databases are different, yes... there will be a problem... Sorry, I don't have time right now to enhance this script :( i've been very busy with my site right now.

When you say problem what exactly will happen if I try to merge and have users with different passwords?

JulianD

01-22-2003, 09:40 PM

The problem is that the script will be unable to connect to your second database.... and will display an error screen. :(

94supratt

01-23-2003, 07:05 AM

Originally posted by JulianD
The problem is that the script will be unable to connect to your second database.... and will display an error screen. :(

I think you may have misunderstood my question. The DATABASE PASSWORDS and USER are the SAME. Its my individual FORUM users that MAY have different passwords. Would that be an issue? Sorry for not being clear. If user passwords are not an issue then I am ready to merge :D

JulianD

01-23-2003, 01:26 PM

Oh.. .Well.. for example if you have two users with the same username, and you associate them before merging, then the posts and PMs will be merged to the user in the actual forum.

If you don't associate the users, then for every duplicated user the script will rename the merged users to something like: username[imported].

Intercept

02-08-2003, 05:32 AM

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 :(

Molok

02-27-2003, 12:36 PM

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

Darkwolf

02-27-2003, 03:44 PM

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

Lanigironu

02-27-2003, 07:32 PM

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.

JulianD

02-28-2003, 01:58 PM

Originally posted by Molok
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

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

if ($userid) {
$DB_site->query("INSERT INTO userfield
(userid,field1,field2,field3,field4,importuserid,i snew)
VALUES
('$userid',
'".addslashes(htmlspecialchars($user[biography]))."',
'".addslashes(htmlspecialchars($user[location]))."',
'".addslashes(htmlspecialchars($user[interests]))."',
'".addslashes(htmlspecialchars($user[occupation]))."',
'$user[importuserid]',1
)");
}

with this:

if ($userid) {
$DB_site->query("INSERT INTO userfield
(userid,importuserid,isnew)
VALUES
('$userid',
'$user[importuserid]',1
)");
}

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

JulianD

02-28-2003, 04:30 PM

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.

KarateKid

03-07-2003, 08:09 PM

Great.

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

Regards.

Iezugod

03-09-2003, 07:35 PM

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

JulianD

03-09-2003, 08:38 PM

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

Iezugod

03-12-2003, 02:48 PM

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..

tucklis

03-12-2003, 09:43 PM

Hi,

Thanks very much for developing this hack.

I have downloaded the beta but have had some problems. After I click "start merge", it says database initialised for import and then when I click associate users it gives me the following error:

Database error in vBulletin Control Panel 2.2.9:

Invalid SQL: SELECT COUNT(*) AS count FROM soccerpages.user
mysql error: select command denied to user: 'tucklis6@server84l.xtreme-support.com' for table 'user'

mysql error number: 1142

Date: Wednesday 12th of March 2003 11:35:19 PM
Script: http://yupz.com/forum/forums/importers/bbimport_vb2.php
Referer: http://yupz.com/forums/importers/bbimport_vb2.php

Does this mean it hasn't worked? My forum now seems to read 0 posts and threads :( What am I doing wrong?

Thanks for your time,
Kerry

JulianD

03-13-2003, 12:06 AM

Give me some time, it's a bug and I'll fix it probably today :)

tucklis

03-13-2003, 09:09 AM

Hi,

I think I may have uploaded the old version - that's maybe why I got that error. I have now uploaded the latest beta and changed the global $vbdbhostname,$vbdbusername,$vbdbpassword,$vbdbnam e; fields to match the database I'm importing from. But now I have a new one!

Warning: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/domains/yupz.com/user/htdocs/forums/admin/db_mysql.php on line 32

Database error in vBulletin Merge Tool 2.2.9:

Link-ID == false, connect failed
mysql error:

mysql error number: 0

Date: Thursday 13th of March 2003 11:02:12 AM
Script: http://yupz.com/forums/forums/importers/bbimport_vb2.php?action=start
Referer: http://yupz.com/forums/admin/bbimport.php?action=

I think this maybe because the two databases that I want to merge are both on different ips to my webspace? Do I have to include the database ip / password for both databses? Where do I edit this?

One other thing (sorry for all these questions!!), should I make all the forums names match so they merge properly?

Thanks alot,
Kerry

JulianD

03-14-2003, 02:21 AM

Today at 06:09 AM tucklis said this in Post #93 (https://vborg.vbsupport.ru/showthread.php?postid=365365#post365365)
One other thing (sorry for all these questions!!), should I make all the forums names match so they merge properly?

Thanks alot,
Kerry

Hi Kerry. Please give me some time and let me come out with a solution to this problem. :) I'm busy with some tests on school right now.

About the forums, no... The forums are not "merged" but it's easy to move all the post from one forum to another using the tools you found on the admin cp.

tucklis

03-14-2003, 08:03 AM

OK, Thanks very much!

tucklis

03-15-2003, 05:50 PM

Any more news? Sorry to be a pest but I really need this script to work!!! I think it mat just be a small alteration that is needed...

Colon33

03-15-2003, 10:38 PM

Im running vb 2.2.9.. an i get this error... I uploaded the new BBIMPORT.php but as soon as i click associate users i get the DB error.

----
Database error in vBulletin Control Panel 2.2.9:

Invalid SQL: SELECT COUNT(*) AS count FROM ndream.user
mysql error: select command denied to user: 'moguslan_mogusad@localhost' for table 'user'

mysql error number: 1142

Date: Saturday 15th of March 2003 07:31:32 PM
Script: http://www.mogusland.com/forums/forums/importers/bbimport_vb2.php
Referer: http://www.mogusland.com/forums/importers/bbimport_vb2.php
---

tucklis

03-18-2003, 11:42 AM

I have edited the following fields in the import script:

<?php
// vBulletin Merge Tool for v2.2.x
error_reporting(7);
require ("./../admin/bbimport.php");

function makehiddenfields() {
global $vbdbhostname,$vbdbusername,$vbdbpassword,$vbdbnam e;
makehiddencode("DBIPADDRESS",$vbdbhostname);
makehiddencode("DBUSERNAME",$vbdbusername);
makehiddencode("DBPASSWORD",$vbdbpassword);
makehiddencode("DBNAME", $vbdbname);

Are these variables supposed to be for the database I'm trying to import or the database I'm importing the records into?

Cheers,
Kerry

JulianD

03-18-2003, 11:09 PM

Ok, download this file again:

https://vborg.vbsupport.ru/attachment.php?s=&postid=359490

Make sure you get the NEW version. The new file (uncompressed) is about 41KB, so make sure you get the new version and not a version from your local cache. If the new file is not about 41KB, clear your browser cache.

tucklis

03-19-2003, 09:24 AM

Thank you very much for updating the hack. But I still have problems. When I click "start merge" it says "Database initialised for import."

When I click on step 2 it says "Database not selected! Warning! Restart application! (I always wanted to say that!) :)".

I think it may be to do with settings I have changes - please take a look as I was unsure what I should change here:

<?php
// vBulletin Merge Tool for v2.2.x
error_reporting(7);
require ("./../admin/bbimport.php");

function makehiddenfields() {
global $vbdbhostname,$vbdbusername,$vbdbpassword,$vbdbnam e;
makehiddencode("IPOFDBTOBEIMPORTED",$vbdbhostname);
makehiddencode("DBUSERNAME",$vbdbusername);
makehiddencode("DBPASSWORD",$vbdbpassword);
makehiddencode("DBNAME", $vbdbname);

}

// ################################################## ############################
// ok you wanted it quicly fixed, it didn't work with the same db class from vb,
// so i created another one.
class DB_Sql_merge {
var $database = "NAMEOFEXISTINGDB";

var $link_id = 1;
var $query_id = 0;
var $record = array();

var $errdesc = "";
var $errno = 0;
var $reporterror = 1;

var $server = "IPOFEXISTINGDB";
var $user = "USERNAME";
var $password = "PASSWORD";

var $appname = "vBulletin";
var $appshortname = "vBulletin (cp)";

function connect() {
global $usepconnect;
// connect to db server

I also changed the link_id to 1. Are these settings correct? Why am I getting this error :(

Thanks Julian,

I appreciate any help you can provide!

Regs,
Kerry

JulianD

03-19-2003, 08:17 PM

No... You don't need to edit the file at all. When you start the merger, you will be prompted for the details of the database to merge (you'll be asked for a host, an username, a password and the database name. You should fill those fields according to the database you want to merge.

For example, if you're merging a database located in the same server you're running vb, then the settings should be something like this:

db host: localhost
db user: user
db pass: password
db name: dbname

but if you're trying to merge a database on a different server, you should change the db host to the host name or IP address where the database is located. Note that you will need to configure your server to allow connections from other hosts (most hosting companies doesn't allow connections to the mysql server if you're not on the local server, but you can change this on your control panel, or ask your hosting company about this matter. I'm unable to provide support here).

Tell me how it goes, or contact me (again :p) if you can't merge the database.

And remember, DON'T modify the script, you don't need to do it.

tucklis

03-20-2003, 02:44 PM

I have uploaded the new version (unmodified) and when I click begin import it gives me the following error:

Database error in vBulletin Merge Tool 2.2.9:

Link-ID == false, connect failed
mysql error:

mysql error number: 0

Date: Thursday 20th of March 2003 04:39:44 PM
Script: http://yupz.com/forums/forums/importers/bbimport_vb2.php?action=start
Referer: http://yupz.com/forums/admin/bbimport.php?action=

My host says there is no reason why I shouldn't be able to connect :(

Regs,
Kerry

tucklis

03-20-2003, 03:00 PM

I just got this reply from my host:

Dear Kerry,

Thank you for your email.

This error is caused because the script is attempting to connect using sockets which isn't allowed on our system. The way to connect on our system is using the IP address of the database and tcp/ip.

What do I do now :(........?

Kerry

JulianD

03-20-2003, 03:45 PM

Can you contact me so I can see what's going on with your server configuration? I have msn icq and aim.

I can't reproduce this problem on my server, so I don't have a way to test it out.

Thanks.

tucklis

03-20-2003, 04:09 PM

Just got another reply from support, here is what they said:

------------------------------------

Dear Kerry,

Looking quickly at the script you should be able to hard code the remote database in:

var $database = "";

var $link_id = 0;

var $query_id = 0;

var $record = array();

var $errdesc = "";

var $errno = 0;

var $reporterror = 1;

var $server = "localhost";

var $user = "root";

var $password = "";

Where database would be the database name and server would be the IP address of the MySQL server and use the Database Owner details.

Unless its using the hidden fields where you should still be able to hardcode or choose the remote server. You may need to specify port 3306 for the server - simply add ,3306 after the IP address specified i.e. 213.171.111.111,3306 .

I hope this helps.

------------------------------------
Cheers,
Kerry

JulianD

03-20-2003, 04:42 PM

OK i think i've fixed the problem. Let me update the file.

tucklis

03-23-2003, 08:44 PM

Julian,

The merge has worked fine. Although I think there was a problem with the polls, it didn't seem to convert them (but this isn't such a big problem).

The only thing is most of the forum ids seemed to have changed, is this common? Any idea how to change em back?

Anyway thanks very much for creating a great hack!

Regards,
Kerry

JulianD

03-23-2003, 10:34 PM

Ummm I don't know about the polls.... When I have some time, I'll look into this.

About the forums id, yeah, those will change according to the new forums id on the board. Everything changes, just like the threadids, postids, even the userids changes....

hockyfan

03-30-2003, 03:17 AM

I just have to comment, the support and assistance I got with this hack was truely unprecedented. I received excellent support, especially considering this was on his own time and without payment etc. This hack did work very well, and I highly recommend it to anyone!

Excellent work julian, and thank you!! :cool:

h

JulianD

03-30-2003, 05:26 AM

Thanks for the kind words :) I'm glad you got it working on your forums.

tucklis

03-30-2003, 02:51 PM

Today at 05:17 AM hockyfan said this in Post #109 (https://vborg.vbsupport.ru/showthread.php?postid=375340#post375340)
I just have to comment, the support and assistance I got with this hack was truely unprecedented. I received excellent support, especially considering this was on his own time and without payment etc. This hack did work very well, and I highly recommend it to anyone!

Excellent work julian, and thank you!! :cool:

h

I have to say I second this - great work Julian, thanks!

gmtalk

03-30-2003, 08:25 PM

12-01-02 at 09:15 PM JulianD said this in Post #69 (https://vborg.vbsupport.ru/showthread.php?postid=327141#post327141)

Ohhh sorry.... Now I understand you...

Unfortunately at this time it's not possible to merge two database without the same user and password. I'll try to release a new version with this ability for you guys.

Would like to ask the progress on this.

Thanks

JulianD

03-31-2003, 12:33 AM

Hi gmtalk.

Download the lastest version from here:

https://vborg.vbsupport.ru/attachment.php?s=&postid=359490

And see if it works for you.... It *should* work using two different databases with different host/user/password... :)

gmtalk

03-31-2003, 04:41 PM

Julian,

Silly question. I DLed the one that you linked and it was the same as the one that i had there. I have been trying this out on my test databases. I am importing over 10k users and 300k messages and when it was all said and done it just duplicated my forum that I was importing into.

So now I have 2 general discussion areas with the same posts etc. Thinking that I messed it up. I restored my database back to normal backups that I had. Both the database to merge into and the db that was to be merged.

I then redid the merge as before, but this time swapped my merger and mergee< is that a word > and it did the same but to the other database this time.

Now maybe I am missing something I am not sure. Shouldnt there be two entry areas one for the to db and one for the from db? On all versions that i have DLed from here it only has the one DB entry.

My server is as follows.

DB1: User: rooter Pass: pass DBName: test1
DB2: User: rooter Pass: pass DBName: test2

of course the User and Pass are the same, just not listing them here.

John

gmtalk

03-31-2003, 04:46 PM

PS: yes i made sure that i had the right program. I am doing this from my laptop and not the desktop where i originally tried this.

So no need to clear my cache until i get home and try from the desktop.

john

JulianD

03-31-2003, 04:59 PM

Uhmmmm First, make sure you have the lastest version... No wait... I'm going to attach the lastest version here in this post, just to make sure.. :)

Ok.. Here's how it works... The database to merge into is the one you're using to run your currently vbulletin installation. You don't need to type the user / password for it, because the script have access to the database, as long as vbulletin is running fine.

Ok now, what's the host/user and password that you should fill at the start of the merge? It's the information for the SECOND database, the one you want to merge with your current vbulletin installation.

If this database is in the same server, you should fill similar values like the ones you have on your config.php. But you have the possibility to merge a database located on another server, by filling the correct host/user/pass and db name, and it should work.

Just send me a PM if you still have problems with the merger.

Here's the lastest version! :)

Link removed.

Zero Complex

04-05-2003, 08:46 PM

What tables does it exactly merge?

I have a 40mb db, and phpmyadmin keeps giving me the error when i try uploading the vbulletin.sql file that there was No SQL Query! So gonna try cleaning out some of the stuff and see what happens after.

JulianD

04-05-2003, 09:47 PM

Not sure if it's going to be helpful for you, but the script only reads the following tables:

attachment
forum
poll
post
privatemessage
thread
user
userfield

I'm not sure if it's the complete list of tables the script needs to read...

TravisH

04-07-2003, 02:09 AM

03-31-03 at 07:41 PM gmtalk said this in Post #114 (https://vborg.vbsupport.ru/showthread.php?postid=376004#post376004)
Julian,

Silly question. I DLed the one that you linked and it was the same as the one that i had there. I have been trying this out on my test databases. I am importing over 10k users and 300k messages and when it was all said and done it just duplicated my forum that I was importing into.

So now I have 2 general discussion areas with the same posts etc. Thinking that I messed it up. I restored my database back to normal backups that I had. Both the database to merge into and the db that was to be merged.

I then redid the merge as before, but this time swapped my merger and mergee< is that a word > and it did the same but to the other database this time.

Now maybe I am missing something I am not sure. Shouldnt there be two entry areas one for the to db and one for the from db? On all versions that i have DLed from here it only has the one DB entry.

My server is as follows.

DB1: User: rooter Pass: pass DBName: test1
DB2: User: rooter Pass: pass DBName: test2

of course the User and Pass are the same, just not listing them here.

John

I am running in to EXACTLY the same problem...
It is just duplicating ALL the entries in the database.

WoodiE

04-07-2003, 03:16 AM

I have vb 2.2.8 that I would like to import to a vb 2.3.0 forum, will this work since the database for 2.2.8 is different from a 2.3.0 forum database?

-WoodiE

JulianD

04-07-2003, 07:14 AM

TravisH: This problem has been reported, so I guess it could be a (very big) bug. hehehe Sorry for all the problems guys, I just don't have the time to test this script. I will however, find some time in the next few days and make some testing and improvements :)

WoodiE: No, there shouldn't be any problem. I think you can use the database schema from 2.2.0 to the newest version available. But remember that the vbulletin version where the script will be executed, should be 2.2.7 or newer, that's the only requirement.

TravisH

04-07-2003, 01:15 PM

Thank you for the reply. :)
I just used the script from your first post in this thread and found that it pretty much suites my needs other than it did not import calendar events, and has a few issues with polls.
This is a GREAT tool and I would like to congratulate you on your efforts and I wish you continued success with future development.

Thank You,

Travis

marcel-ea

04-10-2003, 01:28 AM

hello julian Thx for the hack
I have this problem its a problem with the "-"

Database error in vBulletin Merge Tool 2.2.8:

Invalid SQL: SELECT COUNT(*) AS count FROM date-basename_com.user
mysql error: You have an error in your SQL syntax near '-basename_com.user' at line 1

mysql error number: 1064

Maybe you can fix it :)

JulianD

04-10-2003, 03:12 AM

Ummm let me see what can I do :)

marcel-ea

04-10-2003, 03:14 AM

not the problem. i renamed the database.
all what i mean, is thats a litte bug :D

Ohhh i merge since 30min 2 forums with 180.000 User
and 400.000 Posts.

JulianD

04-10-2003, 03:28 AM

Nice to hear that :)

Anyway, I think I know why it's happening, I was too lazy to remove some obsolete code from the script... :p Thanks for reporting it though.

marcel-ea

04-10-2003, 04:32 AM

oh nooo

By merge Threads???!? now he give me the same thread
again and again... im now by 500000 ?!?!?

Any Ideas?

Edit:

By 6Mio. all the same thread i stop the script.....

Locust99

04-12-2003, 07:59 AM

Um... i am trying to download it... but i keep getting a corrupted zip

zajako

04-19-2003, 03:13 AM

04-10-03 at 12:32 AM marcel-ea said this in Post #127 (https://vborg.vbsupport.ru/showthread.php?postid=380018#post380018)
oh nooo

By merge Threads???!? now he give me the same thread
again and again... im now by 500000 ?!?!?

Any Ideas?

Edit:

By 6Mio. all the same thread i stop the script.....

i noticed this too. I have set it to auto refresh and am leaving it going. Its been going for almost an hour and i have around 21000 posts copying.

When it was not set to auto copy the same thread repeating thing, all of them linked to edit pages that did not exist.

I think there is a large error of sort makes it not work, cause it seemed to be stuck in a loop of sort.

gmtalk

04-19-2003, 03:42 AM

I ran into the same issues with the one thread repeating and repeating....What I did was restored both DB's back to normal and then turned magic quotes off. Once that was done I restarted the process of the merge. I successfully merged 3 sites together. Site 1:7k Users and 290k posts; Site 2: 11k Users and 410k posts; Site 3: 8300 Users and 330k posts.

All went well on the test DB's and I will be doing this on the live forums later this weekend. The only thing I wish it would do is the avatars. Try telling close to 20k users that they need to redo their avatars. I am dreading that.

Other than that it is a great Script. Thanks Julian for the help a week ago.

zajako

04-19-2003, 06:05 AM

it seems the database i told it in the merdge script got my current db cloned to it.. It totaly confused me. I might have to look at the code to see whats up, but correct me if im wrong. The database name i specify in the merdge script is the database i want to copy to that current forums.

also i don't have access to my php ini file to disable magic quotes. is there a way to de-activate it via php coding?

Marshalus

04-24-2003, 02:43 AM

Does having MySQL 4 have anything to do with this script not working? It's worked for me in the past on a MySQL 3 server.

Manik

04-24-2003, 03:36 AM

I think the beta has a big bug.. use the non-beta.

Marshalus

04-24-2003, 04:59 AM

Kiind of a serious bug don't you think :S ;)

Dan

05-02-2003, 01:47 AM

I used it and it worked great except this TINY problem we have now.

Everyone is a guest(even know they are in a usergroup)

Check what happens when they post in the attachement

Any help WILL be greatly appriciated

Dan

05-02-2003, 06:46 PM

If anyone knows the answer to above problem please tell me my forum is down because of this and I got cranky members.

/me won't be able to see any answers till sunday night

gmtalk

05-02-2003, 07:01 PM

Just a silly question. did you have backups of both systems? If so then i suggest restoring it back to normal.

personally i would have tested it out on a test site prior to a live site. but that is just me. I am still trying to iron out bugs and issues that it is creating on the test site of mine.

Dan

05-02-2003, 11:58 PM

/grumbles

I guess I'll try to restore the backup

J.C.

05-03-2003, 01:29 AM

is this hack will work for future vB3?

thanks.

Skyguide

05-21-2003, 12:42 PM

Last night i tried to run the script to import a board with 120'000 postings. The result was an overload of mysql (to many open connections, >200).

Also i was wondering that i didn't get any status back just klicked on start import and then wait to restart mysql....

Any idea ?

regards Skyguide

sweetmercifulcr

05-27-2003, 10:59 PM

Desperately need to be able to merge two boards, but on different servers. Can this be done with this import script?

Excuse me if it's been asked/answered earlier, i dont want to read 10 pages.

gmarik

06-05-2003, 04:19 PM

Respect! Great coding done, I use it every week twice!

gmarik

06-05-2003, 04:19 PM

This should be a full release hack... :sleep:

Dan

06-05-2003, 05:42 PM

no it still has bugs... like it screwed up my board last time I used it

wolfe

06-06-2003, 12:35 AM

got a weird problem i used it and imported all posts/threads/forums/privatemessages and now in the forums where the posts have imported it says

for last posts

31st December 1969 19:00 PM
by

and its got the exact same amount or threads as its got posts but also all the posts inside the thread have got

Sparkz
28th July 2002 19:22 PM This person is on your Ignore List. To view this post click [here]

Sparkz
28th July 2002 19:23 PM This person is on your Ignore List. To view this post click [here]

for all posts

Smellycat

06-08-2003, 01:44 PM

Just merged a 2000+ user database with a 1000 user database and it worked a treat have to say well done, and thank you very much!

wolfe

06-08-2003, 09:43 PM

sorted the problem out on my end i did not run the things as one i did the users then quit then did next so sorted now you da man d00d :D

99SIVTEC

06-17-2003, 04:14 AM

I've got 3 completely separate, but loosely related websites. I'm thinking of starting a large network with them in which there would only be 1 vbulletin forum. Each site would be a top level forum with their individual forums as sub forums under that.

My question is. If I merge the sites will it just place all of the forums in one large group so I can move them around as needed, or is it going to try and merge forums with the same name? Should I rename the forums before mergine so they are something like

site1_lounge
site2_lounge
site3_lounge
site1_performance
site2_perform....

ect ect so the names are all different and easy to recognize

Thanks again for all of your efforts on this hack. It's denfinetly a life saver and top notch quality.

Mikal

07-02-2003, 01:54 PM

I really need some help on this one, I'm trying to merge the old database into the new one. but as soon as I try to run the script
in admin cp

I get this error:
---------------------------------------------------------------------------------
Warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /hotel/sushi-inc_dk/WWW/forums/importers/bbimport_vb2.php on line 45
---------------------------------------------------------------------------------
Database error in vBulletin Merge Tool 2.3.0:

Link-ID == false, connect failed
mysql error:

mysql error number: 0

Date: Wednesday 02nd of July 2003 04:48:53 PM
Script: http://www.sushi-inc.dk/forums/forums/importers/bbimport_vb2.php?action=start
Referer:
---------------------------------------------------------------------------------
and I can't figure out what the problem is.

I did try the first script, but it didnt work since my databases don't have the same dbname or password, although they are on the same server.

I really hope someone here can help me :(

Thanks in advance :)

Mikal

07-02-2003, 01:57 PM

Smellycat

07-02-2003, 03:23 PM

Have you made sure both databases are of the same version? i,e 2.3.0

Mikal

07-02-2003, 05:23 PM

They should be

Mikal

07-03-2003, 02:19 PM

But it doesnt even let me run the script, in admin cp, I choose the script and try to run it, and get the error.

so any ideas?

marcel-ea

07-15-2003, 02:35 PM

Also i offer everybody 100$ cash who help me to fix the script
and merge two big forums. PM me :)

JulianD

07-15-2003, 04:48 PM

I am sorry for all the problems you're having with this script.. It was something I wrote a long time ago and I don't have the time to fix all the numerous bugs that have been appearing with the new PHP and MySQL releases.

I'm sure some of the problems (like the duplicated threads) are caused by new versions of PHP and/or MySQL.... The first releases of this script didn't have such problems... I took a look to the code a few days ago but I can't find the problem... It requires some more testing and some more time, and that's something I don't have right now :(

I'd be very happy if some of you guys can improve this script until Jelsoft officially releases something like this for vB2 and vB3.

Right now I can't take care of this script, even though I would love to fix it and post it here for the benefit of you. :(

!!!cyr0n_k0r

07-27-2003, 04:33 AM

hey, ++++ this guy

I just contacted him on AIM to ask him a question about this script and he blocked me.

I then asked him why he blocked me on ICQ and he blocked me again.

This guys an +++++++.

JulianD

07-28-2003, 03:27 AM

I didn't blocked you. I disconnected from the Internet. Anyway, I am not giving support for this hack, so if you were looking for support, I can't help you. Sorry.

!!!cyr0n_k0r

08-04-2003, 06:41 AM

bull++++ you disconnected. You were online with ICQ after you blocked me from aim.. and only disconnected AFTER I asked you why you blocked me in the first place.

Dont lie to my face +++++++.

JulianD

08-04-2003, 07:56 AM

OK Thread closed. Sorry.

JulianD

10-14-2003, 03:43 PM

I decided to reopen this thread with a new version of this merger. I hope it fixes all the problems with previous versions.

REMEMBER:

If you're going to merge two database that are located on the same host, you SHOULD use a different hostname for both databases.

For example:

If you have 'localhost' configured as your $servername variable on the admin/config.php file, and you want to merge a database stored on the same server, you should use something like '127.0.0.1'. Another example... If you have $servername configured to 'vbulletin.org', and you want to merge a database located on vbulletin.org, use the IP address for that server instead... In this case '205.214.66.221'. Get it?

Sorry, I'm not very good with english and it's very hard to explain this. I hope you've understood this.

Go to the first post... There's the attachment.

TDeath

10-19-2003, 01:55 AM

i have two vbb 2.2.8 databases on the same server. when i try to start the merge script in the control panel, i get the following error msg:

XXXXXXXXXXXXXXXXXXXXX

Warning: Access denied for user: 'p34067380@localhost' (Using password: NO) in /homepages/11/d70604821/htdocs/vbb/admin/db_mysql.php on line 34

Warning: MySQL Connection Failed: Access denied for user: 'p34067380@localhost' (Using password: NO) in /homepages/11/d70604821/htdocs/vbb/admin/db_mysql.php on line 34

Database error in vBulletin Merge Tool 2.2.8:

Link-ID == false, connect failed
mysql error:

mysql error number: 0

XXXXXXXXXXXXXXXXXXXXXX

do i have to edit something in the db_mysql.php? i tried a lot of different stuff, however nothing worked.

JulianD

10-20-2003, 01:37 AM

Are you sure you're typing the right values for the database you want to merge?

hockyfan

10-24-2003, 06:42 PM

I have my forum on my server, and a database dump of the forum I would like to merge into my forum. Is this the correct way of doing it? And where should I upload this database dump to?

Also, do both mine and his databases have to be the same version of vB? Or can his be older than mine (mine is 2.3.2)?

h

JulianD

10-24-2003, 09:54 PM

You should load your dump file to a real mysql database... before starting with the merge you should have two real database... The one you're running at the moment, and the one you want to merge.

I think it shouldn't be a problem if the version of both databases isn't the same.

Just remember, back up your data before proceed and you should be safe :)

hockyfan

10-25-2003, 10:20 PM

JulianD

10-26-2003, 02:55 AM

mysql -uROOT -p tempdatabase < myotherdump.sql

And the new database with your dump file loaded, is called 'tempdatabase'.

hockyfan

10-26-2003, 11:55 AM

Where do I enter that information?

h

Quest4DSS

11-01-2003, 02:03 AM

I am willing to pay someone if they can get this to work on a site for me.
I installed it and the merge user A to user B works but I cannot get the database to merge.
Like I said I am willing to pay (within reason) if someone can help with this.
Thanks in advance.

JulianD

11-01-2003, 02:22 AM

hockyfan: You should enter that information using SSH. Search the forums if you don't know how to do it.

Quest3DDS: I am sorry the script didn't work for you. I tested it on my local forums and it worked fine. It's a little bit tricky to start using it, but it works for me. What's the exact problem you're having?

Quest4DSS

11-01-2003, 02:43 AM

I loaded it and the merge user A and B work fine but when I do the Database merge it just sits there ans then anter about 5 minutes I get Page not found like as if I was being directed somewhere else.

Quest4DSS

11-01-2003, 02:48 AM

Maybe I am entering the info in these fields wrong.

JulianD

11-01-2003, 03:04 AM

The other values are the same database username and database password you use on config.php.

And the Database Name is the name of the database you want to merge.

Quest4DSS

11-01-2003, 03:19 AM

Yes I did that exactly like that.
Is there anyway you can look at it?

JulianD

11-01-2003, 03:29 AM

That's weird... Send me a PM with the details of your forum admin cp...

Quest4DSS

11-01-2003, 03:43 AM

You have a PM.

JulianD

11-01-2003, 04:10 AM

Read my response.

hockyfan

11-02-2003, 04:59 AM

I keep getting this error:
Database error in vBulletin Merge Tool 2.3.2:

Link-ID == false, connect failed
mysql error:

mysql error number: 0

Date: Sunday 02nd of November 2003 07:58:20 AM
Script: http://otnforums.snooboo.com/importers/bbimport_vb2.php?&action=start

h

JulianD

11-02-2003, 02:12 PM

You're not typing the right values for the database you want to merge, and hence, the script cannot connecto to it.

If you want, send me your details such as admincp login/password and username, password and database name of the database you want to merge and I should be able to tell you what's the problem.

Rampag33

11-05-2003, 01:46 PM

excellent hacc, installed

NOTE

combined 232 to 229 all users and post went over fine
attachments were corrupted.

hockyfan

11-08-2003, 11:10 PM

JulianD

11-10-2003, 06:18 PM

excellent hacc, installed

NOTE

combined 232 to 229 all users and post went over fine
attachments were corrupted.

Umm...... I'll have to take a look to the attachments routines... Sorry for that.

JulianD

11-10-2003, 06:23 PM

Due to restrictions on my server, I'm not able to create new MySQL databases. This being the case, I only have two dumps of the forums I'd like to combine, but I have no way to load them to real databases. If I sent someone the dump files, would anyone be able to do this for me?

h
Why don't you do this on your own computer? Install mysql and php, install a local copy of vbulletin, upload both databases to your mysql server and run the merge.

If you don't know how to install mysql and php and all that stuff, try to browse this forums or search on http://www.google.com ... There are plenty of places where you will find some very good tutorials about it.

Gio Takahashi

11-10-2003, 08:36 PM

Are you going to make the hack for vb3 databases and release it when RC is out?

hockyfan

11-10-2003, 09:04 PM

Julian, I was able to install locally, but even when entering (what I believe was) the correct information in your file, I still get that error I previously posted. What, and where exactly am I supposed to enter the DB information?

h

telc

11-19-2003, 11:04 PM

Would it be possible for me to create a new forum on my main vbulletin board, and have all the merged posts go into that forum?

kerplunknet

11-22-2003, 12:59 AM

Oh my goodness, thank you so very much. :)

I will try it very soon. WOO!

kerplunknet

11-22-2003, 01:08 AM

Was that polls bug ever fixed?

VeoMorphine

12-05-2003, 12:52 AM

Im having a few problems marging my db. THe user merge doesnt seem to add any users at all(atleast to the post count), and neither does the forum merge(it will start merging then hang there refershing, the startat var keesp going up though. and the pm merge does the same thing.. I had to edit the file directly and add the database info to the file as well or else i would get the mysql error hocky got.

Im using vbulletin 2.3.0

JulianD

12-09-2003, 01:41 AM

Was that polls bug ever fixed?
I found a bug on the poll merger and I think I fixed it successfully. Try it on your localhost.

VeoMorphine

12-09-2003, 09:57 PM

was my problem addressed?

WoodiE

12-13-2003, 03:18 AM

Will this work with vb2.3.0 to vb3.0gamma?

-Michael

Christy

01-15-2004, 11:17 PM

Is there a way to make it so the forum i want to import goes all into one category on my exisiting forum?

Sean123

01-23-2004, 02:57 PM

I have a quick question. Hopefully someone can answer it.

I have two forums. They are both on different hosts and servers. Is it possible to merge the forums, without moving them onto the same host and server?

Christy

01-23-2004, 03:37 PM

I believe so, just go to the forum you want to merge everything into and run the import script and from there put in the ip or host of the other server along with user/pass info and ya should be good.

subu1

02-05-2004, 08:42 AM

Hallo Julian,

ich mu? jetzt hier mal in deutsch posten, dazu ist mir das Thema zu heikel, ich bekomme genau diesen Fehler hier wie andere auch.

hi julian,

sorry for my bad english, but i will try my best. the problem is that i get the same errors like the others before

Database error in vBulletin Merge Tool 2.3.4:

Invalid SQL: SELECT COUNT(*) AS count FROM paradise-of-emotions_net.user
mysql error: You have an error in your SQL syntax near '-of-emotions_net.user' at line 1

mysql error number: 1064

Date: Thursday 05th of February 2004 11:54:28 AM
Script: http://www.starlight-board.net/board/board/importers/bbimport_vb2.php
Referer: http://starlight-board.net/board/importers/bbimport_vb2.php

der reale Datanbank Name ist aber paradise-of-emotions_net auf localhost

die 2 Datenbanken liegen auf meinen Server, was also mach ich den falsch.

the real database name is paradis ... on local host (hust lool)
the 2 databases are on my server, so what do i wrong?

gr??e subu1

subu1

02-05-2004, 09:14 AM

not the problem. i renamed the database.
all what i mean, is thats a litte bug :)
how you renamed it :-)

lazorde

02-06-2004, 01:23 AM

Now what i would like to know! dose the VB 2.3.2 can be marged with VB 3.0.0 RC3 or it can't ?? :ermm:

TheSonic

03-05-2004, 06:26 PM

I am very interested in a vb3-Version.

Any chance ?

The Charmed One

06-13-2004, 05:30 PM

Question, too tired to read EVERY page but:

If you import the members where to their posts go cause the forums dont have the same like forum names so where do theirt posts go. Do you just import the members and they start with no posts again. If so that is fine as i dont mind just curious!

Raptor

07-02-2004, 11:30 AM

I am very interested in a vb3-Version.

Any chance ?

id like this too :)

Khashyar

07-06-2004, 06:43 AM

This sounds like a great hack, Julian...

(I am wanting to merge two VB 2.3.4 databases, one of them being about one week older than the other).

I wonder if anyone has had luck in trying the merge LOCALLY first, before uploading it on their server?

Also, does the merge overwrite any information in the host database? For example, if you changed the name of a forum in a newer version of the database, will the merge overwrite the newer name?

Another question... If there are two threads that are the same in the two different databases (i.e., one newer version and one older version of the thread), and there were posts that were deleted in the newer version, will the merge reinsert the deleted posts in the thread?

It sounds like a wonderful hack.

Thanks for answering my questions if you can.

Khashyar

Khashyar

07-06-2004, 06:46 AM

Hi again,

Is there a way to merge the posts and threads of ONE user (from an older database) into a newer database where those posts and threads have been deleted, but just not merge other forum data?

Thanks,

Khashyar

lewekleonek

07-26-2004, 07:39 AM

Merging failed big time! I am going to restore from the back-up. The forum is a mess - missing posts, threads etc.
Step 5: Merging threads and posts failed and gave the following error:
(of course I've truncated the filedata field for it was a big one - would not fit in the post).

Database error in vBulletin Control Panel 2.2.9:

Invalid SQL: INSERT INTO attachment (attachmentid,userid,dateline,filename,filedata,vi sible) VALUES (

'',
'541',
'1070546658',
'dildostatic.jpg',
'GIF89a',
'1'
)
mysql error:

mysql error number: 0

Date: Monday 26th of July 2004 04:20:42 AM
Script: http://www.steroidology.com/forum/forum/importers/bbimport_vb2.php
Referer: http://www.steroidology.com/forum/importers/bbimport_vb2.php