Nothing is imported, permissions error?

luke76 - October 18, 2009 - 20:18
Project:vBulletin to Drupal
Version:6.x-1.0-rc1
Component:User interface
Category:support request
Priority:normal
Assigned:Unassigned
Status:fixed
Description

Hi, having a problem getting anything to import using Drupal 6.14

All test running fine:

Testing for vBulletin tables
Table thread: Yes
Table post: Yes
Table user: Yes
Table pm: Yes
Tables check passed!

Testing for PHP safe mode
Safe mode check passed!

Testing whether pictures are enabled
User picture check passed!

Testing Forum module has been enabled correctly
Forum check passed!

If the checks have succeeded you may continue with the migration.

-- so I run the migration, which takes only a few seconds - not right I'm sure - and get :

Importing users...
Importing forums...
Importing threads...
Importing posts...
Importing polls...
Importing files...
Importing private messages...
Rebuilding stats...
Fixing BBCode...
Finished, go back

No users or data are imported, but I do get a veeerry long list of errors:

• user warning: INSERT command denied to user 'joebloggs'@'localhost' for table 'users_signature' query: INSERT IGNORE INTO litop1.users_signature (uid, signature) SELECT vb3_user.userid+1000000, signature FROM vb3_user INNER JOIN vb3_usertextfield ON vb3_user.userid=vb3_usertextfield.userid WHERE signature IS NOT NULL in /var/www/vhosts/sitename.com/httpdocs/sites/all/modules/vbtodrupal/vbtodrupal.module on line 529.
• user warning: INSERT command denied to user 'joebloggs'@'localhost' for table 'users' query: INSERT IGNORE INTO litop1.users (uid, name, pass, mail, created, access, login, status, timezone, picture) SELECT vb3_user.userid+1000000, username, password, email, joindate, lastactivity, lastvisit, 1, timezoneoffset*60*60, CONCAT('sites/default/files/pictures/', vb3_user.userid+1000000, '_', filename) FROM vb3_user LEFT OUTER JOIN vb3_usertextfield ON vb3_user.userid=vb3_usertextfield.userid LEFT OUTER JOIN vb3_customavatar ON vb3_user.userid=vb3_customavatar.userid; in /var/www/vhosts/sitename.com/httpdocs/sites/all/modules/vbtodrupal/vbtodrupal.module on line 544.

It goes on in this vein, for what looks like being each table.

If this is a permissions problem, what do I need to change? I've granted permission to my superadmin role to perform vBulletin migration in my Permissions table. What am I missing?

Any help would be very much appreciated at this point, I'm stumped here!

Thanks

#1

juan_g - October 25, 2009 - 22:08

Another issue related to permissions is Does not Import anything.

#2

smk-ka - November 27, 2009 - 15:53
Status:active» fixed

The README says:

1. Configure your vBulletin database settings. It's important that the user name
   used has read access to the vBulletin database and _write access_ to Drupal
   or the import will fail.

The configured database user needs access to both databases, not just the vBulletin database.

 
 

Drupal is a registered trademark of Dries Buytaert.