lucasbytegenius

Converting from MyBB 1.6 to IP.Board 3.2

25 posts in this topic

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

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

Thanks %7Boption%7D

Well if it helps, here's my logs:
Converter log:

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


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'



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


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'



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


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'



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


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'



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


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'



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


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'



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


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'



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


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'



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


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'



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


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'



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


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'



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


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'



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


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'



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


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.

Share this post


Link to post
Share on other sites

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

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

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

I submitted the ticket, and I just checked the tracker and it appears my ticket was deleted %7Boption%7D What happened?

Share this post


Link to post
Share on other sites

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

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 %7Boption%7D . 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


I've submitted a total of two tickets today and they both got deleted for some reason [img]

[/img] . 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

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

Share this post


Link to post
Share on other sites

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

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

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

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

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

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



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

  • Recently Browsing   0 members

    No registered users viewing this page.