Just did my first 6.x import. Very pleased w/how it went. Forum looks great, including all the bbcode stuff... and now broken tags (user errors like failure to close tag etc.) don't break the page. Probably due to D6's html corrector filter?
Anyway, looking at Private Msgs... checked quite a few at random, and they all appear to be from my own acct. even though some are recent enough that I know I was the recipient not the sender.... so I'm not sure what's up there. Quite possibly a problem w/PM, not the importer.

Comments

zooki’s picture

zooki commented

I have a similar problem, with 6.x-1.0-rc1

I have private messages, however, they are all in the inbox, and they are incorrectly attributed to me.

For example, lets say my username is Zooki

Now, I have a PM from someone else, on the left side, it says their username, but at the top of the message it says From Zooki ,(its definitely not from me)

at the bottom, where I am meant to reply, it says:

*Send Reply to Zooki:

--
It should say send reply to the user who sent me the PM..

any ideas what went wrong here?

liam mcdermott’s picture

liam mcdermott commented
Version: 6.x-1.0-rc1 » 6.x-1.x-dev
Category: support » bug
Status: Active » Fixed

The problem was that the {pm_index} table requires two records per-thread: one for the receiver, the second for the sender. vBulletin to Drupal was only creating a record for the receiver.

This is fixed in the dev version, the tar file on the project home page will update sometime in the next 24 hours, please use that to test. Thanks. :)

zooki’s picture

zooki commented

Thank you Liam !

aharown07’s picture

aharown07 commented

Yes, thanks Liam.
I shd hv opportunity to test inside of a week.

aharown07’s picture

aharown07 commented

oops. Went and did my migration using the old version.
Is there any way to fix up the data after it's imported? I'm thinking not but if I can avoid a redo, that'd be nice.

aharown07’s picture

aharown07 commented
Status: Fixed » Needs review

Did import w/ dev version.
Definitely got more errors than usual. How much they matter I'm not sure.

    * user warning: Unknown column 'skype' in 'field list' query: INSERT IGNORE INTO db_sidr62.profile_values (fid, uid, value) SELECT fid, userid+1000000, skype FROM user, db_sidr62.profile_fields WHERE name="user_skype" AND skype<>""; in /home/folder/public_html/3.0beta/sites/all/modules/vbtodrupal/vbtodrupal.module on line 601.
    * user warning: Unknown column 'a.extension' in 'on clause' query: INSERT IGNORE INTO db_sidr62.files (fid, uid, filename, filepath, filemime, filesize, status, timestamp) SELECT attachmentid+1000000, a.userid+1000000, CONCAT((attachmentid+1000000), '_', filename), CONCAT('sites/default/files/', (attachmentid+1000000), '_', filename), TRIM(LEFT(MID(mimetype, LOCATE('Content-type:', mimetype)+LENGTH('Content-type:'), LENGTH(mimetype)), LOCATE('"',MID(mimetype, LOCATE('Content-type:', mimetype)+LENGTH('Content-type:'), LENGTH(mimetype)))-1)), filesize, 1, a.dateline FROM attachment a INNER JOIN attachmenttype ON a.extension=attachmenttype.extension; in /home/folder/public_html/3.0beta/sites/all/modules/vbtodrupal/vbtodrupal.module on line 1076.
    * user warning: Unknown column 'filedata' in 'field list' 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/folder/public_html/3.0beta/sites/all/modules/vbtodrupal/vbtodrupal.module on line 1111.
    * user warning: Duplicate entry 'John Smith' 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/folder/public_html/3.0beta/sites/all/modules/vbtodrupal/vbtodrupal.module on line 1273.
    * user warning: Duplicate entry '1004112-1000002' for key 1 query: UPDATE users_roles ur, uid_linker ul SET uid = drupal_uid WHERE ur.uid = ul.vb_uid in /home/folder/public_html/3.0beta/sites/all/modules/vbtodrupal/vbtodrupal.module on line 1310.
    * user warning: Duplicate entry '1004112-22' for key 1 query: UPDATE profile_values pv, uid_linker ul SET uid = drupal_uid WHERE pv.uid = ul.vb_uid in /home/folder/public_html/3.0beta/sites/all/modules/vbtodrupal/vbtodrupal.module on line 1314.

I believe the first three are the ones I always get that have to do w/some custom tampering w/our vb database.
So the last three are new for me since going to the dev version.
Perhaps all due to some kind of duplication of one account?

Also, when I run cron I'm getting warning: Invalid argument supplied for foreach() in /home/folder/public_html/3.0beta/modules/taxonomy/taxonomy.module on line 1214.

Edit: forgot to mention. The privatemsg import part does indeed seem to be fixed. I'm guessing I've probably got one user account that's a little messed up... "John Smith" above. Otherwise, everything seems to be OK.

liam mcdermott’s picture

liam mcdermott commented
Status: Needs review » Fixed

Sorry for not replying to this sooner, but yes, it does just seem to be that one user. Maybe it shouldn't try to index on the name like that, strange that vBulletin seems to allow duplicate names, I'll raise another bug for that, but it's not a big problem.

By the way: those last errors are from some new queries designed to link existing Drupal user accounts to their vBulletin users. So it's probably not even relevant for you.

Status: Fixed » Closed (fixed)

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