Support Forum

Simple:Press 6 General Topics

Data importer issue

Data importer issue

Yao Li

Member

Offline

Oct 27, 2016 - 4:55 am

I'm importing the bbpress data to SP. BBP and SP are hosted on same server and same database - they are using the same WP table prefix.

I clicked the "Perform Import" button then I got the error "Error: Unable to query USERS using the db settings supplied", please help...

bbPress Database Name:	[Image Can Not Be Found]	my_wp
bbPress Database User Name:	[Image Can Not Be Found]	name
bbPress Database Password:	[Image Can Not Be Found]	password
bbPress Database Host:	[Image Can Not Be Found]	127.0.0.1
bbPress Table Prefix:	[Image Can Not Be Found]	mywp
Wordpress User Table Prefix:	[Image Can Not Be Found]	mywp Set to the prefix of the database table where the users data resides.

Yao Li

Member

Offline

Oct 27, 2016 - 5:04 am

If my understanding is correct, the BBP table name is mywp_posts, the user table name is mywp_users, mywp_usermeta.

Yellow Swordfish

Glinton, England

SP Master

Offline

Oct 27, 2016 - 5:12 am

So if the bbPress is the plugin version then the data you need can all be found in your wp-config.php file.

Looking at your examples above you have listed your tables as 'mywp_posts' etc., but in the first post, as the table prefix you have only used 'mywp'. If your table names are right then the prefix should be 'mywp_'

YELLOW

SWORDFISH

Yellow Swordfish

Glinton, England

SP Master

Offline

Oct 27, 2016 - 5:14 am

by the way - the importer uses direct mysql php functions. A quick google suggests that these should work ok with your mariadb but I can not confirm that - or guarantee that of course.

YELLOW

SWORDFISH

Yao Li

Member

Offline

Oct 27, 2016 - 5:22 am

‘mywp’works, thank you!