Makemigrations error : django.db.utils.OperationalError: no such table

Question

when I makemigrations

i get the following error:

django.db.utils.OperationalError: no such table: django_site

    Traceback (most recent call last):
  File "manage.py", line 10, in <module>
    execute_from_command_line(sys.argv)
  File "C:\Python27\lib\site-packages\django\core\management\__init__.py", line 364, in execute_from_command_line
    utility.execute()
  File "C:\Python27\lib\site-packages\django\core\management\__init__.py", line 338, in execute
    django.setup()
  File "C:\Python27\lib\site-packages\django\__init__.py", line 27, in setup
    apps.populate(settings.INSTALLED_APPS)
  File "C:\Python27\lib\site-packages\django\apps\registry.py", line 108, in populate
    app_config.import_models()
  File "C:\Python27\lib\site-packages\django\apps\config.py", line 202, in import_models
    self.models_module = import_module(models_module_name)
  File "C:\Python27\lib\importlib\__init__.py", line 37, in import_module
    __import__(name)
  File "C:\Users\KwanfahArunrerk\Desktop\Sinwattana_repo\trunk\sinwattana3_0\campaign\models.py", line 5, in <module>
    from sinUser.models import sinUser, sinUserCategories
  File "C:\Users\KwanfahArunrerk\Desktop\Sinwattana_repo\trunk\sinwattana3_0\sinUser\models.py", line 4, in <module>
    from functionUtility.sendEmails import sendEmailFunctionIsError
  File "C:\Users\KwanfahArunrerk\Desktop\Sinwattana_repo\trunk\sinwattana3_0\functionUtility\sendEmails.py", line 12, in <module>
    HOSTNAME = Site.objects.get_current().domain
  File "C:\Python27\lib\site-packages\django\contrib\sites\models.py", line 63, in get_current
    return self._get_site_by_id(site_id)
  File "C:\Python27\lib\site-packages\django\contrib\sites\models.py", line 35, in _get_site_by_id
    site = self.get(pk=site_id)
  File "C:\Python27\lib\site-packages\django\db\models\manager.py", line 85, in manager_method
    return getattr(self.get_queryset(), name)(*args, **kwargs)
  File "C:\Python27\lib\site-packages\django\db\models\query.py", line 374, in get
    num = len(clone)
  File "C:\Python27\lib\site-packages\django\db\models\query.py", line 232, in __len__
    self._fetch_all()
  File "C:\Python27\lib\site-packages\django\db\models\query.py", line 1118, in _fetch_all
    self._result_cache = list(self._iterable_class(self))
  File "C:\Python27\lib\site-packages\django\db\models\query.py", line 53, in __iter__
    results = compiler.execute_sql(chunked_fetch=self.chunked_fetch)
  File "C:\Python27\lib\site-packages\django\db\models\sql\compiler.py", line 894, in execute_sql
    raise original_exception
django.db.utils.OperationalError: no such table: django_site

I am newbies python programming

some one can help me

thank you

Are you creating a fresh project ? Can you give the INSTALLED_APPS ? — Sandeep Balagopal
– Sandeep Balagopal, Commented Oct 10, 2017 at 10:43

Daniel Roseman · Accepted Answer · 2017-10-10 10:47:04Z

8

Your sendEmails module has a query at the top level: Site.objects.get_current(). This is run when the module is imported, before migrations have had a chance to run.

You must not do any database actions at this level; put it into a method.

answered Oct 10, 2017 at 10:47

Daniel Roseman

602k68 gold badges910 silver badges923 bronze badges

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

1 Comment

Anupam Over a year ago

Ah, after a lot of searching, this answer pointed out the root cause!

NIKHIL RANE · Accepted Answer · 2017-10-10 10:44:50Z

3

Add django.contrib.sites in your INSTALLED_APPS and the run migrate command

python manage.py makemigrations
python manage.py migrate

Hope this helps you

answered Oct 10, 2017 at 10:44

NIKHIL RANE

4,1222 gold badges26 silver badges49 bronze badges

1 Comment

user5359531 Over a year ago

can you explain why this fixes the problem?

Arunkumar Arjunan · Accepted Answer · 2018-12-07 09:45:30Z

3

In this case some migrations are still pending so run python manage.py migrate and python manage.py makemigrations app_name

answered Dec 7, 2018 at 9:45

Arunkumar Arjunan

3821 gold badge3 silver badges12 bronze badges

Comments

Mansoor Ul Haq · Accepted Answer · 2019-12-04 12:48:32Z

1

Change "django.contrib.admin" in INSTALLED_APPS to "django.contrib.admin.apps.SimpleAdminConfig" and then run makemigrations command. after that you can revert your changes.

answered Dec 4, 2019 at 12:48

Mansoor Ul Haq

3304 silver badges9 bronze badges

Comments

Waqar Dongre · Accepted Answer · 2022-07-15 08:25:26Z

0

python manage.py migrate
python manage.py makemigrations

Worked for me, had pending migrations.

answered Jul 15, 2022 at 8:25

Waqar Dongre

631 silver badge6 bronze badges

Collectives™ on Stack Overflow

Makemigrations error : django.db.utils.OperationalError: no such table

5 Answers 5

1 Comment

1 Comment

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related