Migration von Prestashop

Hallo, ich möchte von prestashop zu shopware bekomme aber immer wieder bei der migration folgenden fehler

Beim Importieren der Preise ist ein Fehler aufgetreten

Code : 23000
Line : 234
File : /var/www/vhosts/wwm-server.com/httpdocs/KD/shop/engine/Library/Zend/Db/Statement/Pdo.php

Error : SQLSTATE[23000]: Integrity constraint violation: 1052 Column ‚id_product‘ in order clause is ambiguous
Trace : #0 /var/www/vhosts/wwm-server.com/httpdocs/KD/shop/engine/Library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array) #1 /var/www/vhosts/wwm-server.com/httpdocs/KD/shop/engine/Library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #2 /var/www/vhosts/wwm-server.com/httpdocs/KD/shop/engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(’(\n\t\t\t\t\tSELECT\n …’, Array) #3 /var/www/vhosts/wwm-server.com/httpdocs/KD/shop/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(96): Zend_Db_Adapter_Pdo_Abstract->query(’(\n\t\t\t\t\tSELECT\n …’, Array) #4 /var/www/vhosts/wwm-server.com/httpdocs/KD/shop/engine/Shopware/Plugins/Community/Backend/SwagMigration/Components/Migration/Profile.php(585): Enlight_Components_Db_Adapter_Pdo_Mysql->query(’(\n\t\t\t\t\tSELECT\n …’) #5 /var/www/vhosts/wwm-server.com/httpdocs/KD/shop/engine/Shopware/Plugins/Community/Backend/SwagMigration/Components/Migration/Import/Resource/Price.php(70): Shopware\SwagMigration\Components\Migration\Profile->queryProductPrices(0) #6 /var/www/vhosts/wwm-server.com/httpdocs/KD/shop/engine/Shopware/Plugins/Community/Backend/SwagMigration/Controllers/Backend/SwagMigration.php(465): Shopware\SwagMigration\Components\Migration\Import\Resource\Price->run() #7 /var/www/vhosts/wwm-server.com/httpdocs/KD/shop/engine/Shopware/Plugins/Community/Backend/SwagMigration/Controllers/Backend/SwagMigration.php(502): Shopware_Controllers_Backend_SwagMigration->runImport(‚import_prices‘) #8 /var/www/vhosts/wwm-server.com/httpdocs/KD/shop/engine/Library/Enlight/Controller/Action.php(159): Shopware_Controllers_Backend_SwagMigration->importAction() #9 /var/www/vhosts/wwm-server.com/httpdocs/KD/shop/engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight_Controller_Action->dispatch(‚importAction‘) #10 /var/www/vhosts/wwm-server.com/httpdocs/KD/shop/engine/Library/Enlight/Controller/Front.php(223): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #11 /var/www/vhosts/wwm-server.com/httpdocs/KD/shop/engine/Shopware/Kernel.php(177): Enlight_Controller_Front->dispatch() #12 /var/www/vhosts/wwm-server.com/httpdocs/KD/shop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(487): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #13 /var/www/vhosts/wwm-server.com/httpdocs/KD/shop/engine/Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #14 /var/www/vhosts/wwm-server.com/httpdocs/KD/shop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(258): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #15 /var/www/vhosts/wwm-server.com/httpdocs/KD/shop/engine/Shopware/Components/HttpCache/AppCache.php(103): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true) #16 /var/www/vhosts/wwm-server.com/httpdocs/KD/shop/shopware.php(113): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #17 {main}

OK

kann mir jemand helfen? 

Hallo,

 

von welcher PrestaShop Version wollen Sie denn migrieren?

Ich konnte mei mir auf dem System die Fehlermeldung leider nicht nachstellen.

 

Sie könnten allerdings versuchen in der Datei Components/Migration/Profile/Prestashop15 (für Versionen > 1.4.X) bzw. in der Datei Components/Migration/Profile/Prestashop14 (für Versionen < 1.5) die Funktionen mit dem Namen “getProductPriceSelect” zu suchen und diese Änderung vorzunehmen:

 ORDER BY id\_product, `from`

zu 

 ORDER BY pr.id\_product, `from`

das sollte Ihre Fehlermedung beseitigen.

 

Mit freundlichen Grüßen,

 

Alexander Voss