CODEWITHSUNDEEP
pythondjangopostgresql
Miguel Machado
Miguel Machado

Reputation: 351

Django migration relation does not exist

So I'm trying to run the initial migrations on a django app and when I try to run the migrate command (python manage.py migrate or makemigrations) I get the following error:

psycopg2.ProgrammingError: relation "dotworks_server_internship" does not exist
LINE 1: ...s", "dotworks_server_internship"."questions" FROM "dotworks_...
                                                             ^

I'm on a Windows environment using Django 1.9.6 and my database is postgres. Plus, I'm using PGAdmin to manage my database.

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql',
        'NAME': 'dotworks',
        'USER': 'postgres',
        'PASSWORD': 'mypasswordgoeshere',
        'HOST': 'localhost',
        'PORT': '5432',
    }
}

Upvotes: 18

Views: 24793

Answers (11)

minsu kim
minsu kim

Reputation: 41

First remove all urls from urls.py.

Create simple function view for viewing nothing:

def simple(request):
    context = {}
    return render(request, 'base.html', context)

and add urls to urls.py

do migrate:

python manage.py migrate

after migrate, recover the deleted urls.py contents

Upvotes: 0

Mattchoo
Mattchoo

Reputation: 421

I had this problem and I had to comment out everything in urls.py that referenced views.py, then run makemigrations.

Upvotes: 28

Paramjeet
Paramjeet

Reputation: 47

This error may be related to previous database error. So if you created a new database and you also face that type of error, you can simply run the command with the app name:

python manage.py makemigrations <"app name">
python manage.py migrate <"app name">

Upvotes: 0

Brian Kyckelhahn
Brian Kyckelhahn

Reputation: 342

Django is running an optional check. Pass the --skip-checks flag in your call to manage.py.

Upvotes: 2

AbdolHosein
AbdolHosein

Reputation: 558

When you run a query before applying migrations this error appears.

If you got this error during python manage.py makemigrations or python manage.py migrate you must consider that makemigrations and migrate commands run after successful django bootstrap! So this error happens when you run a query during django bootstrap! So you must find the place you run this query during bootstrap progress.

For example, during bootstrap, django reads root {project}/urls.py and its nested imports. If you use views or viewsets in urls.py and they are run a query during initializing (in their __init__ method or __init__.pyfile or somewhere etc.), it happens!

In this situation and similars, you must comment out any entry in urls.py and similar files which cause running a query during bootstrap and prevent them from running by raising of exception during bootstrap! makemigrations and migrate need successful bootstrap to be run!

If your commented out code needs to makemigrations and migrate handcooks :D, it needs to be patient and be silent for a cycle or a while ;), and after a successful migrations it could be active and verbose ;D.

Upvotes: 3

alireza ranjbaran
alireza ranjbaran

Reputation: 1125

Your app is trying to call some DB entries that does not exist. If you are trying to migrate it to a new database, one of your options is to export a dump of old database and import it to your new DB.

For example in PostgreSQL, import the database using below command then migration will work!

sudo -u postgres -i psql mydb < mydb-export.sql

Upvotes: 1

PleaseHelp
PleaseHelp

Reputation: 162

For me the error came from some initialization code I put into the app.ready() method. Commenting that part of code allowed me to run the command makemigrations without any issue.

I believe app.ready is called at some point by manage.py even for the makemigrations command, which caused my code to query my database before any migration.

I found the problematic code thanks to the traceback.

Upvotes: 0

bandakoo
bandakoo

Reputation: 186

Make sure that you don't have any class variables in your code that are calling Django manager

For example:

class SomeViewSet(viewsets.ViewSet):
    se = SomeEntity.objects.first()  # fetching some entity on the class level

    def list(self, request):
    # the rest of the code

So, when you try to create/apply migrations, this variable will also try to initialise, and will try to access SomeEntity, but at that moment that entity doesn't even exist, and the error occurs.

Upvotes: 17

PHPirate
PHPirate

Reputation: 7572

If all other solutions mentioned fail, if you are still in development probably the easiest solution is dropping the database (in pgAdmin 4 2.0, right-click on database) and then run makemigrations and migrate.

Upvotes: 3

NIKHIL RANE
NIKHIL RANE

Reputation: 4092

Try to migrate particular app using following process. Refer Django migrations 

python manage.py makemigrations

Initial migration created then run migrate command with app name

python manage.py migrate appname1, appname2

Upvotes: 3

David Dahan
David Dahan

Reputation: 11162

If you're running in local, For each Django app (maybe you have only one), erase the content of the migrations folder. Then, run python manage.py makemigrations app1 app2 app3 (if you have 3 Django apps named app1, app2, app3). This will (re)create the migrations files required to migrate your database

Then, run python manage.py migrate. It will apply the migration files you just created.

Upvotes: 0

Related Questions