Convert Xenforo to Invision I have an error help

[Hostingunlock]

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}

[Hostingunlock]

[Sonya*]

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]

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*]

Just now, Hostingunlock said:

how can i solve this problem

1. Ask in Xenforo support how to purge the database from garbage data before converting
2. Ask for a paid conversion service from providers.

2 minutes ago, Hostingunlock said:

can you help me

Unfortunately, no. 

[Hostingunlock]

24 minutes ago, Sonya* said:

1. Ask in Xenforo support how to purge the database from garbage data before converting
2. 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]

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]

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

 

[Hostingunlock]

solution 

SET @@global.sql_mode= 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

[Marc]

Glad to hear you managed to get the issue resolved there

[Stuart Silvester]

Just to let you know, the fixes for the URL and file count issues are included in 4.6.12.

[Hostingunlock]

excellent news

[Matt]

Welcome to Invision Community!