Import DB from vb 2.34 to 3

[guybrush]

Hello
I've installed the last version of Vbulletin.

My "old" forum is running version 2.34.

I use Impex to import the old database into the new one.
In the select box I choose 19.vb2 as source database.

When I arrive at the "import users step" it shows me this error :

Duplicate entry '0' for key 1
mysql error number: 1062


How can I solve this problem?

A strange thing is the beginning of the query that gives the error :

INSERT INTO user
(
username, email, usergroupid,

the USER table in VB3 have differnt fields...
maybe this the problem?

Thanks in advance for your help! :)

[Zachery]

IS there any reason you are not upgrading? The import will take just as long and will not be nearly as complete as an upgrade will be.

[guybrush]

We're migrating the forum from linux machine to Win2k.
WE need to import only the users/users group, not the posts...

So the better way 4 us is to install the Vb3 and import the db... i think :)

[Zachery]

I am not sure why you are getting the database error though, just ensure that you have your ImpexConfig.php file 100% correct.

[guybrush]

This is the config file.. (modified:))

;vBulletin:Impex Config File<?php /*
;| ################################################## ################## |;
;| # vBulletin 3.0.3 - Licence Number -------;| # ---------------------------------------------------------------- # |;
;| # Copyright ©2000–2004 Jelsoft Enterprises Ltd. All Rights Reserved. |;
;| # This file may not be redistributed in whole or significant part. # |;
;| # ---------------- VBULLETIN IS NOT FREE SOFTWARE ---------------- # |;
;| # http://www.vbulletin.com | http://www.vbulletin.com/license.html # |;
;| ################################################## ################## |;
[ Target Database ]
; The following settings allow ImpEx to connect to the vBulletin 3
; database into which you will be importing data.
targetdatabasetype = "mysql"
targetserver = "localhost"
targetuser = "root"
targetpassword = "*****"
targetdatabase = "new_forum"
targettableprefix =
[ Source Database ]
; If the system that is being imported from uses a database,
; enter the details for it here and set 'sourceexists' to TRUE.
; If the source data is NOT stored in a database, set 'sourceexists' to FALSE
sourceexists = true
sourcedatabasetype = "mysql"
sourceserver = "localhost"
sourceuser = "root"
sourcepassword = "*****"
sourcedatabase = "forum_old"
sourcetableprefix =
;| ################################################## ################## |;
;| # File ends with closing PHP tag... # |;
;| ################################################## ################## |;
;*/ ?>

[Zachery]

Are both databases on the same server?

[guybrush]

I explane u:)

I had the forum on a "old" machine.
I moved the old db into the new machine.
Now this new machine has:
-old_forum
-new_forum

So, now both are on the same server (localhost...)

[guybrush]

I've take a look of the upgrade istruction.. but the upgrade arrive only until the 2.3.5 version?

[Steve Machol]

You can upgrade directly from 2.3.4 to 3.0.3.