# Error bei customers bei Import von xtc modified 1.05

**URL:** https://forum.shopware.com/t/error-bei-customers-bei-import-von-xtc-modified-1-05/53384
**Category:** Sonstiges
**Created:** [10. Juni 2018 um 13:31 UTC](https://forum.shopware.com/t/error-bei-customers-bei-import-von-xtc-modified-1-05/53384 "2018-06-10T13:31:41Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![tpk](https://avatars.discourse-cdn.com/v4/letter/t/d2c977/32.png) [@tpk](https://forum.shopware.com/u/tpk)
#### Post date: [10. Juni 2018 um 13:31 UTC](https://forum.shopware.com/t/error-bei-customers-bei-import-von-xtc-modified-1-05/53384/1 "2018-06-10T13:31:41Z")

</div>

Beim Import über das Migrationstool gibt es bei den Kundendaten folgenden Fehler:

&nbsp;

> **An error occurred while importing customers**
> 
> **Code** &nbsp;: 42000  
> **Line** &nbsp;: 224  
> **File** &nbsp;: C:\Users\User\Desktop\www\shopware\engine\Library\Zend\Db\Statement\Pdo.php
> 
> **Error** &nbsp;: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ’ ‚c5751fc346de5f131a04faae9997a939‘)’ at line 2  
> **Trace** &nbsp;: #0 C:\Users\User\Desktop\www\shopware\engine\Library\Zend\Db\Statement.php(297): Zend\_Db\_Statement\_Pdo-\>\_execute(Array)
> 
> #1 C:\Users\User\Desktop\www\shopware\engine\Library\Zend\Db\Adapter\Abstract.php(470): Zend\_Db\_Statement-\>execute(Array)
> 
> &nbsp;
> 
> #2 C:\Users\User\Desktop\www\shopware\engine\Library\Zend\Db\Adapter\Pdo\Abstract.php(232): Zend\_Db\_Adapter\_Abstract-\>query(‚INSERT INTO s\_u…‘, Array)
> 
> #3 C:\Users\User\Desktop\www\shopware\engine\Library\Enlight\Components\Db\Adapter\Pdo\Mysql.php(96): Zend\_Db\_Adapter\_Pdo\_Abstract-\>query(‚INSERT INTO s\_u…‘, Array)
> 
> #4 C:\Users\User\Desktop\www\shopware\engine\Shopware\Plugins\Community\Backend\SwagMigration\Components\DbServices\Import\CustomerImporter.php(471): Enlight\_Components\_Db\_Adapter\_Pdo\_Mysql-\>query(‚INSERT INTO s\_u…‘) #5 C:\Users\User\Desktop\www\shopware\engine\Shopware\Plugins\Community\Backend\SwagMigration\Components\DbServices\Import\CustomerImporter.php(167): Shopware\SwagMigration\Components\DbServices\Import\CustomerImporter-\>createOrUpdateCustomer(Array) #6 C:\Users\User\Desktop\www\shopware\engine\Shopware\Plugins\Community\Backend\SwagMigration\Components\DbServices\Import\Import.php(176): Shopware\SwagMigration\Components\DbServices\Import\CustomerImporter-\>import(Array) #7 C:\Users\User\Desktop\www\shopware\engine\Shopware\Plugins\Community\Backend\SwagMigration\Components\Migration\Import\Resource\Customer.php(207): Shopware\SwagMigration\Components\DbServices\Import\Import-\>customer(Array) #8 C:\Users\User\Desktop\www\shopware\engine\Shopware\Plugins\Community\Backend\SwagMigration\Components\Migration\Import\Resource\Customer.php(82): Shopware\SwagMigration\Components\Migration\Import\Resource\Customer-\>migrateCustomer(Array, Object(Shopware\SwagMigration\Components\DbServices\Import\Import), ‚‘) #9 C:\Users\User\Desktop\www\shopware\engine\Shopware\Plugins\Community\Backend\SwagMigration\Controllers\Backend\SwagMigration.php(444): Shopware\SwagMigration\Components\Migration\Import\Resource\Customer-\>run() #10 C:\Users\User\Desktop\www\shopware\engine\Shopware\Plugins\Community\Backend\SwagMigration\Controllers\Backend\SwagMigration.php(479): Shopware\_Controllers\_Backend\_SwagMigration-\>runImport(‚import\_customer…‘) #11 C:\Users\User\Desktop\www\shopware\engine\Library\Enlight\Controller\Action.php(193): Shopware\_Controllers\_Backend\_SwagMigration-\>importAction() #12 C:\Users\User\Desktop\www\shopware\engine\Library\Enlight\Controller\Dispatcher\Default.php(549): Enlight\_Controller\_Action-\>dispatch(‚importAction‘) #13 C:\Users\User\Desktop\www\shopware\engine\Library\Enlight\Controller\Front.php(222): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #14 C:\Users\User\Desktop\www\shopware\engine\Shopware\Kernel.php(215): Enlight\_Controller\_Front-\>dispatch() #15 C:\Users\User\Desktop\www\shopware\vendor\symfony\http-kernel\HttpCache\HttpCache.php(486): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #16 C:\Users\User\Desktop\www\shopware\engine\Shopware\Components\HttpCache\AppCache.php(268): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #17 C:\Users\User\Desktop\www\shopware\vendor\symfony\http-kernel\HttpCache\HttpCache.php(253): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #18 C:\Users\User\Desktop\www\shopware\engine\Shopware\Components\HttpCache\AppCache.php(105): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass(Object(Symfony\Component\HttpFoundation\Request), true) #19 C:\Users\User\Desktop\www\shopware\shopware.php(122): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #20 {main}
> 
> _OK_