# Error in Backend ProductListing

**URL:** <https://forum.shopware.com/t/error-in-backend-productlisting/36799>\
**Category:** Allgemein\
**Created:** [17. Mai 2016 um 14:43 UTC](https://forum.shopware.com/t/error-in-backend-productlisting/36799 "2016-05-17T14:43:53Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![testusernetwork1](https://avatars.discourse-cdn.com/v4/letter/t/e5b9ba/32.png) [@testusernetwork1](https://forum.shopware.com/u/testusernetwork1)\
**Post date:** [17. Mai 2016 um 14:43 UTC](https://forum.shopware.com/t/error-in-backend-productlisting/36799/1 "2016-05-17T14:43:53Z")

</div>

Hai.,

I have got the following Error.When I click the “Items—\>Overview”

**[2016-05-17 16:06:09] core.ERROR: exception ‘PDOException’ with message ‘SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘LEFT JOIN s\_articles s2\_ ON s0\_.articleID = s2\_.id LEFT JOIN s\_articles\_categori’ at line 1’ in /home/hygeashop/www/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:694 Stack trace: #0 /home/hygeashop/www/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(694): PDOStatement-\>execute() #1 /home/hygeashop/www/htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\DBAL\Connection-\>executeQuery(‘SELECT count(DI…’, Array, Array, NULL) #2 /home/hygeashop/www/htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(286): Doctrine\ORM\Query\Exec\SingleSelectExecutor-\>execute(Object(Doctrine\DBAL\Connection), Array, Array) #3 /home/hygeashop/www/htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(794): Doctrine\ORM\Query-\>\_doExecute() #4 /home/hygeashop/www/htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(598): Doctrine\ORM\AbstractQuery-\>execute(NULL, 3) #5 /home/hygeashop/www/htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(143): Doctrine\ORM\AbstractQuery-\>getScalarResult() #6 /home/hygeashop/www/htdocs/engine/Shopware/Components/MultiEdit/Resource/Product/Filter.php(170): Doctrine\ORM\Tools\Pagination\Paginator-\>count() #7 /home/hygeashop/www/htdocs/engine/Shopware/Components/MultiEdit/Resource/Product/Filter.php(196): Shopware\Components\MultiEdit\Resource\Product\Filter-\>getPaginatedResult(Object(Doctrine\ORM\Query)) #8 /home/hygeashop/www/htdocs/engine/Shopware/Components/MultiEdit/Resource/Product.php(111): Shopware\Components\MultiEdit\Resource\Product\Filter-\>filter(Array, 0, ‘25’, Array) #9 /home/hygeashop/www/htdocs/engine/Shopware/Controllers/Backend/ArticleList.php(364): Shopware\Components\MultiEdit\Resource\Product-\>filter(Array, 0, ‘25’, Array) #10 /home/hygeashop/www/htdocs/engine/Library/Enlight/Controller/Action.php(159): Shopware\_Controllers\_Backend\_ArticleList-\>filterAction() #11 /home/hygeashop/www/htdocs/engine/Library/Enlight/Controller/Dispatcher/Default.php(524): Enlight\_Controller\_Action-\>dispatch(‘filterAction’) #12 /home/hygeashop/www/htdocs/engine/Library/Enlight/Controller/Front.php(227): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #13 /home/hygeashop/www/htdocs/engine/Shopware/Kernel.php(143): Enlight\_Controller\_Front-\>dispatch() #14 /home/hygeashop/www/htdocs/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(490): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #15 /home/hygeashop/www/htdocs/engine/Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #16 /home/hygeashop/www/htdocs/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(261): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #17 /home/hygeashop/www/htdocs/engine/Shopware/Components/HttpCache/AppCache.php(103): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass(Object(Symfony\Component\HttpFoundation\Request), true) #18 /home/hygeashop/www/htdocs/shopware.php(101): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #19 {main} &nbsp;Next exception ‘Doctrine\DBAL\DBALException’ with message ‘An exception occurred while executing ‘SELECT count(DISTINCT s0\_.id) AS sclr0 FROM s\_articles\_details s0\_ INNER JOIN &nbsp;LEFT JOIN s\_articles s2\_ ON s0\_.articleID = s2\_.id LEFT JOIN s\_articles\_categories\_ro s4\_ ON s2\_.id = s4\_.articleID LEFT JOIN s\_categories s3\_ ON s3\_.id = s4\_.categoryID WHERE s0\_.kind = 1 AND (s3\_.path LIKE ? OR s3\_.id LIKE ?)’ with params ["%|66|%", “66”]: &nbsp;SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘LEFT JOIN s\_articles s2\_ ON s0\_.articleID = s2\_.id LEFT JOIN s\_articles\_categori’ at line 1’ in /home/hygeashop/www/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91 Stack trace: #0 /home/hygeashop/www/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(702): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(PDOException), ‘SELECT count(DI…’, Array) #1 /home/hygeashop/www/htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\DBAL\Connection-\>executeQuery(‘SELECT count(DI…’, Array, Array, NULL) #2 /home/hygeashop/www/htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(286): Doctrine\ORM\Query\Exec\SingleSelectExecutor-\>execute(Object(Doctrine\DBAL\Connection), Array, Array) #3 /home/hygeashop/www/htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(794): Doctrine\ORM\Query-\>\_doExecute() #4 /home/hygeashop/www/htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(598): Doctrine\ORM\AbstractQuery-\>execute(NULL, 3) #5 /home/hygeashop/www/htdocs/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(143): Doctrine\ORM\AbstractQuery-\>getScalarResult() #6 /home/hygeashop/www/htdocs/engine/Shopware/Components/MultiEdit/Resource/Product/Filter.php(170): Doctrine\ORM\Tools\Pagination\Paginator-\>count() #7 /home/hygeashop/www/htdocs/engine/Shopware/Components/MultiEdit/Resource/Product/Filter.php(196): Shopware\Components\MultiEdit\Resource\Product\Filter-\>getPaginatedResult(Object(Doctrine\ORM\Query)) #8 /home/hygeashop/www/htdocs/engine/Shopware/Components/MultiEdit/Resource/Product.php(111): Shopware\Components\MultiEdit\Resource\Product\Filter-\>filter(Array, 0, ‘25’, Array) #9 /home/hygeashop/www/htdocs/engine/Shopware/Controllers/Backend/ArticleList.php(364): Shopware\Components\MultiEdit\Resource\Product-\>filter(Array, 0, ‘25’, Array) #10 /home/hygeashop/www/htdocs/engine/Library/Enlight/Controller/Action.php(159): Shopware\_Controllers\_Backend\_ArticleList-\>filterAction() #11 /home/hygeashop/www/htdocs/engine/Library/Enlight/Controller/Dispatcher/Default.php(524): Enlight\_Controller\_Action-\>dispatch(‘filterAction’) #12 /home/hygeashop/www/htdocs/engine/Library/Enlight/Controller/Front.php(227): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #13 /home/hygeashop/www/htdocs/engine/Shopware/Kernel.php(143): Enlight\_Controller\_Front-\>dispatch() #14 /home/hygeashop/www/htdocs/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(490): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #15 /home/hygeashop/www/htdocs/engine/Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #16 /home/hygeashop/www/htdocs/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(261): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #17 /home/hygeashop/www/htdocs/engine/Shopware/Components/HttpCache/AppCache.php(103): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass(Object(Symfony\Component\HttpFoundation\Request), true) #18 /home/hygeashop/www/htdocs/shopware.php(101): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #19 {main} [] {“uid”:“9d6d075”}**

Please help in this to get me out

Thankyou

---

<div class="post-metadata">

**Author:** ![testusernetwork1](https://avatars.discourse-cdn.com/v4/letter/t/e5b9ba/32.png) [@testusernetwork1](https://forum.shopware.com/u/testusernetwork1)\
**Post date:** [18. Mai 2016 um 13:14 UTC](https://forum.shopware.com/t/error-in-backend-productlisting/36799/2 "2016-05-18T13:14:51Z")

</div>

**Oops! An error has occurred!**

**The following notes should help you.**

**An exception occurred while executing ‚SELECT count(DISTINCT s0\_.id) AS sclr0 FROM s\_articles\_details s0\_ INNER JOIN LEFT JOIN s\_articles s2\_ ON s0\_.articleID = s2\_.id WHERE s0\_.kind = 1‘: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‚LEFT JOIN s\_articles s2\_ ON s0\_.articleID = s2\_.id WHERE s0\_.kind = 1‘ at line 1 in vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 91**

**Stack trace:**

```
**#0 vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(702): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(PDOException), 'SELECT count(DI...', Array) #1 vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\DBAL\Connection-\>executeQuery('SELECT count(DI...', Array, Array, NULL) #2 vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(286): Doctrine\ORM\Query\Exec\SingleSelectExecutor-\>execute(Object(Doctrine\DBAL\Connection), Array, Array) #3 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(794): Doctrine\ORM\Query-\>\_doExecute() #4 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(598): Doctrine\ORM\AbstractQuery-\>execute(NULL, 3) #5 vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(143): Doctrine\ORM\AbstractQuery-\>getScalarResult() #6 Shopware/Components/MultiEdit/Resource/Product/Filter.php(170): Doctrine\ORM\Tools\Pagination\Paginator-\>count() #7 Shopware/Components/MultiEdit/Resource/Product/Filter.php(196): Shopware\Components\MultiEdit\Resource\Product\Filter-\>getPaginatedResult(Object(Doctrine\ORM\Query)) #8 Shopware/Components/MultiEdit/Resource/Product.php(111): Shopware\Components\MultiEdit\Resource\Product\Filter-\>filter(Array, 0, '25', Array) #9 Shopware/Controllers/Backend/ArticleList.php(364): Shopware\Components\MultiEdit\Resource\Product-\>filter(Array, 0, '25', Array) #10 Enlight/Controller/Action.php(159): Shopware\_Controllers\_Backend\_ArticleList-\>filterAction() #11 Enlight/Controller/Dispatcher/Default.php(524): Enlight\_Controller\_Action-\>dispatch('filterAction') #12 Enlight/Controller/Front.php(227): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #13 Shopware/Kernel.php(143): Enlight\_Controller\_Front-\>dispatch() #14 vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(490): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #15 Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #16 vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(261): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #17 Shopware/Components/HttpCache/AppCache.php(103): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass(Object(Symfony\Component\HttpFoundation\Request), true) #18 shopware.php(101): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #19 {main}**

```

&nbsp;

**How to solve the Above Errors?**

---

<div class="post-metadata">

**Author:** ![Sunsara](https://avatars.discourse-cdn.com/v4/letter/s/dfb087/32.png) [@Sunsara](https://forum.shopware.com/u/Sunsara)\
**Post date:** [28. Oktober 2017 um 16:02 UTC](https://forum.shopware.com/t/error-in-backend-productlisting/36799/3 "2017-10-28T16:02:21Z")

</div>

Excactly the same error occured all of a sudden. Is there a solution available meanwhile?

---

<div class="post-metadata">

**Author:** ![Sunsara](https://avatars.discourse-cdn.com/v4/letter/s/dfb087/32.png) [@Sunsara](https://forum.shopware.com/u/Sunsara)\
**Post date:** [28. Oktober 2017 um 16:55 UTC](https://forum.shopware.com/t/error-in-backend-productlisting/36799/4 "2017-10-28T16:55:27Z")

</div>

This is the complete error message:

Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen. An exception occurred while executing ‚SELECT count(DISTINCT s0\_.id) AS sclr0 FROM s\_articles\_details s0\_ INNER JOIN LEFT JOIN s\_articles s2\_ ON s0\_.articleID = s2\_.id WHERE s0\_.kind = 1‘: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‚LEFT JOIN s\_articles s2\_ ON s0\_.articleID = s2\_.id WHERE s0\_.kind = 1‘ at line 1 in vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 91 Stack trace: #0 vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(702): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(PDOException), ‚SELECT count(DI…‘, Array) #1 vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\DBAL\Connection-\>executeQuery(‚SELECT count(DI…‘, Array, Array, NULL) #2 vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(286): Doctrine\ORM\Query\Exec\SingleSelectExecutor-\>execute(Object(Doctrine\DBAL\Connection), Array, Array) #3 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(794): Doctrine\ORM\Query-\>\_doExecute() #4 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(598): Doctrine\ORM\AbstractQuery-\>execute(NULL, 3) #5 vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(143): Doctrine\ORM\AbstractQuery-\>getScalarResult() #6 Shopware/Components/MultiEdit/Resource/Product/Filter.php(170): Doctrine\ORM\Tools\Pagination\Paginator-\>count() #7 Shopware/Components/MultiEdit/Resource/Product/Filter.php(196): Shopware\Components\MultiEdit\Resource\Product\Filter-\>getPaginatedResult(Object(Doctrine\ORM\Query)) #8 Shopware/Components/MultiEdit/Resource/Product.php(111): Shopware\Components\MultiEdit\Resource\Product\Filter-\>filter(Array, 0, ‚25‘, Array) #9 Shopware/Controllers/Backend/ArticleList.php(364): Shopware\Components\MultiEdit\Resource\Product-\>filter(Array, 0, ‚25‘, Array) #10 Enlight/Controller/Action.php(159): Shopware\_Controllers\_Backend\_ArticleList-\>filterAction() #11 Enlight/Controller/Dispatcher/Default.php(524): Enlight\_Controller\_Action-\>dispatch(‚filterAction‘) #12 Enlight/Controller/Front.php(227): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #13 Shopware/Kernel.php(143): Enlight\_Controller\_Front-\>dispatch() #14 vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(490): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #15 Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #16 vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(261): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #17 Shopware/Components/HttpCache/AppCache.php(103): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass(Object(Symfony\Component\HttpFoundation\Request), true) #18 shopware.php(101): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #19 {main}&nbsp;