Hostingunlock Posted March 25, 2022 Share Posted March 25, 2022 i am trying to convert xenforo to invisioncommunity but i get this error #0 /home/admin/web/monigsm.com/public_html/applications/convert/sources/Software/Core/Xenforo.php(633): IPS\Db\_Select->first() #1 /home/admin/web/monigsm.com/public_html/applications/convert/sources/Library.php(285): IPS\convert\Software\Core\_Xenforo->convertAttachments() #2 /home/admin/web/monigsm.com/public_html/applications/convert/modules/admin/manage/convert.php(559): IPS\convert\_Library->process() #3 /home/admin/web/monigsm.com/public_html/system/Helpers/MultipleRedirect/MultipleRedirect.php(93): IPS\convert\modules\admin\manage\_convert->IPS\convert\modules\admin\manage\{closure}() #4 /home/admin/web/monigsm.com/public_html/applications/convert/modules/admin/manage/convert.php(578): IPS\Helpers\_MultipleRedirect->__construct() #5 /home/admin/web/monigsm.com/public_html/system/Dispatcher/Controller.php(90): IPS\convert\modules\admin\manage\_convert->runStep() #6 /home/admin/web/monigsm.com/public_html/applications/convert/modules/admin/manage/convert.php(45): IPS\Dispatcher\_Controller->execute() #7 /home/admin/web/monigsm.com/public_html/system/Dispatcher/Dispatcher.php(153): IPS\convert\modules\admin\manage\_convert->execute() #8 /home/admin/web/monigsm.com/public_html/admin/index.php(13): IPS\_Dispatcher->run() #9 {main} Link to comment Share on other sites More sharing options...
Hostingunlock Posted March 26, 2022 Author Share Posted March 26, 2022 Link to comment Share on other sites More sharing options...
Sonya* Posted March 26, 2022 Share Posted March 26, 2022 The table xf_conversation_message seems to be corrupted of inconsistent. There is an attachment in xf_attachment that references to xf_conversation_message, but the message does not exist. Hostingunlock 1 Link to comment Share on other sites More sharing options...
Hostingunlock Posted March 26, 2022 Author Share Posted March 26, 2022 38 minutes ago, Sonya* said: The table xf_conversation_message seems to be corrupted of inconsistent. There is an attachment in xf_attachment that references to xf_conversation_message, but the message does not exist. how can i solve this problem can you help me Link to comment Share on other sites More sharing options...
Sonya* Posted March 26, 2022 Share Posted March 26, 2022 Just now, Hostingunlock said: how can i solve this problem Ask in Xenforo support how to purge the database from garbage data before converting Ask for a paid conversion service from providers. 2 minutes ago, Hostingunlock said: can you help me Unfortunately, no. Link to comment Share on other sites More sharing options...
Hostingunlock Posted March 26, 2022 Author Share Posted March 26, 2022 24 minutes ago, Sonya* said: Ask in Xenforo support how to purge the database from garbage data before converting Ask for a paid conversion service from providers. Unfortunately, no. I just solved the previous problem thanks to you but I get another error INSERT INTO `downloads_files` ( `file_desc`, `file_name`, `file_cat`, `file_downloads`, `file_reviews`, `file_submitted`, `file_updated`, `file_submitter`, `file_topicid`, `file_version`, `file_changelog`, `file_featured`, `file_open`, `file_broken`, `file_broken_reason`, `file_broken_info`, `file_votes`, `file_new`, `file_topicseoname`, `file_post_key`, `file_rating`, `file_views`, `file_pendcomments`, `file_comments`, `file_unapproved_comments`, `file_hidden_comments`, `file_unapproved_reviews`, `file_hidden_reviews`, `file_size`, `file_approver`, `file_approvedon`, `file_ipaddress`, `file_name_furl`, `file_pinned`, `file_primary_screenshot`, `file_locked`, `file_last_comment`, `file_last_review`, `file_edit_time`, `file_edit_name`, `file_edit_reason`, `file_append_edit` ) VALUES ( 'Samsung A10 SM-A105FN bit 2 combination binary 2', 'Combination Samsung A10 SM-A105FN bit 2 u2 Binary 2 Binario 2', 2, 9, 0, 1563152701, 1563152701, 1, 0, 'A105FN combination bit 2 binario 2', 'A105FN_COMBINATION_FAC_FA90_A105FNXXU2ASG1_FACTORY_user_mid_noship COMBINATION_FAC_FA90_A105FNXXU2ASG1 Size: 764 MB Security Patch Level: U2 (BIT 2) Model: SM-A105FN Model Name: Samsung Galaxy A10', 0, 1, 0, NULL, NULL, NULL, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '127.0.0.1', 'combination-samsung-a10-sm-a105fn-bit-2-u2-binary-2-binario-2', 0, 0, 0, 1563152701, 1563152701, NULL, NULL, '', 0 ) Data too long for column 'file_version' at row 1 Link to comment Share on other sites More sharing options...
Jim M Posted March 26, 2022 Share Posted March 26, 2022 The data in that column is too long for what it would be in our software. It needs to be shrunken. If you have any modifications done to your previous software this may happen so you will need to review these items and make calls based on the data. Link to comment Share on other sites More sharing options...
Hostingunlock Posted March 26, 2022 Author Share Posted March 26, 2022 the process is complete but i have another problem Is there any query that can help me solve this problem that can leave me here ALTER TABLE `downloads_files` CHANGE COLUMN `file_version` `file_version` VARCHAR (32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL ;Data too long for column 'file_version' at row 14 ALTER TABLE `downloads_reviews` CHANGE COLUMN `review_version` `review_version` VARCHAR (32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT 'The version being reviewed';Data too long for column 'review_version' at row 10 Link to comment Share on other sites More sharing options...
Solution Hostingunlock Posted March 26, 2022 Author Solution Share Posted March 26, 2022 solution SET @@global.sql_mode= 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'; Matt 1 Link to comment Share on other sites More sharing options...
Marc Posted March 28, 2022 Share Posted March 28, 2022 Glad to hear you managed to get the issue resolved there Matt 1 Link to comment Share on other sites More sharing options...
Stuart Silvester Posted April 5, 2022 Share Posted April 5, 2022 Just to let you know, the fixes for the URL and file count issues are included in 4.6.12. Hostingunlock 1 Link to comment Share on other sites More sharing options...
Hostingunlock Posted April 5, 2022 Author Share Posted April 5, 2022 excellent news Matt 1 Link to comment Share on other sites More sharing options...
Management Matt Posted April 5, 2022 Management Share Posted April 5, 2022 Welcome to Invision Community! Link to comment Share on other sites More sharing options...
Recommended Posts