Hallo,
wir möchten gern von Gambio zu Shopware wechseln. Die Migration gibt aber einen Fehler bei dem Import der Artikel aus.
Nun Kommt die folgende Fehlermeldung… Könntet Ihr vieleicht hier weiterhelfen?
Beim Importieren der Preise ist ein Fehler aufgetreten
Code : 42000
Line : 234
File : /var/www/web1525/htdocs/shop/developer/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 ‘)’ at line 1
Trace : #0 /var/www/web1225/htdocs/shop/developer/engine/Library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array) #1 /var/www/web1525/htdocs/shop/developer/engine/Library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #2 /var/www/web1225/htdocs/shop/developer/engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(’()’, Array) #3 /var/www/web1525/htdocs/shop/developer/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(96): Zend_Db_Adapter_Pdo_Abstract->query(’()’, Array) #4 /var/www/web1525/htdocs/shop/developer/engine/Shopware/Plugins/Community/Backend/SwagMigration/Components/Migration/Profile.php(585): Enlight_Components_Db_Adapter_Pdo_Mysql->query(’()’) #5 /var/www/web1525/htdocs/shop/developer/engine/Shopware/Plugins/Community/Backend/SwagMigration/Components/Migration/Import/Resource/Price.php(70): Shopware\SwagMigration\Components\Migration\Profile->queryProductPrices(0) #6 /var/www/web1525/htdocs/shop/developer/engine/Shopware/Plugins/Community/Backend/SwagMigration/Controllers/Backend/SwagMigration.php(465): Shopware\SwagMigration\Components\Migration\Import\Resource\Price->run() #7 /var/www/web1525/htdocs/shop/developer/engine/Shopware/Plugins/Community/Backend/SwagMigration/Controllers/Backend/SwagMigration.php(502): Shopware_Controllers_Backend_SwagMigration->runImport(‘import_prices’) #8 /var/www/web1525/htdocs/shop/developer/engine/Library/Enlight/Controller/Action.php(159): Shopware_Controllers_Backend_SwagMigration->importAction() #9 /var/www/web1525/htdocs/shop/developer/engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight_Controller_Action->dispatch(‘importAction’) #10 /var/www/web1525/htdocs/shop/developer/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/web1525/htdocs/shop/developer/engine/Shopware/Kernel.php(179): Enlight_Controller_Front->dispatch() #12 /var/www/web1525/htdocs/shop/developer/vendor/symfony/http-kernel/HttpCache/HttpCache.php(487): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #13