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
Comment #1
fosstux commentedI have exactly the same problem. Any news on that issue?
Please help. Thank you.
Christopher
Comment #2
liam mcdermott commentedIs 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).
Comment #3
justin.nethers commentedI 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?
Comment #4
liam mcdermott commentedThere'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.
Comment #5
justin.nethers commentedGreat, thanks for the reply. I will give that a shot now.
Comment #6
justin.nethers commentedOk, 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.
Comment #7
liam mcdermott commentedNot 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!
Comment #8
challenge commentedAn 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).thanks
Comment #9
mattreba commentedrobertorc87: 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
Comment #10
PaulE commentedUsernames 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.
Comment #11
liam mcdermott commentedWow, 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.
Comment #12
liam mcdermott commented