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!
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.
Also das ist ja auch dämlich… 600 Artikel, das waren zwei Wochen arbeit! Um Hilfe wäre ich wirklich dankbar!
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!
[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
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!!!
Und was ist dabei jetzt nun raus gekommen? Waere fuer andere Umsteiger auch interessant zu wissen wie das Problem behoben wurde.
Würd mich auch interessieren, da ich einen ähnlichen Fehler erhalte! Kategorien & Kunden kann ich problemlos importieren…