Nach etlichen Jahren webs (www.webs.de) möchte ich meinen Shop nun gerne modernisieren. Als geeignetes Shopsystem habe ich mir deshalb Shopware ausgesucht. Die Migration der Produkte und Kategorien, Benutzerbewertungen oder auch Preisinformationen ging alles ohne Probleme. Nur beim Kundenimport streikt das Migrationsprogramm und spuckt dabei folgende Fehlermeldung aus:
Code: Alles auswählen
Beim Importieren der Kunden ist ein Fehler aufgetreten
Code : 23000
Line : 224
File : /home/www/web282/html/shopware/engine/Library/Zend/Db/Statement/Pdo.php
Error : SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`shopware`.`s_user_addresses`, CONSTRAINT `s_user_addresses_ibfk_1` FOREIGN KEY (`country_id`) REFERENCES `s_core_countries` (`id`) ON UPDATE CASCADE)
Trace : #0 /home/www/web282/html/shopware/engine/Library/Zend/Db/Statement.php(297): Zend_Db_Statement_Pdo->_execute(Array) #1 /home/www/web282/html/shopware/engine/Library/Zend/Db/Adapter/Abstract.php(470): Zend_Db_Statement->execute(Array) #2 /home/www/web282/html/shopware/engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(232): Zend_Db_Adapter_Abstract->query('INSERT INTO s_u...', Array) #3 /home/www/web282/html/shopware/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(96): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO s_u...', Array) #4 /home/www/web282/html/shopware/engine/Shopware/Plugins/Community/Backend/SwagMigration/Components/DbServices/Import/CustomerImporter.php(641): Enlight_Components_Db_Adapter_Pdo_Mysql->query('INSERT INTO s_u...') #5 /home/www/web282/html/shopware/engine/Shopware/Plugins/Community/Backend/SwagMigration/Components/DbServices/Import/CustomerImporter.php(312): Shopware\SwagMigration\Components\DbServices\Import\CustomerImporter->createOrUpdate(Array, 's_user_addresse...', 'address_id', Array) #6 /home/www/web282/html/shopware/engine/Shopware/Plugins/Community/Backend/SwagMigration/Components/DbServices/Import/Import.php(176): Shopware\SwagMigration\Components\DbServices\Import\CustomerImporter->import(Array) #7 /home/www/web282/html/shopware/engine/Shopware/Plugins/Community/Backend/SwagMigration/Components/Migration/Import/Resource/Customer.php(207): Shopware\SwagMigration\Components\DbServices\Import\Import->customer(Array) #8 /home/www/web282/html/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 /home/www/web282/html/shopware/engine/Shopware/Plugins/Community/Backend/SwagMigration/Controllers/Backend/SwagMigration.php(444): Shopware\SwagMigration\Components\Migration\Import\Resource\Customer->run() #10 /home/www/web282/html/shopware/engine/Shopware/Plugins/Community/Backend/SwagMigration/Controllers/Backend/SwagMigration.php(479): Shopware_Controllers_Backend_SwagMigration->runImport('import_customer...') #11 /home/www/web282/html/shopware/engine/Library/Enlight/Controller/Action.php(193): Shopware_Controllers_Backend_SwagMigration->importAction() #12 /home/www/web282/html/shopware/engine/Library/Enlight/Con
Besten Dank im Voraus