Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
plugins-topic
vBulletin Import Access Denied Errors
Avatar
Jack Kruse
Member
Free Members
sp_UserOfflineSmall Offline
Oct 31, 2012 - 10:53 am

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.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
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.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Jack Kruse
Member
Free Members
sp_UserOfflineSmall Offline
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

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
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.

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: 17363
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625