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](https://stackoverflow.com/a/42614147/14457833). This may help you to overcome your problem. — Ankit Tiwari, Dec 21 '22 at 08:13

Manoj Tolagekar · Answer 1 · 2022-12-21T07:17:55.853

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 '22 at 07:17

answered Dec 21 '22 at 06:34

Manoj Tolagekar

1,816
2
5
22

Thanks but I received same error after step two! – Mahdi Kh Dec 21 '22 at 07:59
ok do one thing, delete all migrations file and db file and then try above commands – Manoj Tolagekar Dec 21 '22 at 08:36
Thanks I had to delete my postgres database and create again and then migrate... this is worked! – Mahdi Kh Dec 25 '22 at 18:02

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

1 Answers1