Question:
In general, there is a site on symfony, I change the driver to pdo_pgsql, the fixer that creates the default user is faulted.
INSERT INTO user (Usr_Username, Usr_Email,
ERROR: syntax error at or near "user"
In general, the system wants user to be in quotes since there is the same variable
This is how the fixture is written
$entity = new User();
$entity->setUsername("root");
$manager->persist($entity);
$entity
->setPassword("bla")
->setEmail("bla@gmail.com")
->setFirst("root")
->setLast("root")
->setOfficePhone("1")
->setMobilePhone("1")
->setTimeZone("11")
->setEnabled(true);
$manager->flush();
In general, how could this be fixed?
Answer:
In general, I will leave a note for myself, in the User Entity you need to write the name of the table in 3 quotes
/**
* @ORM\Table(name="""user""")
*/
Further, by analogy, in general, if there are problems, I only had this place.