Hello,
Omeka Version v1.2.1, CsvImport v1.1-1.2
I recently upgraded and moved my site to a new server and most of everything is working. I'm running into the problem below when I try to do a CSV Import. I find that if I don't select featured and public I get the following error message. It does work correctly if all boxes are checked and filled in. Is this a bug or do I have something wrong with my server configuration?
Thanks,
Josh V.
----------------------------------------
Omeka Has Encountered an Error
Zend_Db_Statement_Mysqli_Exception:
Mysqli statement execute error : Incorrect integer value: '' for column 'is_public' at row 1
Backtrace:
#0 /var/www/vhosts/collections.nysha.org/httpdocs/application/libraries/Zend/Db/Statement.php(300): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /var/www/vhosts/collections.nysha.org/httpdocs/application/libraries/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
#2 [internal function]: Zend_Db_Adapter_Abstract->query('? INSERT...', Array)
#3 /var/www/vhosts/collections.nysha.org/httpdocs/application/libraries/Omeka/Db.php(74): call_user_func_array(Array, Array)
#4 [internal function]: Omeka_Db->__call('query', Array)
#5 /var/www/vhosts/collections.nysha.org/httpdocs/application/libraries/Omeka/Db.php(238): Omeka_Db->query('? INSERT...', Array)
#6 /var/www/vhosts/collections.nysha.org/httpdocs/application/libraries/Omeka/Db.php(218): Omeka_Db->exec('? INSERT...', Array)
#7 /var/www/vhosts/collections.nysha.org/httpdocs/application/libraries/Omeka/Record.php(375): Omeka_Db->insert('CsvImport_Impor...', Array)
#8 /var/www/vhosts/collections.nysha.org/httpdocs/plugins/CsvImport/controllers/IndexController.php(139): Omeka_Record->save()
#9 /var/www/vhosts/collections.nysha.org/httpdocs/application/libraries/Zend/Controller/Action.php(513): CsvImport_IndexController->mapColumnsAction()
#10 /var/www/vhosts/collections.nysha.org/httpdocs/application/libraries/Zend/Controller/Dispatcher/Standard.php(289): Zend_Controller_Action->dispatch('mapColumnsActio...')
#11 /var/www/vhosts/collections.nysha.org/httpdocs/application/libraries/Zend/Controller/Front.php(946): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#12 /var/www/vhosts/collections.nysha.org/httpdocs/application/libraries/Zend/Application/Bootstrap/Bootstrap.php(77): Zend_Controller_Front->dispatch()
#13 /var/www/vhosts/collections.nysha.org/httpdocs/application/libraries/Zend/Application.php(358): Zend_Application_Bootstrap_Bootstrap->run()
#14 /var/www/vhosts/collections.nysha.org/httpdocs/admin/index.php(31): Zend_Application->run()
#15 {main}