Not a bug im having this error whenever a user tries to add a thumbnail or upload a photo

[shimspedy]

Affected version

xf2

Server error log

• XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'xfa_do' in 'field list'
• src/XF/Db/AbstractStatement.php:212
• Generated by: codeslims
• Jun 20, 2018 at 7:23 PM

Stack trace
INSERT INTO `xf_attachment_data` (`user_id`, `filename`, `file_size`, `file_hash`, `file_path`, `width`, `height`, `data_id`, `upload_date`, `thumbnail_width`, `thumbnail_height`, `attach_count`, `xfa_do`, `xfa_url`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL statement...', 1054, '42S22')
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1054, '42S22')
#2 src/XF/Db/Mysqli/Statement.php(54): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(79): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Db/AbstractAdapter.php(160): XF\Db\AbstractAdapter->query('INSERT INTO `x...', Array)
#5 src/XF/Mvc/Entity/Entity.php(1389): XF\Db\AbstractAdapter->insert('xf_attachment_d...', Array, false)
#6 src/XF/Mvc/Entity/Entity.php(1121): XF\Mvc\Entity\Entity->_saveToSource()
#7 src/XF/Service/Attachment/Preparer.php(67): XF\Mvc\Entity\Entity->save(true, false)
#8 src/XF/Service/Attachment/Preparer.php(16): XF\Service\Attachment\Preparer->insertDataFromFile(Object(XF\FileWrapper), 1, Array)
#9 src/XF/Attachment/Manipulator.php(170): XF\Service\Attachment\Preparer->insertAttachment(Object(XF\Attachment\Post), Object(XF\FileWrapper), Object(DBTech\Credits\XF\Entity\User), 'b9b592c451d38da...')
#10 src/XF/Pub/Controller/Attachment.php(86): XF\Attachment\Manipulator->insertAttachmentFromUpload(Object(XF\Http\Upload), NULL)
#11 src/XF/Mvc/Dispatcher.php(249): XF\Pub\Controller\Attachment->actionUpload(Object(XF\Mvc\ParameterBag))
#12 src/XF/Mvc/Dispatcher.php(88): XF\Mvc\Dispatcher->dispatchClass('XF:Attachment', 'Upload', 'json', Object(XF\Mvc\ParameterBag), '', Object(XF\Pub\Controller\Attachment), NULL)
#13 src/XF/Mvc/Dispatcher.php(41): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#14 src/XF/App.php(1931): XF\Mvc\Dispatcher->run()
#15 src/XF.php(328): XF\App->run()
#16 index.php(13): XF::runApp('XF\\Pub\\App')
#17 {main}
Request state
array(4) {
["url"] => string(88) "/attachments/upload?type=post&context[post_id]=132&hash=b9b592c451d38dae0e746955477bc277"
["referrer"] => string(59) "https://www.codeslims.com/threads/codeslims-forum-rules.61/"
["_GET"] => array(3) {
["type"] => string(4) "post"
["context"] => array(1) {
["post_id"] => string(3) "132"
}
["hash"] => string(32) "b9b592c451d38dae0e746955477bc277"
}
["_POST"] => array(3) {
["_xfToken"] => string(8) "********"
["_xfResponseType"] => string(4) "json"
["_xfWithData"] => string(1) "1"
}
}

Delete

 

[Chris D]

It seems to be something to do with an add-on by XFA.

 

[shimspedy]

thanks i will try to find out from addon developers