Has no association named translations

Open Doreitor opened this issue 3 years ago • 1 comments

Composer packages

$ composer show a2lix/auto-form-bundle a2lix/translation-form-bundle antishov/doctrine-extensions-bundle beberlei/doctrineextensions behat/transliterator brick/math composer/package-versions-deprecated damienharper/auditor damienharper/auditor-bundle doctrine/annotations doctrine/cache doctrine/collections doctrine/common doctrine/data-fixtures doctrine/dbal doctrine/deprecations doctrine/doctrine-bundle doctrine/doctrine-fixtures-bundle doctrine/doctrine-migrations-bundle doctrine/event-manager doctrine/inflector doctrine/instantiator doctrine/lexer doctrine/migrations doctrine/orm doctrine/persistence doctrine/sql-formatter egulias/email-validator ezyang/htmlpurifier friendsofphp/proxy-manager-lts friendsofsymfony/rest-bundle gedmo/doctrine-extensions google/recaptcha imagine/imagine ip2location/ip2location-php jms/metadata jms/serializer jms/serializer-bundle karser/karser-recaptcha3-bundle knplabs/doctrine-behaviors knplabs/knp-components knplabs/knp-menu knplabs/knp-menu-bundle knplabs/knp-paginator-bundle kphoen/sitemap-bundle kphoen/sitemap-generator laminas/laminas-code liip/imagine-bundle maennchen/zipstream-php markbaker/complex markbaker/matrix monolog/monolog myclabs/php-enum nelmio/cors-bundle nette/utils nikic/php-parser phpoffice/phpspreadsheet phpstan/phpdoc-parser presta/sitemap-bundle psr/cache psr/container psr/http-client psr/http-factory psr/http-message psr/log psr/simple-cache ramsey/collection ramsey/uuid sensio/framework-extra-bundle swiftmailer/swiftmailer symfony/apache-pack symfony/asset symfony/cache symfony/cache-contracts symfony/config symfony/console symfony/debug symfony/dependency-injection symfony/deprecation-contracts symfony/doctrine-bridge symfony/dotenv symfony/error-handler symfony/event-dispatcher symfony/event-dispatcher-contracts symfony/expression-language symfony/filesystem symfony/finder symfony/flex symfony/form symfony/framework-bundle symfony/http-client symfony/http-client-contracts symfony/http-foundation symfony/http-kernel symfony/intl symfony/lock symfony/maker-bundle symfony/mime symfony/monolog-bridge symfony/monolog-bundle symfony/options-resolver symfony/polyfill-intl-grapheme symfony/polyfill-intl-idn symfony/polyfill-intl-normalizer symfony/polyfill-mbstring symfony/polyfill-php72 symfony/polyfill-php73 symfony/polyfill-php80 symfony/polyfill-php81 symfony/process symfony/property-access symfony/property-info symfony/routing symfony/security-bundle symfony/security-core symfony/security-csrf symfony/security-guard symfony/security-http symfony/service-contracts symfony/stopwatch symfony/string symfony/swiftmailer-bundle symfony/translation symfony/translation-contracts symfony/twig-bridge symfony/twig-bundle symfony/validator symfony/var-dumper symfony/var-exporter symfony/web-profiler-bundle symfony/web-server-bundle symfony/yaml twig/extra-bundle twig/intl-extra twig/twig vich/uploader-bundle willdurand/jsonp-callback-validator willdurand/negotiation

PHP version

$ php -v PHP 8.1.6 (cli) Copyright (c) The PHP Group Zend Engine v4.1.6,

Subject

[Semantical ': Error: App\Entity\Insight

Environment

0.4.3 Automate form building 3.2.1 Translate your doctrine objects easily with some helpers v1.4.3 Forked from stof/doctrine-extensions-bundle integration of the gedmo/doctrine-extensions with Symfony 4 v1.3.0 A set of extensions to Doctrine 2 that add support for additional query functions available in MySQL, Oracle, PostgreSQL and SQLite. v1.5.0 String transliterator 0.9.3 Arbitrary-precision arithmetic library 1.11.99.3 Composer plugin that provides efficient querying for installed package versions (no runtime IO) 2.0.3 The missing audit log library. 5.0.2 Integrate auditor library in your Symfony projects. 1.13.3 Docblock Annotations Parser 2.2.0 PHP Doctrine Cache library is a popular cache implementation that supports many different drivers such as redis, memcache, apc, mongodb and others. 1.6.8 PHP Doctrine Collections library that adds additional functionality on top of PHP arrays. 3.3.0 PHP Doctrine Common project is a library that provides additional functionality that other Doctrine projects depend on such as better reflection support, prox... 1.5.3 Data Fixtures for all Doctrine Object Managers 2.13.9 Powerful PHP database abstraction layer (DBAL) with many features for database schema introspection and management. v1.0.0 A small layer on top of trigger_error(E_USER_DEPRECATED) or PSR-3 logging with options to disable all deprecations or selectively for packages. 2.7.0 Symfony DoctrineBundle 3.4.2 Symfony DoctrineFixturesBundle 2.2.3 Symfony DoctrineMigrationsBundle 1.1.1 The Doctrine Event Manager is a simple PHP event system that was built to be used with the various Doctrine projects. 2.0.4 PHP Doctrine Inflector is a small library that can perform string manipulations with regard to upper/lowercase and singular/plural forms of words. 1.4.1 A small, lightweight utility to instantiate objects in PHP without invoking their constructors 1.2.3 PHP Doctrine Lexer parser library that can be used in Top-Down, Recursive Descent Parsers. 2.3.5 PHP Doctrine Migrations project offer additional functionality on top of the database abstraction layer (DBAL) for versioning your database schema and easily ... 2.12.3 Object-Relational-Mapper for PHP 2.5.3 The Doctrine Persistence project is a set of shared interfaces and functionality that the different Doctrine object mappers share. 1.1.3 a PHP SQL highlighting library 3.2.1 A library for validating emails against several RFCs v4.14.0 Standards compliant HTML filter written in PHP v1.0.12 Adding support for a wider range of PHP versions to ocramius/proxy-manager 3.1.1 This Bundle provides various tools to rapidly develop RESTful API's with Symfony v3.7.0 Doctrine2 behavioral extensions 1.2.4 Client library for reCAPTCHA, a free service that protects websites from spam and abuse. 1.3.2 Image processing for PHP 5.3 8.3.0 [Official Release] IP2Location PHP API to get location info from IPv4 and IPv6 address. 2.6.1 Class/method/property metadata management in PHP 3.17.1 Library for (de-)serializing data of any complexity; supports XML, JSON, and YAML. 3.10.0 Allows you to easily serialize, and deserialize data of any complexity v0.1.22 Google ReCAPTCHA v3 for Symfony 2.3.0 Doctrine Behavior Traits v3.4.0 Knplabs component library v3.3.0 An object oriented menu library v3.2.0 This bundle provides an integration of the KnpMenu library v5.8.0 Paginator bundle for Symfony to automate pagination and simplify sorting and other features 2.0.1 Provides a way to create/generate a sitemap using Doctrine, etc. 1.4.1 Provides a way to create/generate a sitemap using Propel, Doctrine, etc. 4.5.2 Extensions to the PHP Reflection API, static code scanning, and code generation 2.6.1 This bundle provides an image manipulation abstraction toolkit for Symfony-based projects. 2.2.1 ZipStream is a library for dynamically streaming dynamic zip files from PHP without writing to the disk at all on the server. 3.0.1 PHP Class for working with complex numbers 3.0.0 PHP Class for working with matrices 1.27.1 Sends your logs to files, sockets, inboxes, databases and various web services 1.8.3 PHP Enum implementation 2.2.0 Adds CORS (Cross-Origin Resource Sharing) headers support in your Symfony application v3.2.7 🛠 Nette Utils: lightweight utilities for string & array manipulation, image handling, safe JSON e ncoding/decoding, validation, slug or strong password gen... v4.14.0 A PHP parser written in PHP 1.24.0 PHPSpreadsheet - Read, Create and Write Spreadsheet documents in PHP - Spreadsheet engine 1.6.4 PHPDoc parser with support for nullable, intersection and generic types v2.5.0 A Symfony bundle that provides tools to build your application sitemap. 2.0.0 Common interface for caching libraries 1.1.2 Common Container Interface (PHP FIG PSR-11) 1.0.1 Common interface for HTTP clients 1.0.1 Common interfaces for PSR-7 HTTP message factories 1.0.1 Common interface for HTTP messages 1.1.4 Common interface for logging libraries 2.0.0 Common interfaces for simple caching 1.2.2 A PHP library for representing and manipulating collections. 4.3.1 A PHP library for generating and working with universally unique identifiers (UUIDs). v5.6.1 This bundle provides a way to configure your controllers with annotations v6.3.0 Swiftmailer, free feature-rich PHP mailer v1.0.1 A pack for Apache support in Symfony v4.4.40 Manages URL generation and versioning of web assets such as CSS stylesheets, JavaScript files and image files v5.4.10 Provides an extended PSR-6, PSR-16 (and tags) implementation v2.5.2 Generic abstractions related to caching v4.4.42 Helps you find, load, combine, autofill and validate configuration values of any kind v4.4.43 Eases the creation of beautiful and testable command line interfaces v4.4.41 Provides tools to ease debugging PHP code v4.4.43 Allows you to standardize and centralize the way objects are constructed in your application v3.1.1 A generic function and convention to trigger deprecation notices v4.4.43 Provides integration for Doctrine with various Symfony components v4.4.37 Registers environment variables from a .env file v4.4.41 Provides tools to manage errors and ease debugging PHP code v4.4.42 Provides tools that allow your application components to communicate with each other by dispatching events and listening to them v1.1.13 Generic abstractions related to dispatching event v6.1.2 Provides an engine that can compile and evaluate expressions v5.4.9 Provides basic utilities for the filesystem v5.4.8 Finds files and directories via an intuitive fluent interface v1.19.2 Composer plugin for Symfony v4.4.43 Allows to easily create, process and reuse HTML forms v4.4.43 Provides a tight integration between Symfony components and the Symfony full-stack framework v4.4.42 Provides powerful methods to fetch HTTP resources synchronously or asynchronously v2.5.2 Generic abstractions related to HTTP clients v5.4.10 Defines an object-oriented layer for the HTTP specification v4.4.43 Provides a structured process for converting a Request into a Response v5.4.10 Provides a PHP replacement layer for the C intl extension that includes additional data from the ICU library v6.1.1 Creates and manages locks, a mechanism to provide exclusive access to a shared resource v1.39.0 Symfony Maker helps you create empty commands, controllers, form classes, tests and more so you can forget about writing boilerplate code. v5.4.10 Allows manipulating MIME messages v4.4.43 Provides integration for Monolog with various Symfony components v3.8.0 Symfony MonologBundle v5.4.3 Provides an improved replacement for the array_replace PHP function v1.26.0 Symfony polyfill for intl's grapheme_* functions v1.26.0 Symfony polyfill for intl's idn_to_ascii and idn_to_utf8 functions v1.26.0 Symfony polyfill for intl's Normalizer class and related functions v1.26.0 Symfony polyfill for the Mbstring extension v1.26.0 Symfony polyfill backporting some PHP 7.2+ features to lower PHP versions v1.26.0 Symfony polyfill backporting some PHP 7.3+ features to lower PHP versions v1.26.0 Symfony polyfill backporting some PHP 8.0+ features to lower PHP versions v1.26.0 Symfony polyfill backporting some PHP 8.1+ features to lower PHP versions v5.4.8 Executes commands in sub-processes v5.4.8 Provides functions to read and write from/to an object or array using a simple string notation v5.4.10 Extracts information about PHP class' properties using metadata of popular sources v4.4.41 Maps an HTTP request to a set of configuration variables v4.4.42 Provides a tight integration of the Security component into the Symfony full-stack framework v4.4.41 Symfony Security Component - Core Library v4.4.37 Symfony Security Component - CSRF Library v4.4.37 Symfony Security Component - Guard v4.4.42 Symfony Security Component - HTTP Integration v2.5.2 Generic abstractions related to writing services v4.4.38 Provides a way to profile code v5.4.10 Provides an object-oriented API to strings and deals with bytes, UTF-8 code points and grapheme clusters in a unified way v3.5.4 Symfony SwiftmailerBundle v4.4.41 Provides tools to internationalize your application v2.5.2 Generic abstractions related to translation v4.4.42 Provides integration for Twig with various Symfony components v4.4.41 Provides a tight integration of Twig into the Symfony full-stack framework v4.4.43 Provides tools to validate values v5.4.9 Provides mechanisms for walking through any arbitrary PHP variable v6.1.1 Allows exporting any serializable PHP data structure to plain PHP code v4.4.43 Provides a development tool that gives detailed information about the execution of any request v4.4.37 Provides commands for running applications using the PHP built-in web server v4.4.43 Loads and dumps YAML files v3.4.0 A Symfony bundle for extra Twig extensions v3.4.0 A Twig extension for Intl v3.4.1 Twig, the flexible, fast, and secure template language for PHP 1.19.1 Ease file uploads attached to entities v1.1.0 JSONP callback validator. 3.1.0 Content Negotiation tools for PHP provided as a standalone library. (built: May 11 2022 08:55:59) (ZTS Visual C++ 2019 x64) Copyright (c) Zend Technologies Error] line 0, col 61 near 't has no association named translations

Steps to reproduce

SQL Server

Expected results

Actual results

Doctrine\ORM\Query
QueryException SELECT i FROM App\Entity\Insight i INNER JOIN i.translations t WHERE i.regions LIKE :region AND i.languages LIKE :language AND t.locale LIKE :local AND i.published = true ORDER BY t.title ASC

Jul 10 '22 14:07 Doreitor

`public function findByFeatured(Request $request) { $entityManager = $this->getEntityManager();

    $region = $request->attributes->get('_region');
    $language = $request->attributes->get('_locale');

    $query = $entityManager->createQuery(
        "SELECT i FROM App\Entity\Insight i INNER JOIN i.translations t
            WHERE i.regions LIKE :region AND i.languages LIKE :language AND t.locale LIKE :local AND i.published = true
            ORDER BY t.title ASC "
    )->setParameters(array(
            'language' => '%'.$language.'%',
            'region' => '%'.$region.'%',
            'local' => '%'.$language.'%',
    ));

    return $query->getResult();
}`

CREATE TABLE [dbo].[Insight]( [id] [int] IDENTITY(1,1) NOT NULL, [home_id] [int] NULL, [createdAt] [datetime2](6) NULL, [updatedAt] [datetime2](6) NULL, [languages] [varchar](max) NOT NULL, [regions] [varchar](max) NOT NULL, [metaRobots] [nvarchar](128) NULL, [published] [bit] NULL, [headerType] [nvarchar](64) NOT NULL, [showIntroBlock] [bit] NOT NULL, [showKnowledgeBlock] [bit] NOT NULL, [showEventsBlock] [bit] NOT NULL, [showLegalNoveltiesBlock] [bit] NOT NULL, [showCaseStudiesBlock] [bit] NOT NULL, [oldId] [int] NULL, [showTeamsBlock] [bit] NULL, [featured] [bit] NULL, [private] [bit] NULL, [activity_id] [int] NULL)

CREATE TABLE [dbo].[InsightTranslation]( [id] [int] IDENTITY(1,1) NOT NULL, [translatable_id] [int] NULL, [title] [nvarchar](255) NOT NULL, [summary] [varchar](max) NULL, [description] [varchar](max) NULL, [slug] [nvarchar](128) NOT NULL, [metaTitle] [nvarchar](255) NULL, [metaDescription] [nvarchar](255) NULL, [locale] [nvarchar](255) NOT NULL)

Jul 11 '22 06:07 Doreitor