Error when posting a comment (omeka 2.1.1, commenting 2.0)

Hi Folks,

I've installed Commenting 2.0 on my Omeka 2.1.1 instance and all looks okay except when I attempt to post a comment. here's the error I get back - any thoughts?

Zend_Db_Statement_Mysqli_Exception
Mysqli prepare error: Unknown column 'flagged' in 'field list'
#0 /home/wyndhistory/public_html/application/libraries/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('INSERT INTO `om...')
#1 /home/wyndhistory/public_html/application/libraries/Zend/Db/Adapter/Mysqli.php(388): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'INSERT INTO `om...')
#2 /home/wyndhistory/public_html/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 /home/wyndhistory/public_html/application/libraries/Omeka/Db.php(79): call_user_func_array(Array, Array)
#5 [internal function]: Omeka_Db->__call('query', Array)
#6 /home/wyndhistory/public_html/application/libraries/Omeka/Db.php(252): Omeka_Db->query('INSERT INTO `om...', Array)
#7 /home/wyndhistory/public_html/application/libraries/Omeka/Record/AbstractRecord.php(543): Omeka_Db->insert('Comment', Array)
#8 /home/wyndhistory/public_html/plugins/Commenting/controllers/CommentController.php(76): Omeka_Record_AbstractRecord->save()
#9 /home/wyndhistory/public_html/application/libraries/Zend/Controller/Action.php(516): Commenting_CommentController->addAction()
#10 /home/wyndhistory/public_html/application/libraries/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('addAction')
#11 /home/wyndhistory/public_html/application/libraries/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#12 /home/wyndhistory/public_html/application/libraries/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
#13 /home/wyndhistory/public_html/application/libraries/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run()
#14 /home/wyndhistory/public_html/application/libraries/Omeka/Application.php(79): Zend_Application->run()
#15 /home/wyndhistory/public_html/index.php(23): Omeka_Application->run()
#16 {main}


My first guess (by which I mean easy guess) is that something went amiss when the plugin installed the tables in the database -- assuming this is a new install of Omeka and the Commenting plugin. Easy try is to uninstall and reinstall the plugin to see if that fixes it.

If not, we'll move on from there.

Hi Patrick,

Thanks for the quick response.
This is an upgrade from a 1.5 omeka instance that already had the commenting plugin installed.
I've tried an uninstall/reinstall to no avail...

Cheers,

Tom

I think I've found the issue, and am working on a fix for it.

Thanks for the update Patrick,

Cheers,

Tom