Question
relation "app_table" does not exist LINE 1: SELECT COUNT(*)
- Posted on February 22, 2023
- DigitalOcean Managed PostgreSQL DatabaseDjangoPostgreSQLPython
Asked by SleepingNavySeal
i’m running this django app with postgresql db on digital ocean droplet, i’ve added a django model (table), when running makemigrations and migrate everything seems good, but when i try to render the page related to that model i get this error :
relation “app_table” does not exist LINE 1: SELECT COUNT(*)
I’ve tried many solutions except the one suggested to remove the entire database, i know it works, but i can’t simply remove my entire data!
do you guys have better solutions please ? much appreciated
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Hollie's Hub for Good
Working on improving health and education, reducing inequality, and spurring economic growth? We’d like to help.
Get started for free
Enter your email to get $200 in credit for your first 60 days with DigitalOcean.
New accounts only. By submitting your email you agree to our Privacy Policy.
Hi there,
If you were to run
python manage.py showmigrationsare your migrations listed as 'applied`?What I could suggest is connecting to your Postgres database using
psqlor any other SQL client, and verifying that the database and the database tables actually exist. If you do that withpsqlyou can follow the steps here:If everything looks good, I could suggest trying to reset the migrations and running them again from scratch.
Let me know how it goes!