django no such table

Question

I have models in Django set up as below    class Pupil models Model       forename   models CharField max length 30      surname   models CharField max length 30      dateofbirth   models DateField       year   models IntegerField       class group   models CharField max length 30      email   models EmailField blank True      assignments   models ManyToManyField  Assignment   verbose name  related assignments        def   unicode   self           return u  s  s     self forename  self surname   class Subject models Model       name   models CharField max length 30      level   models CharField max length 30      teachers   models ManyToManyField  Teacher   verbose name  related teachers        def   unicode   self           return self name  class Teacher models Model       forename   models CharField max length 30      surname   models CharField max length 30      email   models EmailField blank True       def   unicode   self           return u  s  s     self forename  self surname   class Assignment models Model       assignment name   models CharField max length 30      date assigned   models DateField       date submitted   models DateField        def   unicode   self           return self assignment name   When I attempt to add a pupil and attach an assignment to the pupil in the admin  I get a database error -    no such table  homework pupil assignments   after reading this I realised this could be due to django not updating changes to my models as when I do manage py sqlall homework  I see the following   BEGIN  CREATE TABLE  homework pupil assignments         id  integer NOT NULL PRIMARY KEY       pupil id  integer NOT NULL       assignment id  integer NOT NULL      UNIQUE   pupil id    assignment id       CREATE TABLE  homework pupil         id  integer NOT NULL PRIMARY KEY       forename  varchar 30  NOT NULL       surname  varchar 30  NOT NULL       dateofbirth  date NOT NULL       year  integer NOT NULL       class group  varchar 30  NOT NULL       email  varchar 75  NOT NULL     CREATE TABLE  homework subject teachers         id  integer NOT NULL PRIMARY KEY       subject id  integer NOT NULL       teacher id  integer NOT NULL      UNIQUE   subject id    teacher id       CREATE TABLE  homework subject         id  integer NOT NULL PRIMARY KEY       name  varchar 30  NOT NULL       level  varchar 30  NOT NULL     CREATE TABLE  homework teacher         id  integer NOT NULL PRIMARY KEY       forename  varchar 30  NOT NULL       surname  varchar 30  NOT NULL       email  varchar 75  NOT NULL     CREATE TABLE  homework assignment         id  integer NOT NULL PRIMARY KEY       assignment name  varchar 30  NOT NULL       date assigned  date NOT NULL       date submitted  date NOT NULL     COMMIT    I then installed South  following the directions to get up and running with an existing app  in the hope of successfully syncing these tables  No joy    Can anyone suggest how I can get the database  sqlite3  to reflect the models or point out what I m doing wrong

User · Answer

first step delete db sqlite3 file   go to terminal and run commands   python manage py makemigrations python manage py migrate python manage py createsuperuser python manage py runserver   go to admin page every thing ok now

User · Answer

sqlall just prints the SQL  it doesn t execute it  syncdb will create tables that aren t already created  but it won t modify existing tables

User · Answer

One way to sync your database to your django models is to delete your database file and run makemigrations and migrate commands again  This will reflect your django models structure to your database from scratch  Although  make sure to backup your database file before deleting in case you need your records   This solution worked for me since I wasn t much bothered about the data and just wanted my db and models structure to sync up

User · Answer

Updated answer for Django migrations without south plugin   Like T T suggested in his answer  my previous answer was for south migration plugin  when Django hasn t any schema migration features  Now  works in Django 1 9     T T wrote      You can try this   python manage py makemigrations  python manage py migrate --run-syncdb      Outdated for south migrations plugin     As I can see you done it all in wrong order  to fix it up your should   complete this checklist  I assume you can t delete sqlite3 database   file to start over           Grab any SQLite GUI tool  i e  http   sqliteadmin orbmu2k de     Change your model definition to match database definition  best approach is to comment new fields    Delete migrations folder in your model   Delete rows in south migrationhistory table where app name match your application name  probably homework    Invoke    manage py schemamigration  lt app name gt  --initial   Create tables by   manage py migrate  lt app name gt  --fake  --fake will skip SQL execute because table already exists in your database    Make changes to your app s model   Invoke   manage py schemamigration  lt app name gt  --auto   Then apply changes to database    manage py migrate  lt app name gt          Steps 7 8 9 repeat whenever your model needs any changes

User · Answer

If you are using latest version of django 2 x or 1 11 x  then you have to first create migrations    python manage py makemigrations   After that you just have to run migrate command for syncing database    python manage py migrate --run-syncdb   These will sync your database and python models and also second command will print all sql behind it

User · Answer

You can try this   python manage py migrate --run-syncdb   I have the same problem with Django 1 9 and 1 10  This code works

User · Answer

I think maybe you can try   python manage py syncdb   Even sqlite3 need syncdb  sencondly  you can check your sql file name  it should look like xxx s3db

[django] django no such table:

Examples related to django

Examples related to django-south