Dont understand Impex

[LadyBug]

Done...

[LadyBug]

Zachery cant find the problem, someone else?

[blueuniverse]

I am getting the same problem on my boards when importing from PHPBB 2.07

Basically it comes up with this, which is basically the same problem.

Database error in vBulletin:ImpEx Target 3.0.2:
Invalid SQL: SELECT title, data FROM rouse_datastore WHERE title = 'ImpExSession'
mysql error: Table 'blueuniv_rouse.rouse_datastore' doesn't exist
mysql error number: 1146
Date: Friday 02nd of July 2004 02:38:26 PM
Script: http://www.rouseindahouse.com/impex/index.php
Referer:
Username: ed
IP Address: **.**.***.***

Just fyi rouse_ is the table prefix I am installing with. blueuniv_rouse is the database name I am installing with. The old database has blueuniv_riseofnations as the database name, and rouseindahouseportal1_ as the table prefix.

Thanks (also didn't mean to steal your topic, but the problems look identical at first glance)

[LadyBug]

My config of the Impex system is a little bit changed now, i give it a try this way, when it seems to work u get the code

[Jerry]

Always make sure that you don't copy and paste the details in impexconfig as all the variable names are diffrent.

[blueuniverse]

I got mine sorted, turns out vbulletin didn't install with a table prefix as it said it would, and I had Impex set to look for it with a table prefix.

[LadyBug]

Use this config layout:

;vBulletin:Impex Config File<?php /*
;| #################################################################### |;
;| # vBulletin 3.0.1 - 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          = 
targetpassword      = 
targetdatabase      = 
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          = 
sourcepassword      = 
sourcedatabase      = 
sourcetableprefix   = 


;targetuser          = 
;targetpassword   = 
;targetdatabase   = 
;targettableprefix  = 



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

[Jerry]

Use the original comfig file layout and just add the variables, do not copy a second set of target variables into the file, over or after the source ones.