Hello,
I try to import data from CSV file in a local Omeka (Omeka 2.5, wamp, mySQL 5.7).
I get this error. It seems it is caused by accented characters:
exception 'Zend_Db_Statement_Mysqli_Exception' with message 'Mysqli statement execute error : Incorrect string value: '\x82sent\x82...' for column 'text' at row 1' in C:\wamp64\www\omeka\application\libraries\Zend\Db\Statement\Mysqli.php:214
Stack trace:
#0 C:\wamp64\www\omeka\application\libraries\Zend\Db\Statement.php(303): Zend_Db_Statement_Mysqli->_execute(Array)
#1 C:\wamp64\www\omeka\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 C:\wamp64\www\omeka\application\libraries\Omeka\Db.php(79): call_user_func_array(Array, Array)
#4 C:\wamp64\www\omeka\application\libraries\Omeka\Db.php(252): Omeka_Db->__call('query', Array)
#5 C:\wamp64\www\omeka\application\libraries\Omeka\Db.php(252): Omeka_Db->query('INSERT INTO `om...', Array)
#6 C:\wamp64\www\omeka\application\libraries\Omeka\Record\AbstractRecord.php(543): Omeka_Db->insert('ElementText', Array)
#7 C:\wamp64\www\omeka\application\models\Mixin\ElementText.php(671): Omeka_Record_AbstractRecord->save()
#8 C:\wamp64\www\omeka\application\models\Mixin\ElementText.php(93): Mixin_ElementText->saveElementTexts()
#9 [internal function]: Mixin_ElementText->afterSave(Array)
#10 C:\wamp64\www\omeka\application\libraries\Omeka\Record\AbstractRecord.php(251): call_user_func_array(Array, Array)
#11 C:\wamp64\www\omeka\application\libraries\Omeka\Record\AbstractRecord.php(280): Omeka_Record_AbstractRecord->delegateToMixins('afterSave', Array, true)
#12 C:\wamp64\www\omeka\application\libraries\Omeka\Record\AbstractRecord.php(550): Omeka_Record_AbstractRecord->runCallbacks('afterSave', Array)
#13 C:\wamp64\www\omeka\application\libraries\Omeka\Record\Builder\AbstractBuilder.php(67): Omeka_Record_AbstractRecord->save()
#14 C:\wamp64\www\omeka\application\libraries\globals.php(539): Omeka_Record_Builder_AbstractBuilder->build()
#15 C:\wamp64\www\omeka\plugins\CsvImport\models\CsvImport\Import.php(707): insert_item(Array, Array)
#16 C:\wamp64\www\omeka\plugins\CsvImport\models\CsvImport\Import.php(588): CsvImport_Import->_addItemFromRow(Array)
#17 C:\wamp64\www\omeka\plugins\CsvImport\models\CsvImport\Import.php(336): CsvImport_Import->_importLoop(0)
#18 [internal function]: CsvImport_Import->start()
#19 C:\wamp64\www\omeka\plugins\CsvImport\models\CsvImport\ImportTask.php(39): call_user_func(Array)
#20 C:\wamp64\www\omeka\application\libraries\Omeka\Job\Dispatcher\Adapter\Synchronous.php(25): CsvImport_ImportTask->perform()
#21 C:\wamp64\www\omeka\application\libraries\Omeka\Job\Dispatcher\Default.php(150): Omeka_Job_Dispatcher_Adapter_Synchronous->send('{"className":"C...', Array)
#22 C:\wamp64\www\omeka\plugins\CsvImport\controllers\IndexController.php(386): Omeka_Job_Dispatcher_Default->sendLongRunning('CsvImport_Impor...', Array)
#23 C:\wamp64\www\omeka\plugins\CsvImport\controllers\IndexController.php(135): CsvImport_IndexController->_dispatchImportTask(Object(CsvImport_Import), 'start')
#24 C:\wamp64\www\omeka\application\libraries\Zend\Controller\Action.php(516): CsvImport_IndexController->mapColumnsAction()
#25 C:\wamp64\www\omeka\application\libraries\Zend\Controller\Dispatcher\Standard.php(308): Zend_Controller_Action->dispatch('mapColumnsActio...')
#26 C:\wamp64\www\omeka\application\libraries\Zend\Controller\Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
#27 C:\wamp64\www\omeka\application\libraries\Zend\Application\Bootstrap\Bootstrap.php(105): Zend_Controller_Front->dispatch()
#28 C:\wamp64\www\omeka\application\libraries\Zend\Application.php(384): Zend_Application_Bootstrap_Bootstrap->run()
#29 C:\wamp64\www\omeka\application\libraries\Omeka\Application.php(77): Zend_Application->run()
#30 C:\wamp64\www\omeka\admin\index.php(28): Omeka_Application->run()
#31 {main}
Any idea please? I wonder if french people have ever encountered such a problem!
Thanks,
Julien