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…
Der Fehler sagt, dass das 3. Feld „description“ - also die Beschreibung - nicht NULL sein darf.
1 Like