Hallo,
ich habe vor kurzem ein Update auf Shopware 5.4.5 gemacht. Bis auf ein paar Template-Fehler, die ich beheben konnte, hat danach alles wieder funktioniert. Jetzt ist allerdings doch noch ein Problem aufgetreten, für das ich keine Lösung finde. Um es gleich vorweg zu nehmen: Ja, ich habe im Forum gesucht. Und ja, ich habe etwas dazu gefunden. Allerdings ohne Lösung. Ich weiß nur, dass andere wohl auch das Problem hatten bzw. haben.
Und zwar habe ich einen neuen Artikel erstellt und eine Variantengruppe dazu. Nach dem Klick auf „Varianten generieren“ und „Vorgang starten“ erhalte ich die Fehlermeldung „500 Internal Server Error“. Die Fehlermeldung steht unten. Ich verstehe das so, dass versucht wird, NULL in ein Datenfald zu schreiben, das nicht NULL enthalten darf. An dieser Stelle bin ich allerdings mit meinem Latein am Ende. Was kann ich tun, um diesen Fehler zu beseitigen?
Wir haben früher schon viele Variantenartikel angelegt, was immer funktioniert hat. Das war vor dem Update von 5.2 auf 5.4.5. Ich habe daher den Verdacht, dass es damit zusammenhängt.
Weiß jemand Rat?
exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'name' cannot be null' in /home/httpd/docs/duesenshop2016/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php:168 Stack trace: #0 /home/httpd/docs/duesenshop2016/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(168): PDOStatement-\>execute(NULL) #1 /home/httpd/docs/duesenshop2016/engine/Library/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(281): Doctrine\DBAL\Statement-\>execute() #2 /home/httpd/docs/duesenshop2016/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(1014): Doctrine\ORM\Persisters\Entity\BasicEntityPersister-\>executeInserts() #3 /home/httpd/docs/duesenshop2016/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(378): Doctrine\ORM\UnitOfWork-\>executeInserts(Object(Doctrine\ORM\Mapping\ClassMetadata)) #4 /home/httpd/docs/duesenshop2016/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(356): Doctrine\ORM\UnitOfWork-\>commit(NULL) #5 /home/httpd/docs/duesenshop2016/engine/Shopware/Controllers/Backend/Article.php(224): Doctrine\ORM\EntityManager-\>flush() #6 /home/httpd/docs/duesenshop2016/engine/Library/Enlight/Controller/Action.php(193): Shopware\_Controllers\_Backend\_Article-\>saveConfiguratorSetAction() #7 /home/httpd/docs/duesenshop2016/engine/Library/Enlight/Controller/Dispatcher/Default.php(549): Enlight\_Controller\_Action-\>dispatch('saveConfigurato...') #8 /home/httpd/docs/duesenshop2016/engine/Library/Enlight/Controller/Front.php(222): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #9 /home/httpd/docs/duesenshop2016/engine/Shopware/Kernel.php(215): Enlight\_Controller\_Front-\>dispatch() #10 /home/httpd/docs/duesenshop2016/vendor/symfony/http-kernel/HttpCache/HttpCache.php(486): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #11 /home/httpd/docs/duesenshop2016/engine/Shopware/Components/HttpCache/AppCache.php(268): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #12 /home/httpd/docs/duesenshop2016/vendor/symfony/http-kernel/HttpCache/HttpCache.php(253): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #13 /home/httpd/docs/duesenshop2016/engine/Shopware/Components/HttpCache/AppCache.php(105): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass(Object(Symfony\Component\HttpFoundation\Request), true) #14 /home/httpd/docs/duesenshop2016/shopware.php(122): 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\_article\_configurator\_sets (name, public, type) VALUES (?, ?, ?)' with params [null, 0, 0]: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'name' cannot be null' in /home/httpd/docs/duesenshop2016/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:131 Stack trace: #0 /home/httpd/docs/duesenshop2016/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(178): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), 'INSERT INTO s\_a...', Array) #1 /home/httpd/docs/duesenshop2016/engine/Library/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(281): Doctrine\DBAL\Statement-\>execute() #2 /home/httpd/docs/duesenshop2016/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(1014): Doctrine\ORM\Persisters\Entity\BasicEntityPersister-\>executeInserts() #3 /home/httpd/docs/duesenshop2016/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(378): Doctrine\ORM\UnitOfWork-\>executeInserts(Object(Doctrine\ORM\Mapping\ClassMetadata)) #4 /home/httpd/docs/duesenshop2016/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(356): Doctrine\ORM\UnitOfWork-\>commit(NULL) #5 /home/httpd/docs/duesenshop2016/engine/Shopware/Controllers/Backend/Article.php(224): Doctrine\ORM\EntityManager-\>flush() #6 /home/httpd/docs/duesenshop2016/engine/Library/Enlight/Controller/Action.php(193): Shopware\_Controllers\_Backend\_Article-\>saveConfiguratorSetAction() #7 /home/httpd/docs/duesenshop2016/engine/Library/Enlight/Controller/Dispatcher/Default.php(549): Enlight\_Controller\_Action-\>dispatch('saveConfigurato...') #8 /home/httpd/docs/duesenshop2016/engine/Library/Enlight/Controller/Front.php(222): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #9 /home/httpd/docs/duesenshop2016/engine/Shopware/Kernel.php(215): Enlight\_Controller\_Front-\>dispatch() #10 /home/httpd/docs/duesenshop2016/vendor/symfony/http-kernel/HttpCache/HttpCache.php(486): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #11 /home/httpd/docs/duesenshop2016/engine/Shopware/Components/HttpCache/AppCache.php(268): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #12 /home/httpd/docs/duesenshop2016/vendor/symfony/http-kernel/HttpCache/HttpCache.php(253): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #13 /home/httpd/docs/duesenshop2016/engine/Shopware/Components/HttpCache/AppCache.php(105): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass(Object(Symfony\Component\HttpFoundation\Request), true) #14 /home/httpd/docs/duesenshop2016/shopware.php(122): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #15 {main}