Migration von Modified auf Shopware - Fehlermeldung bei Kundendatenimport

Shopware 5 Installation/Einstieg
1

Hallo Gemeinde,

während der Migration erhalte ich beim Import der Kundendaten von Modified zu Shopware folgende Fehlermeldung:

Beim Importieren der Kunden ist ein Fehler aufgetreten

Code : 42000
Line : 224
File : /www/htdocs/w009fa63/testshop/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 '@meinshop)' at line 2
Trace : #0 /www/htdocs/w009fa63/testshop/engine/Library/Zend/Db/Statement.php(297): Zend_Db_Statement_Pdo->_execute(Array) #1 /www/htdocs/w009fa63/testshop/engine/Library/Zend/Db/Adapter/Abstract.php(470): Zend_Db_Statement->execute(Array) #2 /www/htdocs/w009fa63/testshop/engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(232): Zend_Db_Adapter_Abstract->query('INSERT INTO s_c...', Array) #3 /www/htdocs/w009fa63/testshop/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(96): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO s_c...', Array) #4 /www/htdocs/w009fa63/testshop/engine/Shopware/Plugins/Community/Backend/SwagMigration/Components/DbServices/Import/CustomerImporter.php(803): Enlight_Components_Db_Adapter_Pdo_Mysql->query('INSERT INTO s_c...') #5 /www/htdocs/w009fa63/testshop/engine/Shopware/Plugins/Community/Backend/SwagMigration/Components/DbServices/Import/CustomerImporter.php(300): Shopware\SwagMigration\Components\DbServices\Import\CustomerImporter->newsletterSubscribe(Array) #6 /www/htdocs/w009fa63/testshop/engine/Shopware/Plugins/Community/Backend/SwagMigration/Components/DbServices/Import/Import.php(176): Shopware\SwagMigration\Components\DbServices\Import\CustomerImporter->import(Array) #7 /www/htdocs/w009fa63/testshop/engine/Shopware/Plugins/Community/Backend/SwagMigration/Components/Migration/Import/Resource/Customer.php(207): Shopware\SwagMigration\Components\DbServices\Import\Import->customer(Array) #8 /www/htdocs/w009fa63/testshop/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 /www/htdocs/w009fa63/testshop/engine/Shopware/Plugins/Community/Backend/SwagMigration/Controllers/Backend/SwagMigration.php(443): Shopware\SwagMigration\Components\Migration\Import\Resource\Customer->run() #10 /www/htdocs/w009fa63/testshop/engine/Shopware/Plugins/Community/Backend/SwagMigration/Controllers/Backend/SwagMigration.php(478): Shopware_Controllers_Backend_SwagMigration->runImport('import_customer...') #11 /www/htdocs/w009fa63/testshop/engine/Library/Enlight/Controller/Action.php(193): Shopware_Controllers_Backend_SwagMigration->importAction() #12 /www/htdocs/w009fa63/testshop/engine/Library/Enlight/Controller/Dispatcher/Default.php(549): Enlight_Controller_Action->dispatch('importAction') #13 /www/htdocs/w009fa63/testshop/engine/Library/Enlight/Controller/Front.php(222): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #14 /www/htdocs/w009fa63/testshop/engine/Shopware/Kernel.php(215): Enlight_Controller_Front->dispatch() #15 /www/htdocs/w009fa63/testshop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(486): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #16 /www/htdocs/w009fa63/testshop/engine/Shopware/Components/HttpCache/AppCache.php(268): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #17 /www/htdocs/w009fa63/testshop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(253): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #18 /www/htdocs/w009fa63/testshop/engine/Shopware/Components/HttpCache/AppCache.php(105): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true) #19 /www/htdocs/w009fa63/testshop/shopware.php(122): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #20 {main}
OK

Kann mir jemand sagen wie ich den Fehler beheben kann?

Danke im Voraus.

Grüße

2

Aktuell gibt es einen Pull-Request auf Github der in die gleiche Richtung geht: Bugfix CustomerImporter.php by micronax · Pull Request #22 · shopwareLabs/SwagMigration · GitHub

Kannst ja mal schauen, ob das ggf. dein Problem behebt.

3

Danke [@Moritz Naczenski](http://forum.shopware.com/profile/14574/Moritz Naczenski „Moritz Naczenski“)‍

Konnte die PHP-Datei erfolgreich anpassen!

Jetzt habe ich noch eine Fehlermeldung beim Import der Bestellungen:

Beim Importieren der Bestellungen ist ein Fehler aufgetreten

Code : 0
Line : 224
File : /www/htdocs/w009fa63/testshop/engine/Library/Zend/Db/Statement/Pdo.php

Error : SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_german1_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Trace : #0 /www/htdocs/w009fa63/testshop/engine/Library/Zend/Db/Statement.php(317): Zend_Db_Statement_Pdo->_execute(Array) #1 /www/htdocs/w009fa63/testshop/engine/Library/Zend/Db/Adapter/Abstract.php(470): Zend_Db_Statement->execute(Array) #2 /www/htdocs/w009fa63/testshop/engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(232): Zend_Db_Adapter_Abstract->query('\n\t\t\tSELECT\n\t\t\t\t...', Array) #3 /www/htdocs/w009fa63/testshop/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(96): Zend_Db_Adapter_Pdo_Abstract->query('\n\t\t\tSELECT\n\t\t\t\t...', Array) #4 /www/htdocs/w009fa63/testshop/engine/Shopware/Plugins/Community/Backend/SwagMigration/Components/Migration/Profile.php(689): Enlight_Components_Db_Adapter_Pdo_Mysql->query('\n\t\t\tSELECT\n\t\t\t\t...') #5 /www/htdocs/w009fa63/testshop/engine/Shopware/Plugins/Community/Backend/SwagMigration/Components/Migration/Import/Resource/Order.php(91): Shopware\SwagMigration\Components\Migration\Profile->queryOrders(0) #6 /www/htdocs/w009fa63/testshop/engine/Shopware/Plugins/Community/Backend/SwagMigration/Components/Migration/Import/Resource/Order.php(73): Shopware\SwagMigration\Components\Migration\Import\Resource\Order->importOrders() #7 /www/htdocs/w009fa63/testshop/engine/Shopware/Plugins/Community/Backend/SwagMigration/Controllers/Backend/SwagMigration.php(443): Shopware\SwagMigration\Components\Migration\Import\Resource\Order->run() #8 /www/htdocs/w009fa63/testshop/engine/Shopware/Plugins/Community/Backend/SwagMigration/Controllers/Backend/SwagMigration.php(478): Shopware_Controllers_Backend_SwagMigration->runImport('import_orders') #9 /www/htdocs/w009fa63/testshop/engine/Library/Enlight/Controller/Action.php(193): Shopware_Controllers_Backend_SwagMigration->importAction() #10 /www/htdocs/w009fa63/testshop/engine/Library/Enlight/Controller/Dispatcher/Default.php(549): Enlight_Controller_Action->dispatch('importAction') #11 /www/htdocs/w009fa63/testshop/engine/Library/Enlight/Controller/Front.php(222): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #12 /www/htdocs/w009fa63/testshop/engine/Shopware/Kernel.php(215): Enlight_Controller_Front->dispatch() #13 /www/htdocs/w009fa63/testshop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(486): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #14 /www/htdocs/w009fa63/testshop/engine/Shopware/Components/HttpCache/AppCache.php(268): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #15 /www/htdocs/w009fa63/testshop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(253): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #16 /www/htdocs/w009fa63/testshop/engine/Shopware/Components/HttpCache/AppCache.php(105): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true) #17 /www/htdocs/w009fa63/testshop/shopware.php(122): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #18 {main}
OK

Gibt es dafür evtl. noch einen Hinweis für eine Lösung?

Danke und Grüße

4

Glaube das betrifft deine Quelldatenbank - also die Modified-Datenbank.
Der Fehler sagt erstmal nur, dass da Tabellen/Spalten nicht die gleiche Coallation haben. Am besten schaust du mal in die Datenbank ob es da schon verschiedene Coallations bei den Tabellen von Modified gibt. Geht wohl speziell um die order-tabellen.

1 „Gefällt mir“