When using the Zotero Import plugin to import via a Atom Feed URL for a public group library, the plugin returns “Error” in the Status column. It will import 1 item but that’s it.
We changed the .htaccess to SetEnv APPLICATION_ENV development but aren’t seeing any error messages.
We’re using Reclaim Hosting and have updated the php-cli path.
This Omeka site is http://sovietjewry.hosting.nyu.edu/ and the Zotero group is https://www.zotero.org/groups/soviet_jewish_archive
For this you’ll want to activate error logging. Once you run a failed import, open applications/logs and look at the file errors.log to get details.
Quick check also: what version of Omeka and the Zotero Import plugin are you running?
Thanks for your help. We’re using Omeka 2.5 and Zotero Import 2.0.2.
We activated the error log and repeated the process and the log says
2017-05-03T21:26:44+00:00 ERR (3): exception ‘Zend_Db_Statement_Mysqli_Exception’ with message ‘Mysqli statement execute error : Incorrect datetime value: ‘2017-04-30T09:31:38Z’ for column ‘zotero_updated’ at row 1’ in /home/sovietje/public_html/application/libraries/Zend/Db/Statement/Mysqli.php:214
Stack trace:
#0 /home/sovietje/public_html/application/libraries/Zend/Db/Statement.php(303): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/sovietje/public_html/application/libraries/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#2 [internal function]: Zend_Db_Adapter_Abstract->query(‘INSERT INTO om...', Array) #3 /home/sovietje/public_html/application/libraries/Omeka/Db.php(79): call_user_func_array(Array, Array) #4 /home/sovietje/public_html/application/libraries/Omeka/Db.php(252): Omeka_Db->__call('query', Array) #5 /home/sovietje/public_html/application/libraries/Omeka/Db.php(252): Omeka_Db->query('INSERT INTOom…’, Array)
#6 /home/sovietje/public_html/application/libraries/Omeka/Record/AbstractRecord.php(543): Omeka_Db->insert(‘ZoteroImportIte…’, Array)
#7 /home/sovietje/public_html/plugins/ZoteroImport/models/ZoteroImport/ImportProcess.php(389): Omeka_Record_AbstractRecord->save()
#8 /home/sovietje/public_html/plugins/ZoteroImport/models/ZoteroImport/ImportProcess.php(183): ZoteroImport_ImportProcess->_insertZoteroImportItem(297, ‘TDVPFMUW’, NULL, ‘book’, ‘2017-04-30T09:3…’)
#9 /home/sovietje/public_html/plugins/ZoteroImport/models/ZoteroImport/ImportProcess.php(65): ZoteroImport_ImportProcess->_import()
#10 /home/sovietje/public_html/application/scripts/background.php(61): ZoteroImport_ImportProcess->run(Array)
#11 {main}
I updated to the most recent Zotero Import v2.1. I get a similar, albeit slightly different error message:
exception ‘Zend_Db_Statement_Mysqli_Exception’ with message ‘Mysqli statement execute error : Incorrect string value: ‘\xF4\x80\x8F\x90ic…’ for column ‘text’ at row 1’ in /home/sovietje/public_html/application/libraries/Zend/Db/Statement/Mysqli.php:214
Stack trace:
#0 /home/sovietje/public_html/application/libraries/Zend/Db/Statement.php(303): Zend_Db_Statement_Mysqli->_execute(Array)#1 /home/sovietje/public_html/application/libraries/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#2 [internal function]: Zend_Db_Adapter_Abstract->query('INSERT INTO `om...', Array)#3 /home/sovietje/public_html/application/libraries/Omeka/Db.php(79): call_user_func_array(Array, Array)
#4 /home/sovietje/public_html/application/libraries/Omeka/Db.php(252): Omeka_Db->__call('query', Array)#5 /home/sovietje/public_html/application/libraries/Omeka/Db.php(252): Omeka_Db->query('INSERT INTO om...', Array) ``#6 /home/sovietje/public_html/application/libraries/Omeka/Record/AbstractRecord.php(543): Omeka_Db->insert('ElementText', Array) ``#7 /home/sovietje/public_html/application/models/Mixin/ElementText.php(671): Omeka_Record_AbstractRecord->save()#8 /home/sovietje/public_html/application/models/Mixin/ElementText.php(93): Mixin_ElementText->saveElementTexts()
#9 [internal function]: Mixin_ElementText->afterSave(Array)#10 /home/sovietje/public_html/application/libraries/Omeka/Record/AbstractRecord.php(251): call_user_func_array(Array, Array)
#11 /home/sovietje/public_html/application/libraries/Omeka/Record/AbstractRecord.php(280): Omeka_Record_AbstractRecord->delegateToMixins('afterSave', Array, true)#12 /home/sovietje/public_html/application/libraries/Omeka/Record/AbstractRecord.php(550): Omeka_Record_AbstractRecord->runCallbacks(‘afterSave’, Array)
#13 /home/sovietje/public_html/application/libraries/Omeka/Record/Builder/AbstractBuilder.php(67): Omeka_Record_AbstractRecord->save()#14 /home/sovietje/public_html/application/libraries/globals.php(539): Omeka_Record_Builder_AbstractBuilder->build()
#15 /home/sovietje/public_html/plugins/ZoteroImport/models/ZoteroImport/ImportProcess.php(176): insert_item(Array, Array, Array)#16 /home/sovietje/public_html/plugins/ZoteroImport/models/ZoteroImport/ImportProcess.php(65): ZoteroImport_ImportProcess->_import()
#17 /home/sovietje/public_html/application/scripts/background.php(61): ZoteroImport_ImportProcess->run(Array)#18 {main}
I think one of your Zotero items contains errant characters that the Omeka database cannot decipher. In item 6CJR7PPU you’ll see two “” replacement characters where "f"s should be. Try removing them and re-import. (I simulated this and successfully imported your entire library.)
That worked, thank you!