Django OperationalError No Such Table

Question

I m building a fairly simple application  research  in my Django project that uses Django-CMS    It s my first ground-up attempt at a project application    It s main purpose is to store various intellectual assets  i e article  book  etc  written by a researcher      The problem is that when I point the browser to  research  I get an error saying that the table  research journal  doesn t exist   no such table     I m using Djnago 1 6 5 with a sqlite3 database   Looking at python manage py sql research yields   BEGIN  CREATE TABLE  research researchbase         id  integer NOT NULL PRIMARY KEY       pub date  datetime NOT NULL       authors  varchar 200  NOT NULL       year  varchar 25  NOT NULL       title  varchar 200  NOT NULL       subtitle  varchar 200  NOT NULL       image id  integer NOT NULL REFERENCES  filer image    file ptr id         link  varchar 200  NOT NULL     CREATE TABLE  research journal         researchbase ptr id  integer NOT NULL PRIMARY KEY REFERENCES  research researchbase    id         journal  varchar 200  NOT NULL       abstract  text NOT NULL       citation  varchar 200  NOT NULL     CREATE TABLE  research encyclopedia chapter         researchbase ptr id  integer NOT NULL PRIMARY KEY REFERENCES  research researchbase    id         encyclopedia  varchar 200  NOT NULL       publisher  varchar 200  NOT NULL       summary  varchar 200  NOT NULL     CREATE TABLE  research book         researchbase ptr id  integer NOT NULL PRIMARY KEY REFERENCES  research researchbase    id         publisher  varchar 200  NOT NULL       summary  varchar 200  NOT NULL      COMMIT    I ve run python manage py migrate research and get    Users XXX Documents repos sfs env lib python2 7 site-packages app data fields py 2  DeprecationWarning  django utils simplejson is deprecated  use json instead    from django utils import simplejson as json  Running migrations for research  - Nothing to migrate   - Loading initial data for research  Installed 0 object s  from 0 fixture s    I ve run python manage py syncdb and get the following   Syncing    Creating tables     Installing custom SQL     Installing indexes     Installed 0 object s  from 0 fixture s   Synced    gt  djangocms admin style   gt  django contrib auth   gt  django contrib contenttypes   gt  django contrib sessions   gt  django contrib admin   gt  django contrib sites   gt  django contrib sitemaps   gt  django contrib staticfiles   gt  django contrib messages   gt  mptt   gt  south   gt  sekizai   gt  django select2   gt  hvad  Not synced  use migrations    - djangocms text ckeditor  - cms  - menus  - djangocms style  - djangocms column  - djangocms file  - djangocms flash  - djangocms googlemap  - djangocms inherit  - djangocms link  - djangocms picture  - djangocms teaser  - djangocms video  - reversion  - polls  - djangocms polls  - aldryn blog  - easy thumbnails  - filer  - taggit  - research  use   manage py migrate to migrate these    Here s the models py   from django db import models from django utils import timezone from filer fields image import FilerImageField  import datetime  class ResearchBase models Model       pub date   models DateTimeField  date published       authors   models CharField max length 200      year   models CharField max length 25      title   models CharField max length 200      subtitle   models CharField max length 200  blank True      image   FilerImageField       link   models CharField max length 200  blank True       def   unicode   self           return self title      def was published recently self           return self pub date  gt   timezone now   - datetime timedelta days 1    class Journal ResearchBase       journal   models CharField max length 200      abstract   models TextField       citation   models CharField max length 200    class Encyclopedia Chapter ResearchBase       encyclopedia   models CharField max length 200      publisher   models CharField max length 200      summary   models CharField max length 200    class Book ResearchBase       publisher   models CharField max length 200      summary   models CharField max length 200    Here s my views py  note that I am passing two objects through render  ignore the fact that I have yet to include the class Books in the whole deal    from django shortcuts import render  get object or 404 from django http import HttpResponse  Http404 from django template import RequestContext  loader  from research models import Journal  Encyclopedia Chapter  Book  def research index request       latest journal list   Journal objects order by  -pub date    5      latest chapter list   Encyclopedia Chapter objects order by  -pub date    5       context              latest journal list   latest journal list           latest chapter list   latest chapter list            return render request   research index html   context   def journal detail request  journal id       journal   get object or 404 Journal  pk journal id      return render request   research journal detail html     journal   journal    def chapter detail request  chapter id       chapter   get object or 404 Encyclopedia Chapter  pk chapter id      return render request   research chapter detail html     chapter   chapter     Here s the application s url py   from django conf urls import patterns  url  from research import views  urlpatterns   patterns         url r      views research index  name  research        url r    P lt journal id gt  d       views journal detail  name  journal detail        url r    P lt chapter id gt  d       views chapter detail  name  chapter detail        Here s the index html template      extends  research base html         block research content      lt div class  container  gt       lt div class  row featurette  gt           lt h3 id  research  gt Peer-reviewed Journal Articles lt  h3 gt             if latest journal list                 lt ul id  research  gt                 for journal in latest journal list                     lt li id  research  gt                               lt img src     journal image url     id  research  gt                               lt h4 gt    journal journal    lt  h4 gt                               lt h5 gt    journal title    lt  h5 gt                               lt a href     url  research journal detail  journal id     gt Read More lt  a gt                           lt  li gt                 endfor                 lt  ul gt             else                 lt p gt No journals are available  lt  p gt             endif         lt  div gt        lt div class  row featurette  gt           lt h3 id  research  gt Encyclopedia Chapters lt  h3 gt             if latest chapter list                 lt ul id  research  gt                 for chapter in latest chapter list                     lt li id  research  gt                               lt img src     chapter image url     id  research  gt                               lt h4 gt    chapter journal    lt  h4 gt                               lt h5 gt    chapter title    lt  h5 gt                               lt a href     url  research chapter detail  chapter id     gt Read More lt  a gt                           lt  li gt                 endfor                 lt  ul gt             else                 lt p gt No encyclopedia chapters are available  lt  p gt             endif         lt  div gt   lt  div gt      endblock      Just in case it matters  here s my cms app py   from cms app base import CMSApp from cms apphook pool import apphook pool from django utils translation import ugettext lazy as     class ResearchApp CMSApp       name      Research App       urls     research urls       app name    research   apphook pool register ResearchApp    Thoughts   Any help would be greatly appreciated

User · Answer

The issue may be solved by running migrations    python manage py makemigrations python manage py migrate   perform the operations above whenever you make changes in models py

User · Answer

I m using Django 1 9  SQLite3 and DjangoCMS 3 2 and had the same issue  I solved it by running python manage py makemigrations  This was followed by a prompt stating that the database contained non-null value types but did not have a default value set  It gave me two options  1  select a one off value now or 2  exit and change the default setting in models py  I selected the first option and gave the default value of 1  Repeated this four or five times until the prompt said it was finished  I then ran python manage py migrate  Now it works just fine  Remember  by running python manage py makemigrations first  a revised copy of the database is created  mine was 0004  and you can always revert back to a previous database state

User · Answer

This comment on this page worked for me and a few others  It deserves its own answer   python manage py migrate --run-syncdb

User · Answer

Running the following commands solved this for me     1  python manage py migrate    2  python manage py makemigrations     3  python manage py makemigrations appName

User · Answer

I got through the same error when I went on to the admin panel   You ought to run this instead-  python manage py migrate --run-syncdb  Don t forget to include migrate  I ran   python manage py make migrations and then  python manage py migrate  Still when the error persisted I tried it with the above suggested command

User · Answer

I m using Django CMS 3 4 with Django 1 8  I stepped through the root cause in the Django CMS code  Root cause is the Django CMS is not changing directory to the directory with file containing the SQLite3 database before making database calls  The error message is spurious  The underlying problem is that a SQLite database call is made in the wrong directory   The workaround is to ensure all your Django applications change directory back to the Django Project root directory when changing to working directories

User · Answer

The Thing that worked for me   Find out which migrations in your migration folder created the table if not add the class in your models py  If the class already exist in your models py  try to delete that one and run python manage py makemigrations  lt appname gt  And while migrating fake that migrations as your error might say table not found to delete using python manage py migrate  lt yourappname gt  --fake Add the class again and makemigrations again python manage py makemigrations  lt appname gt   And finally migrate again python manage py migrate  lt appname gt

User · Answer

This error comes when you have not made migrations to your newly created table  So firsty write command on cmd as  python manage py makemigrations and then write another command for applying these migrations made by makemigrations command  python manage py migrate

User · Answer

If you get to the bottom of this list and find this answer  I am almost sure it will solve all your issues    In my case  I had dropped a database table and I was not getting anywhere with makemigrations and migrate So I got a very detailed answer on how to reset everything on this link

User · Answer

If anyone finds that any of the suggested   python manage py makemigrations  python manage py migrate  python manage py migrate --run-syncdb  fail  you may need to add a folder named  migrations  inside the app directory  and create an empty   init   py file

User · Answer

For django 1 10 you may have to do python manage py makemigrations appname

User · Answer

This happened to me and for me it was because I added db sqlite3 as untracked from repository  I added it and pushed it to server so it worked properly   Also run makemigartions and migrate after doing this

User · Answer

It looks like there was an issue with my migration   I ran   manage py schemamigration research --auto and found that many of the fields didn t have a default specified   So  I ran   manage py schemamigration research --init followed by   manage py migrate research  Rerunning the server from there did the trick

[django] Django: OperationalError No Such Table

Examples related to django

Examples related to django-cms