django.db.utils.ProgrammingError: column tickets_ticket.track_code does not exist

Question

I used postgresql and I want add a new field to my model:

track_code = models.CharField(max_length=32, verbose_name=_('کد رهگیری'), default=generate_rrr_unique_trackcode)

but after migrate i received this error:

django.db.utils.ProgrammingError: column tickets_ticket.track_code does not exist
LINE 1: SELECT (1) AS "a" FROM "tickets_ticket" WHERE "tickets_ticke...

I used the command:

python3 manage.py migrate app_name 0001

and delete the last migration file and then try again but not working...

Check this answer. This may help you to overcome your problem. — Ankit Tiwari
– Ankit Tiwari, Commented Dec 21, 2022 at 8:13

Manoj Tolagekar · Accepted Answer · 2022-12-21 07:17:55Z

0

That is wrong command which is you used to migrate.

Migrate using below 3 commands:

python manage.py makemigrations appname

python manage.py sqlmigrate appname 0001 #This value will generate after makemigrations. It can be either 0001, 0002 and so on

python manage.py migrate

Note: don't forget to delete that last migration.

edited Dec 21, 2022 at 7:17

answered Dec 21, 2022 at 6:34

Manoj Tolagekar

2,0082 gold badges7 silver badges25 bronze badges

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

3 Comments

Mahdi Kh Over a year ago

Thanks but I received same error after step two!

Manoj Tolagekar Over a year ago

ok do one thing, delete all migrations file and db file and then try above commands

Mahdi Kh Over a year ago

Thanks I had to delete my postgres database and create again and then migrate... this is worked!

Collectives™ on Stack Overflow

django.db.utils.ProgrammingError: column tickets_ticket.track_code does not exist

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related