Django - Site matching query does not exist

Question

Im trying to get the admin site of my app in Django working. Ive just sync`d the DB and then gone to the site but I get the error ...

Site matching query does not exist.

Any ideas ?

It's a duplicated question http://stackoverflow.com/questions/11476210/getting-site-matching-query-does-not-exist-error-after-creating-django-admin — Fernando Freitas Alves, Apr 17 '13 at 19:28
Possible duplicate of [Getting Site Matching Query Does Not Exist Error after creating django admin](https://stackoverflow.com/questions/11476210/getting-site-matching-query-does-not-exist-error-after-creating-django-admin) — Aniket Thakur, Feb 06 '18 at 07:24
I removed `example.com` site in `django_site` table and added new domain. So I had same issue with you. I changed value of `SITE_ID` to `2` in `settings.py` file. It's for new site. ``` SITE_ID=2 ``` — NinjaDev, Sep 03 '20 at 03:33

score 57 · Accepted Answer · answered Apr 17 '13 at 19:28

57

Every django app needs a Site to run. Here you do not seem to have it.

Log into your django shell

$> ./manage.py shell
>>> from django.contrib.sites.models import Site
>>> site = Site()
>>> site.domain = 'example.com'
>>> site.name = 'example.com'
>>> site.save()

or

$> ./manage.py shell
>>> from django.contrib.sites.models import Site
>>> site = Site.objects.create(domain='example.com', name='example.com')
>>> site.save()

You should be all set.

answered Apr 17 '13 at 19:28

karthikr

97,368
26
197
188

1

How would/should this be added via the settings file ? – felix001 Apr 17 '13 at 19:31
You cannot add it via settings. do `./manage.py shell` and there execute these commands – karthikr Apr 17 '13 at 19:32
Ok thanks I just wondered why my app didnt have this. Also what reference does the domain have within Django. Thanks again... – felix001 Apr 17 '13 at 19:32
Also make sure you set `SITE_ID` in `settings.py` to 0. – Aaron Digulla Feb 15 '14 at 13:29
I love this way to solve any issues with models in broken Django site... – Constantine Kurbatov Jun 12 '21 at 03:10
In my case I had also to delete existing records and set id=1 like:`Site.objects.all().delete() ;Site.objects.create(id=1,domain='example.com', name='example.com').save()` This was after loading from json and strangely id was 5 – piertoni Jun 14 '22 at 15:44

score 42 · Answer 2 · edited Jan 04 '20 at 01:49

42

Add django.contrib.sites in django INSTALLED_APPS and also add SITE_ID=1 in your django setting file.

edited Jan 04 '20 at 01:49

CoderGuy123

6,219
5
59
89

answered Feb 21 '18 at 20:12

Mr Singh

3,936
5
41
60

its plural `django.contrib.sites` – 4givN Dec 12 '19 at 13:53
SITE_ID means in the database table you create a objects where you will add site name according to your app like facebook.com. xyx.com so you can add according to your need – Mr Singh Apr 11 '20 at 22:14
1

I was missing the `SITE_ID=1`. Thanks. – Elias Prado May 01 '22 at 03:56

score 23 · Answer 3 · answered Aug 08 '20 at 08:22

23

Adding SITE_ID=1 on settings.py did the trick for me.

answered Aug 08 '20 at 08:22

Cesar Gamboa Avellan

517
4
6

1

Yes, here is the official proof. https://docs.djangoproject.com/en/3.1/ref/contrib/sites/#enabling-the-sites-framework – Yaroslav Nikitenko Nov 25 '20 at 13:56
Not entirely sure why, but this did the trick for me! – Kevin D. May 13 '22 at 14:05

score 9 · Answer 4 · edited Dec 07 '15 at 23:57

9

You also need to make sure that the site domain is the same with the one you actually use. For example if you are you are accessing the admin site from http://127.0.0.1:8000/admin/ then your site.domain should be: site.domain = '127.0.0.1:8000'.

edited Dec 07 '15 at 23:57

Josh Crozier

233,099
56
391
304

answered Dec 05 '15 at 23:20

Evangelos Tolias

141
1
3

score 5 · Answer 5 · answered Aug 02 '21 at 20:47

5

Try out this in settings.py:

SITE_ID = 1

answered Aug 02 '21 at 20:47

Mohamed El Firdoussi

71
1
2

score 3 · Answer 6 · answered Jul 12 '22 at 16:08

SITE_ID = 1 i didn't work for me

I had to go to the python shell ./manage.py shell

Then get the existing site id using name or domain

from django.contrib.sites.models import Site
Site.objects.get(name='back').id
> 6

For me it was 6, all i had to do then is to change the SITE_ID = 6 and it worked fine

score 0 · Answer 7 · answered May 14 '22 at 16:54

0

I'm using wsgi, so I had to reboot twice, not sure why.

then clear cache and that was it.

answered May 14 '22 at 16:54

Brian Sanchez

832
1
13
11

Django - Site matching query does not exist

7 Answers7

Linked