When attempting to import vblogetin to vbblog I receive the following error when verifying the database.
I have checked and double checked the config file and all info is correct. For some reason it refuses to connect to the source db.
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 vB userid.
blog - importblogid
Completed
blog_attachment - importblogattachmentid
Completed
blog_category - importblogcategoryid
Completed
blog_moderator - importblogmoderatorid
Completed
blog_rate - importblograteid
Completed
blog_subscribeentry - importblogsubscribeentryid
Completed
blog_subscribeuser - importblogsubscribeuserid
Completed
blog_text - importblogtextid
Completed
blog_trackback - importblogtrackbackid
Completed
blog_user - importbloguserid
Completed
usergroup - importusergroupid
Completed
user - importuserid
Completed
usernote - importusernoteid
Completed
customavatar - importcustomavatarid
Completed
customprofilepic - importcustomprofilepicid
Completed
Valid found tables :
Possibly custom tables or incorrect prefix :
blog_blog_attach
NOT found.
blog_blog_blocks
NOT found.
blog_blog_blocks_user
NOT found.
blog_blog_blogviewers
NOT found.
blog_blog_blogviews
NOT found.
blog_blog_category
NOT found.
blog_blog_comment
NOT found.
blog_blog_customfields
NOT found.
blog_blog_entry
NOT found.
blog_blog_entry_rating
NOT found.
blog_blog_entryviews
NOT found.
blog_blog_favorites
NOT found.
blog_blog_feed
NOT found.
blog_blog_feedlog
NOT found.
blog_blog_layouts
NOT found.
blog_blog_lookup
NOT found.
blog_blog_rating
NOT found.
blog_blog_search
NOT found.
blog_blog_search_customfields
NOT found.
blog_blog_search_relevance
NOT found.
blog_blog_settings
NOT found.
blog_blog_stats
NOT found.
blog_blog_subscribeblog
NOT found.
blog_blog_subscribeentry
NOT found.
blog_user
NOT found. Failed Check database permissions and connection, or table prefix to ensure its correct
This is the config file with the full names and passwords removed:
<?php
################################################## ################## |;
# vBulletin - Licence Number VBF149E722
# ---------------------------------------------------------------- # |;
# Copyright ©2000–2006 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.
# If impex is installed in vBulletin you can ignore the target details
# as includes/config.php
if (!defined('IDIR')) { die; }
$impexconfig['target']['databasetype'] = 'mysql';
$impexconfig['target']['server'] = 'localhost';
$impexconfig['target']['user'] = 'fran...';
$impexconfig['target']['password'] = 'kd.....';
$impexconfig['target']['database'] = 'pp....';
$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;
# mysql / mssql
$impexconfig['source']['databasetype'] = 'mysql';
$impexconfig['source']['server'] = 'localhost';
$impexconfig['source']['user'] = 'mg.........';
$impexconfig['source']['password'] = 'kd.......';
$impexconfig['source']['database'] = 'pp..';
$impexconfig['source']['tableprefix'] = '';
# Error logging will log import errors to a database table impexerror
# for use with support.
# Language file is the file of phrases to be used, default is english.
# pagespeed is the second(s) wait before the page refreshes.
$impexconfig['system']['errorlogging'] = true;
$impexconfig['system']['language'] = '/impex_language.php';
$impexconfig['system']['pagespeed'] = 1;
define('impexdebug', true);
define('emailcasesensitive', false);
define('forcesqlmode', false);
?>