Import from phpBB2.0 to vB 3.7.3 error on step 1

[TNCclubman]

checked the config file and the right database info is there...

ImpEx Database errormysql error: Invalid SQL: SHOW TABLES
mysql error: No database selected
mysql error number: 1046
Date: Sunday 21st 2008f September 2008 02:28:53 AM
Database: toronto_phpbb
MySQL error: No database selected


Its an old phpBB2.0... is that why? I noticed impex says 2.0.22 when you pick phpBB2 in the original selection...

I bought vbulletin a week ago and I need to convert my board or this is useless to me.

triple checked the source database name, username, and password...

Please help!

[TNCclubman]

[Steve Machol]

You cannot get that error is the source db info is correct in ImpExConfig.php. Check again.

[TNCclubman]

yes its correct. please advise, I attached the screenshot to show the database exists that the error is saying does not exist...

[Steve Machol]

Post your ImpExConfig.php info.

[TNCclubman]

thanks for your help steve!

<?php
if (!defined('IDIR')) { die; }
#################################################################### |;
# vBulletin - Licence Number hidden
# ---------------------------------------------------------------- # |;
# Copyright ©2000–2008 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 # |;
#################################################################### |;
# The following settings allow ImpEx to connect to the vBulletin 3
# database into which you will be importing data.
####
#
# TARGET - The target is the vBulletin database (where the data is going to)
#
####
$impexconfig['target']['server'] = 'localhost';
$impexconfig['target']['user'] = 'hidden';
$impexconfig['target']['password'] = 'hidden';
$impexconfig['target']['database'] = 'toronto_phpbb3';
$impexconfig['target']['tableprefix'] = '';
# 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
$impexconfig['sourceexists'] = true;
####
#
# SOURCE - The source is the old forum database (where the data is coming from)
#
####
# mysql / mssql
$impexconfig['source']['databasetype'] = 'mysql'; // mysql OR mssql
$impexconfig['source']['server'] = 'localhost';
$impexconfig['source']['user'] = 'hidden';
$impexconfig['source']['password'] = 'hidden';
$impexconfig['source']['database'] = 'toronto_phpbb';
$impexconfig['source']['tableprefix'] = '';
####
#
# DUPLICATE CHECKING
# Where unique import id's are aviable ImpEx can check for duplicates with some
# Tier2 systems this will need to be set to false.
#
# yahoo_groups, YaBB 2.1, Ikonboard 3.1.5 (for attachments)
#
####
define('dupe_checking', true);
###############################################################################
####
#
# ADVANCED - For a standard import or a novice user leave the settings below.
#
####
// Advanced Target
$impexconfig['target']['databasetype'] = 'mysql'; // currently mysql only
$impexconfig['target']['charset'] = '';
$impexconfig['target']['persistent'] = false; // (true/false) use mysql_pconnect
// Advanced Source
$impexconfig['source']['charset'] = '';
$impexconfig['source']['persistent'] = false;
# pagespeed is the second(s) wait before the page refreshes.
$impexconfig['system']['language'] = '/impex_language.php';
$impexconfig['system']['pagespeed'] = 1;
define('impexdebug', false);
define('emailcasesensitive', false);
define('forcesqlmode', false);
define('skipparentids', false);
define('shortoutput', false);
define('do_mysql_fetch_assoc', false);
define('step_through', false);
define('lowercase_table_names', false);
define('use_utf8_encode', false);
define('use_utf8_decode', true);
?>

[TNCclubman]

does everything look correct? Please help, Im stuck!

The old phpBB2.0 database is from another server with MySQL 4.0.15

the new vbulletin server is MySQL 5.0.45


Could that be the issue?

[struff]

I am getting the exact same error message.

In my case, this is the second Import I am trying to do. I did the first one about a month ago and it was fine - an old phpbb to vbulletin. The import I am trying to do today is from a former vbulletin into my current vbulletin. I changed the database name accordingly. The passwords didn't have to be changed because they are the same as the first Import but I double-checked that they are correct anyway.

[Steve Machol]

It looks like your target db info is set for phpBB, not vB. That needs to be the vB database info.

Also your source db table prefix probably needs to be set to: phpbb_

Struff, please start your own thread.

[TNCclubman]

Also your source db table prefix probably needs to be set to: phpbb_

That did it thanks!

vbulletin blows away phpbb.

Glad im part of the family!