Tweet
I have seen plenty of posts with the same error being reported on starting the import using Impex. The canned response is your info in the Impconfig file is wrong 
Well that may be true but in my case here is what I found to be incorrect.
Item 1
Installing VBulletin and per the notes in the /includes/config.php stats
Ok so my server fits this profile and I set my config to reflect mysqli make note of this
Install of VB is perfect, I now move to the import util that now gives me an error after setting things up perfectly
After reading through Almost every post I discovered this is a common issue and the canned responce is
Ok I understand this can and sometimes is the issue, but
The solution I found and what I believe is the core of the problem is this:
Item 2
In the Manual for ImpEx and ImpExconfig.php file it says this:
Now remember MYSQLI There in is the issue
Your VBulletin DataBase is using mysqli, Impex is only allowed MYSQL
The Fix:
Change your /includes/config.php to be mysql (If you are using mysqli)
This is what worked for me
Ya I bloviate
Well that may be true but in my case here is what I found to be incorrect.
Item 1
Installing VBulletin and per the notes in the /includes/config.php stats
// ****** DATABASE TYPE ******
// This is the type of the database server on which your vBulletin database will be located.
// Valid options are mysql and mysqli. Try to use mysqli if you are using PHP 5 and MySQL 4.1+
$config['Database']['dbtype'] = 'mysql';
// This is the type of the database server on which your vBulletin database will be located.
// Valid options are mysql and mysqli. Try to use mysqli if you are using PHP 5 and MySQL 4.1+
$config['Database']['dbtype'] = 'mysql';
Install of VB is perfect, I now move to the import util that now gives me an error after setting things up perfectly
ImpEx Database errormysql error: Invalid SQL: SELECT title, data FROM vb_datastore WHERE title = 'ImpExSession'
mysql error: No database selected
mysql error number: 1046
Date: Tuesday 04th 2006f July 2006 09:24:35 AM
Database: <YOURData_Base>
MySQL error: No database selected
mysql error: No database selected
mysql error number: 1046
Date: Tuesday 04th 2006f July 2006 09:24:35 AM
Database: <YOURData_Base>
MySQL error: No database selected
That error indicates that the data in your ImpExconfig.php file is incorrect.
If you'd like to provide me with FTP login details I'd gladly doublecheck that information.
If you'd like to provide me with FTP login details I'd gladly doublecheck that information.
The solution I found and what I believe is the core of the problem is this:
Item 2
In the Manual for ImpEx and ImpExconfig.php file it says this:
$impexconfig['target']['databasetype']Enter the type of database here, currently this can only be mysql
Your VBulletin DataBase is using mysqli, Impex is only allowed MYSQL
The Fix:
Change your /includes/config.php to be mysql (If you are using mysqli)
This is what worked for me
Ya I bloviate
Comment