Jump to content

Community

SMF to Invision, error


Owdy
 Share

Recommended Posts

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

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 by xtech
Link to comment
Share on other sites

 Share

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...

Important Information

We use technologies, such as cookies, to customise content and advertising, to provide social media features and to analyse traffic to the site. We also share information about your use of our site with our trusted social media, advertising and analytics partners. See more about cookies and our Privacy Policy