CSV Importer Plugin Installation Issue

mysql: 5.7.12
ubuntu: 16.04
php: 7.0.8

While attempting to install CSVImporter 2.0.3, receive the following error:

Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Invalid default value for 'added' 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 /var/www/html/omeka/application/libraries/Omeka/Db.php(79): Zend_Db_Adapter_Abstract->query('CREATE TABLE IF...')
#3 /var/www/html/omeka/plugins/CsvImport/CsvImportPlugin.php(124): Omeka_Db->__call('query', Array)
#4 /var/www/html/omeka/application/libraries/Omeka/Plugin/Broker.php(145): CsvImportPlugin->hookInstall(Array)
#5 /var/www/html/omeka/application/libraries/Omeka/Plugin/Installer.php(130): Omeka_Plugin_Broker->callHook('install', Array, Object(Plugin))
#6 /var/www/html/omeka/application/controllers/PluginsController.php(97): Omeka_Plugin_Installer->install(Object(Plugin))
#7 /var/www/html/omeka/application/libraries/Zend/Controller/Action.php(516): PluginsController->installAction()
#8 /var/www/html/omeka/application/libraries/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('installAction')
#9 /var/www/html/omeka/application/libraries/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_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(79): Zend_Application->run()
#13 /var/www/html/omeka/admin/index.php(28): Omeka_Application->run()
#14 {main}

It looks like we’ve had a fix for this all prepared but just haven’t released it. MySQL 5.7 is much more inflexible (in a good way!) than previous versions about things like dates, so we’ve had to make some changes in a few places to accomodate it.

I’ll let you know when there’s a updated version you can download that fixes this problem.

1 Like

Cheers. What version of mysql would you recommend in the interim?

No need to change MySQL versions.

Try out the new version 2.0.4 of CsvImport instead.

1 Like

Hello,
FYI, I reproduced the problem with Omeka 2.5.1 + PHP 7.0.27 + MariaDB 10.1.26 (replaces MySQL on Debian Stretch) + CSV Import 2.0.4.
Thanks,