flagbit / akeneo-table-attribute-bundle

The Flagbit Table Attribute Bundle for Akeneo PIM gives you the possibility to enrich your product with multi-dimensional data presentation in the form of tables, allowing you maximum flexibility within the PIM.
MIT License
22 stars 21 forks source link

Error when selecting AttributeOption within Rules configuration (Akeneo 5.0.43) #62

Closed tdoedtmann closed 3 years ago

tdoedtmann commented 3 years ago

When editing Rules, it was noticed that a "Semantic Error" occurred when querying AttributeOption.

image

and here are the log entries for the failed query of AttributeOptions

[2021-08-05 14:46:31] request.INFO: Matched route "pim_ui_ajaxentity_list". {"route":"pim_ui_ajaxentity_list","route_parameters":{"_route":"pim_ui_ajaxentity_list","_controller":"pim_ui.controller.ajax_option:listAction"},"request_uri":"http://localhost/list.json?class=Akeneo%5CPim%5CStructure%5CComponent%5CModel%5CAttributeOption&collectionId=357&dataLocale=de_AT&options%5Btype%5D=code&options%5Blocale%5D=de_AT&options%5Bpage%5D=1&options%5Blimit%5D=20&search=","method":"GET"} [] [2021-08-05 14:46:31] request.CRITICAL: Uncaught PHP Exception Doctrine\ORM\Query\QueryException: "[Semantical Error] line 0, col 137 near 'v WITH v.locale=:locale': Error: Class Akeneo\Pim\Structure\Component\Model\AttributeOption has no association named optionValues" at /srv/pim/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php line 74 {"exception":"[object] (Doctrine\ORM\Query\QueryException(code: 0): [Semantical Error] line 0, col 137 near 'v WITH v.locale=:locale': Error: Class Akeneo\Pim\Structure\Component\Model\AttributeOption has no association named optionValues at /srv/pim/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php:74, Doctrine\ORM\Query\QueryException(code: 0): SELECT o.id, o.code, v.value AS label, a.properties FROM Akeneo\Pim\Structure\Component\Model\AttributeOption o LEFT JOIN o.optionValues v WITH v.locale=:locale LEFT JOIN o.attribute a WHERE o.attribute=:attribute ORDER BY o.sortOrder, o.code ASC at /srv/pim/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php:43)"} []

flagbird commented 3 years ago

Thank you for reporting this issue.