IPB --> vB3.0.3 error

[DJCobol]

On step one of the impex script, I'm getting the following error:



Altering tables

ImpEx will now Alter the tables in the vB database to include import id numbers.

This is needed during the import process for maintaining refrences between the tables during an import.If you have large tables (i.e. lots of posts) this can take some time. They will also be left after the import if you need to link back to the origional IPB userid.


moderator - importmoderatorid OK
usergroup - importusergroupid OK
ranks - importranksid OK
poll - importpollid OK
forum - importforumid OK
forum - importcategoryid OK
user - importuserid OK
style - importstyleid OK
thread - importthreadid OK
post - importthreadid OK
thread - importforumid OK
smilie - importsmilieid OK
pmtext - importpmid OK
post - importpostid OK
attachment - importattachmentid OK

There seems to have been a slight problem with the MichiganSpeed Forums database.
Please try again by pressing the refresh (javascript:window.location=window.location;) button in your browser.

An E-Mail has been dispatched to our Technical Staff (djcobol@michiganspeed.com), who you can also contact if the problem persists.

We apologise for any inconvenience.
Database error in vBulletin:ImpEx Source 3.0.3:

Invalid SQL: SHOW TABLES
mysql error: No Database Selected

mysql error number: 1046

Date: Wednesday 28th of July 2004 12:45:06 AM
Script: http://michiganspeed.com/testforums/impex/index.php
Referer: http://michiganspeed.com/testforums/admincp/index.php?do=nav
Username: DJCobol
IP Address: 24.11.21.69


I triple-checked the database names in ImpExConfig.php and I still get the same error.

[Zachery]

Can you paste the contents of your impexconfig.php file?

Did you set everything up and set sourceexists = TRUE ?

[DJCobol]

Apparently I didnt get it:

;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 = dreamer1_djcobol
targetpassword = **********
targetdatabase = dreamer1_forums
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 = dreamer1_djcobol
sourcepassword = **********
sourcedatabase = dreamer1_Speedforum
sourcetableprefix = ibf_

;| ################################################## ################## |;
;| # File ends with closing PHP tag... # |;
;| ################################################## ################## |;
;*/ ?>

Now I dont get an error, I just get a whole lot of nothing.

[Steve Machol]

Run this query:

DELETE FROM datastore WHERE title='ImpExSession';

Then try the import again.

[DJCobol]

I finally got the script to finish executing, but now I have another problem. All post dates are 12-31-1969. Any reason as to why they didnt import correctly?

[Zachery]

Did you rebuild the thread counters and then forum counters?

[DJCobol]

That seems to have fixed it. Thank you very much!