delete all the migrations without init.py , then delete SQLite file , then do makemigrations and migrate
On Tuesday, 22 August 2023 at 13:50:01 UTC+5:30 meenu loranz wrote: > > Yes i delete that 0001_initial.py page and rerun the migration codes and > run the server. But it dosen't work for me.. > > On Tuesday, August 22, 2023 at 12:49:39 AM UTC+5:30 Mike Simkins wrote: > >> Did you regenerate and rerun the migrations ?? >> >> >> python manage.py makemigrations >> python manage.py migrate >> >> >> >> On 21 Aug 2023, at 09:46, meenu loranz <[email protected]> wrote: >> >> Thank you for your response...i changed DOB to dob...but still showing me >> the error... >> OperationalError at /add/ table bank_app_bank has no column named dob >> Request Method: >> POST >> Request URL: >> http://127.0.0.1:8000/add/ >> Django Version: >> 4.2 >> Exception Type: >> OperationalError >> Exception Value: >> table bank_app_bank has no column named dob >> Exception Location: >> C:\Users\Admin\AppData\Local\Programs\Python\Python39\lib\site-packages\django\db\backends\sqlite3\base.py, >> >> line 328, in execute >> Raised during: >> bank_app.views.add_form >> Python Executable: >> C:\Users\Admin\AppData\Local\Programs\Python\Python39\python.exe >> Python Version: >> 3.9.0 >> Python Path: >> ['C:\\Users\\Admin\\myprojects\\banking_system\\bank_project', >> 'C:\\Users\\Admin\\AppData\\Local\\Programs\\Python\\Python39\\python39.zip', >> >> 'C:\\Users\\Admin\\AppData\\Local\\Programs\\Python\\Python39\\DLLs', >> 'C:\\Users\\Admin\\AppData\\Local\\Programs\\Python\\Python39\\lib', >> 'C:\\Users\\Admin\\AppData\\Local\\Programs\\Python\\Python39', >> 'C:\\Users\\Admin\\AppData\\Local\\Programs\\Python\\Python39\\lib\\site-packages'] >> >> >> Server time: >> Mon, 21 Aug 2023 08:44:34 +0000 >> >> On Saturday, August 19, 2023 at 10:49:13 PM UTC+5:30 RANGA BHARATH JINKA >> wrote: >> >>> Hi, >>> >>> Try changing DOB to small letters dob and run the migrations again. >>> >>> All the best 👍 >>> >>> Thanks and Regards >>> >>> J. Ranga Bharath >>> Cell: 9110334114 >>> >>> >>> On Sat, 19 Aug 2023, 9:18 pm ivan harold, <[email protected]> wrote: >>> >>>> >>>> https://stackoverflow.com/questions/68269165/why-django-is-not-detecting-my-table-column >>>> >>>> Try reading this article, it may help you. >>>> >>>> On Saturday, August 19, 2023 at 3:05:57 AM UTC+8 meenu loranz wrote: >>>> >>>>> from django.contrib.auth.models import User >>>>> from django.db import models >>>>> from django.urls import reverse >>>>> # Create your models here. >>>>> >>>>> class bank(models.Model): >>>>> name = models.CharField(max_length=255) >>>>> DOB = models.DateField() >>>>> age = models.IntegerField() >>>>> gender = models.CharField(max_length=10) >>>>> phone_no = models.CharField(max_length=10) >>>>> mail_id = models.EmailField(max_length=25) >>>>> address = models.CharField(max_length=255) >>>>> district = models.CharField(max_length=100) >>>>> branch = models.CharField(max_length=100) >>>>> account_type = models.CharField(max_length=100) >>>>> # materials_provided = models.CharField(max_length=100) >>>>> >>>>> >>>>> def __str__(self): >>>>> return self.name >>>>> >>>>> This is my model.py page. And i can see this table and all fields in >>>>> my database. But while running show me the operational error that no >>>>> column >>>>> named DOB. How can i fix this? >>>>> >>>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "Django users" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to [email protected]. >>>> To view this discussion on the web visit >>>> https://groups.google.com/d/msgid/django-users/1aaf9e41-e11c-43bb-bda9-17b609814059n%40googlegroups.com >>>> >>>> <https://groups.google.com/d/msgid/django-users/1aaf9e41-e11c-43bb-bda9-17b609814059n%40googlegroups.com?utm_medium=email&utm_source=footer> >>>> . >>>> >>> >> -- >> You received this message because you are subscribed to the Google Groups >> "Django users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/django-users/3166bd2f-a556-49ce-9813-6794a3aac838n%40googlegroups.com >> >> <https://groups.google.com/d/msgid/django-users/3166bd2f-a556-49ce-9813-6794a3aac838n%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> >> >> -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/73b81116-7691-421e-b783-7be57b5e12ben%40googlegroups.com.
