Mysqli statement execute error : Incorrect integer value


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?

Josh V.

Omeka Has Encountered an Error
Mysqli statement execute error : Incorrect integer value: '' for column 'is_public' at row 1

#0 /var/www/vhosts/ Zend_Db_Statement_Mysqli->_execute(Array)
#1 /var/www/vhosts/ Zend_Db_Statement->execute(Array)
#2 [internal function]: Zend_Db_Adapter_Abstract->query('? INSERT...', Array)
#3 /var/www/vhosts/ call_user_func_array(Array, Array)
#4 [internal function]: Omeka_Db->__call('query', Array)
#5 /var/www/vhosts/ Omeka_Db->query('? INSERT...', Array)
#6 /var/www/vhosts/ Omeka_Db->exec('? INSERT...', Array)
#7 /var/www/vhosts/ Omeka_Db->insert('CsvImport_Impor...', Array)
#8 /var/www/vhosts/ Omeka_Record->save()
#9 /var/www/vhosts/ CsvImport_IndexController->mapColumnsAction()
#10 /var/www/vhosts/ Zend_Controller_Action->dispatch('mapColumnsActio...')
#11 /var/www/vhosts/ Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#12 /var/www/vhosts/ Zend_Controller_Front->dispatch()
#13 /var/www/vhosts/ Zend_Application_Bootstrap_Bootstrap->run()
#14 /var/www/vhosts/ Zend_Application->run()
#15 {main}

Hi Josh,

I'm unable to reproduce your problem with the versions you specified.

It looks like your import form is either being constructed in a strange way, or the data isn't being correctly retrieved from the form.

The form is designed to include "default" hidden form elements that prevent the exact problem. The form should be valid and cause no errors no matter what boxes are checked or unchecked.