Importing problem

[riverwire]

Hi im getting this problem


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.
moderator - importmoderatorid Completed
usergroup - importusergroupid Completed
ranks - importrankid Completed
poll - importpollid Completed
forum - importforumid Completed
forum - importcategoryid Completed
user - importuserid Completed
style - importstyleid Completed
thread - importthreadid Completed
post - importthreadid Completed
thread - importforumid Completed
smilie - importsmilieid Completed
pmtext - importpmid Completed
avatar - importavatarid Completed
customavatar - importcustomavatarid Completed
customprofilepic - importcustomprofilepicid Completed
post - importpostid Completed
attachment - importattachmentid Completed
pm - importpmid Completed
usernote - importusernoteid Completed
phrase - importphraseid Completed
subscription - importsubscriptionid Completed
subscriptionlog - importsubscriptionlogid Completed

There seems to have been a problem with the database.
ImpEx Database errormysql error: Invalid SQL: SHOW TABLESmysql error: No Database Selectedmysql error number: 1046Date: Friday 11th of April 2008 04:30:04 PMDatabase: sourceMySQL error: No Database Selected



and here is my config file

<?php
if (!defined('IDIR')) { die; }
################################################## ################## |;
# vBulletin - Licence Number L6542561
# ---------------------------------------------------------------- # |;
# 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'] = 'h41mysql19.secureserver.net';
$impexconfig['target']['user'] = 'vbspurs';
$impexconfig['target']['password'] = 'pass';
$impexconfig['target']['database'] = 'pass';
$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'] = 'mysql243.secureserver.net';
$impexconfig['source']['user'] = 'pass';
$impexconfig['source']['password'] = 'pass';
$impexconfig['source']['database'] = 'source';
$impexconfig['source']['tableprefix'] = 'phpbb';
####
#
# 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);
?>


Any help would be great

thanks

[Jerry]

I'd guess you either on h41mysql19 or mysql243 and one account dosn't have the permissions to access the other ?

Try copying all the source tables into the same database that vBulletin is in and setting source and target as the same, as long as there is a table prefix to stop any name clashes.

[riverwire]

Sorry i forgot to write something in, its now connecting but getting these errors now


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.
moderator - importmoderatorid Completed
usergroup - importusergroupid Completed
ranks - importrankid Completed
poll - importpollid Completed
forum - importforumid Completed
forum - importcategoryid Completed
user - importuserid Completed
style - importstyleid Completed
thread - importthreadid Completed
post - importthreadid Completed
thread - importforumid Completed
smilie - importsmilieid Completed
pmtext - importpmid Completed
avatar - importavatarid Completed
customavatar - importcustomavatarid Completed
customprofilepic - importcustomprofilepicid Completed
post - importpostid Completed
attachment - importattachmentid Completed
pm - importpmid Completed
usernote - importusernoteid Completed
phrase - importphraseid Completed
subscription - importsubscriptionid Completed
subscriptionlog - importsubscriptionlogid Completed

Valid found tables :


Possibly custom tables or incorrect prefix :

attachments NOT found.
attachments_desc NOT found.
auth_access NOT found.
banlist NOT found.
categories NOT found.
config NOT found.
confirm NOT found.
disallow NOT found.
forum_prune NOT found.
forums NOT found.
groups NOT found.
posts NOT found.
posts_text NOT found.
privmsgs NOT found.
privmsgs_text NOT found.
ranks NOT found.
search_results NOT found.
search_wordlist NOT found.
search_wordmatch NOT found.
sessions NOT found.
smilies NOT found.
themes NOT found.
themes_name NOT found.
topics NOT found.
topics_watch NOT found.
user_group NOT found.
users NOT found.
vote_desc NOT found.
vote_results NOT found.
vote_voters NOT found.
words NOT found.

If you have all red tables, i.e. none correct this could possible be your table prefix :


phpbb_album_ Failed Check database permissions and connection, or table prefix to ensure its correct

[riverwire]

Sorry i know your busy but i need to get this working before tomorrow night, surely there is someone else apart from Jerry that knows IMPEX ?

[Kerry-Anne]

If you have all red tables, i.e. none correct this could possible be your table prefix :

phpbb_album_ Failed Check database permissions and connection, or table prefix to ensure its correctThis means that your table prefix for your scource database is incorrect and is likely to be phpbb_ or phpbb_album_

[Jerry]

Sorry i know your busy but i need to get this working before tomorrow night, surely there is someone else apart from Jerry that knows IMPEX ?

Well ImpEx was trying to tell you :


If you have all red tables, i.e. none correct this could possible be your table prefix :

phpbb_album_ Failed Check database permissions and connection, or table prefix to ensure its correct

I'd guess KA is right and it's phpbb_