Hallo, ein Kundenshop wird mit folgenden Email/Fehlermeldungen zugeballert. 2013-05-21T05:33:08+02:00 ERR (3): 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 /srv/www/htdocs/cartoshop_dk/engine/Library/Zend/Db/Statement/Pdo.php:228 Stack trace: #0 /srv/www/htdocs/cartoshop_dk/engine/Library/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array) #1 /srv/www/htdocs/cartoshop_dk/engine/Library/Zend/Db/Statement.php(320): Zend_Db_Statement_Pdo->_execute(Array) #2 /srv/www/htdocs/cartoshop_dk/engine/Library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) #3 /srv/www/htdocs/cartoshop_dk/engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(’???SELECT id, …’, Array) #4 /srv/www/htdocs/cartoshop_dk/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(75): Zend_Db_Adapter_Pdo_Abstract->query(’???SELECT id, …’, Array) #5 /srv/www/htdocs/cartoshop_dk/engine/Shopware/Controllers/Frontend/SitemapXml.php(196): Enlight_Components_Db_Adapter_Pdo_Mysql->query(’???SELECT id, …’) #6 /srv/www/htdocs/cartoshop_dk/engine/Shopware/Controllers/Frontend/SitemapXml.php(80): Shopware_Controllers_Frontend_SitemapXml->readBlogUrls(5) #7 /srv/www/htdocs/cartoshop_dk/engine/Library/Enlight/Controller/Action.php(135): Shopware_Controllers_Frontend_SitemapXml->indexAction() #8 /srv/www/htdocs/cartoshop_dk/engine/Library/Enlight/Controller/Dispatcher/Default.php(521): Enlight_Controller_Action->dispatch(‚indexAction‘) #9 /srv/www/htdocs/cartoshop_dk/engine/Library/Enlight/Controller/Front.php(214): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #10 /srv/www/htdocs/cartoshop_dk/engine/Shopware/Bootstrap.php(79): Enlight_Controller_Front->dispatch() #11 /srv/www/htdocs/cartoshop_dk/engine/Library/Enlight/Application.php(192): Shopware_Bootstrap->run() #12 /srv/www/htdocs/cartoshop_dk/shopware.php(74): Enlight_Application->run() #13 {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 /srv/www/htdocs/cartoshop_dk/engine/Library/Zend/Db/Statement/Pdo.php:234 Stack trace: #0 /srv/www/htdocs/cartoshop_dk/engine/Library/Zend/Db/Statement.php(320): Zend_Db_Statement_Pdo->_execute(Array) #1 /srv/www/htdocs/cartoshop_dk/engine/Library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) #2 /srv/www/htdocs/cartoshop_dk/engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(’???SELECT id, …’, Array) #3 /srv/www/htdocs/cartoshop_dk/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(75): Zend_Db_Adapter_Pdo_Abstract->query(’???SELECT id, …’, Array) #4 /srv/www/htdocs/cartoshop_dk/engine/Shopware/Controllers/Frontend/SitemapXml.php(196): Enlight_Components_Db_Adapter_Pdo_Mysql->query(’???SELECT id, …’) #5 /srv/www/htdocs/cartoshop_dk/engine/Shopware/Controllers/Frontend/SitemapXml.php(80): Shopware_Controllers_Frontend_SitemapXml->readBlogUrls(5) #6 /srv/www/htdocs/cartoshop_dk/engine/Library/Enlight/Controller/Action.php(135): Shopware_Controllers_Frontend_SitemapXml->indexAction() #7 /srv/www/htdocs/cartoshop_dk/engine/Library/Enlight/Controller/Dispatcher/Default.php(521): Enlight_Controller_Action->dispatch(‚indexAction‘) #8 /srv/www/htdocs/cartoshop_dk/engine/Library/Enlight/Controller/Front.php(214): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #9 /srv/www/htdocs/cartoshop_dk/engine/Shopware/Bootstrap.php(79): Enlight_Controller_Front->dispatch() #10 /srv/www/htdocs/cartoshop_dk/engine/Library/Enlight/Application.php(192): Shopware_Bootstrap->run() #11 /srv/www/htdocs/cartoshop_dk/shopware.php(74): Enlight_Application->run() #12 {main} Nun geht der Fehler zück auf den Controller SitemapXml.php -> readBlogUrls Hier wird die Blog URL in die sitemap.xml erzeugt. Aber wie sieht es aus, wenn es keinen Blog gibt. Meiner Meinung wird hier nicht überprüft ob die Variabel einen Inhalt hat. Ohne Inhalt verursacht die SQL Abfrage aber einen Fehler. SQL IN () ohne Wert geht nicht! SELECT id, category\_id, DATE(display\_date) as changed FROM s\_blog WHERE active = 1 AND category\_id IN($blogIds) #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 ‚) LIMIT 0, 30‘ at line 3 Könnt ihr das mal Checken?
mist, ist wohl schon bekannt in Github. Hab ich nicht gesehen. https://github.com/ShopwareAG/shopware-4/pull/75