Hi,
I keep getting the following errors when importing or trying to import from eBay:
SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation ‘=’ in engine/Library/Zend/Db/Statement/Pdo.php on line 224
Stack trace:
#0 engine/Library/Zend/Db/Statement.php(297): Zend_Db_Statement_Pdo->_execute(Array)
#1 engine/Library/Zend/Db/Adapter/Abstract.php(472): Zend_Db_Statement->execute(Array)
#2 engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(232): Zend_Db_Adapter_Abstract->query(’\r\n\t\t\t\tSELECT\r\n\t…’, Array)
#3 engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(83): Zend_Db_Adapter_Pdo_Abstract->query(’\r\n\t\t\t\tSELECT\r\n\t…’, Array)
#4 engine/Library/Zend/Db/Adapter/Abstract.php(807): Enlight_Components_Db_Adapter_Pdo_Mysql->query(’\r\n\t\t\t\tSELECT\r\n\t…’, Array)
#5 custom/plugins/CbaxExternalOrder/Components/ExternalOrderBase.php(956): Zend_Db_Adapter_Abstract->fetchOne(’\r\n\t\t\t\tSELECT\r\n\t…’, Array)
#6 custom/plugins/CbaxConnectorEbay/Components/EbayOrdersClient.php(61): CbaxExternalOrder\Components\ExternalOrderBase->doLog(‘ebay’, ‘Error’, ‘Error collectin…’, ‘Picking up the …’, ‘Array\n(\n [Ac…’)
#7 custom/plugins/CbaxConnectorEbay/Components/EbayOrdersConnector.php(37): CbaxConnectorEbay\Components\EbayOrdersClient->getOrders()
#8 custom/plugins/CbaxConnectorEbay/Subscriber/Backend.php(37): CbaxConnectorEbay\Components\EbayOrdersConnector->importOrderAutomatic()
#9 engine/Library/Enlight/Event/Handler/Default.php(87): CbaxConnectorEbay\Subscriber\Backend->onRunImportOrder(Object(Shopware_Components_Cron_CronJob))
#10 engine/Library/Enlight/Event/EventManager.php(251): Enlight_Event_Handler_Default->execute(Object(Shopware_Components_Cron_CronJob))
#11 engine/Library/Enlight/Components/Cron/Manager.php(276): Enlight_Event_EventManager->notifyUntil(‘Shopware_CronJo…’, Object(Shopware_Components_Cron_CronJob))
#12 engine/Shopware/Plugins/Default/Core/Cron/Cron.php(53): Enlight_Components_Cron_Manager->runJob(Object(Enlight_Components_Cron_Job))
#13 engine/Library/Enlight/Controller/Action.php(192): Shopware_Controllers_Backend_Cron->indexAction()
#14 engine/Library/Enlight/Controller/Dispatcher/Default.php(478): Enlight_Controller_Action->dispatch(‘indexAction’)
#15 engine/Library/Enlight/Controller/Front.php(228): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp))
#16 engine/Shopware/Kernel.php(188): Enlight_Controller_Front->dispatch()
#17 vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(102): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#18 vendor/symfony/http-kernel/HttpCache/HttpCache.php(453): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(Object(Shopware\Kernel), Object(Symfony\Component\HttpFoundation\Request), 1, true)
#19 engine/Shopware/Components/HttpCache/AppCache.php(261): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL)
#20 vendor/symfony/http-kernel/HttpCache/HttpCache.php(238): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true)
#21 engine/Shopware/Components/HttpCache/AppCache.php(102): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true)
#22 shopware.php(122): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request))
#23 {main}
Any ideas how to sort this?