Forums » Mysqli statement execute error : Incorrect integer value

RSS feed for this topic

Info

  • Posted in Plugins
  • Started 1 year ago by josh2omeka
  • 2 posts by 2 users
  • Latest reply from John Flatness
  1. 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}

  2. 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.

Reply

You must log in to post.