You will need to edit the importer script and that should be enough.

In the /importers folder is the vbulletin.php file and down on line 46 is this line of code:

$def->required = 'dbname,dbuser,dbpass,dbhost,dbbasepfix,dbpassoption';

if you remove the prefix option then it should pass:

$def->required = 'dbname,dbuser,dbpass,dbhost,dbpassoption';

Try that….

Okay, that much worked, now we’re onto another problem.  It got part of the way through the import and it kicked up a long string of errors, here are the first few:

Warning: mysql_ping() [function.mysql-ping]: Access denied for user ‘root’@’localhost’ (using password: NO) in /problem-with-post-edit-buttonome/cinagro/public_html/wp/wp-content/plugins/simple-press/sp-api/sp-api-error.php on line 145

Warning: mysql_ping() [function.mysql-ping]: A link to the server could not be established in /problem-with-post-edit-buttonome/cinagro/public_html/wp/wp-content/plugins/simple-press/sp-api/sp-api-error.php on line 145

Warning: mysql_affected_rows() [function.mysql-affected-rows]: Access denied for user ‘root’@’localhost’ (using password: NO) in /problem-with-post-edit-buttonome/cinagro/public_html/wp/wp-content/plugins/simple-press/sp-api/sp-api-wpdb.php on line 227

Warning: mysql_ping() [function.mysql-ping]: Access denied for user ‘root’@’localhost’ (using password: NO) in /problem-with-post-edit-buttonome/cinagro/public_html/wp/wp-content/plugins/simple-press/sp-api/sp-api-error.php on line 145

Warning: mysql_ping() [function.mysql-ping]: A link to the server could not be established in /problem-with-post-edit-buttonome/cinagro/public_html/wp/wp-content/plugins/simple-press/sp-api/sp-api-error.php on line 145

Warning: mysql_affected_rows() [function.mysql-affected-rows]: A link to the server could not be established in /problem-with-post-edit-buttonome/cinagro/public_html/wp/wp-content/plugins/simple-press/sp-api/sp-api-wpdb.php on line 227

are you using root with no password on a live mysql db?? 

are both db on the same server?  they must be…

I’m not sure I know what you mean.  The forum is not on the root, but in its own directory, /forum.   I entered the database un/pw into the importer form.  It’s localhost.  It’s on the same server I’ve just installed wp to.  When I go to try again, how can I erase everything that’s been imported during this failed attempt?

Thanks!

so both the vbulletin and simple press installs are on localhost?

Yes.

So you appear to be using a different username/password to access the vBulletin database as opposed to the WordPress database. If the dame user has access to both could you try with the common one – which would be the one set up in the WP config…?

I’d rather not fool with the vbulletin one, I had too much trouble messing with this once already when we were hacked.  Any reason I could just change the wordpress one?

You wouldn’t be messing with the vBulleitin settings at all. the question is whether the databases are both set up to enable the same set of user accounts and that is a server thing.

I am not even sure if this will resolve the issue as I have no real idea why the issue is happening except I see the username being used. using cpanel you should be able to grant access to both databases using the WordPress config settings and that should help I believe

Okay, so I’m going into the mySQL panel and setting both databases to be using the same user.  Should that do it?  What’s the best way to wipe out the improperly imported data before I retry? 

Linda Carter said
Okay, so I’m going into the mySQL panel and setting both databases to be using the same user.  Should that do it?

I am honestly not sure as I do not know what is causing the issue – I was just suggesting you try it. Use the same credentials as the WP config.

What’s the best way to wipe out the improperly imported data before I retry? 

‘Uninstall’ SP and the re-install it. Uninstall will remove all of he current data

No go.  Same errors

Warning: mysql_ping() [function.mysql-ping]: Access denied for user ‘root’@’localhost’ (using password: NO) in /problem-with-post-edit-buttonome/cinagro/public_html/wp/wp-content/plugins/simple-press/sp-api/sp-api-error.php on line 145

Warning: mysql_ping() [function.mysql-ping]: A link to the server could not be established in /problem-with-post-edit-buttonome/cinagro/public_html/wp/wp-content/plugins/simple-press/sp-api/sp-api-error.php on line 145

Warning: mysql_affected_rows() [function.mysql-affected-rows]: Access denied for user ‘root’@’localhost’ (using password: NO) in /problem-with-post-edit-buttonome/cinagro/public_html/wp/wp-content/plugins/simple-press/sp-api/sp-api-wpdb.php on line 227

Warning: mysql_ping() [function.mysql-ping]: Access denied for user ‘root’@’localhost’ (using password: NO) in /problem-with-post-edit-buttonome/cinagro/public_html/wp/wp-content/plugins/simple-press/sp-api/sp-api-error.php on line 145

Warning: mysql_ping() [function.mysql-ping]: A link to the server could not be established in /problem-with-post-edit-buttonome/cinagro/public_html/wp/wp-content/plugins/simple-press/sp-api/sp-api-error.php on line 145

.. and lots more of the same.

What does user “root” mean anyway?  I don’t have a user named root. 

So let’s get this right… you are using the user-name of ‘root’ for database access and this is what is in the wp-config.php file?