Trying to import from vb4 and I am getting the following error:

An AJAX HTTP error occurred. HTTP Result Code: 500 Debugging information follows. Path: /batch?render=overlay&id=7&op=do StatusText: Service unavailable (with message) ResponseText: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'user_yim' for key 'name': INSERT INTO {profile_field} (title, name, explanation, category, page, type, weight, required, register, visibility, options) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10), (:db_insert_placeholder_11, :db_insert_placeholder_12, :db_insert_placeholder_13, :db_insert_placeholder_14, :db_insert_placeholder_15, :db_insert_placeholder_16, :db_insert_placeholder_17, :db_insert_placeholder_18, :db_insert_placeholder_19, :db_insert_placeholder_20, :db_insert_placeholder_21), (:db_insert_placeholder_22, :db_insert_placeholder_23, :db_insert_placeholder_24, :db_insert_placeholder_25, :db_insert_placeholder_26, :db_insert_placeholder_27, :db_insert_placeholder_28, :db_insert_placeholder_29, :db_insert_placeholder_30, :db_insert_placeholder_31, :db_insert_placeholder_32), (:db_insert_placeholder_33, :db_insert_placeholder_34, :db_insert_placeholder_35, :db_insert_placeholder_36, :db_insert_placeholder_37, :db_insert_placeholder_38, :db_insert_placeholder_39, :db_insert_placeholder_40, :db_insert_placeholder_41, :db_insert_placeholder_42, :db_insert_placeholder_43), (:db_insert_placeholder_44, :db_insert_placeholder_45, :db_insert_placeholder_46, :db_insert_placeholder_47, :db_insert_placeholder_48, :db_insert_placeholder_49, :db_insert_placeholder_50, :db_insert_placeholder_51, :db_insert_placeholder_52, :db_insert_placeholder_53, :db_insert_placeholder_54), (:db_insert_placeholder_55, :db_insert_placeholder_56, :db_insert_placeholder_57, :db_insert_placeholder_58, :db_insert_placeholder_59, :db_insert_placeholder_60, :db_insert_placeholder_61, :db_insert_placeholder_62, :db_insert_placeholder_63, :db_insert_placeholder_64, :db_insert_placeholder_65), (:db_insert_placeholder_66, :db_insert_placeholder_67, :db_insert_placeholder_68, :db_insert_placeholder_69, :db_insert_placeholder_70, :db_insert_placeholder_71, :db_insert_placeholder_72, :db_insert_placeholder_73, :db_insert_placeholder_74, :db_insert_placeholder_75, :db_insert_placeholder_76), (:db_insert_placeholder_77, :db_insert_placeholder_78, :db_insert_placeholder_79, :db_insert_placeholder_80, :db_insert_placeholder_81, :db_insert_placeholder_82, :db_insert_placeholder_83, :db_insert_placeholder_84, :db_insert_placeholder_85, :db_insert_placeholder_86, :db_insert_placeholder_87), (:db_insert_placeholder_88, :db_insert_placeholder_89, :db_insert_placeholder_90, :db_insert_placeholder_91, :db_insert_placeholder_92, :db_insert_placeholder_93, :db_insert_placeholder_94, :db_insert_placeholder_95, :db_insert_placeholder_96, :db_insert_placeholder_97, :db_insert_placeholder_98), (:db_insert_placeholder_99, :db_insert_placeholder_100, :db_insert_placeholder_101, :db_insert_placeholder_102, :db_insert_placeholder_103, :db_insert_placeholder_104, :db_insert_placeholder_105, :db_insert_placeholder_106, :db_insert_placeholder_107, :db_insert_placeholder_108, :db_insert_placeholder_109), (:db_insert_placeholder_110, :db_insert_placeholder_111, :db_insert_placeholder_112, :db_insert_placeholder_113, :db_insert_placeholder_114, :db_insert_placeholder_115, :db_insert_placeholder_116, :db_insert_placeholder_117, :db_insert_placeholder_118, :db_insert_placeholder_119, :db_insert_placeholder_120); Array ( [:db_insert_placeholder_0] => YIM [:db_insert_placeholder_1] => user_yim [:db_insert_placeholder_2] => [:db_insert_placeholder_3] => Contact [:db_insert_placeholder_4] => [:db_insert_placeholder_5] => textfield [:db_insert_placeholder_6] => 0 [:db_insert_placeholder_7] => 0 [:db_insert_placeholder_8] => 1 [:db_insert_placeholder_9] => 2 [:db_insert_placeholder_10] => [:db_insert_placeholder_11] => MSN [:db_insert_placeholder_12] => user_msn [:db_insert_placeholder_13] => [:db_insert_placeholder_14] => Contact [:db_insert_placeholder_15] => [:db_insert_placeholder_16] => textfield [:db_insert_placeholder_17] => 0 [:db_insert_placeholder_18] => 0 [:db_insert_placeholder_19] => 1 [:db_insert_placeholder_20] => 2 [:db_insert_placeholder_21] => [:db_insert_placeholder_22] => Skype [:db_insert_placeholder_23] => user_skype [:db_insert_placeholder_24] => [:db_insert_placeholder_25] => Contact [:db_insert_placeholder_26] => [:db_insert_placeholder_27] => textfield [:db_insert_placeholder_28] => 0 [:db_insert_placeholder_29] => 0 [:db_insert_placeholder_30] => 1 [:db_insert_placeholder_31] => 2 [:db_insert_placeholder_32] => [:db_insert_placeholder_33] => AIM [:db_insert_placeholder_34] => user_aim [:db_insert_placeholder_35] => [:db_insert_placeholder_36] => Contact [:db_insert_placeholder_37] => [:db_insert_placeholder_38] => textfield [:db_insert_placeholder_39] => 0 [:db_insert_placeholder_40] => 0 [:db_insert_placeholder_41] => 1 [:db_insert_placeholder_42] => 2 [:db_insert_placeholder_43] => [:db_insert_placeholder_44] => ICQ [:db_insert_placeholder_45] => user_icq [:db_insert_placeholder_46] => [:db_insert_placeholder_47] => Contact [:db_insert_placeholder_48] => [:db_insert_placeholder_49] => textfield [:db_insert_placeholder_50] => 0 [:db_insert_placeholder_51] => 0 [:db_insert_placeholder_52] => 1 [:db_insert_placeholder_53] => 2 [:db_insert_placeholder_54] => [:db_insert_placeholder_55] => Website [:db_insert_placeholder_56] => user_website [:db_insert_placeholder_57] => [:db_insert_placeholder_58] => Contact [:db_insert_placeholder_59] => [:db_insert_placeholder_60] => url [:db_insert_placeholder_61] => 0 [:db_insert_placeholder_62] => 0 [:db_insert_placeholder_63] => 1 [:db_insert_placeholder_64] => 2 [:db_insert_placeholder_65] => [:db_insert_placeholder_66] => Location [:db_insert_placeholder_67] => user_from [:db_insert_placeholder_68] => [:db_insert_placeholder_69] => Personal [:db_insert_placeholder_70] => [:db_insert_placeholder_71] => textfield [:db_insert_placeholder_72] => 0 [:db_insert_placeholder_73] => 0 [:db_insert_placeholder_74] => 1 [:db_insert_placeholder_75] => 2 [:db_insert_placeholder_76] => [:db_insert_placeholder_77] => Occupation [:db_insert_placeholder_78] => user_occ [:db_insert_placeholder_79] => [:db_insert_placeholder_80] => Personal [:db_insert_placeholder_81] => [:db_insert_placeholder_82] => textfield [:db_insert_placeholder_83] => 0 [:db_insert_placeholder_84] => 0 [:db_insert_placeholder_85] => 1 [:db_insert_placeholder_86] => 2 [:db_insert_placeholder_87] => [:db_insert_placeholder_88] => Interests [:db_insert_placeholder_89] => user_interests [:db_insert_placeholder_90] => [:db_insert_placeholder_91] => Personal [:db_insert_placeholder_92] => [:db_insert_placeholder_93] => textfield [:db_insert_placeholder_94] => 0 [:db_insert_placeholder_95] => 0 [:db_insert_placeholder_96] => 1 [:db_insert_placeholder_97] => 2 [:db_insert_placeholder_98] => [:db_insert_placeholder_99] => Gender [:db_insert_placeholder_100] => user_gender [:db_insert_placeholder_101] => [:db_insert_placeholder_102] => Personal [:db_insert_placeholder_103] => [:db_insert_placeholder_104] => selection [:db_insert_placeholder_105] => 0 [:db_insert_placeholder_106] => 0 [:db_insert_placeholder_107] => 1 [:db_insert_placeholder_108] => 2 [:db_insert_placeholder_109] => Male Female [:db_insert_placeholder_110] => Biography [:db_insert_placeholder_111] => user_biography [:db_insert_placeholder_112] => A few details about yourself [:db_insert_placeholder_113] => Personal [:db_insert_placeholder_114] => [:db_insert_placeholder_115] => textarea [:db_insert_placeholder_116] => 0 [:db_insert_placeholder_117] => 0 [:db_insert_placeholder_118] => 1 [:db_insert_placeholder_119] => 2 [:db_insert_placeholder_120] => ) in vbimportapi_import() (line 1015 of /Users/justin/Sites/theoc7/sites/all/modules/vbtodrupal/vbimportapi.module).

I know this technically is supposed to work for vb3 but I did see where you asked someone to pass along errors from vb4. Any ideas what is going on here?

Thanks!

Comments

fosstux’s picture

I have exactly the same problem. Any news on that issue?

Please help. Thank you.

Christopher

liam mcdermott’s picture

Status: Active » Postponed (maintainer needs more info)

Is this the first time you've tried running the import? Because this looks like what would happen if two imports are run (without doing a delete in-between).

justin.nethers’s picture

I tried running it once and got an error that was different, I think, but didn't copy it. Is there a way to start over fresh without deleting/reinstalling the module?

liam mcdermott’s picture

Status: Postponed (maintainer needs more info) » Active

There's a hidden delete feature of vB to Drupal, hidden because it's unfinished and deletes all imported data and any nodes/comments created since. So, you have been warned! :)

To delete the imported data, go to admin/structure/vbtodrupal/delete and click the I understand the warnings, please just delete everything button.

Then you'll be able to start the import again. Then, if/when it comes up with that other error message, please create a new issue. Thanks and good luck.

Am leaving this as a bug, since vB to Drupal should record that an import has been attempted and warn the user before they try to import again.

justin.nethers’s picture

Great, thanks for the reply. I will give that a shot now.

justin.nethers’s picture

Ok, just updating here since I seemed to figure it out on my own. The error was caused by duplicate usernames in my vb_user table. Not sure how that happened but there were a handful of usernames that were duplicates. I went through and wiped them out (they were all spam accounts) and I'm currently in the "importing forum posts" part of the process (32 of 87). I'll update if any other errors pop up. I've got well over a million posts so this will probably take a while.

liam mcdermott’s picture

Not sure how those users got past the vBulletin sign-up form, I just checked and it disallows users with duplicate user names. That said, the vBulletin user table does allow duplicates (while Drupal's equivalent doesn't). This is definitely something I'll have to look out for.

Do let me know whether the import goes through okay!

challenge’s picture

An AJAX HTTP error occurred. HTTP Result Code: 500 Debugging information follows. Path: /batch?id=8&op=do StatusText: Service unavailable (with message) ResponseText: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a.contenttypeid' in 'where clause': SELECT COUNT(*) AS expression FROM (SELECT 1 AS expression FROM {vbulletin.attachment} a INNER JOIN {vbulletin.attachmenttype} av ON a.extension = av.extension WHERE (a.contenttypeid IS NULL ) ) subquery; Array ( ) in vbimportapi_import() (line 980 of [...]sitename/sites/all/modules/vbtodrupal/vbimportapi.module).

  • what does this mean? (asking if could be only related to my db)
  • in VB, attachments should be left in db or switched to files before doing the migration?
  • as now(feature and issue side), it would be better using 6.X release and then update the site to d7, until this will be more stable?

thanks

mattreba’s picture

robertorc87: I think this should be tracked in its own issue as it is not directly related to the original post. I encountered the same issue and believe I found a potential fix. Please see this issue: http://drupal.org/node/1624520

PaulE’s picture

Usernames that contain letters with umlauts trigger this issue as well. For example, a vBulletin user with the username "üsername" and "username" will trigger this issue as well.

liam mcdermott’s picture

a vBulletin user with the username "üsername" and "username" will trigger this issue as well.

Wow, that's interesting. Sorry I don't have much of an answer for this right now, but when I have time I'll test it. In the meantime: patches are definitely welcome! :)

And thanks for reporting the problem.

liam mcdermott’s picture

Title: 500 Error on import » Duplicate usernames in vBulletin table causing 500 error on import