# Einkaufswelten nicht mehr speicher-/kopierbar **URL:** \ **Category:** Allgemein\ **Created:** [4. Juli 2019 um 08:07 UTC](https://forum.shopware.com/t/einkaufswelten-nicht-mehr-speicher-kopierbar/60282 "2019-07-04T08:07:13Z")\ **Posts on this page:** 1\ **Page:** 1
**Author:** ![Kerstin83](https://avatars.discourse-cdn.com/v4/letter/k/49beb7/32.png) [@Kerstin83](https://forum.shopware.com/u/Kerstin83)\ **Post date:** [4. Juli 2019 um 08:07 UTC](https://forum.shopware.com/t/einkaufswelten-nicht-mehr-speicher-kopierbar/60282/1 "2019-07-04T08:07:13Z")
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