Jump to content


Photo

Converting from MyBB 1.6 to IP.Board 3.2


  • Please log in to reply
24 replies to this topic

#1 lucasbytegenius

lucasbytegenius

    IPB Full Member

  • Members
  • PipPipPip
  • 161 posts

Posted 29 July 2011 - 02:14 AM

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?

Posted Image


#2 tera▀yte

tera▀yte

    Needs Hobby

  • +Clients
  • 4,155 posts

Posted 29 July 2011 - 05:29 AM

Have a look at this article to find the 'real' error behind the error page: http://community.inv...ver-errors-r326
  • zzzithrommax likes this

#3 lucasbytegenius

lucasbytegenius

    IPB Full Member

  • Members
  • PipPipPip
  • 161 posts

Posted 29 July 2011 - 05:37 AM

Thanks Posted Image

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'
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.

Posted Image


#4 lucasbytegenius

lucasbytegenius

    IPB Full Member

  • Members
  • PipPipPip
  • 161 posts

Posted 29 July 2011 - 12:49 PM

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?

Posted Image


#5 Alex

Alex

    Needs Hobby

  • +Clients
  • 4,487 posts

Posted 29 July 2011 - 01:00 PM

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

Alex Hobbs
alex[at]alexhobbs.co.uk | Twitter


#6 lucasbytegenius

lucasbytegenius

    IPB Full Member

  • Members
  • PipPipPip
  • 161 posts

Posted 29 July 2011 - 01:13 PM

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 :)

Posted Image


#7 lucasbytegenius

lucasbytegenius

    IPB Full Member

  • Members
  • PipPipPip
  • 161 posts

Posted 29 July 2011 - 02:48 PM

I submitted the ticket, and I just checked the tracker and it appears my ticket was deleted Posted Image What happened?

Posted Image


#8 Alex

Alex

    Needs Hobby

  • +Clients
  • 4,487 posts

Posted 29 July 2011 - 05:31 PM

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.

Alex Hobbs
alex[at]alexhobbs.co.uk | Twitter


#9 lucasbytegenius

lucasbytegenius

    IPB Full Member

  • Members
  • PipPipPip
  • 161 posts

Posted 29 July 2011 - 06:51 PM

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 Posted Image . 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 :)

Posted Image


#10 .time

.time

    Spam Happy

  • Members
  • PipPipPipPipPip
  • 768 posts

Posted 29 July 2011 - 06:59 PM

I've submitted a total of two tickets today and they both got deleted for some reason Posted Image . 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.

#11 lucasbytegenius

lucasbytegenius

    IPB Full Member

  • Members
  • PipPipPip
  • 161 posts

Posted 29 July 2011 - 07:06 PM

Tracker isn't for tickets.

Sigh. That explains a lot. Thanks xD

Posted Image


#12 Alex

Alex

    Needs Hobby

  • +Clients
  • 4,487 posts

Posted 30 July 2011 - 07:19 AM

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

Alex Hobbs
alex[at]alexhobbs.co.uk | Twitter


#13 lucasbytegenius

lucasbytegenius

    IPB Full Member

  • Members
  • PipPipPip
  • 161 posts

Posted 30 July 2011 - 12:31 PM

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

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

Posted Image


#14 lucasbytegenius

lucasbytegenius

    IPB Full Member

  • Members
  • PipPipPip
  • 161 posts

Posted 31 July 2011 - 12:23 AM

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.

Posted Image


#15 Alex

Alex

    Needs Hobby

  • +Clients
  • 4,487 posts

Posted 31 July 2011 - 07:10 AM

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

Alex Hobbs
alex[at]alexhobbs.co.uk | Twitter


#16 BoxingBB

BoxingBB

    IPB Newbie

  • Members
  • Pip
  • 34 posts

Posted 05 August 2011 - 03:44 PM

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

#17 Alex

Alex

    Needs Hobby

  • +Clients
  • 4,487 posts

Posted 05 August 2011 - 05:11 PM

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

Alex Hobbs
alex[at]alexhobbs.co.uk | Twitter


#18 BoxingBB

BoxingBB

    IPB Newbie

  • Members
  • Pip
  • 34 posts

Posted 05 August 2011 - 10:28 PM

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

#19 Alex

Alex

    Needs Hobby

  • +Clients
  • 4,487 posts

Posted 06 August 2011 - 06:26 AM

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

Attached File  converters-aug-05-2011.zip   1.64MB   24 downloads

Alex Hobbs
alex[at]alexhobbs.co.uk | Twitter


#20 BoxingBB

BoxingBB

    IPB Newbie

  • Members
  • Pip
  • 34 posts

Posted 06 August 2011 - 07:43 AM

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




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users