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.

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

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

Ummm let me see what can I do :)

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.

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.

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

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

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.

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.

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?

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.

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

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

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

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

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.

/grumbles

I guess I'll try to restore the backup

is this hack will work for future vB3?

thanks.

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

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.

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

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

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

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

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!

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

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.

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/forum...p?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 :)

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/forum...p?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 :)

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

They should be

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?

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

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

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

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.

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

OK Thread closed. Sorry.

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.