Error message by installing plugins

Omeka Classic Troubleshooting
1

Hello. I am new using the plattform. We recently installed Omeka on our institutional server and at first it was working OK, but when we added the plugins (several ones) we got the following error message. It happens mostly when we try to save changes or display an item.

Omeka.JPG638×978 156 KB

This is the source code:

exception ‘Zend_Db_Statement_Mysqli_Exception’ with message ‘Mysqli statement execute error : Column ‘id’ cannot be null’ in /var/www/html/omeka/application/libraries/Zend/Db/Statement/Mysqli.php:214
Stack trace:
#0 /var/www/html/omeka/application/libraries/Zend/Db/Statement.php(303): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /var/www/html/omeka/application/libraries/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#2 [internal function]: Zend_Db_Adapter_Abstract->query(‘INSERT INTO om...', Array) #3 /var/www/html/omeka/application/libraries/Omeka/Db.php(79): call_user_func_array(Array, Array) #4 /var/www/html/omeka/application/libraries/Omeka/Db.php(252): Omeka_Db->__call('query', Array) #5 /var/www/html/omeka/application/libraries/Omeka/Db.php(252): Omeka_Db->query('INSERT INTOom…’, Array)
#6 /var/www/html/omeka/application/libraries/Omeka/Record/AbstractRecord.php(543): Omeka_Db->insert(‘ItemView’, Array)
#7 /var/www/html/omeka/plugins/ItemViews/libraries/ItemViews_ControllerPlugin.php(18): Omeka_Record_AbstractRecord->save()
#8 /var/www/html/omeka/application/libraries/Zend/Controller/Plugin/Broker.php(309): ItemViews_ControllerPlugin->preDispatch(Object(Zend_Controller_Request_Http))
#9 /var/www/html/omeka/application/libraries/Zend/Controller/Front.php(941): Zend_Controller_Plugin_Broker->preDispatch(Object(Zend_Controller_Request_Http))
#10 /var/www/html/omeka/application/libraries/Zend/Application/Bootstrap/Bootstrap.php(105): Zend_Controller_Front->dispatch()
#11 /var/www/html/omeka/application/libraries/Zend/Application.php(384): Zend_Application_Bootstrap_Bootstrap->run()
#12 /var/www/html/omeka/application/libraries/Omeka/Application.php(77): Zend_Application->run()
#13 /var/www/html/omeka/admin/index.php(28): Omeka_Application->run()
#14 {main}

Next exception ‘Zend_Controller_Exception’ with message ‘Mysqli statement execute error : Column ‘id’ cannot be null#0 /var/www/html/omeka/application/libraries/Zend/Db/Statement.php(303): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /var/www/html/omeka/application/libraries/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#2 [internal function]: Zend_Db_Adapter_Abstract->query(‘INSERT INTO om...', Array) #3 /var/www/html/omeka/application/libraries/Omeka/Db.php(79): call_user_func_array(Array, Array) #4 /var/www/html/omeka/application/libraries/Omeka/Db.php(252): Omeka_Db->__call('query', Array) #5 /var/www/html/omeka/application/libraries/Omeka/Db.php(252): Omeka_Db->query('INSERT INTOom…’, Array)
#6 /var/www/html/omeka/application/libraries/Omeka/Record/AbstractRecord.php(543): Omeka_Db->insert(‘ItemView’, Array)
#7 /var/www/html/omeka/plugins/ItemViews/libraries/ItemViews_ControllerPlugin.php(18): Omeka_Record_AbstractRecord->save()
#8 /var/www/html/omeka/application/libraries/Zend/Controller/Plugin/Broker.php(309): ItemViews_ControllerPlugin->preDispatch(Object(Zend_Controller_Request_Http))
#9 /var/www/html/omeka/application/libraries/Zend/Controller/Front.php(941): Zend_Controller_Plugin_Broker->preDispatch(Object(Zend_Controller_Request_Http))
#10 /var/www/html/omeka/application/libraries/Zend/Application/Bootstrap/Bootstrap.php(105): Zend_Controller_Front->dispatch()
#11 /var/www/html/omeka/application/libraries/Zend/Application.php(384): Zend_Application_Bootstrap_Bootstrap->run()
#12 /var/www/html/omeka/application/libraries/Omeka/Application.php(77): Zend_Application->run()
#13 /var/www/html/omeka/admin/index.php(28): Omeka_Application->run()
#14 {main}’ in /var/www/html/omeka/application/libraries/Zend/Controller/Plugin/Broker.php:312
Stack trace:
#0 /var/www/html/omeka/application/libraries/Zend/Controller/Front.php(941): Zend_Controller_Plugin_Broker->preDispatch(Object(Zend_Controller_Request_Http))
#1 /var/www/html/omeka/application/libraries/Zend/Application/Bootstrap/Bootstrap.php(105): Zend_Controller_Front->dispatch()
#2 /var/www/html/omeka/application/libraries/Zend/Application.php(384): Zend_Application_Bootstrap_Bootstrap->run()
#3 /var/www/html/omeka/application/libraries/Omeka/Application.php(77): Zend_Application->run()
#4 /var/www/html/omeka/admin/index.php(28): Omeka_Application->run()
#5 {main}

2

Can anyone help us please?? We’re very encouraged on using this platform, but no one in our Systems Department has clear how to properly solve this issue.

Thanks in advance

    Ashuttera
3

The log doesn’t indicate the plugin that create an issue. So check the one that fails: disable all plugins, then reenable them one by one and check. Furthermore, what are your versions of Omeka and Mysql?

4

Thanks a lot, Daniel_KM. Our version of Omeka is 2.5.1 and Mysql 5.5.38. We are going to disable every plugin from the admin page and test them one by one. Hopefully we can manage to solve it.
Thanks!

5

From the log it would appear the ItemViews plugin is the one causing this error.

6

Thanks!. It looks like it was ItemViews along with Scripto. We got to fix it finally. Thanks for all help

7

Not sure about the interaction between ItemViews and Scripto, but strictly on the ItemViews side it looks like I foolishly manually fixed it in my database, then forgot to make the change to the installation script. A corrected version will come out in the next day or so.