Problem with Generating Variants

Shopware 5 International (English Only)
1

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.

 

Thanks in Advance.

2

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?

 

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