Owdy Posted December 2, 2020 Share Posted December 2, 2020 I'm trying to convert SMF. All goes well untill end of attachments. Any ideas what to do? 🙂PS\convert\_Library::process: Data too long for column 'log_message' at row 1 Logs INSERT INTO `convert_logs` ( `log_message`, `log_app`, `log_severity`, `log_method`, `log_item_id`, `log_time` ) VALUES ( 'attachment_file_missing - /home/halu/public_html/Yabbse/attachments/32318_t1_ashx_attach1idRgAAAADmmEv9PKKvQ4oBqRQNZomPBwDC2fzi22fpGYTZtymL8wbDrEAADR2fin7AABdHAnbM02eT5ABpTWls3feAAAEk4LJAAAJattid0EADy2fJG2FKMNRrXCQhwtWxz3attcnt15feb5c740bb9f0b99780181b69294c07', 2, 2, 'IPS\convert\Library\_Core::convertAttachment', 32318, 1606872507 ) Data too long for column 'log_message' at row 1 #0 /home/halu/public_html/foorumi/system/Db/Db.php(948): IPS\_Db->preparedQuery('/*halu...', Array) #1 /home/halu/public_html/foorumi/applications/convert/sources/App.php(722): IPS\_Db->insert('convert_logs', Array) #2 /home/halu/public_html/foorumi/applications/convert/sources/Library/Core.php(985): IPS\convert\_App->log('attachment_file...', 'IPS\\convert\\Lib...', 2, 32318) #3 /home/halu/public_html/foorumi/applications/convert/sources/Library/Forums.php(1969): IPS\convert\Library\_Core->convertAttachment(Array, Array, '/home/halu...', NULL, NULL) #4 /home/halu/public_html/foorumi/applications/convert/sources/Software/Forums/Smf.php(562): IPS\convert\Library\_Forums->convertAttachment(Array, Array, '/home/fbodyfinl...') #5 /home/halu/public_html/foorumi/applications/convert/sources/Library.php(285): IPS\convert\Software\Forums\_Smf->convertAttachments() #6 /home/halu/public_html/foorumi/applications/convert/modules/admin/manage/convert.php(553): IPS\convert\_Library->process(15270, 'convertAttachme...', 10) #7 /home/halu/public_html/foorumi/system/Helpers/MultipleRedirect/MultipleRedirect.php(92): IPS\convert\modules\admin\manage\_convert->IPS\convert\modules\admin\manage\{closure}(15270) #8 /home/halu/public_html/foorumi/applications/convert/modules/admin/manage/convert.php(572): IPS\Helpers\_MultipleRedirect->__construct(Object(IPS\Http\Url\Internal), Object(Closure), Object(Closure)) #9 /home/halu/public_html/foorumi/system/Dispatcher/Controller.php(90): IPS\convert\modules\admin\manage\_convert->runStep() #10 /home/halu/public_html/foorumi/applications/convert/modules/admin/manage/convert.php(45): IPS\Dispatcher\_Controller->execute() #11 /home/halu/public_html/foorumi/system/Dispatcher/Dispatcher.php(152): IPS\convert\modules\admin\manage\_convert->execute() #12 /home/halu/public_html/foorumi/admin/index.php(14): IPS\_Dispatcher->run()  Link to comment Share on other sites More sharing options...
xtech Posted December 2, 2020 Share Posted December 2, 2020 (edited) Try to understand what the error message is trying to tell you: the string "attachment_file_missing - /home/halu/public_html/Yabbse/attachments/32318_t1_ashx_attach1idRgAAAADmmEv9PKKvQ4oBqRQNZomPBwDC2fzi22fpGYTZtymL8wbDrEAADR2fin7AABdHAnbM02eT5ABpTWls3feAAAEk4LJAAAJattid0EADy2fJG2FKMNRrXCQhwtWxz3attcnt15feb5c740bb9f0b99780181b69294c07" is too long to be inserted into the column log_message. This is because... it is too long, really. I mean the column "log_message" data type is probably configured to accept smaller strings, so you have two choices: trim the string to fit the maximum allowed data type length, or modify the data type to accept longer strings. I would personally prefer the second option to avoid losing any particular useful log info. Execute this SQL query: Describe convert_logs And see what is the output. Probably the type of the log_message field is Varchar(somenumber). If it is, execute this query: Alter Table convert_logs Modify column log_message LONGTEXT And run the conversion again.  From another perspective in what concerns to the conversion process: mind what the log is also saying: there is an attachment that was not found. If you end up having many logs like this, your newly converted forum will have "void" attachments. If it is just a couple of these logs, you should be fine.  Edited December 2, 2020 by xtech Hostingunlock, Owdy and Meddysong 2 1 Link to comment Share on other sites More sharing options...
bfarber Posted December 2, 2020 Share Posted December 2, 2020 If you are getting an error like this, it sounds like a bug. I'd recommend submitting a ticket. Owdy 1 Link to comment Share on other sites More sharing options...
Owdy Posted December 2, 2020 Author Share Posted December 2, 2020 Done #72210 Ay hazea 1 Link to comment Share on other sites More sharing options...
Owdy Posted December 3, 2020 Author Share Posted December 3, 2020 (edited) It was a bug and now fixed 🙂 Edited December 3, 2020 by Owdy bfarber 1 Link to comment Share on other sites More sharing options...
Recommended Posts