Django: MySQL no such table: aidata.django_session

django, django-models

Solution

- Double check the db credentials

make sure you uncommented this line in your middleware:

MIDDLEWARE_CLASSES = ( .... 'django.contrib.sessions.middleware.SessionMiddleware', )

then try to `python manage.py syncdb`.

- if you are still having issues post any output

EDIT -- NEXT CHECK:

- do you have a "django_content_type" table?

- if so, does that table have a "session" record?

- if so, delete the session record and try to `python manage.py syncdb`

EDIT -- STEP 3:

now i'm guessing, post up your settings file so i can make meaningful troubleshooting attempts

- Stop your server if you have one running

- go into your file browser and delete the settings.pyc file

- try to `python manage.py syncdb`

my thought is that a pyc file with the sqlLite info may be cached and not regenerating

EDIT -- STEP 4:

everything in your settings.py look ok to me. try something for me? create a new django project, don't enable the admin or add in your apps i just want to know if from scratch everything in your django install seems to be working

- django-admin.py startproject testsite

- do the database configuration/setup

- python manage.py syncdb

let me know if the models create properly

Problem

I'm running Django 1.4 on Windows 7 in Pycharm and I installed WAMP because I need to have my data in a MySQL table. This is from setting.py ``` DATABASES = { 'default': { 'ENGINE': 'django.db.backends.mysql', 'NAME': 'aidata', 'USER': 'root' } } ``` From installed_apps I uncommented: ``` 'django.contrib.sessions' ``` Running `manage.py syncdb` does not create any tables ( even models) in my mysqldb. I get the error when trying to acces `/admin/` ``` DatabaseError at /admin/ (1146, "Table 'aidata.django_session' doesn't exist") ```

Original source