TristargamingTristargaming MemberComments: Received thanks: 0 Member since: March 18

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?

Sign In or Register to comment.