Hallo zusammen,
ich versuche in einer Shopware 5.5.7 einen Product Stream anzulegen. Beim Auswählen von Produkten erhalte ich einen MySQL Fehler:
General error: 1525 Incorrect DATE value: ‘lok’ in vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 131
Hier die vollständige Fehlermeldung…
Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen. An exception occurred while executing
SELECT DISTINCT s0_.id AS id_0, (IF(s0_.name LIKE ?, 0.5, 0) + IF(s0_.name = ?, 1, 0)
+ IF(s0_.name = ?, 2, 0)
+ IF(s0_.description LIKE ?, 0.5, 0)
+ IF(s0_.description = ?, 1, 0)
+ IF(s0_.description = ?, 2, 0)
+ IF(s0_.description_long LIKE ?, 0.5, 0)
+ IF(s0_.description_long = ?, 1, 0)
+ IF(s0_.description_long = ?, 2, 0)
+ IF(s0_.datum LIKE ?, 0.5, 0)
+ IF(s0_.datum = ?, 1, 0)
+ IF(s0_.datum = ?, 2, 0)
+ IF(s0_.keywords LIKE ?, 0.5, 0)
+ IF(s0_.keywords = ?, 1, 0)
+ IF(s0_.keywords = ?, 2, 0)
+ IF(s0_.metaTitle LIKE ?, 0.5, 0)
+ IF(s0_.metaTitle = ?, 1, 0)
+ IF(s0_.metaTitle = ?, 2, 0)
+ IF(s0_.changetime LIKE ?, 0.5, 0)
+ IF(s0_.changetime = ?, 1, 0)
+ IF(s0_.changetime = ?, 2, 0)
+ IF(s0_.template LIKE ?, 0.5, 0)
+ IF(s0_.template = ?, 1, 0)
+ IF(s0_.template = ?, 2, 0)
+ IF(s0_.available_from LIKE ?, 0.5, 0)
+ IF(s0_.available_from = ?, 1, 0)
+ IF(s0_.available_from = ?, 2, 0)
+ IF(s0_.available_to LIKE ?, 0.5, 0)
+ IF(s0_.available_to = ?, 1, 0)
+ IF(s0_.available_to = ?, 2, 0)
+ IF(s1_.ordernumber LIKE ?, 0.5, 0)
+ IF(s1_.ordernumber = ?, 1, 0)
+ IF(s1_.ordernumber = ?, 2, 0)) AS sclr_1 FROM s_articles s0_
INNER JOIN s_articles_details s1_ ON s0_.main_detail_id = s1_.id
LEFT JOIN s_articles_details s2_ ON s0_.id = s2_.articleID
WHERE s0_.name LIKE ?
OR s0_.description LIKE ?
OR s0_.description_long LIKE ?
OR s0_.datum LIKE ?
OR s0_.keywords LIKE ?
OR s0_.metaTitle LIKE ?
OR s0_.changetime LIKE ?
OR s0_.template LIKE ?
OR s0_.available_from LIKE ?
OR s0_.available_to LIKE ?
OR s1_.ordernumber LIKE ?
ORDER BY sclr_1 DESC LIMIT 20 OFFSET 0
with params ["%lok%", "lok", "lok", "%lok%", "lok", "lok", "%lok%", "lok", "lok", "%lok%", "lok", "lok", "%lok%", "lok", "lok", "%lok%", "lok", "lok", "%lok%", "lok", "lok", "%lok%", "lok", "lok", "%lok%", "lok", "lok", "%lok%", "lok", "lok", "%lok%", "lok", "lok", "%lok%", "%lok%", "%lok%", "%lok%", "%lok%", "%lok%", "%lok%", "%lok%", "%lok%", "%lok%", "%lok%"]: SQLSTATE[HY000]:
General error: 1525 Incorrect DATE value: 'lok' in vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 131
Stack trace: #0 vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(855): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException),
'SELECT DISTINCT...', Array) #1 vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\DBAL\Connection->executeQuery('SELECT DISTINCT...', Array, Array, NULL)
#2 vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(321): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Object(Doctrine\DBAL\Connection), Array, Array)
#3 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(962): Doctrine\ORM\Query->_doExecute()
#4 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(917): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(NULL, 3)
#5 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(744): Doctrine\ORM\AbstractQuery->execute(NULL, 3)
#6 vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(151): Doctrine\ORM\AbstractQuery->getScalarResult()
#7 engine/Shopware/Controllers/Backend/Search.php(70): Doctrine\ORM\Tools\Pagination\Paginator->getIterator()
#8 engine/Library/Enlight/Controller/Action.php(193): Shopware_Controllers_Backend_Search->searchAction()
#9 engine/Library/Enlight/Controller/Dispatcher/Default.php(563): Enlight_Controller_Action->dispatch('searchAction')
#10 engine/Library/Enlight/Controller/Front.php(222): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp))
#11 engine/Shopware/Kernel.php(202): Enlight_Controller_Front->dispatch()
#12 vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(102): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#13 vendor/symfony/http-kernel/HttpCache/HttpCache.php(448): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(Object(Shopware\Kernel), Object(Symfony\Component\HttpFoundation\Request), 1, true)
#14 engine/Shopware/Components/HttpCache/AppCache.php(268): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL)
#15 vendor/symfony/http-kernel/HttpCache/HttpCache.php(238): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true)
#16 engine/Shopware/Components/HttpCache/AppCache.php(105): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true)
#17 shopware.php(122): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request))
#18 {main}
Mir fehlt ein wenig der Ansatz wo dieses fehlerhafte Datumsfeld herkommen soll. Hat jemand eine Idee?