Über einen Shopware-Cronjob und einen individuelles Import-Plugin holt sich ein Shop Daten rein. Seit kurzem funktioniert der Import nicht mehr. Kurioserwiese klappt es mit einem Aufruf über einen Menüpunkt im Backend. Im Backend findet sich bei dem Cronjob im Feld Data folgendes Array ( [error] =\> exception 'PDOException' with message '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 3' in /var/customers/webs/mueller/emform/engine/Enlight/Vendor/Zend/library/Zend/Db/Statement/Pdo.php:228 Stack trace: #0 /var/customers/webs/mueller/emform/engine/Enlight/Vendor/Zend/library/Zend/Db/Statement/Pdo.php(228): PDOStatement-\>execute(Array) #1 /var/customers/webs/mueller/emform/engine/Enlight/Vendor/Zend/library/Zend/Db/Statement.php(320): Zend\_Db\_Statement\_Pdo-\>\_execute(Array) #2 /var/customers/webs/mueller/emform/engine/Enlight/Vendor/Zend/library/Zend/Db/Adapter/Abstract.php(479): Zend\_Db\_Statement-\>execute(Array) #3 /var/customers/webs/mueller/emform/engine/Enlight/Vendor/Zend/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend\_Db\_Adapter\_Abstract-\>query('?????SELECT id ...', Array) #4 /var/customers/webs/mueller/emform/engine/Enlight/Vendor/Zend/library/Zend/Db/Adapter/Abstract.php(753): Zend\_Db\_Adapter\_Pdo\_Abstract-\>query('?????SELECT id ...', Array) #5 /var/customers/webs/mueller/emform/engine/Enlight/Enlight/Components/Adodb.php(124): Zend\_Db\_Adapter\_Abstract-\>fetchRow('?????SELECT id ...', Array) #6 /var/customers/webs/mueller/emform/engine/connectors/api/import/shopware.php(3373): Enlight\_Components\_Adodb-\>GetRow('?????SELECT id ...') #7 /var/customers/webs/mueller/emform/engine/Shopware/Plugins/Community/Backend/Borm/class.BormImport.php(261): sShopwareImport-\>sArticleTranslation(Array) #8 /var/customers/webs/mueller/emform/engine/Shopware/Plugins/Community/Backend/Borm/class.BormImport.php(77): BormImport-\>importArticle(Array) #9 /var/customers/webs/mueller/emform/engine/Shopware/Plugins/Community/Backend/Borm/class.BormImport.php(35): BormImport-\>importArticles() #10 /var/customers/webs/mueller/emform/engine/Shopware/Plugins/Community/Backend/Borm/Bootstrap.php(75): BormImport-\>import() #11 /var/customers/webs/mueller/emform/engine/Enlight/Enlight/Event/EventHandler.php(60): Shopware\_Plugins\_Backend\_Borm\_Bootstrap::onRun(Object(Shopware\_Components\_Cron\_CronJob)) #12 /var/customers/webs/mueller/emform/engine/Enlight/Enlight/Event/EventManager.php(96): Enlight\_Event\_EventHandler-\>execute('Shopware\_Plugin...', Object(Shopware\_Components\_Cron\_CronJob)) #13 /var/customers/webs/mueller/emform/engine/Shopware/Components/Cron/CronManager.php(51): Enlight\_Event\_EventManager-\>notifyUntil(Object(Shopware\_Components\_Cron\_CronJob)) #14 /var/customers/webs/mueller/emform/engine/Shopware/Plugins/Default/Core/Cron/Cron.php(16): Shopware\_Components\_Cron\_CronManager-\>runCronJob('Shopware\_CronJo...', Object(Shopware\_Components\_Cron\_CronJob)) #15 /var/customers/webs/mueller/emform/engine/Enlight/Enlight/Controller/Action.php(55): Shopware\_Controllers\_Backend\_Cron-\>indexAction(Object(Shopware\_Components\_Cron\_CronJob)) #16 /var/customers/webs/mueller/emform/engine/Enlight/Enlight/Controller/Dispatcher/DispatcherDefault.php(329): Enlight\_Controller\_Action-\>dispatch() #17 /var/customers/webs/mueller/emform/engine/Enlight/Enlight/Controller/Front.php(88): Enlight\_Controller\_Dispatcher\_DispatcherDefault-\>dispatch('indexAction') #18 /var/customers/webs/mueller/emform/engine/Shopware/Bootstrap.php(21): Enlight\_Controller\_Front-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #19 /var/customers/webs/mueller/emform/engine/Enlight/Enlight/Application.php(69): Shopware\_Bootstrap-\>run() #20 /var/customers/webs/mueller/emform/cron.php(7): Enlight\_Application-\>run() #21 {main} Next exception 'Zend\_Db\_Statement\_Exception' with message '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 3' in /var/customers/webs/mueller/emform/engine/Enlight/Vendor/Zend/library/Zend/Db/Statement/Pdo.php:234 Stack trace: #0 /var/customers/webs/mueller/emform/engine/Enlight/Vendor/Zend/library/Zend/Db/Statement.php(320): Zend\_Db\_Statement\_Pdo-\>\_execute(Array) #1 /var/customers/webs/mueller/emform/engine/Enlight/Vendor/Zend/library/Zend/Db/Adapter/Abstract.php(479): Zend\_Db\_Statement-\>execute(Array) #2 /var/customers/webs/mueller/emform/engine/Enlight/Vendor/Zend/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend\_Db\_Adapter\_Abstract-\>query('?????SELECT id ...', Array) #3 /var/customers/webs/mueller/emform/engine/Enlight/Vendor/Zend/library/Zend/Db/Adapter/Abstract.php(753): Zend\_Db\_Adapter\_Pdo\_Abstract-\>query('?????SELECT id ...', Array) #4 /var/customers/webs/mueller/emform/engine/Enlight/Enlight/Components/Adodb.php(124): Zend\_Db\_Adapter\_Abstract-\>fetchRow('?????SELECT id ...', Array) #5 /var/customers/webs/mueller/emform/engine/connectors/api/import/shopware.php(3373): Enlight\_Components\_Adodb-\>GetRow('?????SELECT id ...') #6 /var/customers/webs/mueller/emform/engine/Shopware/Plugins/Community/Backend/Borm/class.BormImport.php(261): sShopwareImport-\>sArticleTranslation(Array) #7 /var/customers/webs/mueller/emform/engine/Shopware/Plugins/Community/Backend/Borm/class.BormImport.php(77): BormImport-\>importArticle(Array) #8 /var/customers/webs/mueller/emform/engine/Shopware/Plugins/Community/Backend/Borm/class.BormImport.php(35): BormImport-\>importArticles() #9 /var/customers/webs/mueller/emform/engine/Shopware/Plugins/Community/Backend/Borm/Bootstrap.php(75): BormImport-\>import() #10 /var/customers/webs/mueller/emform/engine/Enlight/Enlight/Event/EventHandler.php(60): Shopware\_Plugins\_Backend\_Borm\_Bootstrap::onRun(Object(Shopware\_Components\_Cron\_CronJob)) #11 /var/customers/webs/mueller/emform/engine/Enlight/Enlight/Event/EventManager.php(96): Enlight\_Event\_EventHandler-\>execute('Shopware\_Plugin...', Object(Shopware\_Components\_Cron\_CronJob)) #12 /var/customers/webs/mueller/emform/engine/Shopware/Components/Cron/CronManager.php(51): Enlight\_Event\_EventManager-\>notifyUntil(Object(Shopware\_Components\_Cron\_CronJob)) #13 /var/customers/webs/mueller/emform/engine/Shopware/Plugins/Default/Core/Cron/Cron.php(16): Shopware\_Components\_Cron\_CronManager-\>runCronJob('Shopware\_CronJo...', Object(Shopware\_Components\_Cron\_CronJob)) #14 /var/customers/webs/mueller/emform/engine/Enlight/Enlight/Controller/Action.php(55): Shopware\_Controllers\_Backend\_Cron-\>indexAction(Object(Shopware\_Components\_Cron\_CronJob)) #15 /var/customers/webs/mueller/emform/engine/Enlight/Enlight/Controller/Dispatcher/DispatcherDefault.php(329): Enlight\_Controller\_Action-\>dispatch() #16 /var/customers/webs/mueller/emform/engine/Enlight/Enlight/Controller/Front.php(88): Enlight\_Controller\_Dispatcher\_DispatcherDefault-\>dispatch('indexAction') #17 /var/customers/webs/mueller/emform/engine/Shopware/Bootstrap.php(21): Enlight\_Controller\_Front-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #18 /var/customers/webs/mueller/emform/engine/Enlight/Enlight/Application.php(69): Shopware\_Bootstrap-\>run() #19 /var/customers/webs/mueller/emform/cron.php(7): Enlight\_Application-\>run() #20 {main} ) Ich vermute aktuell, dass eine Übersetzung ein ungültiges Zeichen, da für mich der geloggte Aufruf „sShopwareImport->sArticleTranslation(Array)“ die detailierteste Info ist. Das würde auch das plötzliche Auftreten erklären. In den Importdaten kann ich aber nicht erkennen, warum der Import an der Stelle scheitert. Kann man irgendwie detailiertere Infos bekommen? In diesem Falle z.B. an das fragliche SQL-Statement?
Hi, Ich bekomme genau den gleichen Fehler wenn ich versuche über das Migration Tool die Daten von einen Magento Shop zu Importieren. Falls ich eine Lösung finden sollte werde ich es auf jeden fall hier posten. Gruß
Hat sich alles erledigt. Hab´s über die Import/Export Funktion gemacht. Import/Export Funktioniert Perfekt :thumbup: