Support Forum

vBulletin Import Access Denied Errors

JK Jack Kruse
Jack Kruse
Member
Member since Oct 2012
8 posts
Oct 31, 2012 · 10:53 am · Edited

Hi, yesterday I was testing the import of vBulletin to SP and like another member got everything but 0 posts.  Read that thread and decided to update the importer plugin from 2.2 to 2.4 and try again.  

Today I get the users imported only, then I get MySQL warnings like this: http://www.screencast.com/t/eOd3NR1jRx

Those messages repeat hundreds of times then crashes the chrome browser. 

One thing I noticed when I started entering the database name etc was that the VB doesn’t have a table prefix.  On the SP Importer something has to be entered so I used a space.  Not sure if that is causing any issues or not.

Help is appreciated getting these 60,000 posts moved over.

3 Answers

New Answer
YS Yellow Swordfish
Yellow Swordfish
Member
Member since Nov 2008
16,437 posts
Oct 31, 2012 · 11:05 am

In the importers folder youy will find the vbulletin script. near the top is this line of code:

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

It might be worth trying to remove dbbasepfix from that list but I have not tried this of course. It certainly will produce errors if it tries to use a space character.

JK Jack Kruse
Jack Kruse
Member
Member since Oct 2012
8 posts
Oct 31, 2012 · 12:26 pm

Thank you sir.  

Here is an update:  So I deleted the dbbasepfix portion and got posts for the first forum only to the staging/test site.  Then it throws this messaging and tends to lock up the browser window.  Any ideas?

 

User/Member Data Created for Members 3701 – 3800

Forum Group The Optimized Living Discussion Forum Created

Forum Group The Cave Created

Warning: mysql_ping() [function.mysql-ping]: Access denied for user ‘staging’@’localhost’ (using password: NO) in /problem-with-post-edit-buttonome/staging/public_html/simplepress/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/staging/public_html/simplepress/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/staging/public_html/simplepress/wp-content/plugins/simple-press/sp-api/sp-api-wpdb.php on line 227

YS Yellow Swordfish
Yellow Swordfish
Member
Member since Nov 2008
16,437 posts
Oct 31, 2012 · 2:33 pm

Well these are just warnings and should not stop the script from running. Fatal Errors will do that but not warnings.
Are you quite sure you have waited long enough? The importer can take a long time to bring data in.