Error bei customers bei Import von xtc modified 1.05

Shopware 5 Sonstiges
1

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

 

An error occurred while importing customers

Code  : 42000
Line  : 224
File  : C:\Users\User\Desktop\www\shopware\engine\Library\Zend\Db\Statement\Pdo.php

Error  : 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  : #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)

 

#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