# SQLSTATE\[42000\]: Syntax error or access violation: 1066

**URL:** <https://forum.shopware.com/t/sqlstate-42000-syntax-error-or-access-violation-1066/14550>\
**Category:** Shopware 3.5\
**Tags:** administration\
**Created:** [22. Juli 2013 um 18:23 UTC](https://forum.shopware.com/t/sqlstate-42000-syntax-error-or-access-violation-1066/14550 "2013-07-22T18:23:54Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jaguar](https://avatars.discourse-cdn.com/v4/letter/j/4af34b/32.png) [@jaguar](https://forum.shopware.com/u/jaguar)\
**Post date:** [22. Juli 2013 um 18:23 UTC](https://forum.shopware.com/t/sqlstate-42000-syntax-error-or-access-violation-1066/14550/1 "2013-07-22T18:23:54Z")

</div>

Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen. SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias: ‚ac‘ in Zend/Db/Statement/Pdo.php on line 234 Stack trace: #0 Zend/Db/Statement.php(300): Zend\_Db\_Statement\_Pdo-\>\_execute(Array) #1 Zend/Db/Adapter/Abstract.php(479): Zend\_Db\_Statement-\>execute(Array) #2 Zend/Db/Adapter/Pdo/Abstract.php(238): Zend\_Db\_Adapter\_Abstract-\>query(’???SELECT SQL\_…’, Array) #3 Enlight/Components/Db/Adapter/Pdo/Mysql.php(75): Zend\_Db\_Adapter\_Pdo\_Abstract-\>query(’???SELECT SQL\_…’, Array) #4 Zend/Db/Adapter/Abstract.php(736): Enlight\_Components\_Db\_Adapter\_Pdo\_Mysql-\>query(’???SELECT SQL\_…’, Array) #5 Enlight/Components/Adodb.php(247): Zend\_Db\_Adapter\_Abstract-\>fetchAll(’???SELECT SQL\_…’, Array) #6 Enlight/Components/Adodb.php(393): Enlight\_Components\_Adodb-\>GetAll(’???SELECT SQL\_…’, Array) #7 Enlight/Components/Adodb.php(410): Enlight\_Components\_Adodb-\>callCached(‚GetAll‘, 86400, ‚???SELECT SQL\_…‘, false, ‚search\_supplier‘) #8 engine/core/class/sArticles.php(714): Enlight\_Components\_Adodb-\>CacheGetAll(86400, ‚???SELECT SQL\_…‘, false, ‚search\_supplier‘) #9 Shopware/Controllers/Frontend/Search.php(52): sArticles-\>sGetArticlesByName(‚a.name ASC‘, ‚‘, ‚supplier‘, ‚4‘) #10 Enlight/Controller/Action.php(148): Shopware\_Controllers\_Frontend\_Search-\>supplierSearchAction() #11 Enlight/Controller/Dispatcher/Default.php(521): Enlight\_Controller\_Action-\>dispatch(‚supplierSearchA…‘) #12 Enlight/Controller/Front.php(214): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #13 Shopware/Components/HttpCache/HttpKernel.php(79): Enlight\_Controller\_Front-\>dispatch() #14 Symfony/Component/HttpKernel/HttpCache/HttpCache.php(434): Shopware\Components\HttpCache\HttpKernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #15 Shopware/Components/HttpCache/AppCache.php(234): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #16 Symfony/Component/HttpKernel/HttpCache/HttpCache.php(403): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #17 Symfony/Component/HttpKernel/HttpCache/HttpCache.php(303): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>fetch(Object(Symfony\Component\HttpFoundation\Request), true) #18 Shopware/Components/HttpCache/AppCache.php(158): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>lookup(Object(Symfony\Component\HttpFoundation\Request), true) #19 Symfony/Component/HttpKernel/HttpCache/HttpCache.php(192): Shopware\Components\HttpCache\AppCache-\>lookup(Object(Symfony\Component\HttpFoundation\Request), true) #20 Shopware/Components/HttpCache/AppCache.php(110): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #21 Shopware/Bootstrap.php(70): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #22 Enlight/Application.php(192): Shopware\_Bootstrap-\>run() #23 shopware.php(83): Enlight\_Application-\>run() #24 {main} Bitte brauche dringend Hilfe!!! Dieser Fehler tritt auf wenn ich in den Artikeldetails auf „Weitere Artikel von …“ klicke.

---

<div class="post-metadata">

**Author:** ![SebastianKloepper](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/sebastiankloepper/32/21435_2.png) [@SebastianKloepper](https://forum.shopware.com/u/SebastianKloepper)\
**Post date:** [22. Juli 2013 um 18:26 UTC](https://forum.shopware.com/t/sqlstate-42000-syntax-error-or-access-violation-1066/14550/2 "2013-07-22T18:26:26Z")

</div>

Hallo, über die Suche findet man direkt die Lösung [post66429.html#p66486](http://forum.shopware.de/post66429.html#p66486) Da ist im Template wohl noch ein alter Link Sebastian

---

<div class="post-metadata">

**Author:** ![jaguar](https://avatars.discourse-cdn.com/v4/letter/j/4af34b/32.png) [@jaguar](https://forum.shopware.com/u/jaguar)\
**Post date:** [22. Juli 2013 um 18:53 UTC](https://forum.shopware.com/t/sqlstate-42000-syntax-error-or-access-violation-1066/14550/3 "2013-07-22T18:53:00Z")

</div>

Danke für die schnelle Antwort. Jetzt klappt alles wieder.