SQL error.

[CureTheItch]

I do the Check and update database... Then I goto do Associate Users, and I get this error "Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /impex/db_mysql.php on line 247
".

[Steve Machol]

This means that info in your ImpExConfig.php file is not correct, most likely the target info.

[CureTheItch]

This means that info in your ImpExConfig.php file is not correct, most likely the target info.

I wasnt sure if I did that correct or not, could you please tell me if I have or not? :o



$impexconfig['sourceexists'] = false;
# mysql / mssql
$impexconfig['source']['databasetype'] = 'mysql';
$impexconfig['source']['server'] = '64.**.**.**;
$impexconfig['source']['user'] = 'username_here';
$impexconfig['source']['password'] = 'password_here';
$impexconfig['source']['tableprefix'] = 'phpbb_';


Is that correct?

I tried to take the database and put it on my server, but I keep getting SQL errors.. The host screwed something up, so now I'm trying to move it and convert it but I'm having alot of trouble with the simple part.. The other database :(

[Steve Machol]

What are you importing from? If it's another BB system, then you need to change this:

$impexconfig['sourceexists'] = false;

To this:

$impexconfig['sourceexists'] = true;

Also if the data is on another server then that server needs to be configured to allow remote MySQL connections from your vB server. Otherwise you will need to move that database onto the vB server to do the import.