Category: mysql

Doctrine generating query with wrong table alias – Symfony 5

I’m trying to insert an user in my database and doctrine generate before this : An exception occurred while executing ‘SELECT t0.id AS id_1, t0.name AS name_2, t0.first_name AS first_name_3, t0.username AS username_4, t0.password AS password_5, t0.aRoles AS aRoles_6, t0.create_date…

Doctrine query builder – where IN with non string column names can’t be generated

I can’t sleep because of this, I either must be missing something really obvious or it can’t be done like that. I have this Doctrine Query Builder thingy: $this->queryBuilder ->where(‘entity.id != ‘ . $id) ->andWhere( $this->queryBuilder->expr()->andX( $this->queryBuilder->expr()->in(“:validatedValue”, [‘slug’, ‘title’, ‘content’])…

Php Connection issue(SQL STATE 2002) with MySQL while connection string is right

I couldn’t push schema changes to MySQL DB from terminal. I’m always getting 2002 error. I have installed MySQL. It’s up and running. I’m using MAMP. Here is my .env file # In all environments, the following files are loaded…

Symfony API Platform very slow with MYQSL as persistance layer [closed]

This is moreover a generic/ architectural stuff.So let me explain the scenario. We are using Symfony API platform as our backend for REST API’s and our Front end is React. The api’s are becoming slow day by day. Our mysql…