View Full Version : ImpEx Import problems...
Kreeper-X
Wed 23rd Aug '06, 8:57pm
I just installed 3.6 on a new server and am attempting a clean import of a 3.5.3 database to the new board.
I downloaded ImpEx, edited the config file, uploaded everything in ASCII mode and when I click on Import > > Import, it asked for my Customer number. After inputting the customer number, the board acknowledges the number and says it's re-directing to impex/index.php and loads for a while before giving me a blank screen.
I searched the board here and have gone into the config file and edited out 1 line of "white space" from the end of the file, deleted everyting Impex relates and re-uploaded it all again.
Logged off the admin control panel, logged back in, went to Import > > Import and it asks for Customer#. Input the number, clicked the button. I get another long load time and then blank white screen again!
I've turned off gzip, made sure to do everything in Ascii mode, deleted all but the version of vb I'm trying to import, and am at a loss. Is there something I'm missing?
Jerry
Wed 23rd Aug '06, 8:59pm
Anything in the PHP error or web server logs ?
Running on windows ?
Kreeper-X
Wed 23rd Aug '06, 9:05pm
Anything in the PHP error or web server logs ?
Running on windows ?
I'll check the logs... The server is running Linux...
Logs say jack... It's not giving me a PHP error at all... It accepts the customer number and then loads for a while before defaulting to a white page while trying to load the impex/index.php file...
I've tried to go directly to the impex/index.php file and it does the same thing.
I'm going to re-check all the files I've uploaded to see if there is something I overlooked...
Jerry
Wed 23rd Aug '06, 9:11pm
Try running ImpEx stand alone as well.
Whats your PHP memory limit and time out ?
Kreeper-X
Wed 23rd Aug '06, 9:21pm
Try running ImpEx stand alone as well.
Whats your PHP memory limit and time out ?
By stand alone, do you mean just running Impex directly? Like Hitting /impex/index.php and bypassing the admincp? If so I already did that and it did the same thing.
Time out is set to 30 seconds, can't find the php memory limit...
Kreeper-X
Wed 23rd Aug '06, 9:36pm
Try running ImpEx stand alone as well.
I have my forum installed into the root directory, so if I install Impex in the root directory it'll overwrite my forum index.php file...
Okay, I tried re-naming my forum index page to forumindex.php and installed Impex into my root directory and tried a stand alone... Still getting the white screen.
Kreeper-X
Wed 23rd Aug '06, 10:09pm
Here's my config file for Impex...
<?php
################################################## ################## |;
# vBulletin - Licence Number VBF45BE232
# ---------------------------------------------------------------- # |;
# 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'] = 'xxxxx';
$impexconfig['target']['user'] = 'x';
$impexconfig['target']['password'] = 'x';
$impexconfig['target']['database'] = 'x';
$impexconfig['target']['tableprefix'] = 'xxx';
# 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'] = 'mysql.x.com';
$impexconfig['source']['user'] = 'x';
$impexconfig['source']['password'] = 'x';
$impexconfig['source']['database'] = 'x';
$impexconfig['source']['tableprefix'] = 'xxxx';
# 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', false);
define('emailcasesensitive', false);
define('forcesqlmode', false);
define('skipparentids', false);
?>
IS there something I missed here? I'm importing from a Netfirms site and have turned remote access on for the D-Base in question.
Jerry
Wed 23rd Aug '06, 10:32pm
$impexconfig['source']['server'] = 'mysql.x.com';
Is the source a remote server ? If so does the user your using have remote connection privileges ?
Kreeper-X
Wed 23rd Aug '06, 11:05pm
Is the source a remote server ? If so does the user your using have remote connection privileges ?
The source is a remote server and I've set up the D-Base for remote access, I'm checking my user privilages... Yep. The user is set up for remote access.
But looking a little deeper, the new server doesn't allow remote access to thier databases. Would that be the problem with the blank page?
Jerry
Wed 23rd Aug '06, 11:09pm
But looking a little deeper, the new server doesn't allow remote access to thier databases. Would that be the problem with the blank page?
Err well if ImpEx can't access the database that is a serious issue, i.e. a show stopper.
I'd suggest not bothering with remote access and setups, slow and trouble some, just back up the database and restore it on the same server as ImpEx and vBulletin.
Powered by vBulletin™ Version 4.0.0 Beta 4 Copyright © 2009 vBulletin Solutions, Inc. All rights