Error Symfony Doctrine PostgreSQL : SQLSTATE[42703]: Undefined column: 7 ERROR

Question

Hi i'm using Symfony and i'm trying to connect my project to a PostgreSQL server version 9.6. I'have already edited the .env file. Then i did my migrations. So I have my new tables in the database, but when i'm creating an account in my web app i have this error.

An exception occurred while executing 'SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.email AS email_4, t0.confirmation_token AS confirmation_token_5, t0.account_activated AS account_activated_6 FROM user t0 WHERE t0.email = ?' with params ["[email protected]"]:

SQLSTATE[42703]: Undefined column: 7 ERROR: column t0.id does not exist
LINE 1: SELECT t0.id AS id_1, t0.username AS username_2, t0.password...

I've already used

php bin/console doctrine:schema:update --force

But it changed nothing. I have also added the corrects extensions to the php.ini file.

Ngatia Frankline · Accepted Answer · 2020-04-15 17:55:02Z

8

In future, instead of changing table name, add @ORM\Table(name="user"). as shown below. Note the the grave accent ( ` ) diacritical mark.

namespace App\Entity;

use Doctrine\ORM\Mapping as ORM;
use Symfony\Bridge\Doctrine\Validator\Constraints\UniqueEntity;
use Symfony\Component\Security\Core\User\UserInterface;

/**
 * @ORM\Entity(repositoryClass="App\Repository\UserRepository")
 * @ORM\Table(name="`user`")
 * @UniqueEntity(fields={"username"}, message="There is already an account with this username")
 */
class User implements UserInterface
{
    /**
     * @ORM\Id()
     * @ORM\GeneratedValue()
     * @ORM\Column(type="integer")
     */

.....the rest of code continues...

answered Apr 15, 2020 at 17:55

Ngatia Frankline

3,2563 gold badges24 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dudy83 · Accepted Answer · 2020-02-13 13:25:49Z

4

Finally found an issue : "user" is keyword in postgreSQL. I renamed my entity and made migrations. Now it's working

answered Feb 13, 2020 at 13:25

Dudy83

731 silver badge5 bronze badges

Collectives™ on Stack Overflow

Error Symfony Doctrine PostgreSQL : SQLSTATE[42703]: Undefined column: 7 ERROR

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related