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} 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 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”]: 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