Error on running Database cleanup & restart in Impex

[akulion]

Im porting over from SMF 1.1
To vB 3.6.4

Ran impex, everything went great all the stuff ran and said successful

Then clicked on the link "Database cleanup & restart" and got this error

ImpEx Database errormysql error: Link-ID == false, connect failed

mysql error: 

mysql error number: 0

Date: Friday 26th of January 2007 06:15:54 AM
Database: p2p_forums
MySQL error:

any idea what it means?

aku

[Jerry]

It means your ImpExConfig.php details are incorrect or that user has no permissions on the source database.

[akulion]

Thats weird because all the details were correct for impex to be able to import everything over to vB, this only occurs when clicking the cleanup link

but thanks - ill have a closer look and see whats up

[ViperMaul]

I have the same problem.
ImpExConfig.php detail are correct as I have many successful imports in my test runs.
However, when I click on that link I get the same or similar error:


ImpEx Database errormysql error: Link-ID == false, connect failed

mysql error:

mysql error number: 0

Date: Saturday 27th 2007f October 2007 01:08:59 AM
Database: arma_tow_com_forum
MySQL error:

[Steve Machol]

See this:

http://www.vbulletin.com/docs/html/troubleshoot_mysql_linkid

[Jerry]

Thats weird because all the details were correct for impex to be able to import everything over to vB, this only occurs when clicking the cleanup link

but thanks - ill have a closer look and see whats up

Ensure that you have the target details in the ImpExConfig.php as well if you want to use the cleanup page.

[tommythejoat]

Ensure that you have the target details in the ImpExConfig.php as well if you want to use the cleanup page.

Has there been any further information on this? I copied and ran the small script that was provided above and it was successful. I believe that means that mySQL and vBulletin are happy with the information in ./include.

That information is:

$impexconfig['target']['server']  = 'localhost';
$impexconfig['target']['user']   = 'jelsoft';
$impexconfig['target']['password']  = 'theirpassword';
$impexconfig['target']['database']  = 'NAWCCmb';
$impexconfig['target']['tableprefix'] = '';

The information in the ImpEx file is essentially the same except it is another user on the database. These credentials were, I thought, used during the import.

$impexconfig['target']['server']  = 'localhost';
$impexconfig['target']['user']   = 'nawccmb';
$impexconfig['target']['password']  = 'apassword';
$impexconfig['target']['database']  = 'NAWCCmb';
$impexconfig['target']['tableprefix'] = '';

I am not trying to run cleaner at this time and it is still inactive. However, none of the information that I have imported is visible under AdminCP.

I can look at the database with phpMyAdmin and it all seems to be there, but I don't know how to make it visible in vBulletin.

We had vBulletin professionally installed and that is why the username and password differ between the two files. It seemed to be good practice to change to our own account when preparing to run the message board.

I can make the information the same and check that out, but it seems illogical to me that the import would proceed and bring in 297,000 posts with "bad" connect information.

[Jerry]

Well if the import ran, though you aren't seeing anything in the forums I'm guessing you haven't followed the clean up instructions ?

http://www.vbulletin.com/docs/html/impex_cleanup

[tommythejoat]

Well if the import ran, though you aren't seeing anything in the forums I'm guessing you haven't followed the clean up instructions ?

http://www.vbulletin.com/docs/html/impex_cleanup

The reason I posted in this thread is that I get the connection failure described at the start of the thread when I try to click on the cleanup and restart link.

I have checked the database connection with both sets of credentials and it says that it connects OK.

The error message from ImpEx does not have enough information to go any farther.

[B]Impex Help page[/B]
[INDENT] 
[B]There seems to have been a problem with the database.[/B]
ImpEx Database errormysql error: Link-ID == false, connect failedmysql error: mysql error number: 0Date: Tuesday 27th 2008f May 2008 12:48:09 PMDatabase: NAWCCmbMySQL error: 
[/INDENT]

If I knew where this message was being generated, I would try to add some debugging statements to it.

[Jerry]

Ensure that the target details are in ImpExConfig.php

[tommythejoat]

Ensure that the target details are in ImpExConfig.php

I suspect that I am not labeling my examples clearly enough:
includes/config.php

 // ****** MASTER DATABASE SERVER NAME AND PORT ******
 // This is the hostname or IP address and port of the database server.
 // If you are unsure of what to put here, leave the default values.
$config['MasterServer']['servername'] = 'mb.nawcc.org';
$config['MasterServer']['port'] = 3306;
 // ****** MASTER DATABASE USERNAME & PASSWORD ******
 // This is the username and password you use to access MySQL.
 // These must be obtained through your webhost.
$config['MasterServer']['username'] = 'nawccmb';
$config['MasterServer']['password'] = '******';

impex/impexconfig.php

####
$impexconfig['target']['server']  = 'localhost';
$impexconfig['target']['user']   = 'nawccmb';
$impexconfig['target']['password']  = '******';
$impexconfig['target']['database']  = 'NAWCCmb';
$impexconfig['target']['tableprefix'] = '';

The fragment from /include/config.php originally had the credentials I gave Jelsoft during the istallation. It makes no difference since both sets of credentials have %/global/all privileges on the mySQL database.

Both sets of credentials work just fine with the test code:

<?php 
require_once('./includes/config.php'); 
$db = @mysql_connect($config['MasterServer']['servername'], $config['MasterServer']['username'], $config['MasterServer']['password']) or die(mysql_error()); 
mysql_select_db($config['Database']['dbname'], $db); 
echo "Connected sucessfully."; 
?>

This installation is mySQL 5.0.27-standard protocol version 10 and the installation of vBulletin is 3.6.9 at http://mb.nawcc.org/index.php.

I log onto the message board with the message board administrators account and select the admin link at the bottom of the board and after supplying my password again, I select the import option.

The import option shows:

Import / Export
.isucc { color: green; } .ifail { color: red; }[B]ImpEx build version : 1.88[/B]
[CENTER][URL="http://mb.nawcc.org/impex/help.php"][COLOR=#810081]Database cleanup & restart[/COLOR][/URL] ||| [URL="http://www.vbulletin.com/docs/html/impex"][COLOR=#810081]Online manual[/COLOR][/URL]
Using includes/config.php for target config.[/CENTER]
 
 

[B]Import / Export :: bbBoardv2[/B]ModuleActionSuccessfulFailedTime taken001Check and update database 101 sec(s)002Associate Users 000 sec(s)003Import User 742301 min(s)004Import Forum 2902 sec(s)005Import Thread 40211032 min(s)006Import Smilie 47381 sec(s)007Import Post 294421081 min(s)008Import Poll 041 min(s)009Import Private Messages 1287028 sec(s)010Import Attachment 006 min(s)[B]Totals:[/B][B]343419[/B][B]42[/B][B]122.97 min(s)[/B][CENTER][URL="http://www.vbulletin.com/"][COLOR=#810081]vBulletin® v3.6.9, Copyright ©2000-2008, Jelsoft Enterprises Ltd.[/COLOR][/URL][/CENTER]

I then click on the database cleanup & restart link and get the "help" screen with the connect error:

 
Import / Export - Help page
[B]Impex Help page[/B][INDENT]
[B]There seems to have been a problem with the database.[/B]
ImpEx Database errormysql error: Link-ID == false, connect failedmysql error: mysql error number: 0Date: Tuesday 27th 2008f May 2008 05:09:15 PMDatabase: NAWCCmbMySQL error: 
 
[/INDENT]

[tommythejoat]

Get rid of default forum and category.

It turns out that one must delete the default forum after the import before the imported forums can be seen.

There is a warning in the documentation about deleting this forum on the chance that the imported material was stored under it.

In my case there was nothing stored under the forum generated by the original install. However, it blocked my view of the others.

Everything seems to be working at the moment. When I make the next import pass, I will delete the existing defaults before I start.

I suspect the other users who posted earlier in this thread had the same problem. The solution is not obvious to a new user.

[Jerry]

That step is mentioned in the clean up instructions:

http://www.vbulletin.com/docs/html/impex_cleanup

Forum cache

To rebuild the forum cache so your imported forums appear, go to your forum manager and save the display.

Deleting the default forum, archives the same result as the cache is rebuilt.

[tommythejoat]

I think the instructions could be more clear. I invoked the forum manager and saved the display several times. All I ever saw were the two default entries.

Perhaps it might say "If all you see are the default entries, delete them."