Hostingunlock Posted March 25, 2022 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}
Sonya* Posted March 26, 2022 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
Hostingunlock Posted March 26, 2022 Author 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
Sonya* Posted March 26, 2022 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.
Hostingunlock Posted March 26, 2022 Author 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
Jim M Posted March 26, 2022 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.
Hostingunlock Posted March 26, 2022 Author 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
Solution Hostingunlock Posted March 26, 2022 Author Solution Posted March 26, 2022 solution SET @@global.sql_mode= 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'; Matt 1
Marc Posted March 28, 2022 Posted March 28, 2022 Glad to hear you managed to get the issue resolved there Matt 1
Stuart Silvester Posted April 5, 2022 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
Recommended Posts