Heroku No migrations to apply

Question

I'm having trouble with my database at Heroku:

I've added some models for my App and whenever I run makemigrations it detects those changes. However when I run migrate it only says no migrations to apply. Please help!

that is not a big deal some time this happens because maybe table already exits that's why it says no migrations to apply try to run you server if you get any error like no such table than let me know — Ankit Tiwari, Jun 03 '21 at 07:39
Does this answer your question? [Django 1.7 - "No migrations to apply" when run migrate after makemigrations](https://stackoverflow.com/questions/25958708/django-1-7-no-migrations-to-apply-when-run-migrate-after-makemigrations) — Ankit Tiwari, Jun 03 '21 at 07:41
there's no table. the server says programming error: no column"position" exists in clients — Tyrone Jasper Galang, Jun 03 '21 at 07:42
I dont know how to execute the solution and I think it doesn't work on my problem — Tyrone Jasper Galang, Jun 03 '21 at 07:43
and than try to run again makemigrations and migrate command — Ankit Tiwari, Jun 03 '21 at 07:44
Let us [continue this discussion in chat](https://chat.stackoverflow.com/rooms/233265/discussion-between-ankit-tiwari-and-tyrone-jasper-galang). — Ankit Tiwari, Jun 03 '21 at 07:45

Tyrone Jasper Galang · Accepted Answer · 2021-06-08T02:47:51.627

I'VE FINALLY FIXED IT!!! This is what I did:

First I did a backup Download by heroku pg:backups:restore capture

then heroku pg:backups:restore download it made a "latest.dump" file

then I used heroku pg:reset it deleted the recent database of host

then I applied my fixes on my models and forms new fields has to have "defaults=None" for models with Data you want to preserve (If you won't do this, the merge for this model won't take effect and will be cancelled)

then I run heroku run bash run python manage.py makemigrations appname then migrate

and then used "pg_restore --verbose --clean --no-acl --no-owner -h yourDBhost -U yourDBuser -d yourDBname latest.dump" (Your database credentials will be found on your postgresql addon settings) and then type or copy-paste yourDBpassword(from credentials also) to merge the backed up database with the new one with changes

and know it's done and perfectly working!

Good to know finally you solved your problem. – Ankit Tiwari Jun 09 '21 at 18:30 — Ankit Tiwari, Jun 09 '21 at 18:30

Heroku No migrations to apply

1 Answers1