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
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
Sounds like the prefix to the database table is incorrect. In this case it should be the same prefix as the other tables.
Thanks for the rapid reply.
It seems to me that there are no prefixes or am I looking in the wrong place?
odd – never seen an smf without a prefix… but another question, are both db on the same server? they need to be…
Yes they are.
This is the old site:
http://naastriathlonclub.com/HTML_FILES/post.htm
This is the new site:
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?