PDA

View Full Version : IPBoard 1.3.1 to VB3.0.3



tuckers
Wed 21st Jul '04, 8:50pm
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 L33T-Elite database.
Please try again by pressing the refresh (http://javascript<b></b>:window.location=window.location;) button in your browser.

An E-Mail has been dispatched to our Technical Staff (kain@l33t-elite.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 21st of July 2004 06:41:09 PM
Script: http://www.l33t-elite.com/forumv2/impex/index.php
Referer: http://www.l33t-elite.com/forumv2/admincp/index.php?do=nav
Username: kain
IP Address: **.***.**.**



I get that error when i try and import my old forums database.

ceska
Wed 21st Jul '04, 8:58pm
Double check your ImpExConfig.php file, that it is PERFECT and correct.

I have.. but still having a similar issue...
http://www.vbulletin.com/forum/showthread.php?t=110963

tuckers
Wed 21st Jul '04, 9:21pm
i got the same error after i fixed the config file as you did, i just ignored it.

ceska
Wed 21st Jul '04, 9:52pm
Hmm.

Make sure your config file looks like this

Let's analyze my file.

targetdatabasetype = mysql
targetserver = localhost
targetuser = youraccount_username **Username is the same for both databases, the old Invision and the new vBulletin
targetpassword = wacky **Password is the same for the username of both databases, the old Invision and the new vBulletin
targetdatabase = youracount_newvbulletindbname
targettableprefix =

....

sourceexists = true

sourcedatabasetype = mysql
sourceserver = localhost
sourceuser = youraccount_username
sourcepassword = wacky
sourcedatabase = youraccount_invisiondatabasename
sourcetableprefix = ibf_

sourceuser and targetuser must be the same username.
The passwords must also be the same