Category: mysql

Symfony entitymanager refuses to insert one column

I’m trying to persist and flush a new entity into my database. However, one column: tblCompaniesServicesId, doesn’t get inserted along with the other data, resulting in a SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘tbl_companies_services_id’ cannot be null response. When I…

como hacer un inner join con 5 tablas relacionadas con symfony 4 y mostrarlo en una vista todos los datos? [closed]

reciene stoy entrando a progranmas con symfony y aun no domno mucho , mi consulta es : $em = $this->getDoctrine()->getManager(); $query = $em->createQuery(“SELECT P,E,I,T,S,R FROM AppEntityPersona P INNER JOIN AppEntityEstudio E WITH E.id = P.id INNER JOIN AppEntityIdioma I WITH…

How do I manage/close connections if I can’t change max_user_connections variable?

I am using shared hosting that has “max user connections” set to 30. I’ve contacted them and they said they could not change this value. By surfing through my website I get an exception thrown that says: SQLSTATE[42000]: Syntax error…