Blank White Screen

[Tresclub]

I feel like I'm back in the old Windoze BSD days, lol.
When I click on Import/Export, all I get is a BWS (blank white screen).

Here is my ImpExConfig.php:

[ 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 = "xxx"
targetpassword = "xxx"
targetdatabase = vbgolfconn
targettableprefix = phpBB2Plus

[ 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

; mysql OR mssql
sourcedatabasetype = mysql
sourceserver = localhost
sourceuser = "sameasabove"
sourcepassword = "sameasabove"
sourcedatabase = vbgolfconn
sourcetableprefix = phpBB2Plus

Can you see where I went wrong?

Warren

[Steve Machol]

The most likely cause of this problem is that you did not upload the Impex files correctly. Reupload the vB Impex files and make sure you upload these in ASCII format and that you overwrite the ones on the server.

[Boxy]

Your source and target database details are the same. The source database should your phpBB2Plus and the target will be your vBulletin database.

[Tresclub]

Thanks guys, I really appreciate your help.


Warren

[Tresclub]

OK, I changed the impex config file to this:

[ 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 = "xxx"
targetpassword = "xxx"
targetdatabase = vbgolfconn (new database)
targettableprefix = vBtest (prefix for new database)

[ 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

; mysql OR mssql
sourcedatabasetype = mysql
sourceserver = localhost
sourceuser = "xxx"
sourcepassword = "xxx"
sourcedatabase = golfconnection (old database)
sourcetableprefix = phpBB2Plus (old database prefix)

This didn't help, still getting the BWS. I wonder of the 'local host' thing might be causing it.

Warren

[Steve Machol]

Did you reupload the Impex files?

[Tresclub]

Did you reupload the Impex files?

Oh crap, forgot all about that part. Sorry . . .
Back in a few.

Warren

The first time. I only upload the phpBB2 folder.

[Tresclub]

I went back re-uploaded. This time I included phpBB, textfile, VB3 and xoops thinking there may be somethning in those others that may be needed.

Now when I try it, I get this error message:

Database error in vBulletin:ImpEx Target 3.0.7:
Link-ID == false, connect failed
mysql error:
mysql error number: 0
Date: Monday 16th of May 2005 02:35:47 PM
Script: http://www.thegolfconn.com/vBtest/impex/index.php
Referer: http://www.thegolfconn.com/vBtest/admincp/index.php?do=nav
Username: Admin
IP Address: 64.169.154.241

Warren

[Steve Machol]

The 'false, connect failed' error means that either the source or target db info in ImpExConfig.php is incorrect.

[Tresclub]

The database names are correct. I have attached a screenshot of the database file column from my golfconn database. I want to export the database from my phpBB2Plus board, and import it to my new vBtest board.

Shouldn't the export prefixes be: phpBB2Plus

[Steve Machol]

Some of that info is wrong, otherwise you would not get this error. Is the phpBB database on the same server as vB?

[Tresclub]

Some of that info is wrong, otherwise you would not get this error. Is the phpBB database on the same server as vB?

Yes.

Warren

[Jerry]

I went back re-uploaded. This time I included phpBB, textfile, VB3 and xoops thinking there may be somethning in those others that may be needed.

Now when I try it, I get this error message:

Database error in vBulletin:ImpEx Target 3.0.7:
Link-ID == false, connect failed
mysql error:
mysql error number: 0
Date: Monday 16th of May 2005 02:35:47 PM
Script: http://www.thegolfconn.com/vBtest/impex/index.php
Referer: http://www.thegolfconn.com/vBtest/admincp/index.php?do=nav
Username: Admin
IP Address: 64.169.154.241

Warren

To get this error your ImpExConfig and includes/config.php data must be diffrent some how.

[Tresclub]

To get this error your ImpExConfig and includes/config.php data must be diffrent some how.

From the config.php file in my vBtest/includes folder:

// ****** DATABASE SERVER NAME ******
// This is the hostname or IP address of the database server.
// It is in the format HOST:PORT. If no PORT is specified, 3306 is used.
// If you are unsure of what to put here, leave it at the default value.
$servername = 'mysql10.powweb.com';
// ****** DATABASE USERNAME & PASSWORD ******
// This is the username and password you use to access MySQL.
// These must be obtained through your webhost.
$dbusername = xxx;
$dbpassword = xxx;
// ****** DATABASE NAME ******
// This is the name of the database where your vBulletin will be located.
// This must be created by your webhost.
$dbname = 'vbgolfconn';

From the impex/ImpExConfig.php file:

[ Target Database ]
; The following settings allow ImpEx to connect to the vBulletin 3
; database into which you will be importing data.
targetdatabasetype = mysql
targetserver = ftp01.powweb.com
targetuser = "xxx"
targetpassword = "xxx"
targetdatabase = vbgolfconn
targettableprefix = vBtest
[ 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
; mysql OR mssql
sourcedatabasetype = mysql
sourceserver = ftp01.powweb.com
sourceuser = "xxx"
sourcepassword = "xxx"
sourcedatabase = golfconnection
sourcetableprefix = phpBB2Plus

[Jerry]

targetserver = mysql10.powweb.com

The target server is where the data is going to, i.e. the same as vBulletin.

Though if you are going across diffrent servers you must have access permissions to do that.