An exception occurred while executing query, column not found in Symfony 2.3

Question

While executing command through command line I'm getting this error "column not found"

    [Doctrine\DBAL\DBALException]                                                                                                                
  An exception occurred while executing 'SELECT t0.id AS id1, t0.first_name AS first_name2, t0.last_name AS last_name3, t0.email AS email4, t  
  0.gender AS gender5, t0.is_active AS is_active6, t0.vote_count AS vote_count7, t0.created_at AS created_at8, t0.updated_at AS updated_at9,   
  t0.fbUserId AS fbUserId10, t0.username AS username11, t0.password AS password12, t0.salt AS salt13 FROM users t0 WHERE t0.is_active = ?' wi  
  th params [0]:                                                                                                                               
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.fbUserId' in 'field list'                                                         

  [PDOException]                                                                        
  SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.fbUserId' in 'field list'

Any idea why only through command line I'm getting this error.

Ajeet Varma · Accepted Answer · 2014-07-07 07:40:19Z

3

Probably You have forgotten to update your schema , If it is please update your schema ..

answered Jul 7, 2014 at 7:40

Ajeet Varma

7264 silver badges21 bronze badges

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

Comments

zx485 · Accepted Answer · 2016-11-19 20:42:29Z

1

For version Symfony > 2.7 use:

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

For version Symfony < 2.7 use:

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

edited Nov 19, 2016 at 20:42

zx485

29.1k28 gold badges55 silver badges65 bronze badges

answered Nov 19, 2016 at 20:11

Philipe De Campos

111 bronze badge

1 Comment

milo526 Over a year ago

In your answer please include some explanation as to why this might help the op

Kasumi Gunasekara · Accepted Answer · 2018-01-17 11:41:39Z

0

The error is occurred since you have not updated your database schema according to your model. Use following command to update the schema:

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

or use following command for upper versions (> 2.8)

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

answered Jan 17, 2018 at 11:41

Kasumi Gunasekara

6298 silver badges11 bronze badges

Collectives™ on Stack Overflow

An exception occurred while executing query, column not found in Symfony 2.3

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related