Django: MySQL no such table: aidata.django

 

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")
  • 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

    I was running into the same problem and for me (running django 1.7 development trunk of mid-sept.2013) it helped to

  • remove all south migrations ( [app]/migration )-directories
  • remove south from INSTALLED_APPS in settings.py

    • That might be due to the shift towards the integrated migration system in django v1.7, but I'm speculating here.

    链接地址: http://www.djcxy.com/p/59364.html

    上一篇: XmlSerializer不使用由sgen创建的XmlSerializers.dll

    下一篇: Django：MySQL没有这样的表：aidata.django