Django Programming error column does not exist even after running migrations

by

I got the same problem (column not exist) but when I try to run migrate not with makemigrations (it is the same issue I believe)

  • Cause: I removed the migration files and replaced them with single pretending intial migration file 0001 before running the migration for the last change

  • Solution:

    1. Drop tables involved in that migration of that app (consider a backup workaround if any)
    2. Delete the rows responsible of the migration of that app from the table django_migrations in which migrations are recorded, This is how Django knows which migrations have been applied and which still need to be applied.

And here is how solve this problem:

  • log in as postgres user (my user is called posgres):

    sudo -i -u postgres

  • Open an sql terminal and connect to your database:

    psql -d database_name

  • List your table and spot the tables related to that app:

    \dt

  • Drop them (consider drop order with relations):

    DROP TABLE tablename ;

  • List migration record, you will see migrations applied classified like so:

id | app | name | applied
–+——+——–+———+

SELECT * FROM django_migrations;

  • Delete rows of migrations of that app (you can delete by id or by app, with app don’t forget ‘quotes’):

    DELETE FROM django_migrations WHERE app='yourapp';

  • log out and run your migrations merely (maybe run makemigrations in your case):

    python manage.py migrate --settings=your.settings.module_if_any

Note: it is possible that in your case will not have to drop all the tables of that app and not all the migrations, just the ones of the models causing the problem.

I wish this can help.

More Related Contents:

  1. How to revert the last migration?
  2. Django migrate –fake and –fake-initial explained
  3. django 1.7 migrate gets error “table already exists”
  4. How to reset migrations in Django 1.7
  5. Django data migration when changing a field to ManyToMany
  6. Django 1.8: Create initial migrations for existing schema
  7. Disable migrations when running unit tests in Django 1.7
  8. Creating Partial Indexes with Django 1.7
  9. Django Migrations Add Field with Default as Function of Model
  10. How to simplify migrations in Django 1.7?
  11. Proper way to handle multiple forms on one page in Django
  12. Using a UUID as a primary key in Django models (generic relations impact)
  13. Django ManyToMany filter()
  14. Limit foreign key choices in select in an inline form in admin
  15. Django get the static files URL in view
  16. Confusion in Django admin, static and media files
  17. Django multi-select widget?
  18. Using Heroku for Django Media Files
  19. Where can I find the error logs of nginx, using FastCGI and Django?
  20. Django’s self.client.login(…) does not work in unit tests
  21. Django “xxxxxx Object” display customization in admin action sidebar
  22. How to install libpq-fe.h?
  23. Using Django auth UserAdmin for a custom user model
  24. List field in model?
  25. Django class based view ListView with form
  26. Django – limiting query results
  27. Django migration with uuid field generates duplicated values
  28. How to have 2 different admin sites in a Django project?
  29. How to pass extra context to Django Rest Framework serializers
  30. Get type of Django form widget from within template

Leave a Comment