Support Forum

Data Import Plugin, error and question

JM James Mueller
James Mueller
Member
Member since Jan 2014
94 posts
Jan 4, 2014 · 2:35 pm · Edited

— We need to import from phpBB3

–Our host — WPEngine — does not allow creation of new databases, so I imported the phpBB tables to our staging db.

— Checked and re-checked the sql credentials with our host and cannot resolve an importer error: “Error: Unable to query USERS using the db settings supplied”

— Our web host is guessing the plugin might me making an external call to somewhere , which is not allowed. Please confirm if this is the case. << If that is the case, the host is willing to make an exception.

— As a workaround, would it be possible to run the sql scripts from phpMyAdmin?

Thanks much.
Jim

 

5 Answers

New Answer
YS Yellow Swordfish
Yellow Swordfish
Member
Member since Nov 2008
16,437 posts
Jan 4, 2014 · 6:08 pm

No – Simple:Press is not making any external calls.

Is this phpBB database on the same MySQL server as your WP/Simple:Press installation?

And I note that you specify this is phpBB V3. Can you tell me what the name of the table is within the database that contains the user data?

JM James Mueller
James Mueller
Member
Member since Jan 2014
94 posts
Jan 6, 2014 · 2:31 pm

<< Is this phpBB database on the same MySQL server as your WP/Simple:Press installation?

That could be the issue.
I imported the tables into our staging db — not the same db as the install.

The phpbb tables should be in the same db as Simple:Press, yes?

<< Can you tell me what the name of the table is within the database that contains the user data?

Also interesting. I see we only imported 7 phpBB tables (seems like there should be more). And, browsing the contents of these tables, I don’t see any that contains user data.

I’ll look at another dump and re-import.

 

 

YS Yellow Swordfish
Yellow Swordfish
Member
Member since Nov 2008
16,437 posts
Jan 6, 2014 · 2:53 pm

James Mueller said
<< Is this phpBB database on the same MySQL server as your WP/Simple:Press installation?

That could be the issue.
I imported the tables into our staging db — not the same db as the install.
The phpbb tables should be in the same db as Simple:Press, yes?

Not necessary for them to be in the same actual database but certainly they need to be in the same mySQL server instance.

<< Can you tell me what the name of the table is within the database that contains the user data?

Also interesting. I see we only imported 7 phpBB tables (seems like there should be more). And, browsing the contents of these tables, I don’t see any that contains user data.
I’ll look at another dump and re-import.
 

Simple:Press will be looking for a phpBB table literally named ‘users’.

JM James Mueller
James Mueller
Member
Member since Jan 2014
94 posts
Jan 6, 2014 · 7:19 pm

Success! I re-named the user file.  Thanks much.