testusernetwork1testusernetwork1 MitgliedKommentare: 34 Danke erhalten: 1 Mitglied seit: Februar 2014 bearbeitet 2. August

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.

Antworten

  • PStadtfeldPStadtfeld MitgliedKommentare: 265 Danke erhalten: 59 Mitglied seit: August 2017

    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.

Anmelden oder Registrieren, um zu kommentieren.