Currently vB to Drupal only supports importing files and avatars from the vBulletin database. We should add support for when they're stored in the file system too.

Comments

drhus’s picture

yeah that's what i found out, i'm planning to move it disk to DB (on vB) and do the migration again.

drhus’s picture

Doesn't work with me,
i moved attach and profile pic on vB back to database >> used vbtodrupal for migration i got this error

    * user warning: Error writing file '/tmp/MYxdIjDg' (Errcode: 28) query: SELECT cid, pid, nid, thread FROM `USER_drupal6`.comments WHERE thread = '' ORDER BY timestamp in /home/USER/public_html/area51/sites/all/modules/vbtodrupal/vbtodrupal.module on line 961.
    * user warning: Incorrect key file for table '/tmp/#sql_31b2_0.MYI'; try to repair it query: SELECT attachmentid+1000000 AS uniqueid, filename, filedata, 0 AS avatar FROM attachment UNION SELECT IF(userid=0,0,userid+1000000) AS uniqueid, filename, filedata, 1 AS avatar FROM customavatar; in /home/USER/public_html/area51/sites/all/modules/vbtodrupal/vbtodrupal.module on line 1180.
    * user warning: Duplicate entry '??????' for key 1 query: ALTER TABLE uid_linker ADD CONSTRAINT uid_linker_name PRIMARY KEY (name), ADD CONSTRAINT uid_linker_drupal_uid UNIQUE (drupal_uid), ADD CONSTRAINT uid_liner_vb_uid UNIQUE (vb_uid), ADD CONSTRAINT uid_liner_vb_uid_orig UNIQUE (vb_uid_orig) in /home/USER/public_html/area51/sites/all/modules/vbtodrupal/vbtodrupal.module on line 1342.
    * user warning: Duplicate entry '1000186-1000002' for key 1 query: UPDATE users_roles ur, uid_linker ul SET uid = drupal_uid WHERE ur.uid = ul.vb_uid in /home/USER/public_html/area51/sites/all/modules/vbtodrupal/vbtodrupal.module on line 1379.
    * user warning: Duplicate entry '1000186-9' for key 1 query: UPDATE profile_values pv, uid_linker ul SET uid = drupal_uid WHERE pv.uid = ul.vb_uid in /home/USER/public_html/area51/sites/all/modules/vbtodrupal/vbtodrupal.module on line 1383.

i tried that 4 times till now, i tried repair optimize mysql vB forum then import .. didn't work

that error happen where the post/users etc all migrated correctly but attach n profile pics
--
>> drupal /sites/Domain.com/files >> is empty nothing

--
i tried again now moved attach back to disk and did the import again
i got the same error above BUT
>> drupal /sites/Domain.com/files and
drupal /sites/Domain.com/files/picture
has all attachments / pics as name ONLY
i mean profile pic on /sites/Domain.com/files/picture al 100001_xxxx.jpg 1000002_xxx.jpg etc
but file size is ZERO
attachments the same story .. all attachments already there but 0 size
(that didn't happens on 1st try when attach/ profile pics on database it happen only when it was on disk)

any ideas ?

drhus’s picture

this error 28 on my box is "no space left on device".
Which partition is running out of disk space?
/tmp ?

my box /tmp is 2.0G
where the attachment table on vB database is 28G

if that's the case how can i get around that?

liam mcdermott’s picture

It seems the problem is what you thought: the /tmp partition is out of space. I'm not sure what it's doing, probably filling the partition with temporary files, but a paying customer has this problem so I'm working on a way to import from vBulletin when files are stored on disk instead of the database.

drhus’s picture

this is great news, any time frame for next version?

liam mcdermott’s picture

Status: Active » Fixed

Just added this feature.

Follow the instructions at: http://drupal.org/node/189776/git-instructions/master/nonmaintainer to grab a copy via git. :)

Any bugs found should be raised as new, so please don't mark this active. Thanks!

liam mcdermott’s picture

Title: Import files and avatars when stored on disk » Import for files and avatars stored on disk.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.