# Semantical Error\] line 0, col 82 near 'articleDetailId': Err

**URL:** <https://forum.shopware.com/t/semantical-error-line-0-col-82-near-articledetailid-err/18653>\
**Category:** Shopware 3.5\
**Tags:** general\
**Created:** [24. Februar 2014 um 18:56 UTC](https://forum.shopware.com/t/semantical-error-line-0-col-82-near-articledetailid-err/18653 "2014-02-24T18:56:10Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nedea](https://avatars.discourse-cdn.com/v4/letter/n/35a633/32.png) [@Nedea](https://forum.shopware.com/u/Nedea)\
**Post date:** [24. Februar 2014 um 18:56 UTC](https://forum.shopware.com/t/semantical-error-line-0-col-82-near-articledetailid-err/18653/1 "2014-02-24T18:56:10Z")

</div>

Das bekomme ich angezeigt im frontend: [quote][Semantical Error] line 0, col 82 near ‚articleDetailId‘: Error: Class Shopware\Models\Attribute\Article has no field or association named articleDetailId in vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php on line 63 Stack trace: #0 vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(483): Doctrine\ORM\Query\QueryException::semanticalError(‚line 0, col 82 …‘, Object(Doctrine\ORM\Query\QueryException)) #1 vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(759): Doctrine\ORM\Query\Parser-\>semanticalError(‚Class Shopware…‘, Array) #2 vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(279): Doctrine\ORM\Query\Parser-\>processDeferredPathExpressions(Object(Doctrine\ORM\Query\AST\SelectStatement)) #3 vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(351): Doctrine\ORM\Query\Parser-\>getAST() #4 vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(255): Doctrine\ORM\Query\Parser-\>parse() #5 vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(267): Doctrine\ORM\Query-\>\_parse() #6 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(794): Doctrine\ORM\Query-\>\_doExecute() #7 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(612): Doctrine\ORM\AbstractQuery-\>execute(NULL, 2) #8 engine/core/class/sConfigurator.php(644): Doctrine\ORM\AbstractQuery-\>getOneOrNullResult(2) #9 engine/core/class/sConfigurator.php(616): sConfigurator-\>getDetailAttributes(1376) #10 engine/core/class/sConfigurator.php(279): sConfigurator-\>getConvertedDetail(Array) #11 engine/core/class/sConfigurator.php(741): sConfigurator-\>getArticleConfigurator(‚1101‘, Array) #12 engine/core/class/sArticles.php(2562): sConfigurator-\>sGetArticleConfig(‚1101‘, Array) #13 engine/core/class/sArticles.php(3217): sArticles-\>sGetArticleConfig(‚1101‘, Array) #14 Shopware/Controllers/Frontend/Detail.php(80): sArticles-\>sGetArticleById(1101) #15 Enlight/Controller/Action.php(159): Shopware\_Controllers\_Frontend\_Detail-\>indexAction() #16 Enlight/Controller/Dispatcher/Default.php(528): Enlight\_Controller\_Action-\>dispatch(‚indexAction‘) #17 Enlight/Controller/Front.php(228): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #18 Shopware/Kernel.php(141): Enlight\_Controller\_Front-\>dispatch() #19 vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(473): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #20 Shopware/Components/HttpCache/AppCache.php(256): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #21 vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(430): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #22 vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(330): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>fetch(Object(Symfony\Component\HttpFoundation\Request), true) #23 Shopware/Components/HttpCache/AppCache.php(178): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>lookup(Object(Symfony\Component\HttpFoundation\Request), true) #24 vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(194): Shopware\Components\HttpCache\AppCache-\>lookup(Object(Symfony\Component\HttpFoundation\Request), true) #25 Shopware/Components/HttpCache/AppCache.php(113): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #26 shopware.php(91): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #27 {main}[/quote] Im Backend kommt folgende Fehlermeldung, wenn ich einen Artikel mit Varianten aufrufe: `Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen. An exception occurred while executing 'SELECT s0\_.id AS id0, s0\_.main\_detail\_id AS main\_detail\_id1, s0\_.supplierID AS supplierID2, s0\_.taxID AS taxID3, s0\_.pricegroupID AS pricegroupID4, s0\_.filtergroupID AS filtergroupID5, s0\_.configurator\_set\_id AS configurator\_set\_id6, s0\_.name AS name7, s0\_.description AS description8, s0\_.description\_long AS description\_long9, s0\_.datum AS datum10, s0\_.active AS active11, s0\_.pseudosales AS pseudosales12, s0\_.topseller AS topseller13, s0\_.keywords AS keywords14, s0\_.metaTitle AS metaTitle15, s0\_.changetime AS changetime16, s0\_.pricegroupActive AS pricegroupActive17, s0\_.laststock AS laststock18, s0\_.crossbundlelook AS crossbundlelook19, s0\_.notification AS notification20, s0\_.template AS template21, s0\_.mode AS mode22, s0\_.available\_from AS available\_from23, s0\_.available\_to AS available\_to24, s1\_.id AS id25, s1\_.articleID AS articleID26, s1\_.unitID AS unitID27, s1\_.ordernumber AS ordernumber28, s1\_.suppliernumber AS suppliernumber29, s1\_.kind AS kind30, s1\_.additionaltext AS additionaltext31, s1\_.active AS active32, s1\_.instock AS instock33, s1\_.stockmin AS stockmin34, s1\_.weight AS weight35, s1\_.width AS width36, s1\_.length AS length37, s1\_.height AS height38, s1\_.ean AS ean39, s1\_.position AS position40, s1\_.minpurchase AS minpurchase41, s1\_.purchasesteps AS purchasesteps42, s1\_.maxpurchase AS maxpurchase43, s1\_.purchaseunit AS purchaseunit44, s1\_.referenceunit AS referenceunit45, s1\_.packunit AS packunit46, s1\_.shippingfree AS shippingfree47, s1\_.releasedate AS releasedate48, s1\_.shippingtime AS shippingtime49, s2\_.id AS id50, s2\_.tax AS tax51, s2\_.description AS description52, s3\_.id AS id53, s3\_.articleID AS articleID54, s3\_.articledetailsID AS articledetailsID55, s3\_.attr1 AS attr156, s3\_.attr2 AS attr257, s3\_.attr3 AS attr358, s3\_.attr4 AS attr459, s3\_.attr5 AS attr560, s3\_.attr6 AS attr661, s3\_.attr7 AS attr762, s3\_.attr8 AS attr863, s3\_.attr9 AS attr964, s3\_.attr10 AS attr1065, s3\_.attr11 AS attr1166, s3\_.attr12 AS attr1267, s3\_.attr13 AS attr1368, s3\_.attr14 AS attr1469, s3\_.attr15 AS attr1570, s3\_.attr16 AS attr1671, s3\_.attr17 AS attr1772, s3\_.attr18 AS attr1873, s3\_.attr19 AS attr1974, s3\_.attr20 AS attr2075, s3\_.dreisc\_seo\_url AS dreisc\_seo\_url76 FROM s\_articles s0\_ LEFT JOIN s\_articles\_details s1\_ ON s0\_.main\_detail\_id = s1\_.id LEFT JOIN s\_core\_tax s2\_ ON s0\_.taxID = s2\_.id LEFT JOIN WHERE s0\_.id = ?' with params ["1146"]: 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 'WHERE s0\_.id = '1146'' at line 1 in ` Es gibt eine Hilfe: [http://wiki.shopware.de/Foreign-Keys-re … l\_954.html](http://wiki.shopware.de/Foreign-Keys-reparieren%5C_detail%5C_954.html), die ich auch genau so befolgt habe. Leider funktioniert es nicht. Ich erhalte folgenden Kommentar von der Datenbank: [quote]Fehler SQL-Befehl: ALTER TABLE `s_articles_attributes` ADD FOREIGN KEY ( `articledetailsID` ) REFERENCES `s_articles_details` ( `id` ) ON DELETE CASCADE ON UPDATE NO ACTION ; MySQL meldet: Dokumentation #1452 - Cannot add or update a child row: a foreign key constraint fails (`db_my`.`#sql-274_154b9`, CONSTRAINT `#sql-274_154b9_ibfk_2` FOREIGN KEY (`articledetailsID`) REFERENCES `s_articles_details` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION) [/quote] Jemand eine Lösung für mich?

---

<div class="post-metadata">

**Author:** ![Nedea](https://avatars.discourse-cdn.com/v4/letter/n/35a633/32.png) [@Nedea](https://forum.shopware.com/u/Nedea)\
**Post date:** [28. Februar 2014 um 07:04 UTC](https://forum.shopware.com/t/semantical-error-line-0-col-82-near-articledetailid-err/18653/2 "2014-02-28T07:04:54Z")

</div>

Niemand eine Lösung, wie ich die Artikelatribute wieder online bekomme? Irgendetwas muss ich schließlich ändern, aber bevor ich irgendetwas schlimmverbessere, wollte ich eine Antwort eines Experten.