Invision Community 5: A video walkthrough creating a custom theme and homepage By Matt Thursday at 04:02 PM
Owdy Posted December 2, 2020 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() Â
xtech Posted December 2, 2020 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 Owdy, Hostingunlock and Meddysong 2 1
bfarber Posted December 2, 2020 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
Owdy Posted December 3, 2020 Author Posted December 3, 2020 (edited) It was a bug and now fixed 🙂 Edited December 3, 2020 by Owdy bfarber 1
Recommended Posts