Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
Importing vbulletin to simple press no table prefix
Avatar
Linda Carter
Member
Free Members
sp_UserOfflineSmall Offline
Feb 9, 2013 - 7:52 am

I'm trying to run the Simple:Press Data import.  It's asking for a table prefix.  I don't have a table prefix in my vbulletin database.  So, it keeps hanging, asking for it.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Feb 9, 2013 - 8:55 am

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

 

andy-signature.png
YELLOW
SWORDFISH
Avatar
Linda Carter
Member
Free Members
sp_UserOfflineSmall Offline
Feb 9, 2013 - 10:36 am

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

 

 

 

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Feb 9, 2013 - 10:45 am

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

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

Avatar
Linda Carter
Member
Free Members
sp_UserOfflineSmall Offline
Feb 9, 2013 - 11:27 am

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!

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Feb 9, 2013 - 12:08 pm

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

Avatar
Linda Carter
Member
Free Members
sp_UserOfflineSmall Offline
Feb 9, 2013 - 12:09 pm

Yes.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Feb 9, 2013 - 1:18 pm

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

andy-signature.png
YELLOW
SWORDFISH
Avatar
Linda Carter
Member
Free Members
sp_UserOfflineSmall Offline
Feb 9, 2013 - 1:29 pm

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?

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Feb 9, 2013 - 1:35 pm

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

andy-signature.png
YELLOW
SWORDFISH
Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 619
Members: 17362
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625