Can not restart Impex

[jvanas]

New vBulletin user - so sorry for the lame question. VB 3.5.0

I am trying to use Impex to import a CSV file. Looks like I picked the wrong import type.

I have tried pressing the "Database cleanup & restart" option, but it fails with the error below.

TIA for any help you can provide!

Impex Help page

There seems to have been a slight problem with the database.
Please try again by pressing the refresh 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.

[Floris]

Hello,

Thank you for using our impex software to import from a custom source into vBulletin. Hopefully I can asisst you with correcting any impex issues you run into. Though I must say that my experience with CVS imports is a bit low.

The first step we need to take is to find out what the full MySQL error is, so please right click the page where this happens and click on 'view source', this will open something like notepad with the page source, find the <!-- database error --> tags and the full error will be displayed there. Paste it here so we can determine what might be wrong, and help resolve it.

[jvanas]

Here is the text:

<!--
Database error in vBulletin:ImpEx Target :
Link-ID == false, connect failed
mysql error:
mysql error number: 0
Date: Tuesday 11th of October 2005 08:58:32 AM
Script: http://<SiteNameRemoved>/forum/impex/help.php
Referer: http://<SiteNameRemoved>/forum/impex/index.php
IP Address: <IPremoved>
-->

I can send you the private ip and site name info if you need it.

I really didn't make any changes to the impex config file before starting. All I did was make a copy and remove the .new from the end. I couldn't find any instructions on how to tell the config file to point to a CSV, so I was hoping it would be done in the GUI. Then I picked the wrong import type.....

Here is my Impex config file:
$impexconfig['target']['databasetype'] = 'mysql';
$impexconfig['target']['server'] = 'localhost';
$impexconfig['target']['user'] = 'username';
$impexconfig['target']['password'] = 'password';
$impexconfig['target']['database'] = 'vbulletin_forum';
$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'] = false;
# mysql / mssql
$impexconfig['source']['databasetype'] = 'mysql';
$impexconfig['source']['server'] = 'localhost';
$impexconfig['source']['user'] = 'username';
$impexconfig['source']['password'] = 'password';
$impexconfig['source']['database'] = 'source';
$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;


Like I said.... nothing changed.

[Boxy]

The cause of the Link-ID == false error is most likely caused because the config file doesn't have the correct data.

You need to edit the ImpExConfig file and add in the database name, user name, password and table prefix for both the source (current board) and the target (vBulletin) databases.

For instructions on Importing please see the ImpEx section of the manual.

[jvanas]

According to the file's header and the manual, I don't need to put in the "source" database info because it is taken from VB. Is that true?

from the man:
"Target Database Information (Into which database do we import?)

If you have ImpEx installed correctly and are running it via the admincp, you can ignore the target settings go to the source. This is because ImpEx will read you vBulletin config file."


I also didn't think I needed to change the source settings because I was importing from a CSV file.

also from the man:
"$impexconfig['sourceexists']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."

So I left it as "false" and did not change any of the db settings.


Do I need to change these settings?

[Steve Machol]

The source info is the db info you are importing. You need to set this.

[Jerry]

Do I need to change these settings?

No, you should leave it to false if your importing CSV as its a file, not a database.

The database clean up is help.php, it gets the config for the target database to clean from ImpExConfig.php. I'd need to see the source of the page, with the SQL error to see what the issue is.

[jvanas]

Jerry, I think you are asking for the source on the page that I click "Database cleanup & restart" that results in the error code? If so - here it is - the "Import / Export" screen for Impex:


<- edit : removed by Jerry >

[jvanas]

Or, maybe you were asking for the code for impex/help.php:

<- edit : removed by Jerry >

[Jerry]

No, I need the source of the page when you get the error :

There seems to have been a slight problem with the database.

[jvanas]

This is the "View Source" from the screeen with the error:


<!--
Database error in vBulletin:ImpEx Target :
Link-ID == false, connect failed
mysql error:
mysql error number: 0
Date: Wednesday 12th of October 2005 02:45:25 PM
Script: http://<forumnameremoved>/forum/impex/help.php
Referer: http://<forumnameremoved>/forum/admincp/index.php
IP Address: <ipaddressremoved>
-->

[Jerry]

Ok that's usually config, are you using the latest ImpEx ? i.e. downloaded within the last 24 hours ?

[jvanas]

D/L on Sunday 10/9. Should I D/L and update today?

[Jerry]

The fix to help.php was done before that so you should be ok.

You'll have to start a support ticket so i can check the files in situ.

[jvanas]

Filing request with support now.