I have an unusual index, which is consists of: some_field, COALESCE(other_field, 0) So I'm trying to use it in description of my entity #[ORMUniqueConstraint( name: 'some_index', columns: ['some_field', 'COALESCE(other_field, 0)'] )] Of course, doctrine cannot find such column and returns…
In localhost, symfony console doctrine:database:create runs perfectly. But when I try to install the project for production on Ubunthu server, that does not work. I have a .env file with vars like : .env ###> symfony/framework-bundle ### APP_ENV=%APP_ENV% APP_SECRET=%APP_SECRET% ###<…
I try make charge test with a symfony web app. I've an Entity with 13 fields including 1 primary key and 7 foreiner keys. I've injected 40K data. My controller use a findAll() and KNP Paginator with a maximum of…
Given an entity Client, I have several columns, such as clientName, clientNo, etc. The table itself holds 250+ entries. There are several ManyToOne links, with tables that hold 500.000+ entries. For reasons I don't understand, this query: $queryBuilder = $this->getDoctrine()…
In Doctrine ORM there is a separation between persist() and flush() operations. Looks like whenever you want to insert/update your entity, you have to call two methods one by one. And most developers do it this way. But I wonder…
I recently upgraded a Laminas project from doctrine-migrations 1.4 to 3.6 and doctrine-orm-module from 1 to 5.3. On my deployment server, when running ./vendor/bin/doctrine-module sync-metadata-storage, I receive the following error: Fatal error: Uncaught DoctrineDBALException: The given 'driverClass' DoctrineDBALDriverPDOMySqlDriver has to…
Assume I have two tables related with one to many: Person: - name - age - phone Attributes: - fk - field - value for example Person: id name age phone 1 John 18 null 2 Sue 22 1234567890 3…
i am using friendsofsymfony bundle for authentication, the scenario is when i try to login, the user logged in successfully and getting access token, but in same request when some security events triggered and try to update lastLogin column in…
I have this: /** * @var string[] */ #[ORMColumn(type: 'json', nullable: true)] private array $roles = []; How can I change string[] to php8 attribute ? Something like #[Array(string)] I am working with Symfony and Doctrine, and I am trying…
I have a docker env set up with Symfony (5.x) & MariaDB - the docker-compose.yaml file contains the db configuration env variables. The .env.local file in the Symfony app uses the configuration variables from the docker-compose file to build out…