# Fehler mit der Magento Migration **URL:** \ **Category:** Shopware 3.5\ **Tags:** programming\ **Created:** [17. Juni 2011 um 12:52 UTC](https://forum.shopware.com/t/fehler-mit-der-magento-migration/3164 "2011-06-17T12:52:03Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![delite](https://avatars.discourse-cdn.com/v4/letter/d/ce7236/32.png) [@delite](https://forum.shopware.com/u/delite)\ **Post date:** [17. Juni 2011 um 12:52 UTC](https://forum.shopware.com/t/fehler-mit-der-magento-migration/3164/1 "2011-06-17T12:52:03Z")
Hallo Zusammen, wir möchten unsere bestehenden Artikel von unserem Magento-Shop in unseren neuen Shopware Shop einfügen (es sind fast 600 Stück). Soweit hat alles funktioniert, nur bekomme ich eine Fehlermeldung wenn ich die Übertragung starte! ` Import fehlgeschlagen exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias: 'weight'' in /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Enlight/Vendor/Zend/library/Zend/Db/Statement/Pdo.php:228 Stack trace: ` Vielen Dank für die Informationen! ---
**Author:** ![Bibeno](https://avatars.discourse-cdn.com/v4/letter/b/13edae/32.png) [@Bibeno](https://forum.shopware.com/u/Bibeno)\ **Post date:** [17. Juni 2011 um 12:54 UTC](https://forum.shopware.com/t/fehler-mit-der-magento-migration/3164/2 "2011-06-17T12:54:49Z")
Hi, den habe ich auch bekommen. Habe hier im Forum auch schon mal vor ca 2 Wochen angefragt. Kam leider nie ne Reaktion. Nun Kopier ich die Artikel einzeln. ---
**Author:** ![delite](https://avatars.discourse-cdn.com/v4/letter/d/ce7236/32.png) [@delite](https://forum.shopware.com/u/delite)\ **Post date:** [17. Juni 2011 um 12:55 UTC](https://forum.shopware.com/t/fehler-mit-der-magento-migration/3164/3 "2011-06-17T12:55:52Z")
Also das ist ja auch dämlich… 600 Artikel, das waren zwei Wochen arbeit! Um Hilfe wäre ich wirklich dankbar! ---
**Author:** ![Stefan\_Hamann](https://avatars.discourse-cdn.com/v4/letter/s/5e9695/32.png) [@Stefan\_Hamann](https://forum.shopware.com/u/Stefan_Hamann)\ **Post date:** [17. Juni 2011 um 12:58 UTC](https://forum.shopware.com/t/fehler-mit-der-magento-migration/3164/4 "2011-06-17T12:58:05Z")
Kannst du einmal den Stacktrace hier einstellen und mir ggf. einen PHPMyAdmin Zugang zu einer Magento DB bereitstellen? Dann kann ich das Problem vermutlich schnell beheben! ---
**Author:** ![Bibeno](https://avatars.discourse-cdn.com/v4/letter/b/13edae/32.png) [@Bibeno](https://forum.shopware.com/u/Bibeno)\ **Post date:** [17. Juni 2011 um 13:08 UTC](https://forum.shopware.com/t/fehler-mit-der-magento-migration/3164/5 "2011-06-17T13:08:17Z")
[quote=„delite“]Also das ist ja auch dämlich… 600 Artikel, das waren zwei Wochen arbeit! Um Hilfe wäre ich wirklich dankbar![/quote] Ich habe 800 Artikel, lachen kann ich darueber auch nicht. Wenn hier jemand eine Loesung in den Raum wirft waere das Klasse ---
**Author:** ![delite](https://avatars.discourse-cdn.com/v4/letter/d/ce7236/32.png) [@delite](https://forum.shopware.com/u/delite)\ **Post date:** [17. Juni 2011 um 13:09 UTC](https://forum.shopware.com/t/fehler-mit-der-magento-migration/3164/6 "2011-06-17T13:09:52Z")
` Artikel importieren: Artikel-Übersetzungen importieren: Kundengruppen-Preise importieren: Artikel-Bilder importieren: Kategorien importieren: Kunden importieren: Bewertungen importieren: Bestellungen importieren: Import abschließen: Default-Hersteller: Zurück Start Artikel importieren: Artikel-Übersetzungen importieren: Kundengruppen-Preise importieren: Artikel-Bilder importieren: Kategorien importieren: Kunden importieren: Bewertungen importieren: Bestellungen importieren: Import abschließen: Default-Hersteller: Zurück Start Import fehlgeschlagen exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias: 'weight'' in /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Enlight/Vendor/Zend/library/Zend/Db/Statement/Pdo.php:228 Stack trace: #0 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Enlight/Vendor/Zend/library/Zend/Db/Statement/Pdo.php(228): PDOStatement-\>execute(Array) #1 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Enlight/Vendor/Zend/library/Zend/Db/Statement.php(300): Zend\_Db\_Statement\_Pdo-\>\_execute(Array) #2 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Enlight/Vendor/Zend/library/Zend/Db/Adapter/Abstract.php(479): Zend\_Db\_Statement-\>execute(Array) #3 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Enlight/Vendor/Zend/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend\_Db\_Adapter\_Abstract-\>query('????SELECT ????...', Array) #4 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Enlight/Enlight/Components/Db/Adapter/Pdo/Mysql.php(50): Zend\_Db\_Adapter\_Pdo\_Abstract-\>query('????SELECT ????...', Array) #5 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Shopware/Plugins/Community/Backend/SwagMigration/Components/Migration/Profile.php(199): Enlight\_Components\_Db\_Adapter\_Pdo\_Mysql-\>query('????SELECT ????...') #6 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Shopware/Plugins/Community/Backend/SwagMigration/Controllers/Migration.php(513): Shopware\_Components\_Migration\_Profile-\>queryProducts(0) #7 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Shopware/Plugins/Community/Backend/SwagMigration/Controllers/Migration.php(940): Shopware\_Controllers\_Backend\_Migration-\>importProducts() #8 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Enlight/Enlight/Controller/Action.php(70): Shopware\_Controllers\_Backend\_Migration-\>importAction() #9 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Enlight/Enlight/Controller/Dispatcher/DispatcherDefault.php(329): Enlight\_Controller\_Action-\>dispatch('importAction') #10 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Enlight/Enlight/Controller/Front.php(99): Enlight\_Controller\_Dispatcher\_DispatcherDefault-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #11 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Shopware/Bootstrap.php(33): Enlight\_Controller\_Front-\>dispatch() #12 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Enlight/Enlight/Application.php(86): Shopware\_Bootstrap-\>run() #13 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/shopware.php(6): Enlight\_Application-\>run() #14 {main} Next exception 'Zend\_Db\_Statement\_Exception' with message 'SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias: 'weight'' in /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Enlight/Vendor/Zend/library/Zend/Db/Statement/Pdo.php:234 Stack trace: #0 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Enlight/Vendor/Zend/library/Zend/Db/Statement.php(300): Zend\_Db\_Statement\_Pdo-\>\_execute(Array) #1 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Enlight/Vendor/Zend/library/Zend/Db/Adapter/Abstract.php(479): Zend\_Db\_Statement-\>execute(Array) #2 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Enlight/Vendor/Zend/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend\_Db\_Adapter\_Abstract-\>query('????SELECT ????...', Array) #3 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Enlight/Enlight/Components/Db/Adapter/Pdo/Mysql.php(50): Zend\_Db\_Adapter\_Pdo\_Abstract-\>query('????SELECT ????...', Array) #4 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Shopware/Plugins/Community/Backend/SwagMigration/Components/Migration/Profile.php(199): Enlight\_Components\_Db\_Adapter\_Pdo\_Mysql-\>query('????SELECT ????...') #5 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Shopware/Plugins/Community/Backend/SwagMigration/Controllers/Migration.php(513): Shopware\_Components\_Migration\_Profile-\>queryProducts(0) #6 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Shopware/Plugins/Community/Backend/SwagMigration/Controllers/Migration.php(940): Shopware\_Controllers\_Backend\_Migration-\>importProducts() #7 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Enlight/Enlight/Controller/Action.php(70): Shopware\_Controllers\_Backend\_Migration-\>importAction() #8 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Enlight/Enlight/Controller/Dispatcher/DispatcherDefault.php(329): Enlight\_Controller\_Action-\>dispatch('importAction') #9 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Enlight/Enlight/Controller/Front.php(99): Enlight\_Controller\_Dispatcher\_DispatcherDefault-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #10 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Shopware/Bootstrap.php(33): Enlight\_Controller\_Front-\>dispatch() #11 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Enlight/Enlight/Application.php(86): Shopware\_Bootstrap-\>run() #12 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/shopware.php(6): Enlight\_Application-\>run() #13 {main} OK #0 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Enlight/Vendor/Zend/library/Zend/Db/Statement/Pdo.php(228): PDOStatement-\>execute(Array) #1 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Enlight/Vendor/Zend/library/Zend/Db/Statement.php(300): Zend\_Db\_Statement\_Pdo-\>\_execute(Array) #2 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Enlight/Vendor/Zend/library/Zend/Db/Adapter/Abstract.php(479): Zend\_Db\_Statement-\>execute(Array) #3 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Enlight/Vendor/Zend/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend\_Db\_Adapter\_Abstract-\>query('????SELECT ????...', Array) #4 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Enlight/Enlight/Components/Db/Adapter/Pdo/Mysql.php(50): Zend\_Db\_Adapter\_Pdo\_Abstract-\>query('????SELECT ????...', Array) #5 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Shopware/Plugins/Community/Backend/SwagMigration/Components/Migration/Profile.php(199): Enlight\_Components\_Db\_Adapter\_Pdo\_Mysql-\>query('????SELECT ????...') #6 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Shopware/Plugins/Community/Backend/SwagMigration/Controllers/Migration.php(513): Shopware\_Components\_Migration\_Profile-\>queryProducts(0) #7 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Shopware/Plugins/Community/Backend/SwagMigration/Controllers/Migration.php(940): Shopware\_Controllers\_Backend\_Migration-\>importProducts() #8 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Enlight/Enlight/Controller/Action.php(70): Shopware\_Controllers\_Backend\_Migration-\>importAction() #9 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Enlight/Enlight/Controller/Dispatcher/DispatcherDefault.php(329): Enlight\_Controller\_Action-\>dispatch('importAction') #10 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Enlight/Enlight/Controller/Front.php(99): Enlight\_Controller\_Dispatcher\_DispatcherDefault-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #11 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Shopware/Bootstrap.php(33): Enlight\_Controller\_Front-\>dispatch() #12 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Enlight/Enlight/Application.php(86): Shopware\_Bootstrap-\>run() #13 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/shopware.php(6): Enlight\_Application-\>run() #14 {main} Next exception 'Zend\_Db\_Statement\_Exception' with message 'SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias: 'weight'' in /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Enlight/Vendor/Zend/library/Zend/Db/Statement/Pdo.php:234 Stack trace: #0 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Enlight/Vendor/Zend/library/Zend/Db/Statement.php(300): Zend\_Db\_Statement\_Pdo-\>\_execute(Array) #1 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Enlight/Vendor/Zend/library/Zend/Db/Adapter/Abstract.php(479): Zend\_Db\_Statement-\>execute(Array) #2 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Enlight/Vendor/Zend/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend\_Db\_Adapter\_Abstract-\>query('????SELECT ????...', Array) #3 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Enlight/Enlight/Components/Db/Adapter/Pdo/Mysql.php(50): Zend\_Db\_Adapter\_Pdo\_Abstract-\>query('????SELECT ????...', Array) #4 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Shopware/Plugins/Community/Backend/SwagMigration/Components/Migration/Profile.php(199): Enlight\_Components\_Db\_Adapter\_Pdo\_Mysql-\>query('????SELECT ????...') #5 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Shopware/Plugins/Community/Backend/SwagMigration/Controllers/Migration.php(513): Shopware\_Components\_Migration\_Profile-\>queryProducts(0) #6 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Shopware/Plugins/Community/Backend/SwagMigration/Controllers/Migration.php(940): Shopware\_Controllers\_Backend\_Migration-\>importProducts() #7 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Enlight/Enlight/Controller/Action.php(70): Shopware\_Controllers\_Backend\_Migration-\>importAction() #8 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Enlight/Enlight/Controller/Dispatcher/DispatcherDefault.php(329): Enlight\_Controller\_Action-\>dispatch('importAction') #9 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Enlight/Enlight/Controller/Front.php(99): Enlight\_Controller\_Dispatcher\_DispatcherDefault-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #10 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Shopware/Bootstrap.php(33): Enlight\_Controller\_Front-\>dispatch() #11 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/engine/Enlight/Enlight/Application.php(86): Shopware\_Bootstrap-\>run() #12 /srv/www/vhosts/attigoo.com/subdomains/dev/httpdocs/shopware.php(6): Enlight\_Application-\>run() #13 {main} OK ` Rest kommt per PM! Danke Dir!!! ---
**Author:** ![Bibeno](https://avatars.discourse-cdn.com/v4/letter/b/13edae/32.png) [@Bibeno](https://forum.shopware.com/u/Bibeno)\ **Post date:** [22. Juni 2011 um 09:10 UTC](https://forum.shopware.com/t/fehler-mit-der-magento-migration/3164/7 "2011-06-22T09:10:58Z")
Und was ist dabei jetzt nun raus gekommen? Waere fuer andere Umsteiger auch interessant zu wissen wie das Problem behoben wurde. ---
**Author:** ![Chaos](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/chaos/32/13622_2.png) [@Chaos](https://forum.shopware.com/u/Chaos)\ **Post date:** [8. Juli 2011 um 16:43 UTC](https://forum.shopware.com/t/fehler-mit-der-magento-migration/3164/8 "2011-07-08T16:43:39Z")
Würd mich auch interessieren, da ich einen ähnlichen Fehler erhalte! Kategorien & Kunden kann ich problemlos importieren…