# Problem with Generating Variants

**URL:** <https://forum.shopware.com/t/problem-with-generating-variants/54377>\
**Category:** International (English Only)\
**Tags:** programming\
**Created:** [1. August 2018 um 13:04 UTC](https://forum.shopware.com/t/problem-with-generating-variants/54377 "2018-08-01T13:04:23Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![testusernetwork1](https://avatars.discourse-cdn.com/v4/letter/t/e5b9ba/32.png) [@testusernetwork1](https://forum.shopware.com/u/testusernetwork1)\
**Post date:** [1. August 2018 um 13:04 UTC](https://forum.shopware.com/t/problem-with-generating-variants/54377/1 "2018-08-01T13:04:23Z")

</div>

Hello,

Recently i have updated my shopware store from 5.4.5. Everything is working fine.

But i am getting trouble while generating the variant for a product. I am getting the following error.

> Oops! An error has occurred! The following notes should help you. 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 vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 131 Stack trace: #0 vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(177): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), ‚INSERT INTO s\_a…‘, Array) #1 engine/Library/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(281): Doctrine\DBAL\Statement-\>execute() #2 vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(1014): Doctrine\ORM\Persisters\Entity\BasicEntityPersister-\>executeInserts() #3 vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(378): Doctrine\ORM\UnitOfWork-\>executeInserts(Object(Doctrine\ORM\Mapping\ClassMetadata)) #4 vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(356): Doctrine\ORM\UnitOfWork-\>commit(NULL) #5 engine/Shopware/Controllers/Backend/Article.php(224): Doctrine\ORM\EntityManager-\>flush() #6 engine/Library/Enlight/Controller/Action.php(193): Shopware\_Controllers\_Backend\_Article-\>saveConfiguratorSetAction() #7 engine/Library/Enlight/Controller/Dispatcher/Default.php(549): Enlight\_Controller\_Action-\>dispatch(‚saveConfigurato…‘) #8 engine/Library/Enlight/Controller/Front.php(222): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #9 engine/Shopware/Kernel.php(215): Enlight\_Controller\_Front-\>dispatch() #10 vendor/symfony/http-kernel/HttpCache/HttpCache.php(486): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #11 engine/Shopware/Components/HttpCache/AppCache.php(268): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #12 vendor/symfony/http-kernel/HttpCache/HttpCache.php(253): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #13 engine/Shopware/Components/HttpCache/AppCache.php(105): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass(Object(Symfony\Component\HttpFoundation\Request), true) #14 shopware.php(122): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #15 {main}

Could anyone please help to fix this issue.

&nbsp;

Thanks in Advance.

---

<div class="post-metadata">

**Author:** ![PStadtfeld](https://avatars.discourse-cdn.com/v4/letter/p/3bc359/32.png) [@PStadtfeld](https://forum.shopware.com/u/PStadtfeld)\
**Post date:** [8. August 2018 um 09:12 UTC](https://forum.shopware.com/t/problem-with-generating-variants/54377/2 "2018-08-08T09:12:23Z")

</div>

Well the error sais that shopware is trying to insert an empty name-value into the database which would in fact not be allowed.

Usually the set-name is defined by the articlenumber, maybe your articlenumber is not set? Have you tried giving the configuration-set a specific name?

Alternatively it could be a problem with your variants (if it’s an article coming with variants) where shopware fails to find the „pre-selected“ variant amongst them.

The article should have at least 1 row in the s\_articles\_details table, maybe it is set active = 0 while the actual article in s\_articles is active?

&nbsp;

If you can’t find the error after all maybe deleting and creating the article anew helps… obviously the most uncomfortable solution though.