sonata-project / SonataAdminBundle

The missing Symfony Admin Generator
https://docs.sonata-project.org/projects/SonataAdminBundle
MIT License
2.1k stars 1.26k forks source link

Exception thrown filtering many to many #7859

Closed MylesKingsnorth closed 2 years ago

MylesKingsnorth commented 2 years ago

Environment

Sonata packages

show

``` sonata-project/admin-bundle 4.13.0 4.13.0 The missing Symfony Admin Generator sonata-project/block-bundle 4.14.0 4.14.0 Symfony SonataBlockBundle sonata-project/cache 2.2.0 2.2.0 Cache library Package sonata-project/cache is abandoned, you should avoid using it. No replacement was suggested. sonata-project/doctrine-extensions 1.17.0 1.17.0 Doctrine2 behavioral extensions sonata-project/doctrine-orm-admin-bundle 4.3.0 4.3.0 Integrate Doctrine ORM into the SonataAdminBundle sonata-project/exporter 2.13.0 2.13.0 Lightweight Exporter library sonata-project/form-extensions 1.17.1 1.17.1 Symfony form extensions sonata-project/twig-extensions 1.10.0 1.10.0 Sonata twig extensions ```

Symfony packages

show

``` symfony/asset v6.0.7 v6.1.0 Manages URL generation and versioning of web assets such as CSS stylesheets, JavaScript files and image files symfony/browser-kit v6.0.3 v6.1.0 Simulates the behavior of a web browser, allowing you to make requests, click on links and submit forms programmatically symfony/cache v6.0.10 v6.1.2 Provides an extended PSR-6, PSR-16 (and tags) implementation symfony/cache-contracts v3.1.1 v3.1.1 Generic abstractions related to caching symfony/config v6.0.9 v6.1.0 Helps you find, load, combine, autofill and validate configuration values of any kind symfony/console v6.0.10 v6.1.2 Eases the creation of beautiful and testable command line interfaces symfony/css-selector v6.0.3 v6.1.0 Converts CSS selectors to XPath expressions symfony/debug-bundle v6.0.3 v6.1.0 Provides a tight integration of the Symfony VarDumper component and the ServerLogCommand from MonologBridge into the Symfony full-stack framework symfony/dependency-injection v6.0.10 v6.1.2 Allows you to standardize and centralize the way objects are constructed in your application symfony/deprecation-contracts v3.1.1 v3.1.1 A generic function and convention to trigger deprecation notices symfony/doctrine-bridge v6.0.10 v6.1.2 Provides integration for Doctrine with various Symfony components symfony/doctrine-messenger v6.0.8 v6.1.1 Symfony Doctrine Messenger Bridge symfony/dom-crawler v6.0.9 v6.1.0 Eases DOM navigation for HTML and XML documents symfony/dotenv v6.0.5 v6.1.0 Registers environment variables from a .env file symfony/error-handler v6.0.9 v6.1.0 Provides tools to manage errors and ease debugging PHP code symfony/event-dispatcher v6.0.9 v6.1.0 Provides tools that allow your application components to communicate with each other by dispatching events and listening to them symfony/event-dispatcher-contracts v3.1.1 v3.1.1 Generic abstractions related to dispatching event symfony/expression-language v6.0.10 v6.1.2 Provides an engine that can compile and evaluate expressions symfony/filesystem v6.0.9 v6.1.0 Provides basic utilities for the filesystem symfony/finder v6.0.8 v6.1.0 Finds files and directories via an intuitive fluent interface symfony/flex v2.2.2 v2.2.2 Composer plugin for Symfony symfony/form v6.0.10 v6.1.2 Allows to easily create, process and reuse HTML forms symfony/framework-bundle v6.0.10 v6.1.2 Provides a tight integration between Symfony components and the Symfony full-stack framework symfony/http-client v6.0.9 v6.1.2 Provides powerful methods to fetch HTTP resources synchronously or asynchronously symfony/http-client-contracts v3.1.1 v3.1.1 Generic abstractions related to HTTP clients symfony/http-foundation v6.0.10 v6.1.2 Defines an object-oriented layer for the HTTP specification symfony/http-kernel v6.0.10 v6.1.2 Provides a structured process for converting a Request into a Response symfony/intl v6.0.8 v6.1.0 Provides a PHP replacement layer for the C intl extension that includes additional data from the ICU library symfony/mailer v6.0.10 v6.1.2 Helps sending emails symfony/maker-bundle v1.43.0 v1.43.0 Symfony Maker helps you create empty commands, controllers, form classes, tests and more so you can forget about writing boilerplate code. symfony/messenger v6.0.10 v6.1.2 Helps applications send and receive messages to/from other applications or via message queues symfony/mime v6.0.10 v6.1.1 Allows manipulating MIME messages symfony/monolog-bridge v6.0.10 v6.1.2 Provides integration for Monolog with various Symfony components symfony/monolog-bundle v3.8.0 v3.8.0 Symfony MonologBundle symfony/notifier v6.0.8 v6.1.0 Sends notifications via one or more channels (email, SMS, ...) symfony/options-resolver v6.0.3 v6.1.0 Provides an improved replacement for the array_replace PHP function symfony/password-hasher v6.0.8 v6.1.0 Provides password hashing utilities symfony/phpunit-bridge v6.1.2 v6.1.2 Provides utilities for PHPUnit, especially user deprecation notices management symfony/polyfill-intl-grapheme v1.26.0 v1.26.0 Symfony polyfill for intl's grapheme_* functions symfony/polyfill-intl-icu v1.26.0 v1.26.0 Symfony polyfill for intl's ICU-related data and classes symfony/polyfill-intl-idn v1.26.0 v1.26.0 Symfony polyfill for intl's idn_to_ascii and idn_to_utf8 functions symfony/polyfill-intl-normalizer v1.26.0 v1.26.0 Symfony polyfill for intl's Normalizer class and related functions symfony/polyfill-mbstring v1.26.0 v1.26.0 Symfony polyfill for the Mbstring extension symfony/polyfill-php81 v1.26.0 v1.26.0 Symfony polyfill backporting some PHP 8.1+ features to lower PHP versions symfony/process v6.0.8 v6.1.0 Executes commands in sub-processes symfony/property-access v6.0.8 v6.1.0 Provides functions to read and write from/to an object or array using a simple string notation symfony/property-info v6.0.10 v6.1.2 Extracts information about PHP class' properties using metadata of popular sources symfony/proxy-manager-bridge v6.0.6 v6.1.0 Provides integration for ProxyManager with various Symfony components symfony/routing v6.0.8 v6.1.1 Maps an HTTP request to a set of configuration variables symfony/runtime v6.0.8 v6.1.1 Enables decoupling PHP applications from global state symfony/security-acl v3.3.1 v3.3.1 Symfony Security Component - ACL (Access Control List) symfony/security-bundle v6.0.9 v6.1.0 Provides a tight integration of the Security component into the Symfony full-stack framework symfony/security-core v6.0.8 v6.1.2 Symfony Security Component - Core Library symfony/security-csrf v6.0.9 v6.1.0 Symfony Security Component - CSRF Library symfony/security-http v6.0.10 v6.1.2 Symfony Security Component - HTTP Integration symfony/serializer v6.0.10 v6.1.2 Handles serializing and deserializing data structures, including object graphs, into array structures or other formats like XML and JSON. symfony/service-contracts v3.1.1 v3.1.1 Generic abstractions related to writing services symfony/stopwatch v6.0.5 v6.1.0 Provides a way to profile code symfony/string v6.0.10 v6.1.2 Provides an object-oriented API to strings and deals with bytes, UTF-8 code points and grapheme clusters in a unified way symfony/translation v6.0.9 v6.1.0 Provides tools to internationalize your application symfony/translation-contracts v3.1.1 v3.1.1 Generic abstractions related to translation symfony/twig-bridge v6.0.10 v6.1.2 Provides integration for Twig with various Symfony components symfony/twig-bundle v6.0.8 v6.1.1 Provides a tight integration of Twig into the Symfony full-stack framework symfony/validator v6.0.10 v6.1.1 Provides tools to validate values symfony/var-dumper v6.0.9 v6.1.0 Provides mechanisms for walking through any arbitrary PHP variable symfony/var-exporter v6.0.10 v6.1.1 Allows exporting any serializable PHP data structure to plain PHP code symfony/web-link v6.0.3 v6.1.0 Manages links between resources symfony/web-profiler-bundle v6.0.10 v6.1.2 Provides a development tool that gives detailed information about the execution of any request symfony/yaml v6.0.10 v6.1.2 Loads and dumps YAML files ```

PHP version

8.1.6

Subject

When filtering an admin with a many to many relationship, the error below is thrown. I have a company entity which has a many to many with a tag entity. On the company list, if I try to filter by one of the tags the error below is caused.

Minimal repository with the bug

https://github.com/MylesKingsnorth/sonata-many-to-many-filter

Steps to reproduce

Using the repository above, go to /admin, then company list, then click filters and check tag, then pick the Test tag.

Actual results

An exception has been thrown during the rendering of a template ("[Semantical Error] line 0, col 43 near 'tags = :tags_0': Error: Invalid PathExpression. StateFieldPathExpression or SingleValuedAssociationField expected.").

Can provide more of the trace if need be.

Twig\Error\RuntimeError:
An exception has been thrown during the rendering of a template ("[Semantical Error] line 0, col 43 near 'tags = :tags_0': Error: Invalid PathExpression. StateFieldPathExpression or SingleValuedAssociationField expected.").

  at vendor/sonata-project/admin-bundle/src/Resources/views/CRUD/base_list.html.twig:34
VincentLanglet commented 2 years ago

Works fine if you use

$filter->add('tags.id', ...