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, 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?
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.