V4.2.3 - Fehler beim Bilderimport - An exception occurred...

Hallo Zusammen, leider haben wir einen Fehler beim Import weiterer Bilder: An exception occurred while executing 'INSERT INTO s\_articles\_img (articleID, article\_detail\_id, description, img, main, position, width, height, relations, extension, parent\_id, media\_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["7027", null, null, "hgb\_00938", "1", "", 0, 0, "", "jpg", null, 72963]: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'description' cannot be null Stack Trace:#0 /home/shopware/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php(167): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(PDOException), 'INSERT INTO s\_a...', Array) #1 /home/shopware/httpdocs/engine/Library/Doctrine/ORM/Persisters/BasicEntityPersister.php(279): Doctrine\DBAL\Statement-\>execute() #2 /home/shopware/httpdocs/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(952): Doctrine\ORM\Persisters\BasicEntityPersister-\>executeInserts() #3 /home/shopware/httpdocs/vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(335): Doctrine\ORM\UnitOfWork-\>executeInserts(Object(Doctrine\ORM\Mapping\ClassMetadata)) #4 /home/shopware/httpdocs/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(389): Doctrine\ORM\UnitOfWork-\>commit(Object(Shopware\Models\Article\Image)) #5 /home/shopware/httpdocs/engine/Shopware/Controllers/Backend/ImportExport.php(1703): Doctrine\ORM\EntityManager-\>flush(Object(Shopware\Models\Article\Image)) #6 /home/shopware/httpdocs/engine/Shopware/Controllers/Backend/ImportExport.php(1557): Shopware\_Controllers\_Backend\_ImportExport-\>importImages('/home/shopware/...') #7 /home/shopware/httpdocs/engine/Library/Enlight/Controller/Action.php(159): Shopware\_Controllers\_Backend\_ImportExport-\>importAction() #8 /home/shopware/httpdocs/engine/Library/Enlight/Controller/Dispatcher/Default.php(528): Enlight\_Controller\_Action-\>dispatch('importAction') #9 /home/shopware/httpdocs/engine/Library/Enlight/Controller/Front.php(228): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #10 /home/shopware/httpdocs/engine/Shopware/Kernel.php(141): Enlight\_Controller\_Front-\>dispatch() #11 /home/shopware/httpdocs/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(473): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #12 /home/shopware/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(256): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #13 /home/shopware/httpdocs/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(244): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #14 /home/shopware/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(102): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass(Object(Symfony\Component\HttpFoundation\Request), true) #15 /home/shopware/httpdocs/shopware.php(91): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #16 {main} Der Großteil unserer Artikel hat bereits Bilder, daher stimmt der Aufbau der CSV definitiv und die zu importierenden Bilder sind auch einwandfrei erreichbar. Hoffe ihr habt eine Idee… :frowning:

Der Fehler sagt, dass das 3. Feld „description“ - also die Beschreibung - nicht NULL sein darf.

1 Like