Django unable to create default table using "python manage.py syncdb" command

Question

I am new to Django. I am following the instructions given in the tutorial. When I am running python manage.py syncdb, I am getting the following error:

D:\MyDev\DjnagoProject\mysite>python manage.py syncdb
Traceback (most recent call last):
  File "manage.py", line 9, in <module>
    execute_from_command_line(sys.argv)
  File "C:\Python27\lib\site-packages\django\core\management\__init__.py", line 420, in execute_from_command_
line
    utility.execute()
  File "C:\Python27\lib\site-packages\django\core\management\__init__.py", line 359, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "C:\Python27\lib\site-packages\django\core\management\base.py", line 196, in run_from_argv
    self.execute(*args, **options.__dict__)
  File "C:\Python27\lib\site-packages\django\core\management\base.py", line 232, in execute
    output = self.handle(*args, **options)
  File "C:\Python27\lib\site-packages\django\core\management\base.py", line 371, in handle
    return self.handle_noargs(**options)
  File "C:\Python27\lib\site-packages\django\core\management\commands\syncdb.py", line 57, in handle_noargs
    cursor = connection.cursor()
  File "C:\Python27\lib\site-packages\django\db\backends\dummy\base.py", line 15, in complain
    raise ImproperlyConfigured("You haven't set the database ENGINE setting yet.")
django.core.exceptions.ImproperlyConfigured: You haven't set the database ENGINE setting yet.

Adding information : Python version : 2.7.2, django version : (1, 4, 0, 'alpha', 1) OS : windows XP

Please let me know where I am making a mistake.

I don't know which tutorial you are following but the official tutorial clearly mentions to setup database engine first and than run python manage.py syncdb. — RanRag
– RanRag, Commented May 21, 2012 at 10:46
I am also following the same document which you have mentioned here. this is database value which i have modified as per my requirement in setting.py file DATABASES = { 'default': { 'ENGINE': 'django.db.backends.sqlite3', # Add 'postgresql_psycopg2', 'postgresql', 'mysql', 'sqlite3' or 'oracle'. 'NAME': r'D:/MyDev/DjnagoProject/mysite/myDev.db', # Or path to database file if using sqlite3. — Reetesh Nigam
– Reetesh Nigam, Commented May 21, 2012 at 10:59
Show us the content of settings.py file relevant to the database section. And also which database you are using I suggest you use sqlite3 which is in-built for python >2.5 — RanRag
– RanRag, Commented May 21, 2012 at 11:00

vartec · Accepted Answer · 2012-05-21 10:52:05Z

5

Read your error messages:

ImproperlyConfigured: You haven't set the database ENGINE setting yet.

Check DATABASES in your settings.py. You need at least ENGINE and database NAME

edited May 21, 2012 at 10:52

answered May 21, 2012 at 10:36

vartec

135k38 gold badges227 silver badges248 bronze badges

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

4 Comments

vartec Over a year ago

it's either not loading your settings or you have not set the database engine setting.

Reetesh Nigam Over a year ago

can you please suggest what should i do? As i have tried to set PYTHONPOATH as well but no result. It will be great if you can suggest some alternative..

RanRag Over a year ago

@vartec: Isn't these things happen by default when you do pip install django. It happened for me

Reetesh Nigam Over a year ago

Do i need to setup PythonPath or DJANGO_SETTINGS_MODULE path in my system environment?

DanS · Accepted Answer · 2012-05-21 10:37:30Z

1

You haven't set the database ENGINE setting yet.

Make sure you have correct DB credentials in settings.py.

answered May 21, 2012 at 10:37

DanS

18.8k9 gold badges55 silver badges47 bronze badges

Comments

thavan · Accepted Answer · 2012-05-21 13:06:53Z

1

you need to do following two things in settings.py

add database engine and credentials in database dictionary.

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.sqllite3',
        'NAME': '/home/yourname/mydb', 
        'USER': '',   
        'PASSWORD': '',  
        'HOST': '',        
        'PORT': '',  
}
}

add your app to installed_app list

INSTALLED_APPS = (
    'com.example.myapp',
    ....

answered May 21, 2012 at 13:06

thavan

2,48924 silver badges32 bronze badges

1 Comment

Reetesh Nigam Over a year ago

I am still getting the same error. DATABASES = { 'default': { 'ENGINE':"sqlite3", 'NAME':r"D:/MyDev/DjnagoProject/mysite/myDev.db", 'USER':'', 'PASSWORD':'', 'HOST':'', 'PORT':'', } } INSTALLED_APPS = ( 'django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.sites', 'django.contrib.messages', 'django.contrib.staticfiles', 'mysite.blog', ) I have created blog application inside the mysite.

Serjik · Accepted Answer · 2015-10-19 14:42:32Z

1

I addition to database configuration in settings.py file:

Now on Django 1.8.x, it fully supports migrations.

syncdb will be fully removed in version 1.9

Try to use makemigrations and migrate instead

python manage.py makemigrations app1 app2 app3

will make migration scripts in each app migration folder

python manage.py migrate

Will look at database django_migrations table and migrations folder and will migrate the changes.

answered Oct 19, 2015 at 14:42

Serjik

11.1k8 gold badges63 silver badges72 bronze badges

Comments

user37542 · Accepted Answer · 2013-09-28 21:34:43Z

0

Install MySQL-python worked for me!

answered Sep 28, 2013 at 21:34

user37542

1

Collectives™ on Stack Overflow

Django unable to create default table using "python manage.py syncdb" command

5 Answers 5

4 Comments

Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

4 Comments

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related