OperationalError no such column Django

Question

I am very new to django and was able to finish the tutorial on djangoproject com without any errors  I am now going through the Django REST framework tutorial found at http   www django-rest-framework org  I am almost finished with it and just added authentication  Now I am getting    OperationalError at  snippets  no such column  snippets snippet owner id Request Method  GET Request URL     http   localhost 8000 snippets  Django Version  1 7 Exception Type  OperationalError Exception Value      no such column  snippets snippet owner id Exception Location   Users taylorallred Desktop env lib python2 7 site-packages django db backends sqlite3 base py in execute  line 485 Python Executable    Users taylorallred Desktop env bin python Python Version  2 7 5 Python Path         Users taylorallred Desktop tutorial      Users taylorallred Desktop env lib python27 zip      Users taylorallred Desktop env lib python2 7      Users taylorallred Desktop env lib python2 7 plat-darwin      Users taylorallred Desktop env lib python2 7 plat-mac      Users taylorallred Desktop env lib python2 7 plat-mac lib-scriptpackages      Users taylorallred Desktop env Extras lib python      Users taylorallred Desktop env lib python2 7 lib-tk      Users taylorallred Desktop env lib python2 7 lib-old      Users taylorallred Desktop env lib python2 7 lib-dynload      System Library Frameworks Python framework Versions 2 7 lib python2 7      System Library Frameworks Python framework Versions 2 7 lib python2 7 plat-darwin      System Library Frameworks Python framework Versions 2 7 lib python2 7 lib-tk      System Library Frameworks Python framework Versions 2 7 lib python2 7 plat-mac      System Library Frameworks Python framework Versions 2 7 lib python2 7 plat-mac lib-scriptpackages      Users taylorallred Desktop env lib python2 7 site-packages   Server time     Sat  11 Oct 2014 07 02 34  0000   I have looked in several places on the web  not just StackOverflow for the solution  it seems like in general that the problem is with my database and need to delete it then remake it  I have done this several times  the tutorial even has me delete the database and remake it at the point    Here is my models py   from django db import models from pygments lexers import get all lexers from pygments styles import get all styles from pygments lexers import get lexer by name from pygments formatters html import HtmlFormatter from pygments import highlight   LEXERS    item for item in get all lexers   if item 1   LANGUAGE CHOICES   sorted   item 1  0   item 0   for item in LEXERS   STYLE CHOICES   sorted  item  item  for item in get all styles       class Snippet models Model       owner   models ForeignKey  auth User   related name  snippets       highlighted   models TextField       created   models DateTimeField auto now add True      title   models CharField max length 100  blank True  default         code   models TextField       linenos   models BooleanField default False      language   models CharField choices LANGUAGE CHOICES                                              default  python                                               max length 100      style   models CharField choices STYLE CHOICES                                       default  friendly                                        max length 100      class Meta          ordering     created    def save self   args    kwargs               Use the  pygments  library to create a highlighted HTML     representation of the code snippet              lexer   get lexer by name self language      linenos   self linenos and  table  or False     options   self title and   title   self title  or        formatter   HtmlFormatter style self style  linenos linenos                                        full true    options      self highlighted   highlight self code  lexer  formatter      super Snippet  self  save  args    kwargs    My serializers py   from django forms import widgets from rest framework import serializers from snippets models import Snippet  LANGUAGE CHOICES  STYLE CHOICES from django contrib auth models import User    class SnippetSerializer serializers ModelSerializer       owner   serializers Field source  owner username       class Meta          model   Snippet         fields     id    title    code    linenos    language    style    owner     class UserSerializer serializers ModelSerializer       snippets   serializers PrimaryKeyRelatedField many True        class Meta          model   User         fields     id    username    snippets     My views py   from snippets models import Snippet from snippets serializers import SnippetSerializer from rest framework import generics from django contrib auth models import User from snippets serializers import UserSerializer from rest framework import permissions  class SnippetList generics ListCreateAPIView               List all snippets  or create a new snippet              queryset   Snippet objects all       serializer class   SnippetSerializer     def pre save self  obj           obj owner   self request user     permission classes    permissions IsAuthenticatedOrReadOnly    class SnippetDetail generics RetrieveUpdateDestroyAPIView               Retrieve  update or delete a nippet instance              queryset   Snippet objects all       serializer class   SnippetSerializer     def pre save self  obj           obj owner   self request user     permission classes    permissions IsAuthenticatedOrReadOnly    class UserList generics ListAPIView       queryset   User objects all       serializer class   UserSerializer  class UserDetail generics RetrieveAPIView       queryset   User objects all       serializer class   UserSerializer   And finally my urls py  from django conf urls import include from django conf urls import patterns  url from rest framework urlpatterns import format suffix patterns from snippets import views   urlpatterns   patterns         url r  snippets     views SnippetList as view         url r  snippets   P lt pk gt  0-9        views SnippetDetail as view         url r  users     views UserList as view         url r  users   P lt pk gt  0-9        views UserDetail as view        urlpatterns   format suffix patterns urlpatterns   urlpatterns    patterns         url r  api-auth    include  rest framework urls                                          namespace  rest framework         I apologize if I posted a bunch of unnecessary info  Thanks in advance guys   Edit   DB Schema   CREATE TABLE  snippets snippet    id  integer NOT NULL PRIMARY KEY AUTOINCREMENT    created  datetime NOT NULL   title  varchar 100  NOT NULL   code  text NOT NULL    linenos  bool NOT NULL   language  varchar 100  NOT NULL   style  varchar 100  NOT NULL     After doing some digging I found that when deleting and recreating the DB  as the tutorial says to  instead of using the make migrations command it would not only NOT add the columns but it would also not tell me something was wrong when running the make migrations command it tells me   You are trying to add a non-nullable field  highlighted  to snippet without a default  we can t do that  the database needs something to populate existing rows   Please select a fix   1  Provide a one-off default now  will be set on all existing rows   2  Quit  and let me add a default in models py   If I comment out the highlighted section in models py it will post the same message above but for the owner line  So it wants a default for both highlighted and owner  but I am not sure what to use as it  As well as the tutorial isn t helping me either on it

User · Answer

Taken from Burhan Khalid s answer and his comment about migrations  what worked for me was removing the content of the  migrations  folder along with the database  and then running manage py migrate  Removing the database is not enough because of the saved information about table structure in the migrations folder

User · Answer

Initially  I have commented my new fields which is causing those errors  and run python manage py makemigrations and then python manage py migrate to actually delete those new fields     class FootballScore models Model       team   models ForeignKey Team  related name  teams football   on delete models CASCADE        match played   models IntegerField default  0         lose   models IntegerField default  0       win   models IntegerField default  0         points   models IntegerField default  0    class FootballScore models Model       team   models ForeignKey Team  related name  teams football   on delete models CASCADE      match played   models IntegerField default  0       lose   models IntegerField default  0       win   models IntegerField default  0       points   models IntegerField default  0     Then i freshly uncommented them and run python manage py makemigrations and python manage py migrate and boom  It worked for me

User · Answer

I think you skipped this steps   run the following commands to see if you had forgotten to execute them   it worked for me    python manage py makemigrations   python manage py migrate Thank you

User · Answer

As you went through the tutorial you must have come across the section on migration  as this was one of the major changes in Django 1 7  Prior to Django 1 7  the syncdb command never made any change that had a chance to destroy data currently in the database  This meant that if you did syncdb for a model  then added a new row to the model  a new column  effectively   syncdb would not affect that change in the database   So either you dropped that table by hand and then ran syncdb again  to recreate it from scratch  losing any data   or you manually entered the correct statements at the database to add only that column   Then a project came along called south which implemented migrations  This meant that there was a way to migrate forward  and reverse  undo  any changes to the database and preserve the integrity of data   In Django 1 7  the functionality of south was integrated directly into Django  When working with migrations  the process is a bit different    Make changes to models py  as normal   Create a migration  This generates code to go from the current state to the next state of your model  This is done with the makemigrations command  This command is smart enough to detect what has changed and will create a script to effect that change to your database  Next  you apply that migration with migrate  This command applies all migrations in order    So your normal syncdb is now a two-step process  python manage py makemigrations followed by python manage py migrate   Now  on to your specific problem   class Snippet models Model       owner   models ForeignKey  auth User   related name  snippets       highlighted   models TextField       created   models DateTimeField auto now add True      title   models CharField max length 100  blank True  default         code   models TextField       linenos   models BooleanField default False      language   models CharField choices LANGUAGE CHOICES                                              default  python                                               max length 100      style   models CharField choices STYLE CHOICES                                       default  friendly                                        max length 100    In this model  you have two fields highlighted and code that is required  they cannot be null    Had you added these fields from the start  there wouldn t be a problem because the table has no existing rows   However  if the table has already been created and you add a field that cannot be null  you have to define a default value to provide for any existing rows - otherwise  the database will not accept your changes because they would violate the data integrity constraints   This is what the command is prompting you about   You can tell Django to apply a default during migration  or you can give it a  blank  default highlighted   models TextField default     in the model itself

User · Answer

I had same issue with sqlite  My models py looked all right  I did the following  sqlite3 db sqlite3  tables PRAGMA table info table name    Thru PRAGMA I was able to see that there was columns missing in the table failing  I dropped all tables in the app  Be careful because this will make lose your data in the tables  DROP table table name  quit  Then do this  python manage py makemigrations your app python manage py migrate your app python manage py sqlmigrate your app 0001  Then enter again to sqlite as follows and paste all the code you got from sqlimigrate  sqlite3 db sqlite3  As an example  this is what I pasted inside sqlite  CREATE TABLE  quot adpet ad quot    quot id quot  integer NOT NULL PRIMARY KEY AUTOINCREMENT   quot title quot  varchar 200  NOT NULL   quot breed quot  varchar 30  NULL   quot weight quot  decimal NULL   quot age quot  integer NULL   quot text quot  text NOT NULL   quot created at quot  datetime NOT NULL   quot updated at quot  datetime NOT NULL   quot picture quot  BLOB NULL   quot content type quot  varchar 256  NULL   quot name quot  varchar 100  NULL   quot phone quot  varchar 31  NOT NULL   quot gender id quot  integer NULL REFERENCES  quot adpet gender quot    quot id quot   DEFERRABLE INITIALLY DEFERRED   quot owner id quot  integer NOT NULL REFERENCES  quot auth user quot    quot id quot   DEFERRABLE INITIALLY DEFERRED   quot size id quot  integer NULL REFERENCES  quot adpet size quot    quot id quot   DEFERRABLE INITIALLY DEFERRED   quot specie id quot  integer NULL REFERENCES  quot adpet specie quot    quot id quot   DEFERRABLE INITIALLY DEFERRED   quot sterilized id quot  integer NULL REFERENCES  quot adpet sterilized quot    quot id quot   DEFERRABLE INITIALLY DEFERRED   quot vaccinated id quot  integer NULL REFERENCES  quot adpet vaccinated quot    quot id quot   DEFERRABLE INITIALLY DEFERRED

User · Answer

I see we have the same problem here  I have the same error  I want to write this for the future user who will experience the same error  After making changes to your class Snippet model like  Burhan Khalid said  you must migrate tables   python manage py makemigrations snippets python manage py migrate   And that should resolve the error  Enjoy

User · Answer

I simple made a careless mistake of forgetting to actually apply the migration  migrate  after making migrations  Writing this just in case anyone might make the same mistake

User · Answer

Let s focus on the error      Exception Value    no such column  snippets snippet owner id   Let s see if that s true     You can use the manage py command to access your db shell  this will use the settings py variables  so you re sure to connect to the right one    manage py dbshell  You can now show the details of your table by typing    schema TABLE NAME  Or in your case    schema snippets snippet  More sqlite commands can be found here or by issuing a   help  Lastly  end your session by typing    quit  This doesn t get you out of the woods  but it helps you know what end of the problem to work on     Good luck

User · Answer

If your issue is like mine  then this a workaround  The good news is that you wont have to delete your db   Check that there isn t some other model that uses this model as a reference    django db utils OperationalError  no such column  parts part type blah   This was only happening to me because I had another model called  product  in a different app called  products  that referenced this model    part   models ForeignKey  parts Part   related name  some part   limit choices to   part type  Part Type objects get prefix  PART        My solution was    comment out the other app  in this case prodcuts  from settings py python manage py makemigrations  python manage py migrate un-comment the other app so its enabled again  python manage py makemigrations  python manage py migrate   Technically I think I need to change the limit choices to reference so

User · Answer

I did the following   Delete my db sqlite3 database python manage py makemigrations python manage py migrate   It renewed the database and fixed the issues without affecting my project  Please note you might need to do python manage py createsuperuser because it will affect all your objects being created

User · Answer

Deleting all your migrations in the migration folder of your django app  then run makemigrations followed by migrate commands  You should be able to get out of the woods

User · Answer

Step 1  Delete the db sqlite3 file    Step 2     python manage py migrate  Step 3     python manage py makemigrations  Step 4   Create the super user using   python manage py createsuperuser  new db sqlite3 will generates automatically

User · Answer

This error can happen if you instantiate a class that relies on that table  for example in views py

User · Answer

Agree with Rishikesh  I too tried to solve this issue for a long time  This will be solved with either or both of 2 methods-  1 Try deleting the migrations in the app s migrations folder except init py    and then running makemigrations command  2 If that doesn t work  try renaming the model  this is the last resort and might get a little messy but will work for sure If django asks  did you rename the model  just press N    Hope it helps

User · Answer

You did every thing correct  I have been gone through same problem  First delete you db and migrations I solved my adding name of my app in makemigrations   python manage py makemigrations appname python manage py migrate   This will definitely work

User · Answer

The most direct way of solving this type of problem is just the following 3 steps process    Delete all the migration related files from app s migrations folder directory  these basically starts with 0001  0002  0003 etc   Delete Rename the existing database file named db sqlite3 from App directory  Now run the following command    python manage py migrate  Finally execute  python manage py createsuperuser  to perform the administrative tasks  If you want

User · Answer

I had this problem recently  even though on a different tutorial  I had the django version 2 2 3 so I thought I should not have this kind of issue  In my case  once I add a new field to a model and try to access it in admin  it would say no such column  I learnt the  right  way after three days of searching for solution with nothing working  First  if you are making a change to a model  you should make sure that the server is not running  This is what caused my own problem  And this is not easy to rectify  I had to rename the field  while server was not running  and re-apply migrations  Second  I found that python manage py makemigrations  lt app name gt  captured the change as opposed to just python manage py makemigrations  I don t know why  You could also follow that up with python manage py migrate  lt app name gt   I m glad I found this out by myself

User · Answer

In my case  in admin py I was querying from the table in which new ForeignKey field was added  So comment out admin py then run makemigrations and migrate command as usual  Finally uncomment admin py

User · Answer

Anyone coming here   Remove all migrations Remove db sqlite file  redo migrations

User · Answer

If the error persists after doing what  Burhan Khalid said  Try this line  python manage py migrate --run-syncdb

User · Answer

You did not migrated all changes you made in model  so 1  python manage py makemigrations 2  python manage py migrate 3  python manag py runserver it works 100

User · Answer

just remember there is a pycache folder hidden inside the migrations folder so if you change your models and delete all your migration files you MUST delete the pycache folder also   The only one you should not delete is your init file   Hope this helps

User · Answer

I am also faced same problem    If you re adding a new field then it gives the error as no column found   Then you apply make migration command and after that migrate command Then still same error   EX      path models FilePathField     Add default value for field    path models FilePathField default       and than apply command     python manage py makemigrations    python manage py migrate   It may help you

User · Answer

I faced this problem and this is how I solved it   1  Delete all the migration records from your app s migration directory  These are files named 0001  0002  0003  etc  Be careful as to not delete the    init   py file   2  Delete the db sqlite3 file  It will be regenerated later   Now  run the following commands   python manage py makemigrations appname python manage py migrate   Be sure to write the name of your app after makemigrations  You might have to create a superuser to access your database again  Do so by the following       python manage py createsuperuser

[python] OperationalError, no such column. Django

Examples related to python

Examples related to django

Examples related to django-rest-framework