SMF to Invision, error

Posted December 2, 20204 yr

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()

December 2, 20204 yr

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, 20204 yr by xtech