Django DB Migration InconsistentMigrationHistory when running migrate

Question

I am unable to migrate my django after running python ./manage.py migrate.

This is what showmigrations is displaying

customerweb
 [X] 0001_initial
 [X] 0002_user_industry
 [X] 0003_auto_20220209_1737
 [X] 0004_userconfiguration_night_surcharge_exempt
 [ ] 0005_auto_20220614_1100
 [X] 0006_orderdelivery_is_order_unique
 [ ] 0007_orderdelivery_client_reference_no

I have tried --fake as well as trying to move back by one migrate using

python ./manage.py migrate <app_name> <000x_migrate_file>

all these is not working as the exeception keeps prompting InconsistentMigrationHistory. I have tried deleting the migration folders as well (keeping init only) but does not work as well.

Check django_migrations table in db where the migration history is kept. Try and sync your files to records in django_migrations table while making sure that your models.py is correct and in sync with your database. — N3mo, Jul 06 '22 at 06:06
@N3mo for the syncing portion, would it be achievable via --run-syncdb? — stranger, Jul 06 '22 at 06:15
if you have deleted migrations folder try makemigrations with app names in order of creation date — Shishir Subedi, Jul 06 '22 at 06:17

Himanshu Poddar · Accepted Answer · 2022-07-06T06:30:49.090

1

So Django admin expects a default auth model which is AUTH_USER_MODEL. Admin app apply migration as django's auth model Now since you changes the dependency hence the error. Please follow the below steps

Take a backup of your database
Comment out your created app in INSTALLED_APPS and AUTH_USER_MODEL = 'account.User' in your settings.py in project folder
Run python manage.py admin zero
Uncomment lines commented in step 2
Run python manage.py migrate

edited Jul 06 '22 at 06:30

answered Jul 06 '22 at 06:06

Himanshu Poddar

7,112
10
47
93

Im using Postgresql. Does this still applies? – stranger Jul 06 '22 at 06:18
try my updated answer – Himanshu Poddar Jul 06 '22 at 06:21
1

worked like a charm! omg thank you! will accept yours as the answer. Thank you for your time again! – stranger Jul 06 '22 at 06:25

Django DB Migration InconsistentMigrationHistory when running migrate

1 Answers1