Nothing is imported, permissions error?
| Project: | vBulletin to Drupal |
| Version: | 6.x-1.0-rc1 |
| Component: | User interface |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | fixed |
Jump to:
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
Another issue related to permissions is Does not Import anything.
#2
The README says:
1. Configure your vBulletin database settings. It's important that the user nameused 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.