Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
plugins-topic
Problem importing SMF1 to Simple Press using Importer plugin
Avatar
Ivan O'Connor
Member
Free Members
sp_UserOfflineSmall Offline
May 3, 2012 - 5:00 pm

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

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
May 3, 2012 - 5:06 pm

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

andy-signature.png
YELLOW
SWORDFISH
Avatar
Ivan O'Connor
Member
Free Members
sp_UserOfflineSmall Offline
May 3, 2012 - 5:52 pm

Thanks for the rapid reply.

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

Db DetailsImage Enlarger

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
May 3, 2012 - 9:14 pm

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

Avatar
Ivan O'Connor
Member
Free Members
sp_UserOfflineSmall Offline
May 4, 2012 - 1:40 am

Yes they are.

This is the old site:

http://naastriathlonclub.com/H.....S/post.htm

This is the new site:

http://naastriathlonclub.com/w.....age_id=578

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
May 4, 2012 - 3:25 am

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?

andy-signature.png
YELLOW
SWORDFISH
Avatar
Ivan O'Connor
Member
Free Members
sp_UserOfflineSmall Offline
May 4, 2012 - 9:07 am

Fantastic stuff guys.

Worked first time.

Thanks a million.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
May 4, 2012 - 9:27 am

Excellent news. Thanks for the update

andy-signature.png
YELLOW
SWORDFISH
Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 619
Members: 17362
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625