Leaving aside the database name and the password – can you tell me what other values you are using please?

By the way – I have never had a ‘forumpress’ database to test – the script was based upon the original ‘wp-forum’ plugin although of the data schema is the same then I would hope it would still work.

Thank you for getting back to me.

I am using Media Temple as my host. I have been able to log into my databases using Sequel on Mac OS X, using

external-db.s145620.gridserver.com << — Host

wp_forum <<— WP-Forum Table Prefix

wp_users <<— WP-Forum Tables Prefix for the Users Table

Also chose option: Copy source passwords from user records

and UTF-8 encode results both on and off.

Isn’t the table prefix just ‘wp_’? It would need to be the same for all of the tables….

That’s what I thought as well, but the docs say otherwise, but I think you right.

I did create another sub-domain a little while ago, and installed WordPress, then installed forumpress, and then simple:press. I installed the data importer and used the very same information except instead of external. for host I used ‘internal…’. I also used wp_ for both prefixes. Amazingly I was able to connect to the database and it read the correct number of users, posts, etc, but failed to import a usergroup or any of them forums.

Take a look below… Still, under the same domain, which is content.spinfuel, I cannot get the importer to connect to the same database I did connect to using the other sub-domain, which is blog.spinfuel.

Here’s the report for the blog.spinfuel domain import results. Using the same information I cannot get it to connect on the content.spinfuel domain’s installation of simple:press and forumpress. I don’t get it.

User/Member Data Created for Members 1 – 100

IMPORTED:
   48 Users
   12 Groups
   48 Forums
   107 Topics
   583 Posts

IMPORT FAILURES:
   Creation of General eCig Talk Group failed

Members Post Counts Updated

IMPORTED:
   1 Users
   12 Groups
   48 Forums
   107 Topics
   583 Posts

IMPORT FAILURES:
   Creation of Forum: Favorite eLiquid Flavors Failed
   Creation of Forum: Latest News Failed
   Creation of Forum: FDA News & Talk Failed
   Creation of Forum: Buying Your First Mod Failed
   Creation of Forum: Starter Kits Failed
   Creation of Forum: What To Look For Failed
   Creation of Forum: What To Stay Away From Failed
   Creation of Forum: Cartos, Clearos, Tanks? Failed
   Creation of Forum: Rebuildable Attys Failed

You have confused me here as to what I am looking at I am afraid. They both look like imported data results so what am I missing here?

But – also let’s go back to the beginning. Open up your wp-config.php file for the domain where the source data is coming from. There in that file will be all the settings – db name, password, hostname and table prefix. These are the settings you need for the import form.

Sorry about that, I was trying to make it sound less complicated but I wound up making it sound worse.

Okay, as far as the wordpress config information goes it’s all correct, the localhost, or host, is written in php, there is no straight up host anymore.

// ** MySQL settings – You can get this info from your web host ** //
/** The name of the database for WordPress */
define(‘DB_NAME’, ‘XXXX’);

/** MySQL database username */
define(‘DB_USER’, ‘dbXXXX’);

/** MySQL database password */
define(‘DB_PASSWORD’, ‘XXXXXXXXXX’);

/** MySQL hostname */
define(‘DB_HOST’, $_ENV{DATABASE_SERVER});

/** Database Charset to use in creating database tables. */
define(‘DB_CHARSET’, ‘utf8’);

All of that information is correct. The problem is I am not able to create a connection from the plugin sp-import to the database using that correct information. It continues to give me a “cannot create a connection” error.

What I meant to convey in my last post was that I was able to connect to that database while using a completely different wordpress/simple:press/sp-import set up on another sub-domain, with the very same login information.

I’m going to wipe simple:press and the importer from my main sub-domain and start all over.

You’re not going to believe this. I solved the problem and it was so sneaky I haven’t been fooled by it for at least a decade… in the text box for the host name there was an empty space AFTER the host name. I got rid of the empty space and it worked perfectly.

Thank you for pushing me along, I had about given up.

Check those EMPTY spaces!

Great stuff!

Stephanie Manzione said
You’re not going to believe this. I solved the problem and it was so sneaky I haven’t been fooled by it for at least a decade… in the text box for the host name there was an empty space AFTER the host name. I got rid of the empty space and it worked perfectly. Thank you for pushing me along, I had about given up. Check those EMPTY spaces!  

OMG, you saved my day. I had the same problem. It is finally connected and imported the data. 

But now I have another problem. I have 2 forum pages on my website: http://easy-exposure.com

One still has Mingle forum and other one is empty. Do I have to activate SP forum somehow, for it to show up?

take a look at forum – integration – page and permalink… play with the display options, namely display in loop and multiple display…