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.
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.
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}
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!
p.s. I am using CSV Import v. 1.3.1 and omeka 1.4.1
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.
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!
The status (and the errors) remain the same, but the players have changed.
Omeka 1.4.2, CSVImport 1.3.1
Thanks! We've seen this bug in the importer at least once elsewhere, and should have a fix fairly soon.
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!
Sweet! Thanks, Patrick! Will give it a whirl after lunch!
VICTORY!!!
I did have to still comment out the Mime Type line in Main.php but it worked like a charm. Thank you!!!!