Fehlermeldung

Shopware 5 Allgemein
1

 

Hallo,

beim Versuch eine neue Kundegruppe zu erstellen, speichert er die nicht und es kommt die Fehlermeldung

 PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'basketdiscountstart' cannot be null in /www/htdocs/w015a097/riff-aquaristik-lange.de/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php:168

 Stack trace:

 #0 /www/htdocs/w015a097/riff-aquaristik-lange.de/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(168): PDOStatement-\>execute(NULL)

 #1 /www/htdocs/w015a097/riff-aquaristik-lange.de/engine/Library/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(281): Doctrine\DBAL\Statement-\>execute()

 #2 /www/htdocs/w015a097/riff-aquaristik-lange.de/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(1014): Doctrine\ORM\Persisters\Entity\BasicEntityPersister-\>executeInserts()

 #3 /www/htdocs/w015a097/riff-aquaristik-lange.de/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(378): Doctrine\ORM\UnitOfWork-\>executeInserts(Object(Doctrine\ORM\Mapping\ClassMetadata))

 #4 /www/htdocs/w015a097/riff-aquaristik-lange.de/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(356): Doctrine\ORM\UnitOfWork-\>commit(NULL)

 #5 /www/htdocs/w015a097/riff-aquaristik-lange.de/engine/Shopware/Controllers/Backend/Config.php(631): Doctrine\ORM\EntityManager-\>flush()

 #6 /www/htdocs/w015a097/riff-aquaristik-lange.de/engine/Library/Enlight/Controller/Action.php(193): Shopware\_Controllers\_Backend\_Config-\>saveValuesAction()

 #7 /www/htdocs/w015a097/riff-aquaristik-lange.de/engine/Library/Enlight/Controller/Dispatcher/Default.php(549): Enlight\_Controller\_Action-\>dispatch('saveValuesActio...')

 #8 /www/htdocs/w015a097/riff-aquaristik-lange.de/engine/Library/Enlight/Controller/Front.php(222): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp))

 #9 /www/htdocs/w015a097/riff-aquaristik-lange.de/engine/Shopware/Kernel.php(215): Enlight\_Controller\_Front-\>dispatch()

 #10 /www/htdocs/w015a097/riff-aquaristik-lange.de/vendor/symfony/http-kernel/HttpCache/HttpCache.php(486): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)

 #11 /www/htdocs/w015a097/riff-aquaristik-lange.de/engine/Shopware/Components/HttpCache/AppCache.php(268): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL)

 #12 /www/htdocs/w015a097/riff-aquaristik-lange.de/vendor/symfony/http-kernel/HttpCache/HttpCache.php(253): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true)

 #13 /www/htdocs/w015a097/riff-aquaristik-lange.de/engine/Shopware/Components/HttpCache/AppCache.php(105): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass(Object(Symfony\Component\HttpFoundation\Request), true)

 #14 /www/htdocs/w015a097/riff-aquaristik-lange.de/shopware.php(122): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request))

 #15 {main}

  

 Next Doctrine\DBAL\DBALException: An exception occurred while executing 'INSERT INTO s\_core\_customergroups\_discounts (basketdiscount, basketdiscountstart, groupID) VALUES (?, ?, ?)' with params [5, null, 2]:

  

 SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'basketdiscountstart' cannot be null in /www/htdocs/w015a097/riff-aquaristik-lange.de/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:131

 Stack trace:

 #0 /www/htdocs/w015a097/riff-aquaristik-lange.de/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(177): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), 'INSERT INTO s\_c...', Array)

 #1 /www/htdocs/w015a097/riff-aquaristik-lange.de/engine/Library/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(281): Doctrine\DBAL\Statement-\>execute()

 #2 /www/htdocs/w015a097/riff-aquaristik-lange.de/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(1014): Doctrine\ORM\Persisters\Entity\BasicEntityPersister-\>executeInserts()

 #3 /www/htdocs/w015a097/riff-aquaristik-lange.de/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(378): Doctrine\ORM\UnitOfWork-\>executeInserts(Object(Doctrine\ORM\Mapping\ClassMetadata))

 #4 /www/htdocs/w015a097/riff-aquaristik-lange.de/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(356): Doctrine\ORM\UnitOfWork-\>commit(NULL)

 #5 /www/htdocs/w015a097/riff-aquaristik-lange.de/engine/Shopware/Controllers/Backend/Config.php(631): Doctrine\ORM\EntityManager-\>flush()

 #6 /www/htdocs/w015a097/riff-aquaristik-lange.de/engine/Library/Enlight/Controller/Action.php(193): Shopware\_Controllers\_Backend\_Config-\>saveValuesAction()

 #7 /www/htdocs/w015a097/riff-aquaristik-lange.de/engine/Library/Enlight/Controller/Dispatcher/Default.php(549): Enlight\_Controller\_Action-\>dispatch('saveValuesActio...')

 #8 /www/htdocs/w015a097/riff-aquaristik-lange.de/engine/Library/Enlight/Controller/Front.php(222): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp))

 #9 /www/htdocs/w015a097/riff-aquaristik-lange.de/engine/Shopware/Kernel.php(215): Enlight\_Controller\_Front-\>dispatch()

 #10 /www/htdocs/w015a097/riff-aquaristik-lange.de/vendor/symfony/http-kernel/HttpCache/HttpCache.php(486): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)

 #11 /www/htdocs/w015a097/riff-aquaristik-lange.de/engine/Shopware/Components/HttpCache/AppCache.php(268): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL)

 #12 /www/htdocs/w015a097/riff-aquaristik-lange.de/vendor/symfony/http-kernel/HttpCache/HttpCache.php(253): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true)

 #13 /www/htdocs/w015a097/riff-aquaristik-lange.de/engine/Shopware/Components/HttpCache/AppCache.php(105): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass(Object(Symfony\Component\HttpFoundation\Request), true)

 #14 /www/htdocs/w015a097/riff-aquaristik-lange.de/shopware.php(122): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request))

 #15 {main}

 2018-05-05T16:07:08.735649+0200

 core

 {

     "uri": "/backend/Config/saveValues?\_repositoryClass=customerGroup&\_dc=1525529042609",

     "method": "POST",

     "query": {

         "\_repositoryClass": "customerGroup",

         "\_dc": "1525529042609",

         "module": "backend",

         "controller": "Config",

         "action": "saveValues"

     },

     "post": {

         "id": 2,

         "key": "H",

         "name": "Händler",

         "tax": true,

         "taxInput": false,

         "mode": false,

         "discount": 0,

         "minimumOrder": 0,

         "minimumOrderSurcharge": 0,

         "deletable": true,

         "discounts": [

             {

                 "discount": 5,

                 "value": null,

                 "id": null

             }

         ]

     }

 }

 No shop data available

 {

     "userId": "50",

     "roleId": "1"

 }

 

 

2

Hoffe das mir hier jemand helfen kann um das Problem zu lösen 

3

Hallo Dietmar,

bist du mit dem Problem weitergekommen?

Wir haben gerade das gleiche Problem. Was funktioniert ist das Anlegen der Gruppe, aber beim Hinzufügen eines Warenkorb Rabatt kommt die gleiche Fehlermeldung.