Support Forum

Problem importing SMF1 to Simple Press using Importer plugin

IC Ivan O'Connor
Ivan O'Connor
Member

Hi,

When trying to import a SMF version Forum I am getting the following error:

“Error: Unable to query USERS using the db settings supplied”

Is there anyway to troubleshoot this?

Thanks in advance,

Ivan

7 Answers

New Answer

YS Yellow Swordfish
Yellow Swordfish
Member

Sounds like the prefix to the database table is incorrect. In this case it should be the same prefix as the other tables.

IC Ivan O'Connor
Ivan O'Connor
Member

Thanks for the rapid reply.

It seems to me that there are no prefixes or am I looking in the wrong place?

Db Details
MP Mr Papa
Mr Papa
Member

odd – never seen an smf without a prefix… but another question, are both db on the same server? they need to be…

YS Yellow Swordfish
Yellow Swordfish
Member

Mmmm – like Steve I have only seen SMF databases with a prefix.

Could you make a small edit to the importer file? In the /importers folder – open the right one.

Around line 46 you will see this:

$def->required        = 'dbname,dbuser,dbpass,dbhost,dbbasepfix,dbpassoption';

Remove the dbbasepfix entry from the list. That will make it optional – as I see, the user table prefix already is.

$def->required        = 'dbname,dbuser,dbpass,dbhost,dbpassoption';

See if that works now?

IC Ivan O'Connor
Ivan O'Connor
Member

Fantastic stuff guys.

Worked first time.

Thanks a million.

YS Yellow Swordfish
Yellow Swordfish
Member

Excellent news. Thanks for the update