Support Forum

Data importer issue

YL Yao Li
Yao Li
Member

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…

bullet.png  my_wp
bullet.png  name
bullet.png  password
bullet.png  127.0.0.1
bullet.png  mywp
bullet.png mywp

Set to the prefix of the database table where the users data resides.

5 Answers

New Answer

YL Yao Li
Yao Li
Member

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

YS Yellow Swordfish
Yellow Swordfish
Member

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_’

YS Yellow Swordfish
Yellow Swordfish
Member

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.