# SQL Fehler SQLSTATE\[23000\]
**URL:** https://forum.shopware.com/t/sql-fehler-sqlstate-23000/48086
**Category:** Sonstiges
**Created:** [6. September 2017 um 10:11 UTC](https://forum.shopware.com/t/sql-fehler-sqlstate-23000/48086 "2017-09-06T10:11:40Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@Fabian1994](https://forum.shopware.com/u/Fabian1994)
#### Post date: [6. September 2017 um 10:11 UTC](https://forum.shopware.com/t/sql-fehler-sqlstate-23000/48086/1 "2017-09-06T10:11:40Z")
Hallo,
ich habe ein Problem in meinem Shop.
Wenn ich im Backend einen Artikel bearbeite und diesen Speichern möchte, kommt folgende Fehlermeldung:
```
[2017-09-06 09:40:56] core.ERROR: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'name' cannot be null in /usr/local/www/apache24/noexec/Werkzeugblitz.de/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php:165 Stack trace: #0 /usr/local/www/apache24/noexec/Werkzeugblitz.de/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(165): PDOStatement->execute(NULL) #1 /usr/local/www/apache24/noexec/Werkzeugblitz.de/engine/Library/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(281): Doctrine\DBAL\Statement->execute() #2 /usr/local/www/apache24/noexec/Werkzeugblitz.de/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(1018): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts() #3 /usr/local/www/apache24/noexec/Werkzeugblitz.de/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(378): Doctrine\ORM\UnitOfWork->executeInserts(Object(Doctrine\ORM\Mapping\ClassMetadata)) #4 /usr/local/www/apache24/noexec/Werkzeugblitz.de/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(356): Doctrine\ORM\UnitOfWork->commit(NULL) #5 /usr/local/www/apache24/noexec/Werkzeugblitz.de/engine/Shopware/Controllers/Backend/Article.php(2888): Doctrine\ORM\EntityManager->flush() #6 /usr/local/www/apache24/noexec/Werkzeugblitz.de/engine/Shopware/Controllers/Backend/Article.php(164): Shopware_Controllers_Backend_Article->saveArticle(Array, Object(Shopware\Models\Article\Article)) #7 /usr/local/www/apache24/noexec/Werkzeugblitz.de/engine/Library/Enlight/Controller/Action.php(159): Shopware_Controllers_Backend_Article->saveAction() #8 /usr/local/www/apache24/noexec/Werkzeugblitz.de/engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight_Controller_Action->dispatch('saveAction') #9 /usr/local/www/apache24/noexec/Werkzeugblitz.de/engine/Library/Enlight/Controller/Front.php(223): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #10 /usr/local/www/apache24/noexec/Werkzeugblitz.de/engine/Shopware/Kernel.php(182): Enlight_Controller_Front->dispatch() #11 /usr/local/www/apache24/noexec/Werkzeugblitz.de/vendor/symfony/http-kernel/HttpCache/HttpCache.php(491): Shopware\Kernel->handle(Object(Enlight_Controller_Request_RequestHttp), 1, true) #12 /usr/local/www/apache24/noexec/Werkzeugblitz.de/engine/Shopware/Components/HttpCache/AppCache.php(266): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #13 /usr/local/www/apache24/noexec/Werkzeugblitz.de/vendor/symfony/http-kernel/HttpCache/HttpCache.php(258): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #14 /usr/local/www/apache24/noexec/Werkzeugblitz.de/engine/Shopware/Components/HttpCache/AppCache.php(103): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true) #15 /usr/local/www/apache24/noexec/Werkzeugblitz.de/shopware.php(117): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #16 {main} Next Doctrine\DBAL\DBALException: An exception occurred while executing 'INSERT INTO s_articles (main_detail_id, supplierID, taxID, pricegroupID, filtergroupID, configurator_set_id, name, description, description_long, datum, active, pseudosales, topseller, keywords, metaTitle, changetime, pricegroupActive, laststock, crossbundlelook, notification, template, mode, available_from, available_to) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [null, null, null, null, null, null, null, null, null, "2017-09-06", 0, 0, 0, null, null, "2017-09-06 09:40:56", 0, 0, false, 0, "", 0, null, null]: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'name' cannot be null in /usr/local/www/apache24/noexec/Werkzeugblitz.de/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:119 Stack trace:
#0 /usr/local/www/apache24/noexec/Werkzeugblitz.de/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(174): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), 'INSERT INTO s_a...', Array)
#1 /usr/local/www/apache24/noexec/Werkzeugblitz.de/engine/Library/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(281): Doctrine\DBAL\Statement->execute()
#2 /usr/local/www/apache24/noexec/Werkzeugblitz.de/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(1018): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts()
#3 /usr/local/www/apache24/noexec/Werkzeugblitz.de/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(378): Doctrine\ORM\UnitOfWork->executeInserts(Object(Doctrine\ORM\Mapping\ClassMetadata))
#4 /usr/local/www/apache24/noexec/Werkzeugblitz.de/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(356): Doctrine\ORM\UnitOfWork->commit(NULL)
#5 /usr/local/www/apache24/noexec/Werkzeugblitz.de/engine/Shopware/Controllers/Backend/Article.php(2888): Doctrine\ORM\EntityManager->flush()
#6 /usr/local/www/apache24/noexec/Werkzeugblitz.de/engine/Shopware/Controllers/Backend/Article.php(164): Shopware_Controllers_Backend_Article->saveArticle(Array, Object(Shopware\Models\Article\Article))
#7 /usr/local/www/apache24/noexec/Werkzeugblitz.de/engine/Library/Enlight/Controller/Action.php(159): Shopware_Controllers_Backend_Article->saveAction()
#8 /usr/local/www/apache24/noexec/Werkzeugblitz.de/engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight_Controller_Action->dispatch('saveAction')
#9 /usr/local/www/apache24/noexec/Werkzeugblitz.de/engine/Library/Enlight/Controller/Front.php(223): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp))
#10 /usr/local/www/apache24/noexec/Werkzeugblitz.de/engine/Shopware/Kernel.php(182): Enlight_Controller_Front->dispatch()
#11 /usr/local/www/apache24/noexec/Werkzeugblitz.de/vendor/symfony/http-kernel/HttpCache/HttpCache.php(491): Shopware\Kernel->handle(Object(Enlight_Controller_Request_RequestHttp), 1, true)
#12 /usr/local/www/apache24/noexec/Werkzeugblitz.de/engine/Shopware/Components/HttpCache/AppCache.php(266): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL)
#13 /usr/local/www/apache24/noexec/Werkzeugblitz.de/vendor/symfony/http-kernel/HttpCache/HttpCache.php(258): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true)
#14 /usr/local/www/apache24/noexec/Werkzeugblitz.de/engine/Shopware/Components/HttpCache/AppCache.php(103): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true)
#15 /usr/local/www/apache24/noexec/Werkzeugblitz.de/shopware.php(117): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #16 {main} [] {"uid":"b764b90"}
```
Er sagt dass der Name nicht Null sein darf, obwohl dieser gefüllt ist.
Woran kann das liegen?
Mit freundlichen Grüßen
F. Steffens
---
### Author:  [@FabianMaas](https://forum.shopware.com/u/FabianMaas)
#### Post date: [6. September 2017 um 10:57 UTC](https://forum.shopware.com/t/sql-fehler-sqlstate-23000/48086/2 "2017-09-06T10:57:21Z")
Hallo Fabian1994,
hier könnte es sein, dass Deine Foreign Keys nicht passend gesetzt sind.
Schau Dir am besten folgenden Doku-Eintrag an:
[http://community.shopware.com/Foreign-Keys-reparieren\_detail\_954.html](http://community.shopware.com/Foreign-Keys-reparieren_detail_954.html)
Am Ende findest Du ein Script welches Du am besten einmal ausführen solltest.
---
### Author:  [@Fabian1994](https://forum.shopware.com/u/Fabian1994)
#### Post date: [6. September 2017 um 13:57 UTC](https://forum.shopware.com/t/sql-fehler-sqlstate-23000/48086/3 "2017-09-06T13:57:55Z")
Wunderbar, hat funktioniert!
Vielen Dank.