Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Closed
tdoedtmann opened this issue Aug 5, 2021 · 1 comment · Fixed by #65
Closed
Milestone

Comments

@tdoedtmann
Copy link

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
Copy link
Collaborator

Thank you for reporting this issue.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants