Data too long for column 'metadata' at row 1

I am receiving the following error message when I try to upload files to an Item. I was able to upload more than 60 files in a row without any difficulty, but the last 10 image files (small size, jpegs) will not upload. I encountered this same problem with certain audio files a few months ago and it was never resolved. Any insights?
Mysqli statement execute error : Data too long for column ‘metadata’ at row 1

Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Data too long for column ‘metadata’ at row 1 in /home/scsharch/public_html/application/libraries/Zend/Db/Statement/Mysqli.php:214
Stack trace:
#0 /home/scsharch/public_html/application/libraries/Zend/Db/Statement.php(303): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/scsharch/public_html/application/libraries/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#2 /home/scsharch/public_html/application/libraries/Omeka/Db.php(80): Zend_Db_Adapter_Abstract->query(‘INSERT INTO `om…’, Array)
#3 /home/scsharch/public_html/application/libraries/Omeka/Db.php(257): Omeka_Db->__call(‘query’, Array)
#4 /home/scsharch/public_html/application/libraries/Omeka/Record/AbstractRecord.php(541): Omeka_Db->insert(‘om_files’, Array)
#5 /home/scsharch/public_html/application/models/File.php(358): Omeka_Record_AbstractRecord->save()
#6 /home/scsharch/public_html/application/models/Job/FileProcessUpload.php(22): File->createDerivatives()
#7 /home/scsharch/public_html/application/libraries/Omeka/Job/Dispatcher/Adapter/Synchronous.php(25): Job_FileProcessUpload->perform()
#8 /home/scsharch/public_html/application/libraries/Omeka/Job/Dispatcher/Default.php(137): Omeka_Job_Dispatcher_Adapter_Synchronous->send(’{“className”:"J…’, Array)
#9 /home/scsharch/public_html/application/models/File.php(203): Omeka_Job_Dispatcher_Default->send(‘Job_FileProcess…’, Array)
#10 /home/scsharch/public_html/application/libraries/Omeka/Record/AbstractRecord.php(280): File->afterSave(Array)
#11 /home/scsharch/public_html/application/libraries/Omeka/Record/AbstractRecord.php(548): Omeka_Record_AbstractRecord->runCallbacks(‘afterSave’, Array)
#12 /home/scsharch/public_html/application/models/Item.php(336): Omeka_Record_AbstractRecord->save()
#13 /home/scsharch/public_html/application/models/Builder/Item.php(203): Item->saveFiles()
#14 /home/scsharch/public_html/application/libraries/globals.php(567): Builder_Item->addFiles(‘Upload’, ‘file’, Array)
#15 /home/scsharch/public_html/application/models/Item.php(321): insert_files_for_item(Object(Item), ‘Upload’, ‘file’, Array)
#16 /home/scsharch/public_html/application/models/Item.php(231): Item->_uploadFiles()
#17 /home/scsharch/public_html/application/libraries/Omeka/Record/AbstractRecord.php(280): Item->beforeSave(Array)
#18 /home/scsharch/public_html/application/libraries/Omeka/Record/AbstractRecord.php(529): Omeka_Record_AbstractRecord->runCallbacks(‘beforeSave’, Array)
#19 /home/scsharch/public_html/application/libraries/Omeka/Controller/AbstractActionController.php(229): Omeka_Record_AbstractRecord->save(false)
#20 /home/scsharch/public_html/application/controllers/ItemsController.php(88): Omeka_Controller_AbstractActionController->editAction()
#21 /home/scsharch/public_html/application/libraries/Zend/Controller/Action.php(516): ItemsController->editAction()
#22 /home/scsharch/public_html/application/libraries/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch(‘editAction’)
#23 /home/scsharch/public_html/application/libraries/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#24 /home/scsharch/public_html/application/libraries/Zend/Application/Bootstrap/Bootstrap.php(105): Zend_Controller_Front->dispatch()
#25 /home/scsharch/public_html/application/libraries/Zend/Application.php(384): Zend_Application_Bootstrap_Bootstrap->run()
#26 /home/scsharch/public_html/application/libraries/Omeka/Application.php(73): Zend_Application->run()
#27 /home/scsharch/public_html/admin/index.php(28): Omeka_Application->run()

1 Like

The issue is probably that these images contain too much embedded metadata (EXIF, and so on) for Omeka to store.

One option is to strip the metadata from those files before uploading them. Another would be to expand the storage space Omeka has for this embedded metadata, but that would involve editing the database.

1 Like

There is very little metadata attached to these images.

Are you able to share one of the problem images?

From the error message you’re reporting, it’s pretty much certain to be an issue with “too much” metadata, whether or not the image appears to have a significant amount (there could be something that’s large but “internal,” for example).

scsharchives, Did you ever find a solution to this issue? Having the same problem.

If either of you have an example file that reliably causes this issue that can be shared with us, that would help us see what’s happening and possibly suggest a workaround or a fix.