Forums » CSV Import error: Column "Featured" Cannot be Null

RSS feed for this topic

Info

• Posted in Import / Export
• Started 6 months ago by jeannette
• 13 posts by 4 users
• Latest reply from patrickmj

1. 

   jeannette Posted 6 months ago

   Hello, again!

   I am finally able to ingest my .csv file using CSV Import. Hooray!

   Unforunately, my process keeps erring out. Thanks to omeka's handy "how to enable error logging" page, I get to see why:

   ERR (3): [CsvImport] exception 'Zend_Db_Statement_Mysqli_Exception' with message 'Mysqli statement execute error : Column 'featured' cannot be null' in /home/jet/radicalcupcake.com/omeka/dziadek/application/libraries/Zend/Db/Statement/Mysqli.php:214

   If the Stack trace would be helpful I will be happy to include it.

2. 

   patrickmj (Omeka Dev Team) Posted 6 months ago

   Thanks. Actually, the stack trace will probably be helpful here.

   Also, knowing which version of CsvImport will help, since we recently released a new version of it.

3. 

   jeannette Posted 6 months ago

   Thanks, Patrick!

   I am using Omeka 1.4.1 and CSV Import 1.3.1

   2011-10-27T15:13:25-07:00 ERR (3): [CsvImport] exception 'Zend_Db_Statement_Mysqli_Exception' with message 'Mysqli statement execute error : Column 'featured' cannot be null' in /home/jet/radicalcupcake.com/omeka/dziadek/application/libraries/Zend/Db/Statement/Mysqli.php:214
   Stack trace:
   #0 /home/jet/radicalcupcake.com/omeka/dziadek/application/libraries/Zend/Db/Statement.php(300): Zend_Db_Statement_Mysqli->_execute(Array)
   #1 /home/jet/radicalcupcake.com/omeka/dziadek/application/libraries/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
   #2 /home/jet/radicalcupcake.com/omeka/dziadek/application/libraries/Omeka/Db.php(84): Zend_Db_Adapter_Abstract->query('?        INSERT...', Array)
   #3 /home/jet/radicalcupcake.com/omeka/dziadek/application/libraries/Omeka/Db.php(298): Omeka_Db->__call(Array, Array)
   #4 /home/jet/radicalcupcake.com/omeka/dziadek/application/libraries/Omeka/Db.php(298): Omeka_Db->query('query', Array)
   #5 /home/jet/radicalcupcake.com/omeka/dziadek/application/libraries/Omeka/Db.php(268): Omeka_Db->exec('?        INSERT...', Array)
   #6 /home/jet/radicalcupcake.com/omeka/dziadek/application/libraries/Omeka/Record.php(553): Omeka_Db->insert('?        INSERT...', Array)
   #7 /home/jet/radicalcupcake.com/omeka/dziadek/application/libraries/Omeka/Record.php(583): Omeka_Record->save('Item', Array)
   #8 /home/jet/radicalcupcake.com/omeka/dziadek/application/libraries/Omeka/Record/Builder.php(71): Omeka_Record->forceSave()
   #9 /home/jet/radicalcupcake.com/omeka/dziadek/application/libraries/globals.php(473): Omeka_Record_Builder->build()
   #10 /home/jet/radicalcupcake.com/omeka/dziadek/plugins/CsvImport/models/CsvImport/Import.php(345): insert_item()
   #11 /home/jet/radicalcupcake.com/omeka/dziadek/plugins/CsvImport/models/CsvImport/Import.php(255): CsvImport_Import->_addItemFromRow()
   #12 /home/jet/radicalcupcake.com/omeka/dziadek/plugins/CsvImport/models/CsvImport/Import.php(197): CsvImport_Import->_importLoop(Array, Array)
   #13 /home/jet/radicalcupcake.com/omeka/dziadek/plugins/CsvImport/models/CsvImport/ImportTask.php(22): CsvImport_Import->start(Array, Array, Object(CsvImport_ColumnMap_Set))
   #14 /home/jet/radicalcupcake.com/omeka/dziadek/application/libraries/Omeka/Job/Dispatcher/Adapter/Synchronous.php(26): CsvImport_ImportTask->perform(0)
   #15 /home/jet/radicalcupcake.com/omeka/dziadek/application/libraries/Omeka/Job/Dispatcher/Default.php(91): Omeka_Job_Dispatcher_Adapter_Synchronous->send()
   #16 /home/jet/radicalcupcake.com/omeka/dziadek/plugins/CsvImport/controllers/IndexController.php(131): Omeka_Job_Dispatcher_Default->send(Array)
   #17 /home/jet/radicalcupcake.com/omeka/dziadek/application/libraries/Zend/Controller/Action.php(513): CsvImport_IndexController->mapColumnsAction()
   #18 /home/jet/radicalcupcake.com/omeka/dziadek/application/libraries/Zend/Controller/Dispatcher/Standard.php(295): Zend_Controller_Action->dispatch('{"className":"C...', Array)
   #19 /home/jet/radicalcupcake.com/omeka/dziadek/application/libraries/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch('CsvImport_Impor...', Array)
   #20 /home/jet/radicalcupcake.com/omeka/dziadek/application/libraries/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
   #21 /home/jet/radicalcupcake.com/omeka/dziadek/application/libraries/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run('mapColumnsActio...')
   #22 /home/jet/radicalcupcake.com/omeka/dziadek/application/libraries/Omeka/Core.php(166): Zend_Application->run(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
   #23 /home/jet/radicalcupcake.com/omeka/dziadek/admin/index.php(45): Omeka_Core->run()
   #24 {main}
   2011-10-27T15:13:25-07:00 ERR (3): exception 'Zend_Db_Statement_Mysqli_Exception' with message 'Mysqli statement execute error : Column 'featured' cannot be null' in /home/jet/radicalcupcake.com/omeka/dziadek/application/libraries/Zend/Db/Statement/Mysqli.php:214
   Stack trace:
   #0 /home/jet/radicalcupcake.com/omeka/dziadek/application/libraries/Zend/Db/Statement.php(300): Zend_Db_Statement_Mysqli->_execute(Array)
   #1 /home/jet/radicalcupcake.com/omeka/dziadek/application/libraries/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
   #2 /home/jet/radicalcupcake.com/omeka/dziadek/application/libraries/Omeka/Db.php(84): Zend_Db_Adapter_Abstract->query('?        INSERT...', Array)
   #3 /home/jet/radicalcupcake.com/omeka/dziadek/application/libraries/Omeka/Db.php(298): Omeka_Db->__call(Array, Array)
   #4 /home/jet/radicalcupcake.com/omeka/dziadek/application/libraries/Omeka/Db.php(298): Omeka_Db->query('query', Array)
   #5 /home/jet/radicalcupcake.com/omeka/dziadek/application/libraries/Omeka/Db.php(268): Omeka_Db->exec('?        INSERT...', Array)
   #6 /home/jet/radicalcupcake.com/omeka/dziadek/application/libraries/Omeka/Record.php(553): Omeka_Db->insert('?        INSERT...', Array)
   #7 /home/jet/radicalcupcake.com/omeka/dziadek/application/libraries/Omeka/Record.php(583): Omeka_Record->save('Item', Array)
   #8 /home/jet/radicalcupcake.com/omeka/dziadek/application/libraries/Omeka/Record/Builder.php(71): Omeka_Record->forceSave()
   #9 /home/jet/radicalcupcake.com/omeka/dziadek/application/libraries/globals.php(473): Omeka_Record_Builder->build()
   #10 /home/jet/radicalcupcake.com/omeka/dziadek/plugins/CsvImport/models/CsvImport/Import.php(345): insert_item()
   #11 /home/jet/radicalcupcake.com/omeka/dziadek/plugins/CsvImport/models/CsvImport/Import.php(255): CsvImport_Import->_addItemFromRow()
   #12 /home/jet/radicalcupcake.com/omeka/dziadek/plugins/CsvImport/models/CsvImport/Import.php(197): CsvImport_Import->_importLoop(Array, Array)
   #13 /home/jet/radicalcupcake.com/omeka/dziadek/plugins/CsvImport/models/CsvImport/ImportTask.php(22): CsvImport_Import->start(Array, Array, Object(CsvImport_ColumnMap_Set))
   #14 /home/jet/radicalcupcake.com/omeka/dziadek/application/libraries/Omeka/Job/Dispatcher/Adapter/Synchronous.php(26): CsvImport_ImportTask->perform(0)
   #15 /home/jet/radicalcupcake.com/omeka/dziadek/application/libraries/Omeka/Job/Dispatcher/Default.php(91): Omeka_Job_Dispatcher_Adapter_Synchronous->send()
   #16 /home/jet/radicalcupcake.com/omeka/dziadek/plugins/CsvImport/controllers/IndexController.php(131): Omeka_Job_Dispatcher_Default->send(Array)
   #17 /home/jet/radicalcupcake.com/omeka/dziadek/application/libraries/Zend/Controller/Action.php(513): CsvImport_IndexController->mapColumnsAction()
   #18 /home/jet/radicalcupcake.com/omeka/dziadek/application/libraries/Zend/Controller/Dispatcher/Standard.php(295): Zend_Controller_Action->dispatch('{"className":"C...', Array)
   #19 /home/jet/radicalcupcake.com/omeka/dziadek/application/libraries/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch('CsvImport_Impor...', Array)
   #20 /home/jet/radicalcupcake.com/omeka/dziadek/application/libraries/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch()
   #21 /home/jet/radicalcupcake.com/omeka/dziadek/application/libraries/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run('mapColumnsActio...')
   #22 /home/jet/radicalcupcake.com/omeka/dziadek/application/libraries/Omeka/Core.php(166): Zend_Application->run(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
   #23 /home/jet/radicalcupcake.com/omeka/dziadek/admin/index.php(45): Omeka_Core->run()
   #24 {main}

4. 

   jeannette_again Posted 6 months ago

   Hey, Patrick!

   I'm guessing you didn't see my replies with the stack trace - I wonder if my other login "jeannette" got flagged as a spammer or something, maybe since my post was so long? I have posted to the forum 4 times since this original post and they only show up when I am logged in.

   I am reluctant to post the stack trace here again if that is the reason I have been blacklisted. You can email me at jet AT radicalcupcake.com if you are interested in seeing the stack trace.

   Thank you!

5. 

   jeannette_again Posted 6 months ago

   p.s. I am using CSV Import v. 1.3.1 and omeka 1.4.1

6. 

   John Flatness (Omeka Dev Team) Posted 6 months ago

   Thanks for the info.

   I've resurrected your post with the stack trace, and I deleted all your extra attempts to post the trace in different places.

   The system doesn't seem to have your user marked as a spammer, it's possible it just didn't like the length of those messages.

7. 

   jeannette Posted 6 months ago

   Thanks, John!

   I am going to go ahead and upgrade omeka and the plugin (if necessary) and see what I can break. So, if anyone sees this message, I will update the status of this problem later today!

8. 

   jeannette Posted 6 months ago

   The status (and the errors) remain the same, but the players have changed.

   Omeka 1.4.2, CSVImport 1.3.1

9. 

   patrickmj (Omeka Dev Team) Posted 6 months ago

   Thanks! We've seen this bug in the importer at least once elsewhere, and should have a fix fairly soon.

10. 

    patrickmj (Omeka Dev Team) Posted 6 months ago

    We're fairly confident that we have fixed this (and a few other) issues with the latest version. Please let us know if it works for you. Thanks!

11. 

    jeannette Posted 6 months ago

    Sweet! Thanks, Patrick! Will give it a whirl after lunch!

12. 

    jeannette Posted 6 months ago

    VICTORY!!!

    I did have to still comment out the Mime Type line in Main.php but it worked like a charm. Thank you!!!!

13. 

    patrickmj (Omeka Dev Team) Posted 6 months ago

    Glad it worked!

Topic Closed

This topic has been closed to new replies.