Converting from MyBB 1.6 to IP.Board 3.2

25 posts in this topic

Posted

Alright so I've recently bought IP.Board (fabulous software by the way ;)) and I'm trying to run the converter on a test forum I've set up so I can make sure everything works before I convert my main forum which is running MyBB 1.6 to IPB 3.2.

Problem is, whenever I try to convert the custom profile fields, the member groups, and the members it results in a "database driver error", which is very confusing.

Any way to resolve this?

Share this post


Link to post
Share on other sites

Posted

Have a look at this article to find the 'real' error behind the error page: http://community.invisionpower.com/resources/documentation/index.html/_/knowledge-base/recurring-non-version-specific-issues/database-driver-errors-r326

zzzithrommax likes this

Share this post


Link to post
Share on other sites

Posted

Thanks smile.png

Well if it helps, here's my logs:
Converter log:
1-2: No friend ID found 1-9: No friend ID found 1-8: No friend ID found 1-6: No friend ID found 1-3: No friend ID found 1-417: No friend ID found 1-418: No friend ID found 1: reg_error_username_taken with name: lucasbytegenius. Member has still been created but with username as lucasbytegenius1311923555 1-2: No friend ID found 1-9: No friend ID found 1-8: No friend ID found 1-6: No friend ID found 1-3: No friend ID found 1-417: No friend ID found 1-418: No friend ID found 1: reg_error_username_taken with name: lucasbytegenius. Member has still been created but with username as lucasbytegenius1311930720 1-2: No friend ID found 1-9: No friend ID found 1-8: No friend ID found 1-6: No friend ID found 1-3: No friend ID found 1-417: No friend ID found 1-418: No friend ID found 1: reg_error_username_taken with name: lucasbytegenius. Member has still been created but with username as lucasbytegenius1311930725 1-2: No friend ID found 1-9: No friend ID found 1-8: No friend ID found 1-6: No friend ID found 1-3: No friend ID found 1-417: No friend ID found 1-418: No friend ID found

SQL error log:
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Fri, 29 Jul 2011 06:54:59 +0000 Error: 1060 - Duplicate column name 'field_1' IP Address: **************** - /admin/index.php?adsess=ecc6b87e203dedf920dae609032048a9&app=convert&module=board&section=mybb ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: ALTER TABLE pfields_content ADD field_1 text NULL .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | admin/applications_addon/ips/convert/sources/lib_board.php | [db_main_mysql].addField | 2099 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications_addon/ips/convert/modules_admin/board/mybb.php | [lib_board].convertPField | 1555 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | | [admin_convert_board_mybb].convert_pfields | | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications_addon/ips/convert/modules_admin/board/mybb.php | [].call_user_func | 97 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/sources/base/ipsController.php | [admin_convert_board_mybb].doExecute | 299 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Fri, 29 Jul 2011 06:55:37 +0000 Error: 1054 - Unknown column 'g_avatar_upload' in 'field list' IP Address: **************- /admin/index.php?adsess=ecc6b87e203dedf920dae609032048a9&app=convert&app=convert&module=board&section=mybb&do=groups&st=&cycle=100&total=10 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: INSERT INTO groups (`g_view_board`,`g_mem_info`,`g_other_topics`,`g_use_search`,`g_edit_profile`,`g_post_new_topics`,`g_reply_own_topics`,`g_reply_other_topics`,`g_edit_posts`,`g_delete_own_posts`,`g_post_polls`,`g_vote_polls`,`g_use_pm`,`g_is_supmod`,`g_title`,`g_access_offline`,`g_attach_max`,`g_avatar_upload`,`prefix`,`suffix`,`g_max_messages`,`g_max_mass_pm`,`g_perm_id`,`g_bypass_badwords`,`g_topic_rate_setting`,`g_dname_changes`,`g_rep_max_positive`,`g_rep_max_negative`) VALUES(1,0,1,1,0,0,'','',0,0,0,0,0,0,'Guests_converted',0,0,0,'','',0,0,7,0,0,0,0,0) .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | admin/applications_addon/ips/convert/sources/lib_master.php | [db_main_mysql].insert | 1901 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications_addon/ips/convert/modules_admin/board/mybb.php | [lib_master].convertGroup | 366 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | | [admin_convert_board_mybb].convert_groups | | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications_addon/ips/convert/modules_admin/board/mybb.php | [].call_user_func | 97 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/sources/base/ipsController.php | [admin_convert_board_mybb].doExecute | 299 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Fri, 29 Jul 2011 06:55:41 +0000 Error: 1054 - Unknown column 'g_avatar_upload' in 'field list' IP Address: ************** - /admin/index.php?adsess=ecc6b87e203dedf920dae609032048a9&app=convert&app=convert&module=board&section=mybb&do=groups&st=&cycle=100&total=10 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: INSERT INTO groups (`g_view_board`,`g_mem_info`,`g_other_topics`,`g_use_search`,`g_edit_profile`,`g_post_new_topics`,`g_reply_own_topics`,`g_reply_other_topics`,`g_edit_posts`,`g_delete_own_posts`,`g_post_polls`,`g_vote_polls`,`g_use_pm`,`g_is_supmod`,`g_title`,`g_access_offline`,`g_attach_max`,`g_avatar_upload`,`prefix`,`suffix`,`g_max_messages`,`g_max_mass_pm`,`g_perm_id`,`g_bypass_badwords`,`g_topic_rate_setting`,`g_dname_changes`,`g_rep_max_positive`,`g_rep_max_negative`) VALUES(1,0,1,1,0,0,'','',0,0,0,0,0,0,'Guests_converted',0,0,0,'','',0,0,7,0,0,0,0,0) .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | admin/applications_addon/ips/convert/sources/lib_master.php | [db_main_mysql].insert | 1901 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications_addon/ips/convert/modules_admin/board/mybb.php | [lib_master].convertGroup | 366 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | | [admin_convert_board_mybb].convert_groups | | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications_addon/ips/convert/modules_admin/board/mybb.php | [].call_user_func | 97 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/sources/base/ipsController.php | [admin_convert_board_mybb].doExecute | 299 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Fri, 29 Jul 2011 06:55:52 +0000 Error: 1054 - Unknown column 'g_avatar_upload' in 'field list' IP Address: *************** - /admin/index.php?adsess=ecc6b87e203dedf920dae609032048a9&app=convert&app=convert&module=board&section=mybb&do=groups&st=&cycle=100&total=10 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: INSERT INTO groups (`g_view_board`,`g_mem_info`,`g_other_topics`,`g_use_search`,`g_edit_profile`,`g_post_new_topics`,`g_reply_own_topics`,`g_reply_other_topics`,`g_edit_posts`,`g_delete_own_posts`,`g_post_polls`,`g_vote_polls`,`g_use_pm`,`g_is_supmod`,`g_title`,`g_access_offline`,`g_attach_max`,`g_avatar_upload`,`prefix`,`suffix`,`g_max_messages`,`g_max_mass_pm`,`g_perm_id`,`g_bypass_badwords`,`g_topic_rate_setting`,`g_dname_changes`,`g_rep_max_positive`,`g_rep_max_negative`) VALUES(1,0,1,1,0,0,'','',0,0,0,0,0,0,'Guests_converted',0,0,0,'','',0,0,7,0,0,0,0,0) .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | admin/applications_addon/ips/convert/sources/lib_master.php | [db_main_mysql].insert | 1901 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications_addon/ips/convert/modules_admin/board/mybb.php | [lib_master].convertGroup | 366 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | | [admin_convert_board_mybb].convert_groups | | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications_addon/ips/convert/modules_admin/board/mybb.php | [].call_user_func | 97 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/sources/base/ipsController.php | [admin_convert_board_mybb].doExecute | 299 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Fri, 29 Jul 2011 06:55:52 +0000 Error: 1054 - Unknown column 'g_avatar_upload' in 'field list' IP Address: ************** - /admin/index.php?adsess=ecc6b87e203dedf920dae609032048a9&app=convert&app=convert&module=board&section=mybb&do=groups&st=&cycle=100&total=10 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: INSERT INTO groups (`g_view_board`,`g_mem_info`,`g_other_topics`,`g_use_search`,`g_edit_profile`,`g_post_new_topics`,`g_reply_own_topics`,`g_reply_other_topics`,`g_edit_posts`,`g_delete_own_posts`,`g_post_polls`,`g_vote_polls`,`g_use_pm`,`g_is_supmod`,`g_title`,`g_access_offline`,`g_attach_max`,`g_avatar_upload`,`prefix`,`suffix`,`g_max_messages`,`g_max_mass_pm`,`g_perm_id`,`g_bypass_badwords`,`g_topic_rate_setting`,`g_dname_changes`,`g_rep_max_positive`,`g_rep_max_negative`) VALUES(1,0,1,1,0,0,'','',0,0,0,0,0,0,'Guests_converted',0,0,0,'','',0,0,7,0,0,0,0,0) .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | admin/applications_addon/ips/convert/sources/lib_master.php | [db_main_mysql].insert | 1901 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications_addon/ips/convert/modules_admin/board/mybb.php | [lib_master].convertGroup | 366 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | | [admin_convert_board_mybb].convert_groups | | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications_addon/ips/convert/modules_admin/board/mybb.php | [].call_user_func | 97 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/sources/base/ipsController.php | [admin_convert_board_mybb].doExecute | 299 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Fri, 29 Jul 2011 07:09:35 +0000 Error: 1060 - Duplicate column name 'field_1' IP Address: ************** - /admin/index.php?adsess=ecc6b87e203dedf920dae609032048a9&app=convert&module=board&section=mybb ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: ALTER TABLE pfields_content ADD field_1 text NULL .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | admin/applications_addon/ips/convert/sources/lib_board.php | [db_main_mysql].addField | 2099 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications_addon/ips/convert/modules_admin/board/mybb.php | [lib_board].convertPField | 1555 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | | [admin_convert_board_mybb].convert_pfields | | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications_addon/ips/convert/modules_admin/board/mybb.php | [].call_user_func | 97 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/sources/base/ipsController.php | [admin_convert_board_mybb].doExecute | 299 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Fri, 29 Jul 2011 07:09:44 +0000 Error: 1060 - Duplicate column name 'field_2' IP Address: *************** - /admin/index.php?adsess=ecc6b87e203dedf920dae609032048a9&app=convert&module=board&section=mybb ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: ALTER TABLE pfields_content ADD field_2 text NULL .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | admin/applications_addon/ips/convert/sources/lib_board.php | [db_main_mysql].addField | 2099 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications_addon/ips/convert/modules_admin/board/mybb.php | [lib_board].convertPField | 1555 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | | [admin_convert_board_mybb].convert_pfields | | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications_addon/ips/convert/modules_admin/board/mybb.php | [].call_user_func | 97 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/sources/base/ipsController.php | [admin_convert_board_mybb].doExecute | 299 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Fri, 29 Jul 2011 07:10:05 +0000 Error: 1054 - Unknown column 'view_avs' in 'field list' IP Address:************ - /admin/index.php?adsess=ecc6b87e203dedf920dae609032048a9&app=convert&app=convert&module=board&section=mybb&do=members&st=&cycle=250&total=257 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: INSERT INTO members (`ip_address`,`posts`,`title`,`allow_admin_mails`,`time_offset`,`warn_level`,`last_post`,`view_sigs`,`view_avs`,`bday_day`,`bday_month`,`bday_year`,`msg_show_notification`,`misc`,`last_visit`,`last_activity`,`dst_in_use`,`coppa_user`,`members_disable_pm`,`conv_password`,`name`,`member_group_id`,`email`,`joined`,`member_login_key`,`member_login_key_expire`,`members_display_name`,`members_seo_name`,`members_l_display_name`,`members_l_username`,`members_pass_hash`,`members_pass_salt`,`mgroup_others`) VALUES('72.205.15.162',13,'',1,-5,0,1300676796,1,1,27,7,1997,1,'mCRpfGT8',1308895439,1309139160,1,0,0,'0f59f107a25608dde81ad4eccb58e422','CareyS','','fanmancw@gmail.com',1286317997,'b66fc4c71eb2cc9ac4fe61404297f00d',1312528205,'CareyS','careys','careys','careys','','','') .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | admin/applications_addon/ips/convert/sources/lib_master.php | [db_main_mysql].insert | 1216 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications_addon/ips/convert/modules_admin/board/mybb.php | [lib_master].convertMember | 576 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | | [admin_convert_board_mybb].convert_members | | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications_addon/ips/convert/modules_admin/board/mybb.php | [].call_user_func | 97 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/sources/base/ipsController.php | [admin_convert_board_mybb].doExecute | 299 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Fri, 29 Jul 2011 07:12:35 +0000 Error: 1054 - Unknown column 'view_avs' in 'field list' IP Address:**************- /admin/index.php?adsess=ecc6b87e203dedf920dae609032048a9&app=convert&app=convert&module=board&section=mybb&do=members&st=&cycle=250&total=257 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: INSERT INTO members (`ip_address`,`posts`,`title`,`allow_admin_mails`,`time_offset`,`warn_level`,`last_post`,`view_sigs`,`view_avs`,`bday_day`,`bday_month`,`bday_year`,`msg_show_notification`,`misc`,`last_visit`,`last_activity`,`dst_in_use`,`coppa_user`,`members_disable_pm`,`conv_password`,`name`,`member_group_id`,`email`,`joined`,`member_login_key`,`member_login_key_expire`,`members_display_name`,`members_seo_name`,`members_l_display_name`,`members_l_username`,`members_pass_hash`,`members_pass_salt`,`mgroup_others`) VALUES('72.205.15.162',13,'',1,-5,0,1300676796,1,1,27,7,1997,1,'mCRpfGT8',1308895439,1309139160,1,0,0,'0f59f107a25608dde81ad4eccb58e422','CareyS','','fanmancw@gmail.com',1286317997,'c6f96064d8c678e8a24568f38bf0da86',1312528355,'CareyS','careys','careys','careys','','','') .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | admin/applications_addon/ips/convert/sources/lib_master.php | [db_main_mysql].insert | 1216 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications_addon/ips/convert/modules_admin/board/mybb.php | [lib_master].convertMember | 576 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | | [admin_convert_board_mybb].convert_members | | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications_addon/ips/convert/modules_admin/board/mybb.php | [].call_user_func | 97 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/sources/base/ipsController.php | [admin_convert_board_mybb].doExecute | 299 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Fri, 29 Jul 2011 09:11:44 +0000 Error: 1060 - Duplicate column name 'field_1' IP Address: ****************** - /admin/index.php?adsess=6d5d6cfb3a571fa6e864ae7e7edebae2&app=convert&module=board&section=mybb ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: ALTER TABLE pfields_content ADD field_1 text NULL .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | admin/applications_addon/ips/convert/sources/lib_board.php | [db_main_mysql].addField | 2099 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications_addon/ips/convert/modules_admin/board/mybb.php | [lib_board].convertPField | 1555 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | | [admin_convert_board_mybb].convert_pfields | | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications_addon/ips/convert/modules_admin/board/mybb.php | [].call_user_func | 97 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/sources/base/ipsController.php | [admin_convert_board_mybb].doExecute | 299 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Fri, 29 Jul 2011 09:12:01 +0000 Error: 1054 - Unknown column 'view_avs' in 'field list' IP Address: *************** - /admin/index.php?adsess=6d5d6cfb3a571fa6e864ae7e7edebae2&app=convert&app=convert&module=board&section=mybb&do=members&st=&cycle=250&total=265 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: INSERT INTO members (`ip_address`,`posts`,`title`,`allow_admin_mails`,`time_offset`,`warn_level`,`last_post`,`view_sigs`,`view_avs`,`bday_day`,`bday_month`,`bday_year`,`msg_show_notification`,`misc`,`last_visit`,`last_activity`,`dst_in_use`,`coppa_user`,`members_disable_pm`,`conv_password`,`name`,`member_group_id`,`email`,`joined`,`member_login_key`,`member_login_key_expire`,`members_display_name`,`members_seo_name`,`members_l_display_name`,`members_l_username`,`members_pass_hash`,`members_pass_salt`,`mgroup_others`) VALUES('72.205.15.162',13,'',1,-5,0,1300676796,1,1,27,7,1997,1,'mCRpfGT8',1308895439,1309139160,1,0,0,'0f59f107a25608dde81ad4eccb58e422','CareyS','','fanmancw@gmail.com',1286317997,'584b1eac8b59da8881e841f8a5c5cd8d',1312535521,'CareyS','careys','careys','careys','','','') .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | admin/applications_addon/ips/convert/sources/lib_master.php | [db_main_mysql].insert | 1216 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications_addon/ips/convert/modules_admin/board/mybb.php | [lib_master].convertMember | 576 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | | [admin_convert_board_mybb].convert_members | | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications_addon/ips/convert/modules_admin/board/mybb.php | [].call_user_func | 97 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/sources/base/ipsController.php | [admin_convert_board_mybb].doExecute | 299 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Fri, 29 Jul 2011 09:12:05 +0000 Error: 1054 - Unknown column 'view_avs' in 'field list' IP Address: ************ - /admin/index.php?adsess=6d5d6cfb3a571fa6e864ae7e7edebae2&app=convert&app=convert&module=board&section=mybb&do=members&st=&cycle=250&total=265 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: INSERT INTO members (`ip_address`,`posts`,`title`,`allow_admin_mails`,`time_offset`,`warn_level`,`last_post`,`view_sigs`,`view_avs`,`bday_day`,`bday_month`,`bday_year`,`msg_show_notification`,`misc`,`last_visit`,`last_activity`,`dst_in_use`,`coppa_user`,`members_disable_pm`,`conv_password`,`name`,`member_group_id`,`email`,`joined`,`member_login_key`,`member_login_key_expire`,`members_display_name`,`members_seo_name`,`members_l_display_name`,`members_l_username`,`members_pass_hash`,`members_pass_salt`,`mgroup_others`) VALUES('72.205.15.162',13,'',1,-5,0,1300676796,1,1,27,7,1997,1,'mCRpfGT8',1308895439,1309139160,1,0,0,'0f59f107a25608dde81ad4eccb58e422','CareyS','','fanmancw@gmail.com',1286317997,'24432abc282c75ae196c0772b35ba8c2',1312535525,'CareyS','careys','careys','careys','','','') .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | admin/applications_addon/ips/convert/sources/lib_master.php | [db_main_mysql].insert | 1216 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications_addon/ips/convert/modules_admin/board/mybb.php | [lib_master].convertMember | 576 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | | [admin_convert_board_mybb].convert_members | | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications_addon/ips/convert/modules_admin/board/mybb.php | [].call_user_func | 97 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/sources/base/ipsController.php | [admin_convert_board_mybb].doExecute | 299 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Fri, 29 Jul 2011 09:14:17 +0000 Error: 1060 - Duplicate column name 'field_2' IP Address: **************** - /admin/index.php?adsess=6d5d6cfb3a571fa6e864ae7e7edebae2&app=convert&module=board&section=mybb ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: ALTER TABLE pfields_content ADD field_2 text NULL .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | admin/applications_addon/ips/convert/sources/lib_board.php | [db_main_mysql].addField | 2099 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications_addon/ips/convert/modules_admin/board/mybb.php | [lib_board].convertPField | 1555 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | | [admin_convert_board_mybb].convert_pfields | | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications_addon/ips/convert/modules_admin/board/mybb.php | [].call_user_func | 97 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/sources/base/ipsController.php | [admin_convert_board_mybb].doExecute | 299 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

I hope this can get solved soon.

1: reg_error_username_taken with name: lucasbytegenius. Member has still been created but with username as lucasbytegenius1311923405

























































































































































































































































































Share this post


Link to post
Share on other sites

Posted

I don't mean to be pushy, but I'm itching to get this working and have my forum converted. Is there any way to fix these errors and have the conversion process go smoothly as it should?

Share this post


Link to post
Share on other sites

Posted

Please submit a ticket and we can provide you with the appropriate fixes, the main converters have not been updated yet, thanks!

Share this post


Link to post
Share on other sites

Posted

[quote name='Alex' timestamp='1311962406' post='2143090']
Please submit a ticket and we can provide you with the appropriate fixes, the main converters have not been updated yet, thanks!

That explains it! Thanks, I've submitted the ticket :)

Share this post


Link to post
Share on other sites

Posted

I submitted the ticket, and I just checked the tracker and it appears my ticket was deleted cry.png What happened?

Share this post


Link to post
Share on other sites

Posted

I haven't seen your ticket come through to the conversions department, I'll have a look for you though. You can send me a PM here with your email address you use on the client area and I can check it out.

Share this post


Link to post
Share on other sites

Posted

[quote name='Alex' timestamp='1311978690' post='2143312']
I haven't seen your ticket come through to the conversions department, I'll have a look for you though. You can send me a PM here with your email address you use on the client area and I can check it out.

I've submitted a total of two tickets today and they both got deleted for some reason cry.png . I submitted them to the IP.Board 3.x section as there doesn't seem to be a section for the converters.

I'll send you a PM with the email :)

Share this post


Link to post
Share on other sites

Posted

[quote name='lucasbytegenius' timestamp='1311983505' post='2143345']

I've submitted a total of two tickets today and they both got deleted for some reason cry.png . I submitted them to the IP.Board 3.x section as there doesn't seem to be a section for the converters.

I'll send you a PM with the email :)

Tracker isn't for tickets.

Share this post


Link to post
Share on other sites

Posted

[quote name='.time' timestamp='1311983953' post='2143348']
Tracker isn't for tickets.

Sigh. That explains a lot. Thanks xD

Share this post


Link to post
Share on other sites

Posted

Please submit the tickets in the client area :) http://www.invisionpower.com/clients

Share this post


Link to post
Share on other sites

Posted

[quote name='Alex' timestamp='1312028369' post='2143635']
Please submit the tickets in the client area smile.pnghttp://www.invisionpower.com/clients

I did, Jason Hanna replied and I sent the cache data to him, haven't heard back from him yet.

Share this post


Link to post
Share on other sites

Posted

Well I had to install IP.Board 3.1.4 and then use the old converters Jason gave me, but it's working now! :) Really happy.

Share this post


Link to post
Share on other sites

Posted

Glad to hear it's been resolved for you :)

Share this post


Link to post
Share on other sites

Posted

Not to bump this or anything but where can i find the updated converter for MyBB 1.6?

Share this post


Link to post
Share on other sites

Posted

I'll see if I can prompt them to be updated on the website

Share this post


Link to post
Share on other sites

Posted

Ya, im trying to convert and im getting errors and i figured it needs updating.

Share this post


Link to post
Share on other sites

Posted

Due to it being the weekend the website won't be updated, I've attached the most recent converters build.

converters-aug-05-2011.zip

Share this post


Link to post
Share on other sites

Posted

Also when converting do i pick "Skip - Don't create those tables or Drop original tables and overwrite"?

Share this post


Link to post
Share on other sites

Posted

That's when installing the converters correct? Choose skip.

Share this post


Link to post
Share on other sites

Posted

I tried those, but the driver error still appears when trying to convert members, posts, topics, this is upsetting.

Share this post


Link to post
Share on other sites

Posted

Can you post the whole SQL error here please? (/cache/sql_error_log_date.cgi)

Share this post


Link to post
Share on other sites

Posted



Date: Sat, 06 Aug 2011 18:49:10 +0000


Error: 1054 - Unknown column 'notes' in 'field list'


IP Address: 71.174.4.125 - /forums/admin/index.php?adsess=7b1b8414c52d83a74e300af029aad526&app=convert&app=convert&module=board&section=mybb&do=members&st=&cycle=250&total=580


----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------


mySQL query error: INSERT INTO profile_portal (`pp_reputation_points`,`notes`,`signature`,`pp_setting_count_comments`,`pp_setting_count_friends`,`pp_member_id`,`pp_photo_type`) VALUES(1,'','',1,1,2,'')


.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.


| File                                                                   	| Function                                                                  	| Line No.      	|


|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|


| admin/applications_addon/ips/convert/sources/lib_master.php            	| [db_main_mysql].insert                                                    	| 1372          	|


'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'


| admin/applications_addon/ips/convert/modules_admin/board/mybb.php      	| [lib_master].convertMember                                                	| 575           	|


'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'


|                                                                        	| [admin_convert_board_mybb].convert_members                                	|               	|


'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'


| admin/applications_addon/ips/convert/modules_admin/board/mybb.php      	| [].call_user_func                                                         	| 97            	|


'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'


| admin/sources/base/ipsController.php                                   	| [admin_convert_board_mybb].doExecute                                      	| 299           	|


'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'


----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------


Date: Sat, 06 Aug 2011 18:51:40 +0000


Error: 1062 - Duplicate entry 'd90a64da2c7aa2f1481cf0631b28c837' for key 'PRIMARY'


IP Address: 71.174.4.125 - /forums/admin/index.php?adsess=d179d2791b275e67a3302288c4f5eaf3&app=convert&module=board&section=mybb


----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------


mySQL query error: INSERT INTO core_like (`like_app`,`like_area`,`like_rel_id`,`like_member_id`,`like_id`,`like_lookup_id`,`like_lookup_area`) VALUES('forums','topics',249,678,'d90a64da2c7aa2f1481cf0631b28c837','d4d8126ad4c8b20e94051e5f2ae48e76','2738bf621e92f87d99c6b29e9fc64476')


.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.


| File                                                                   	| Function                                                                  	| Line No.      	|


|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|


| admin/applications_addon/ips/convert/sources/lib_master.php            	| [db_main_mysql].insert                                                    	| 2018          	|


'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'


| admin/applications_addon/ips/convert/sources/lib_board.php             	| [lib_master].convertFollow                                                	| 1951          	|


'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'


| admin/applications_addon/ips/convert/modules_admin/board/mybb.php      	| [lib_board].convertTopicSubscription                                      	| 888           	|


'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'


|                                                                        	| [admin_convert_board_mybb].convert_topics                                 	|               	|


'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'


| admin/applications_addon/ips/convert/modules_admin/board/mybb.php      	| [].call_user_func                                                         	| 97            	|


'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'


| admin/sources/base/ipsController.php                                   	| [admin_convert_board_mybb].doExecute                                      	| 299           	|


'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'


----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------


Date: Sat, 06 Aug 2011 18:52:25 +0000


Error: 1062 - Duplicate entry 'ec6d608b5ebad2aa408d1b2969633db9' for key 'PRIMARY'


IP Address: 71.174.4.125 - /forums/admin/index.php?adsess=d179d2791b275e67a3302288c4f5eaf3&app=convert&module=board&section=mybb


----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------


mySQL query error: INSERT INTO core_like (`like_app`,`like_area`,`like_rel_id`,`like_member_id`,`like_id`,`like_lookup_id`,`like_lookup_area`) VALUES('forums','topics',2,1,'ec6d608b5ebad2aa408d1b2969633db9','7755c4c5ade204ce8d5a408d9829e680','3e2b3668d5fde75d58550cf39166c2ad')


.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.


| File                                                                   	| Function                                                                  	| Line No.      	|


|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|


| admin/applications_addon/ips/convert/sources/lib_master.php            	| [db_main_mysql].insert                                                    	| 2018          	|


'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'


| admin/applications_addon/ips/convert/sources/lib_board.php             	| [lib_master].convertFollow                                                	| 1951          	|


'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'


| admin/applications_addon/ips/convert/modules_admin/board/mybb.php      	| [lib_board].convertTopicSubscription                                      	| 888           	|


'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'


|                                                                        	| [admin_convert_board_mybb].convert_topics                                 	|               	|


'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'


| admin/applications_addon/ips/convert/modules_admin/board/mybb.php      	| [].call_user_func                                                         	| 97            	|


'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'


| admin/sources/base/ipsController.php                                   	| [admin_convert_board_mybb].doExecute                                      	| 299           	|


'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'


Douglas Haber likes this

Share this post


Link to post
Share on other sites

Posted

There you go.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now

  • Who's Browsing   0 members

    No registered users viewing this page.