drewstr
Wed 5th Sep '07, 8:06pm
vBlogetin import error
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);
?>