Hi Moritz, bei uns kommt das auch die ganze zeit:
[Doctrine\ORM\Query\QueryException]
[Semantical Error] line 0, col 3162 near ‚attr27 as attributeAttr27,‘: Error: Class Shopware\Models\Attribute\Article has no field or association named attr27
Wenn ich das Model dann neu generiere geht es eine Zeit lang (geschätzt ne Stunde) und dann kommt die Meldung wieder. Erst wenn man das Model nocmals generiert geht es wieder. Dann wieder nicht usw…
Wir nutzen Shopware 5.4
Ganze Fehlermeldung:
[Doctrine\ORM\Query\QueryException]
SELECT article.id as articleId, article.name as name, article.description as description, article.descriptionLong as descriptionLong, DATE_FORMAT(article.added, ‚%Y-%m-%d‘) as date, article.pseudoSales as pseudoSales, article.highlight as topSelle
r, article.metaTitle as metaTitle, article.keywords as keywords, DATE_FORMAT(article.changed, ‚%Y-%m-%d %H:%i:%s‘) as changeTime, article.priceGroupId as priceGroupId, article.priceGroupActive as priceGroupActive, article.lastStock as lastStock, a
rticle.crossBundleLook as crossBundleLook, article.notification as notification, article.template as template, article.mode as mode, article.availableFrom as availableFrom, article.availableTo as availableTo, supplier.id as supplierId, supplier.na
me as supplierName, articleTax.id as taxId, articleTax.tax as tax, filterGroup.id as filterGroupId, filterGroup.name as filterGroupName, variant.id as variantId, variant.number as orderNumber, mv.number as mainNumber, variant.kind as kind, variant
.additionalText as additionalText, variant.inStock as inStock, variant.active as active, variant.stockMin as stockMin, variant.weight as weight, variant.position as position, variant.width as width, variant.height as height, variant.len as length,
variant.ean as ean, variant.unitId as unitId, variant.purchaseSteps as purchaseSteps, variant.minPurchase as minPurchase, variant.maxPurchase as maxPurchase, variant.purchaseUnit as purchaseUnit, variant.referenceUnit as referenceUnit, variant.pa
ckUnit as packUnit, DATE_FORMAT(variant.releaseDate, ‚%Y-%m-%d‘) as releaseDate, variant.shippingTime as shippingTime, variant.shippingFree as shippingFree, variant.supplierNumber as supplierNumber, variant.purchasePrice as purchasePrice, attribut
e.attr1 as attributeAttr1, attribute.attr2 as attributeAttr2, attribute.attr3 as attributeAttr3, attribute.attr4 as attributeAttr4, attribute.attr5 as attributeAttr5, attribute.attr6 as attributeAttr6, attribute.attr7 as attributeAttr7, attribute.
attr8 as attributeAttr8, attribute.attr9 as attributeAttr9, attribute.attr10 as attributeAttr10, attribute.attr11 as attributeAttr11, attribute.attr12 as attributeAttr12, attribute.attr13 as attributeAttr13, attribute.attr14 as attributeAttr14, at
tribute.attr15 as attributeAttr15, attribute.attr16 as attributeAttr16, attribute.attr17 as attributeAttr17, attribute.attr18 as attributeAttr18, attribute.attr19 as attributeAttr19, attribute.attr20 as attributeAttr20, attribute.coeArticlestock a
s attributeCoeArticlestock, attribute.attr21 as attributeAttr21, attribute.attr22 as attributeAttr22, attribute.attr23 as attributeAttr23, attribute.attr24 as attributeAttr24, attribute.attr25 as attributeAttr25, attribute.attr26 as attributeAttr2
6, attribute.viisonIncomingStock as attributeViisonIncomingStock, attribute.viisonPhysicalStock as attributeViisonPhysicalStock, attribute.viisonNotRelevantForStockManager as attributeViisonNotRelevantForStockManager, attribute.viisonPhysicalStock
ForSale as attributeViisonPhysicalStockForSale, attribute.viisonMoss as attributeViisonMoss, attribute.viisonOtherServiceParagraphOneOrTwo as attributeViisonOtherServiceParagraphOneOrTwo, attribute.attr27 as attributeAttr27, attribute.attr28 as at
tributeAttr28, variantsUnit.unit as unit, articleEsd.file as esd FROM Shopware\Models\Article\Detail variant INNER JOIN variant.article article LEFT JOIN Shopware\Models\Article\Detail mv WITH mv.articleId=article.id AND mv.kind=1 LEFT JOIN varian
t.attribute attribute LEFT JOIN article.tax articleTax LEFT JOIN article.supplier supplier LEFT JOIN article.propertyGroup filterGroup LEFT JOIN article.esds articleEsd LEFT JOIN variant.unit variantsUnit WHERE variant.id IN (:ids) ORDER BY varian
t.kind ASC