# SQLSTATE(HY000)

**URL:** https://forum.shopware.com/t/sqlstate-hy000/65575
**Category:** International (English Only)
**Created:** [18. März 2020 um 12:33 UTC](https://forum.shopware.com/t/sqlstate-hy000/65575 "2020-03-18T12:33:22Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![Tristargaming](https://avatars.discourse-cdn.com/v4/letter/t/b19c9b/32.png) [@Tristargaming](https://forum.shopware.com/u/Tristargaming)
#### Post date: [18. März 2020 um 12:33 UTC](https://forum.shopware.com/t/sqlstate-hy000/65575/1 "2020-03-18T12:33:22Z")

</div>

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&nbsp;&nbsp;&nbsp; [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?

---

<div class="post-metadata">

### Author: ![LenaForlin](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/lenaforlin/32/13485_2.png) [@LenaForlin](https://forum.shopware.com/u/LenaForlin)
#### Post date: [24. Juni 2020 um 07:43 UTC](https://forum.shopware.com/t/sqlstate-hy000/65575/2 "2020-06-24T07:43:43Z")

</div>

The error message indicates different collations in the database tables. Please make sure that all shopware tables in your database have a uniform coalition (utf8\_unicode\_ci).