Importing and error in code?

[Big_Ad]

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /impex/db_mysql.php on line 248

Line 248 being:

$query_id = $query_type($query_string, $this->link_id);

Got this when trying to start the Associate Users module? Not quite sure what to do?

I'm not having any other sort of errors. Help would be grateful!

Thanks.

[Jerry]

You must of recived errors in the database check module as well I'm guessing ?

[Big_Ad]

For the check and update database module, I get (this is for PHPBB btw):

moderator - importmoderatorid OK
usergroup - importusergroupid OK
ranks - importrankid OK
poll - importpollid OK
forum - importforumid OK
forum - importcategoryid OK
user - importuserid OK
style - importstyleid OK
thread - importthreadid OK
post - importthreadid OK
thread - importforumid OK
smilie - importsmilieid OK
pmtext - importpmid OK
avatar - importavatarid OK
customavatar - importcustomavatarid OK
customprofilepic - importcustomprofilepicid OK
post - importpostid OK
attachment - importattachmentid OK
pm - importpmid OK

Please set 'sourceexists = true' in ImpExConfig.php

I thought sourceexists should = false?

After this, it shows 19 imports with 0 failed.

Infact, when I set sourceexists as true, I get:

"A source database was not entered in ImpExConfig.php"

[Jerry]

Please set 'sourceexists = true' in ImpExConfig.php[/B]

I thought sourceexists should = false?

After this, it shows 19 imports with 0 failed.

Infact, when I set sourceexists as true, I get:

"A source database was not entered in ImpExConfig.php"

Then this is the issue, you are ignoring the error. You have to edit ImpExConfig to enter your source database (phpBB) details and set the source to true.

[Big_Ad]

Ah I see.

sourcedatabasetype = mysql
sourceserver = localhost
sourceuser = "myuser"
sourcepassword = "mypass"
sourcedatabase =
sourcetableprefix =

What should I set sourcedatabase and sourcetableprefix as? Sorry, new to this.

[Jerry]

Is your phpBB database on the same host and database as yoru vBulletin install ?

99% of the time the sourcetableprefix is "phpbb_"

[Big_Ad]

Is your phpBB database on the same host and database as yoru vBulletin install ?

99% of the time the sourcetableprefix is "phpbb_"

No it's not. It's backed up in a SQL file, but it's a new host. We have transfered hosts and forum software.

Does it make a difference in the process? :confused:

[Jerry]

No it's not. It's backed up in a SQL file, but it's a new host. We have transfered hosts and forum software.

Does it make a difference in the process? :confused:

Yes as you have to restore the SQL file to the database so that impex can read from it.


http://www.vbulletin.com/docs/html/main/moving_servers_restore

[Big_Ad]

Yes as you have to restore the SQL file to the database so that impex can read from it.


http://www.vbulletin.com/docs/html/main/moving_servers_restore

So I have to login to my host via Telnet/SSH and dump the SQL file?

Does it matter where I dump the file?

[Jerry]

You said above you have the SQL file, that needs to be moved to and restored on the new host.

[Big_Ad]

You said above you have the SQL file, that needs to be moved to and restored on the new host.

Yes that is correct.

So it is just the case of:

mysqldump --opt -Q -uUSERNAME -p DATABASENAME > phpbb_db_backup.sql

(My host is FreeBSD and I am running Windows 2000)

Thanks for your patience.

[Jerry]

Yes, then move that file to your new host and restore it.