Unknown column 'record_id' in 'field list' when posting comments

Omeka Classic Plugins
1

Trying out the commenting module on a locally hosted instance of 2.4.1 Plugin appears to configure ok and displays on the page as expected. However when I try to post a test comment I get this error:

Unknown column 'record_id' in 'field list'

Commenting is set to allow comments from anyone and to use moderation. The full stack trace is below if that helps.

Thanks.

Bobb Menk
MIT Lincoln Laboratory Library

exception 'Zend_Db_Statement_Mysqli_Exception' with message 'Mysqli prepare error: Unknown column 'record_id' in 'field list'' in /var/www/html/omeka241/application/libraries/Zend/Db/Statement/Mysqli.php:77
Stack trace:
#0 /var/www/html/omeka241/application/libraries/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('INSERT INTO `om...')
#1 /var/www/html/omeka241/application/libraries/Zend/Db/Adapter/Mysqli.php(388): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'INSERT INTO `om...')
#2 /var/www/html/omeka241/application/libraries/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Adapter_Mysqli->prepare('INSERT INTO `om...')
#3 [internal function]: Zend_Db_Adapter_Abstract->query('INSERT INTO `om...', Array)
#4 /var/www/html/omeka241/application/libraries/Omeka/Db.php(79): call_user_func_array(Array, Array)
#5 /var/www/html/omeka241/application/libraries/Omeka/Db.php(252): Omeka_Db->__call('query', Array)
#6 /var/www/html/omeka241/application/libraries/Omeka/Db.php(252): Omeka_Db->query('INSERT INTO `om...', Array)
#7 /var/www/html/omeka241/application/libraries/Omeka/Record/AbstractRecord.php(543): Omeka_Db->insert('Comment', Array)
#8 /var/www/html/omeka241/plugins/Commenting/controllers/CommentController.php(80): Omeka_Record_AbstractRecord->save()
#9 /var/www/html/omeka241/application/libraries/Zend/Controller/Action.php(516): Commenting_CommentController->addAction()
#10 /var/www/html/omeka241/application/libraries/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('addAction')
#11 /var/www/html/omeka241/application/libraries/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#12 /var/www/html/omeka241/application/libraries/Zend/Application/Bootstrap/Bootstrap.php(105): Zend_Controller_Front->dispatch()
#13 /var/www/html/omeka241/application/libraries/Zend/Application.php(384): Zend_Application_Bootstrap_Bootstrap->run()
#14 /var/www/html/omeka241/application/libraries/Omeka/Application.php(79): Zend_Application->run()
#15 /var/www/html/omeka241/index.php(23): Omeka_Application->run()
#16 {main}`
2

If you don’t have any actual existing comments you’re concerned about keeping, I think your first and best bet is to simply uninstall and re-install the plugin from the Plugins page.

The most likely cause here would be a problem with the Commenting plugin’s upgrade process, and an uninstall/re-install would avoid that problem.

3

That seems to have done it - thanks!

Bobb Menk