Hallo!
Es gibt in meinem Shop einen Fehler, den ich nicht reproduzieren kann, aber hin und wieder auftaucht… “Ups, ein Fehler ist aufgetreten.”
Die Mail, die ich dazu bekomme hilft mir nicht wirklich weiter.
Vl kann mir jemand einen Tipp geben in welche Richtung ich für die Lösung des Fehlers schauen muss.
Danke, und schöne Grüße Martina
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 'WHERE alias.emotionid = '13'' at line 1' in /www/htdocs/w010b2af/vegankost.at/shopware/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:987
Stack trace:
#0 /www/htdocs/w010b2af/vegankost.at/shopware/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(987): PDOStatement->execute()
#1 /www/htdocs/w010b2af/vegankost.at/shopware/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(208): Doctrine\DBAL\Connection->executeUpdate('UPDATE s_emotio...', Array, Array)
#2 /www/htdocs/w010b2af/vegankost.at/shopware/engine/Shopware/Bundle/AttributeBundle/Service/DataPersister.php(198): Doctrine\DBAL\Query\QueryBuilder->execute()
#3 /www/htdocs/w010b2af/vegankost.at/shopware/engine/Shopware/Bundle/AttributeBundle/Service/DataPersister.php(89): Shopware\Bundle\AttributeBundle\Service\DataPersister->update('s_emotion_attri...', Array, 13)
#4 /www/htdocs/w010b2af/vegankost.at/shopware/engine/Shopware/Bundle/AttributeBundle/Service/DataPersister.php(115): Shopware\Bundle\AttributeBundle\Service\DataPersister->persist(Array, 's_emotion_attri...', 13)
#5 /www/htdocs/w010b2af/vegankost.at/shopware/engine/Shopware/Controllers/Backend/Emotion.php(731): Shopware\Bundle\AttributeBundle\Service\DataPersister->cloneAttribute('s_emotion_attri...', 12, 13)
#6 /www/htdocs/w010b2af/vegankost.at/shopware/engine/Library/Enlight/Controller/Action.php(159): Shopware_Controllers_Backend_Emotion->duplicateAction()
#7 /www/htdocs/w010b2af/vegankost.at/shopware/engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight_Controller_Action->dispatch('duplicateAction')
#8 /www/htdocs/w010b2af/vegankost.at/shopware/engine/Library/Enlight/Controller/Front.php(223): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp))
#9 /www/htdocs/w010b2af/vegankost.at/shopware/engine/Shopware/Kernel.php(180): Enlight_Controller_Front->dispatch()
#10 /www/htdocs/w010b2af/vegankost.at/shopware/vendor/symfony/http-kernel/HttpCache/HttpCache.php(487): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#11 /www/htdocs/w010b2af/vegankost.at/shopware/engine/Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL)
#12 /www/htdocs/w010b2af/vegankost.at/shopware/vendor/symfony/http-kernel/HttpCache/HttpCache.php(258): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true)
#13 /www/htdocs/w010b2af/vegankost.at/shopware/engine/Shopware/Components/HttpCache/AppCache.php(103): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true)
#14 /www/htdocs/w010b2af/vegankost.at/shopware/shopware.php(117): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request))
#15 {main}
Next exception 'Doctrine\DBAL\DBALException' with message 'An exception occurred while executing 'UPDATE s_emotion_attributes alias SET WHERE alias.emotionid = ?' with params [13]:
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 'WHERE alias.emotionid = '13'' at line 1' in /www/htdocs/w010b2af/vegankost.at/shopware/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:119
Stack trace:
#0 /www/htdocs/w010b2af/vegankost.at/shopware/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(996): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), 'UPDATE s_emotio...', Array)
#1 /www/htdocs/w010b2af/vegankost.at/shopware/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(208): Doctrine\DBAL\Connection->executeUpdate('UPDATE s_emotio...', Array, Array)
#2 /www/htdocs/w010b2af/vegankost.at/shopware/engine/Shopware/Bundle/AttributeBundle/Service/DataPersister.php(198): Doctrine\DBAL\Query\QueryBuilder->execute()
#3 /www/htdocs/w010b2af/vegankost.at/shopware/engine/Shopware/Bundle/AttributeBundle/Service/DataPersister.php(89): Shopware\Bundle\AttributeBundle\Service\DataPersister->update('s_emotion_attri...', Array, 13)
#4 /www/htdocs/w010b2af/vegankost.at/shopware/engine/Shopware/Bundle/AttributeBundle/Service/DataPersister.php(115): Shopware\Bundle\AttributeBundle\Service\DataPersister->persist(Array, 's_emotion_attri...', 13)
#5 /www/htdocs/w010b2af/vegankost.at/shopware/engine/Shopware/Controllers/Backend/Emotion.php(731): Shopware\Bundle\AttributeBundle\Service\DataPersister->cloneAttribute('s_emotion_attri...', 12, 13)
#6 /www/htdocs/w010b2af/vegankost.at/shopware/engine/Library/Enlight/Controller/Action.php(159): Shopware_Controllers_Backend_Emotion->duplicateAction()
#7 /www/htdocs/w010b2af/vegankost.at/shopware/engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight_Controller_Action->dispatch('duplicateAction')
#8 /www/htdocs/w010b2af/vegankost.at/shopware/engine/Library/Enlight/Controller/Front.php(223): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp))
#9 /www/htdocs/w010b2af/vegankost.at/shopware/engine/Shopware/Kernel.php(180): Enlight_Controller_Front->dispatch()
#10 /www/htdocs/w010b2af/vegankost.at/shopware/vendor/symfony/http-kernel/HttpCache/HttpCache.php(487): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#11 /www/htdocs/w010b2af/vegankost.at/shopware/engine/Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL)
#12 /www/htdocs/w010b2af/vegankost.at/shopware/vendor/symfony/http-kernel/HttpCache/HttpCache.php(258): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true)
#13 /www/htdocs/w010b2af/vegankost.at/shopware/engine/Shopware/Components/HttpCache/AppCache.php(103): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true)
#14 /www/htdocs/w010b2af/vegankost.at/shopware/shopware.php(117): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request))
#15 {main}
2017-04-26T12:43:40.999882+0200
core
{
"uri": "/backend/emotion/duplicate",
"method": "POST",
"query": {
"module": "backend",
"controller": "emotion",
"action": "duplicate"
},
"post": {
"emotionId": "12",
"forDevice": "0,1,2,3,4"
}
}
No shop data available
{
"userId": "50",
"roleId": "1"
}