django.db.utils.ProgrammingError: (1146, "Table 'main.socialaccount_socialapp_sites' doesn't exist")

Question

I'm trying to implement Google Login on my Django production website. It works fine on development server, but on my production server, I face this issue after having run python manage.py migrate. I'm not sure what to do, I already tried deleting all the migrations and re-running makemigrations and migrate.

not much to go on... Do you have different types of databases between dev and prod? Does your prod db allow periods in the name? Do you see any error messages when running the migrations? — Tim Tisdall
– Tim Tisdall, Commented Jul 6, 2022 at 15:06

Kikito · Accepted Answer · 2022-07-06 15:27:24Z

1

Checklist

run showmigrations to see which migrations are done.
if the relevant migration containing the table appears to be migrated, rollback and run migrate again.
when you want to regenerate migration files, you need to first rollback while you have the old migration files.
if you'd like to check which tables exist, use dbshell or other shell depending on the database you're using.

Other things

I would not recommend regenerating migration files just because there is some db issue.

answered Jul 6, 2022 at 15:27

Kikito

2241 silver badge6 bronze badges

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

1 Comment

Kikito Over a year ago

please let me know if you got more questions!

Collectives™ on Stack Overflow

django.db.utils.ProgrammingError: (1146, "Table 'main.socialaccount_socialapp_sites' doesn't exist")

1 Answer 1

Checklist

Other things

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Checklist

Other things

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related