Support Forum

Simple:Press 6 General Topics

Data Import Plugin, error and question

Data Import Plugin, error and question

James Mueller

Member

Free Members

Offline

Jan 4, 2014 - 2:35 pm

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

Yellow Swordfish

Glinton, England

SP Master

Offline

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?

YELLOW

SWORDFISH

James Mueller

Member

Free Members

Offline

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.

Yellow Swordfish

Glinton, England

SP Master

Offline

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'.

YELLOW

SWORDFISH

James Mueller

Member

Free Members

Offline

Jan 6, 2014 - 7:19 pm

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