Liebes Forum
ich kann Einkaufswelten nicht mehr speichern und nicht mehr kopieren. Es kommt die Fehlermeldung:
ERROR
Message:
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 MariaDB server version for the right syntax to use near ‚rows, cols, cell_spacing, cell_height, article_height, mode) VALUES (1, 1, NULL,‘ at line 1‘ in /var/www/vhosts/ambiarte.de/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php:165
Stack trace:
#0 /var/www/vhosts/ambiarte.de/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(165): PDOStatement->execute(NULL)
#1 /var/www/vhosts/ambiarte.de/httpdocs/engine/Library/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(281): Doctrine\DBAL\Statement->execute()
#2 /var/www/vhosts/ambiarte.de/httpdocs/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(1018): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts()
#3 /var/www/vhosts/ambiarte.de/httpdocs/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(378): Doctrine\ORM\UnitOfWork->executeInserts(Object(Doctrine\ORM\Mapping\ClassMetadata))
#4 /var/www/vhosts/ambiarte.de/httpdocs/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(356): Doctrine\ORM\UnitOfWork->commit(NULL)
#5 /var/www/vhosts/ambiarte.de/httpdocs/engine/Shopware/Controllers/Backend/Emotion.php(428): Doctrine\ORM\EntityManager->flush()
#6 /var/www/vhosts/ambiarte.de/httpdocs/engine/Library/Enlight/Controller/Action.php(159): Shopware_Controllers_Backend_Emotion->duplicateAction()
#7 /var/www/vhosts/ambiarte.de/httpdocs/engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight_Controller_Action->dispatch(‚duplicateAction‘)
#8 /var/www/vhosts/ambiarte.de/httpdocs/engine/Library/Enlight/Controller/Front.php(223): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp))
#9 /var/www/vhosts/ambiarte.de/httpdocs/engine/Shopware/Kernel.php(182): Enlight_Controller_Front->dispatch()
#10 /var/www/vhosts/ambiarte.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(491): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#11 /var/www/vhosts/ambiarte.de/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(266): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL)
#12 /var/www/vhosts/ambiarte.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(258): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true)
#13 /var/www/vhosts/ambiarte.de/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(103): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true)
#14 /var/www/vhosts/ambiarte.de/httpdocs/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 ‚INSERT INTO s_emotion (show_listing, template_id, parent_id, active, name, userID, position, device, fullscreen, valid_from, is_landingpage, seo_title, seo_keywords, seo_description, valid_to, create_date, modified, rows, cols, cell_spacing, cell_height, article_height, mode) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)‘ with params [1, 1, null, 1, „20 Sch\u00f6nes aus Frankreich - Copy“, 51, 20, „0,1,2,3,4“, 0, null, 0, „“, „“, „“, null, „2019-07-03 16:40:04“, „2019-07-03 16:40:04“, 126, 3, 8, 61, 4, „fluid“]:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‚rows, cols, cell_spacing, cell_height, article_height, mode) VALUES (1, 1, NULL,‘ at line 1’ in /var/www/vhosts/ambiarte.de/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:119
Stack trace:
#0 /var/www/vhosts/ambiarte.de/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(175): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), ‚INSERT INTO s_e…‘, Array)
#1 /var/www/vhosts/ambiarte.de/httpdocs/engine/Library/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(281): Doctrine\DBAL\Statement->execute()
#2 /var/www/vhosts/ambiarte.de/httpdocs/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(1018): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts()
#3 /var/www/vhosts/ambiarte.de/httpdocs/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(378): Doctrine\ORM\UnitOfWork->executeInserts(Object(Doctrine\ORM\Mapping\ClassMetadata))
#4 /var/www/vhosts/ambiarte.de/httpdocs/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(356): Doctrine\ORM\UnitOfWork->commit(NULL)
#5 /var/www/vhosts/ambiarte.de/httpdocs/engine/Shopware/Controllers/Backend/Emotion.php(428): Doctrine\ORM\EntityManager->flush()
#6 /var/www/vhosts/ambiarte.de/httpdocs/engine/Library/Enlight/Controller/Action.php(159): Shopware_Controllers_Backend_Emotion->duplicateAction()
#7 /var/www/vhosts/ambiarte.de/httpdocs/engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight_Controller_Action->dispatch(‚duplicateAction‘)
#8 /var/www/vhosts/ambiarte.de/httpdocs/engine/Library/Enlight/Controller/Front.php(223): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp))
#9 /var/www/vhosts/ambiarte.de/httpdocs/engine/Shopware/Kernel.php(182): Enlight_Controller_Front->dispatch()
#10 /var/www/vhosts/ambiarte.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(491): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#11 /var/www/vhosts/ambiarte.de/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(266): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL)
#12 /var/www/vhosts/ambiarte.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(258): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true)
#13 /var/www/vhosts/ambiarte.de/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(103): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true)
#14 /var/www/vhosts/ambiarte.de/httpdocs/shopware.php(117): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request))
#15 {main}
Time:
2019-07-03T16:40:04.727808+0200
Channel:
core
request:
{
„uri“: „/backend/emotion/duplicate“,
„method“: „POST“,
„query“: {
„module“: „backend“,
„controller“: „emotion“,
„action“: „duplicate“
},
„post“: {
„emotionId“: „224“,
„forDevice“: „0,1,2,3,4“
}
}
shop:
No shop data available
session:
{
„userId“: „51“,
„roleId“: „1“
}
Es scheint an der SQL zu liegen mit dem ungültigen Ausdruck : …VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'…
Was könnte da passiert sein ?
Liebe Grüße
Kerstin