I have Omeka (2.5) and CSVImport (2.0.4). when I try to upload a CSV file I get the following error message:
Thanks in advance.
Omeka has encountered an error
Zend_Db_Statement_Mysqli_Exception
Mysqli statement execute error : Column 'stopped' cannot be null
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Column ‘stopped’ cannot be null in /home/swoger/geosciencecollections.milne-library.org/application/libraries/Zend/Db/Statement/Mysqli.php:214
Stack trace:
#0 /home/swoger/geosciencecollections.milne-library.org/application/libraries/Zend/Db/Statement.php(303): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/swoger/geosciencecollections.milne-library.org/application/libraries/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#2 /home/swoger/geosciencecollections.milne-library.org/application/libraries/Omeka/Db.php(79): Zend_Db_Adapter_Abstract->query(‘INSERT INTO `om…’, Array)
#3 /home/swoger/geosciencecollections.milne-library.org/application/libraries/Omeka/Db.php(252): Omeka_Db->__call(‘query’, Array)
#4 /home/swoger/geosciencecollections.milne-library.org/application/libraries/Omeka/Record/AbstractRecord.php(543): Omeka_Db->insert(‘omeka_processes’, Array)
#5 /home/swoger/geosciencecollections.milne-library.org/application/libraries/Omeka/Job/Process/Dispatcher.php(46): Omeka_Record_AbstractRecord->save()
#6 /home/swoger/geosciencecollections.milne-library.org/application/libraries/Omeka/Job/Dispatcher/Adapter/BackgroundProcess.php(31): Omeka_Job_Process_Dispatcher::startProcess(‘Omeka_Job_Proce…’, Object(User), Array)
#7 /home/swoger/geosciencecollections.milne-library.org/application/libraries/Omeka/Job/Dispatcher/Default.php(150): Omeka_Job_Dispatcher_Adapter_BackgroundProcess->send(’{“className”:"C…’, Array)
#8 /home/swoger/geosciencecollections.milne-library.org/plugins/CsvImport/controllers/IndexController.php(384): Omeka_Job_Dispatcher_Default->sendLongRunning(‘CsvImport_Impor…’, Array)
#9 /home/swoger/geosciencecollections.milne-library.org/plugins/CsvImport/controllers/IndexController.php(135): CsvImport_IndexController->_dispatchImportTask(Object(CsvImport_Import), ‘start’)
#10 /home/swoger/geosciencecollections.milne-library.org/application/libraries/Zend/Controller/Action.php(516): CsvImport_IndexController->mapColumnsAction()
#11 /home/swoger/geosciencecollections.milne-library.org/application/libraries/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch(‘mapColumnsActio…’)
#12 /home/swoger/geosciencecollections.milne-library.org/application/libraries/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#13 /home/swoger/geosciencecollections.milne-library.org/application/libraries/Zend/Application/Bootstrap/Bootstrap.php(105): Zend_Controller_Front->dispatch()
#14 /home/swoger/geosciencecollections.milne-library.org/application/libraries/Zend/Application.php(384): Zend_Application_Bootstrap_Bootstrap->run()
#15 /home/swoger/geosciencecollections.milne-library.org/application/libraries/Omeka/Application.php(77): Zend_Application->run()
#16 /home/swoger/geosciencecollections.milne-library.org/admin/index.php(28): Omeka_Application->run()
#17 {main}
You’re sure you’re using Omeka 2.5? The error you describe is something that was fixed in 2.5. In short, 2.5 alters the database so that “stopped” is allowed to be null. Your posted message would indicate your database doesn’t have that change.
I tried to upgrade Omeka to 2.5 again. Now I’m getting the following error message when I click on “Upgrade”:
Omeka encountered an error when upgrading your installation.
SQL error in migration: Mysqli statement execute error : Incorrect datetime value: ‘0000-00-00 00:00:00’ for column ‘stopped’ at row 3
exception ‘Zend_Db_Statement_Mysqli_Exception’ with message ‘Mysqli statement execute error : Incorrect datetime value: ‘0000-00-00 00:00:00’ for column ‘stopped’ at row 3’ in /home/swoger/geosciencecollections.milne-library.org/application/libraries/Zend/Db/Statement/Mysqli.php:214
Stack trace:
#0 /home/swoger/geosciencecollections.milne-library.org/application/libraries/Zend/Db/Statement.php(303): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/swoger/geosciencecollections.milne-library.org/application/libraries/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#2 [internal function]: Zend_Db_Adapter_Abstract->query(‘ALTER TABLE ome…’)
#3 /home/swoger/geosciencecollections.milne-library.org/application/libraries/Omeka/Db.php(79): call_user_func_array(Array, Array)
#4 /home/swoger/geosciencecollections.milne-library.org/application/migrations/20151209103300_removeZeroDateDefaults.php(19): Omeka_Db->__call(‘query’, Array)
#5 /home/swoger/geosciencecollections.milne-library.org/application/migrations/20151209103300_removeZeroDateDefaults.php(19): Omeka_Db->query(‘ALTER TABLE ome…’)
#6 /home/swoger/geosciencecollections.milne-library.org/application/libraries/Omeka/Db/Migration/Manager.php(231): removeZeroDateDefaults->up()
#7 /home/swoger/geosciencecollections.milne-library.org/application/libraries/Omeka/Db/Migration/Manager.php(111): Omeka_Db_Migration_Manager->_migrateUp(Object(DateTime))
#8 /home/swoger/geosciencecollections.milne-library.org/application/controllers/UpgradeController.php(49): Omeka_Db_Migration_Manager->migrate()
#9 /home/swoger/geosciencecollections.milne-library.org/application/libraries/Zend/Controller/Action.php(516): UpgradeController->migrateAction()
#10 /home/swoger/geosciencecollections.milne-library.org/application/libraries/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch(‘migrateAction’)
#11 /home/swoger/geosciencecollections.milne-library.org/application/libraries/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#12 /home/swoger/geosciencecollections.milne-library.org/application/libraries/Zend/Application/Bootstrap/Bootstrap.php(105): Zend_Controller_Front->dispatch()
#13 /home/swoger/geosciencecollections.milne-library.org/application/libraries/Zend/Application.php(384): Zend_Application_Bootstrap_Bootstrap->run()
#14 /home/swoger/geosciencecollections.milne-library.org/application/libraries/Omeka/Application.php(77): Zend_Application->run()
#15 /home/swoger/geosciencecollections.milne-library.org/admin/index.php(28): Omeka_Application->run()
#16 {main}
Omeka 2.5.1 has just been released, and should fix some of these upgrade issues. Have you tried upgrading to that version instead?
Upgrading to 2.5.1 fixed the issue! Thanks!