PDA

View Full Version : phpBB2 to VB3.5 Impex



Aidden
Fri 7th Oct '05, 6:26pm
-Brand new install of 3.5
-All databases local. Connectivity verified with both DB's
-Impex and VB 3.5 both downloaded today.

When I launch impex and attempt load the first step I get the following error:


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
There seems to have been a slight problem with the database.
Please try again by pressing the refresh (http://javascript%3cb%3e%3c/b%3E:window.location=window.location;) button in your browser.
An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.
We apologise for any inconvenience.

Jerry
Fri 7th Oct '05, 8:19pm
The SQL error will be in the source of the page, its most likely config in ImpExDatabase.php

Aidden
Sun 9th Oct '05, 8:11pm
Error from view source:



<!--
Database error in vBulletin:ImpEx Source :

Invalid SQL: SHOW TABLES
mysql error: No Database Selected

mysql error number: 1046

Date: Sunday 09th of October 2005 04:09:46 PM
Script: http://xxx.xxx.com/impex/index.php
Referer: http://xxx.xxx.com/impex/index.php
IP Address: xxx.xxx.xxx.xxx
-->

Jerry
Mon 10th Oct '05, 9:49pm
Either a missconfigured ImpExConfig.php or an old version of ImpEx, have you downloaded the latest build ?

Aidden
Thu 13th Oct '05, 3:55pm
As state din the initial post I had just downloaded the file the day I posted.

To be sure I again dowloaded the ImpEx Files and ftp'ed them up about 5 minutes ago. Problem still persists.

So to answer your question, yes it is the latest ImpEx download.

as for my config file, se below:



<?php
################################################## ################## |;
# vBulletin - Licence Number L618926b
# ---------------------------------------------------------------- # |;
# Copyright ©2000–2005 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

$impexconfig['target']['databasetype'] = 'mysql';
$impexconfig['target']['server'] = 'localhost';
$impexconfig['target']['user'] = 'xxxxxx';
$impexconfig['target']['password'] = 'xxxxxxxx';
$impexconfig['target']['database'] = 'xxxxxxxx';
$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'] = 'xxxxxxx';
$impexconfig['source']['password'] = 'xxxxxxxxx';
$impexconfig['source']['database'] = 'xxxxxxxxx';
$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/impex_language.php';
$impexconfig['system']['pagespeed'] = 1;

?>

Jerry
Thu 13th Oct '05, 4:25pm
Well if its with the latest ImpEx I'm at a loss, you'll have to start a support ticket to I can have a look behind the scenes to see what is going on.