# Frontend / Backend Kategorien und Artikel funktionieren nicht mehr.

**URL:** https://forum.shopware.com/t/frontend-backend-kategorien-und-artikel-funktionieren-nicht-mehr/44191
**Category:** Administration
**Created:** [2. März 2017 um 19:34 UTC](https://forum.shopware.com/t/frontend-backend-kategorien-und-artikel-funktionieren-nicht-mehr/44191 "2017-03-02T19:34:14Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Randal](https://avatars.discourse-cdn.com/v4/letter/r/58f4c7/32.png) [@Randal](https://forum.shopware.com/u/Randal)
#### Post date: [2. März 2017 um 19:34 UTC](https://forum.shopware.com/t/frontend-backend-kategorien-und-artikel-funktionieren-nicht-mehr/44191/1 "2017-03-02T19:34:14Z")

</div>

Hallo wir haben seit kurzem das Problem, dass in unserem Shop weder im Frontend noch im Backand die Kategorien oder Artikel aufgerufen werden können. Beim klicken auf Artikel im Backend erhalten wir folgende Meldung :&nbsp;

&nbsp;

Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen. An exception occurred while executing ‘SELECT t0.id AS id\_1, t0.articleID AS articleID\_2, t0.articledetailsID AS articledetailsID\_3, t0.attr1 AS attr1\_4, t0.attr2 AS attr2\_5, t0.attr3 AS attr3\_6, t0.attr4 AS attr4\_7, t0.attr5 AS attr5\_8, t0.attr6 AS attr6\_9, t0.attr7 AS attr7\_10, t0.attr8 AS attr8\_11, t0.attr9 AS attr9\_12, t0.attr10 AS attr10\_13, t0.attr11 AS attr11\_14, t0.attr12 AS attr12\_15, t0.attr13 AS attr13\_16, t0.attr14 AS attr14\_17, t0.attr15 AS attr15\_18, t0.attr16 AS attr16\_19, t0.attr17 AS attr17\_20, t0.attr18 AS attr18\_21, t0.attr19 AS attr19\_22, t0.attr20 AS attr20\_23, t0.lenz\_background\_image\_url AS lenz\_background\_image\_url\_24, t0.deposit AS deposit\_25, t0.dreisc\_seo\_url AS dreisc\_seo\_url\_26, t0.dreisc\_seo\_title AS dreisc\_seo\_title\_27, t0.dreisc\_seo\_title\_replace AS dreisc\_seo\_title\_replace\_28, t0.dreisc\_seo\_breadcrumb AS dreisc\_seo\_breadcrumb\_29, t0.dreisc\_canonical\_link AS dreisc\_canonical\_link\_30, t0.dreisc\_robots\_tag AS dreisc\_robots\_tag\_31, t0.dreisc\_facebook\_description AS dreisc\_facebook\_description\_32, t0.dreisc\_twitter\_description AS dreisc\_twitter\_description\_33, t0.articleID AS articleID\_34, t0.articledetailsID AS articledetailsID\_35 FROM s\_articles\_attributes t0 WHERE t0.articledetailsID = ?’ with params [29288]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.lenz\_background\_image\_url’ in ‘field list’ in vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 119 Stack trace: #0 vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(836): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), ‘SELECT t0.id AS…’, Array) #1 engine/Library/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(742): Doctrine\DBAL\Connection-\>executeQuery(‘SELECT t0.id AS…’, Array, Array) #2 engine/Library/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(820): Doctrine\ORM\Persisters\Entity\BasicEntityPersister-\>load(Array, NULL, Array) #3 vendor/doctrine/orm/lib/Doctrine/ORM/UnitOfWork.php(2626): Doctrine\ORM\Persisters\Entity\BasicEntityPersister-\>loadOneToOneEntity(Array, Object(Shopware\Models\Article\Detail)) #4 vendor/doctrine/orm/lib/Doctrine/ORM/Internal/Hydration/ObjectHydrator.php(273): Doctrine\ORM\UnitOfWork-\>createEntity(‘Shopware\Models…’, Array, Array) #5 vendor/doctrine/orm/lib/Doctrine/ORM/Internal/Hydration/ObjectHydrator.php(491): Doctrine\ORM\Internal\Hydration\ObjectHydrator-\>getEntity(Array, ‘detail’) #6 vendor/doctrine/orm/lib/Doctrine/ORM/Internal/Hydration/ObjectHydrator.php(165): Doctrine\ORM\Internal\Hydration\ObjectHydrator-\>hydrateRowData(Array, Array) #7 vendor/doctrine/orm/lib/Doctrine/ORM/Internal/Hydration/AbstractHydrator.php(147): Doctrine\ORM\Internal\Hydration\ObjectHydrator-\>hydrateAllData() #8 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(978): Doctrine\ORM\Internal\Hydration\AbstractHydrator-\>hydrateAll(Object(PDOStatement), Object(Doctrine\ORM\Query\ResultSetMapping), Array) #9 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(924): Doctrine\ORM\AbstractQuery-\>executeIgnoreQueryCache(NULL, 1) #10 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(727): Doctrine\ORM\AbstractQuery-\>execute(NULL, 1) #11 vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(165): Doctrine\ORM\AbstractQuery-\>getResult(1) #12 engine/Shopware/Components/MultiEdit/Resource/Product/Filter.php(178): Doctrine\ORM\Tools\Pagination\Paginator-\>getIterator() #13 engine/Shopware/Components/MultiEdit/Resource/Product/Filter.php(199): Shopware\Components\MultiEdit\Resource\Product\Filter-\>getPaginatedResult(Object(Doctrine\ORM\Query)) #14 engine/Shopware/Components/MultiEdit/Resource/Product.php(111): Shopware\Components\MultiEdit\Resource\Product\Filter-\>filter(Array, 0, ‘25’, Array) #15 engine/Shopware/Controllers/Backend/ArticleList.php(364): Shopware\Components\MultiEdit\Resource\Product-\>filter(Array, 0, ‘25’, Array) #16 engine/Library/Enlight/Controller/Action.php(159): Shopware\_Controllers\_Backend\_ArticleList-\>filterAction() #17 engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight\_Controller\_Action-\>dispatch(‘filterAction’) #18 engine/Library/Enlight/Controller/Front.php(223): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #19 engine/Shopware/Kernel.php(178): Enlight\_Controller\_Front-\>dispatch() #20 vendor/symfony/http-kernel/HttpCache/HttpCache.php(487): Shopware\Kernel-\>handle(Object(Enlight\_Controller\_Request\_RequestHttp), 1, true) #21 engine/Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #22 vendor/symfony/http-kernel/HttpCache/HttpCache.php(258): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #23 engine/Shopware/Components/HttpCache/AppCache.php(103): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass(Object(Symfony\Component\HttpFoundation\Request), true) #24 shopware.php(113): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #25 {main} &nbsp;

Leider kann ich mit der Fehlermeldung nicht viel Anfangen, hat hier vielleicht jemand ne idee oder kann hilfe geben ?&nbsp;

---

<div class="post-metadata">

### Author: ![sschreier](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/sschreier/32/23296_2.png) [@sschreier](https://forum.shopware.com/u/sschreier)
#### Post date: [2. März 2017 um 19:43 UTC](https://forum.shopware.com/t/frontend-backend-kategorien-und-artikel-funktionieren-nicht-mehr/44191/2 "2017-03-02T19:43:45Z")

</div>

Hallo,

ansich steht doch die Fehlermeldung recht deutlich da: "Column not found: 1054 Unknown column 't0. **lenz\_background\_image\_url’** in ‘field list’. Es liegt also an einem Plugin vom Hersteller Lenz.

Beste Grüße

Sebastian

---

<div class="post-metadata">

### Author: ![Randal](https://avatars.discourse-cdn.com/v4/letter/r/58f4c7/32.png) [@Randal](https://forum.shopware.com/u/Randal)
#### Post date: [3. März 2017 um 09:51 UTC](https://forum.shopware.com/t/frontend-backend-kategorien-und-artikel-funktionieren-nicht-mehr/44191/3 "2017-03-03T09:51:08Z")

</div>

Danke dir für deine Antwort. Wir konnten den Fehler gestern noch beheben.
