RM 2.1 MySQL statement prepare error [1054]: Unknown column 'resource_title_last_edit_date' in 'field list'

Joe Link

Well-known member
I just purchased and installed XFRM, fresh install. Trying to create a resource and I get this error.

Code:
XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'resource_title_last_edit_date' in 'field list' in src/XF/Db/AbstractStatement.php at line 217
XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 39
XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 54
XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 221
XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1452
XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1184
XF\Mvc\Entity\Entity->save() in src/addons/XFRM/Service/ResourceItem/Create.php at line 288
XFRM\Service\ResourceItem\Create->_save() in src/XF/Service/ValidateAndSavableTrait.php at line 40
XFRM\Service\ResourceItem\Create->save() in src/addons/XFRM/Pub/Controller/Category.php at line 269
XFRM\Pub\Controller\Category->actionAdd() in src/XF/Mvc/Dispatcher.php at line 321
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 248
XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 100
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 50
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2177
XF\App->run() in src/XF.php at line 390
XF::runApp() in index.php at line 20
 
Code:
XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'resource_title_last_edit_date' in 'field list' src/XF/Db/AbstractStatement.php:217
Generated by: Joe Link Mar 27, 2019 at 9:27 AM
Stack trace
INSERT  INTO `xf_rm_resource` (`resource_category_id`, `user_id`, `username`, `resource_state`, `title`, `tag_line`, `external_url`, `alt_support_url`, `resource_type`, `custom_fields`, `rating_weighted`, `rating_avg`, `resource_id`, `resource_date`, `current_version_id`, `description_update_id`, `discussion_thread_id`, `external_purchase_url`, `price`, `currency`, `view_count`, `download_count`, `rating_count`, `rating_sum`, `update_count`, `review_count`, `last_update`, `prefix_id`, `icon_date`, `tags`, `resource_title_last_edit_date`, `resource_title_last_edit_user_id`, `resource_title_edit_count`) 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(94): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Db/AbstractAdapter.php(221): XF\Db\AbstractAdapter->query('INSERT  INTO `x...', Array)
#5 src/XF/Mvc/Entity/Entity.php(1452): XF\Db\AbstractAdapter->insert('xf_rm_resource', Array, false)
#6 src/XF/Mvc/Entity/Entity.php(1184): XF\Mvc\Entity\Entity->_saveToSource()
#7 src/addons/XFRM/Service/ResourceItem/Create.php(288): XF\Mvc\Entity\Entity->save(true, false)
#8 src/XF/Service/ValidateAndSavableTrait.php(40): XFRM\Service\ResourceItem\Create->_save()
#9 src/addons/XFRM/Pub/Controller/Category.php(269): XFRM\Service\ResourceItem\Create->save()
#10 src/XF/Mvc/Dispatcher.php(321): XFRM\Pub\Controller\Category->actionAdd(Object(XF\Mvc\ParameterBag))
#11 src/XF/Mvc/Dispatcher.php(248): XF\Mvc\Dispatcher->dispatchClass('XFRM:Category', 'Add', Object(XF\Mvc\RouteMatch), Object(XFRM\Pub\Controller\Category), NULL)
#12 src/XF/Mvc/Dispatcher.php(100): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(XFRM\Pub\Controller\Category), NULL)
#13 src/XF/Mvc/Dispatcher.php(50): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#14 src/XF/App.php(2177): XF\Mvc\Dispatcher->run()
#15 src/XF.php(390): XF\App->run()
#16 index.php(20): XF::runApp('XF\\Pub\\App')
#17 {main}
 
Back
Top Bottom