(en) PS C:\Users\steve.musyoka\Desktop\CRM-master> python manage.py
runserver
C:\Python311\python.exe: can't open file
'C:\\Users\\steve.musyoka\\Desktop\\CRM-master\\manage.py': [Errno 2] No
such file or directory
(en) PS C:\Users\steve.musyoka\Desktop\CRM-master> cd
(en) PS C:\Users\steve.musyoka\Desktop\CRM-master> ls
this is the error am getting when i run my django project any help please
On Thursday, August 24, 2023 at 10:25:23 AM UTC+3 meenu loranz wrote:
> from django.contrib import auth, messages
> from django.http import HttpResponse
> from django.shortcuts import render, redirect
>
> from bank_app.models import bank
>
> # Create your views here.
>
>
> def home(request):
> return render(request,"home.html")
>
> def login(request):
> if request.method == 'POST':
> username = request.POST['username']
> password = request.POST['password']
> user = auth.authenticate(username=username,password=password)
>
> if user is not None:
> auth.login(request,user)
> return redirect('/')
> else:
> messages.info(request,"invalid username or password")
> return redirect('login')
> return render(request,"login.html")
>
> def registration(request):
> return render(request,"registration.html")
>
> def add_form(request):
> if request.method == "POST":
> name = request.POST.get('name',)
> dob = request.POST.get('dob', )
> age = request.POST.get('age', )
> gender = request.POST.get('gender', )
> phone_no = request.POST.get('phone_no', )
> mail_id = request.POST.get('mail_id',)
> address = request.POST.get('address',)
> district = request.POST.get('district',)
> branch = request.POST.get('branch',)
> account_type = request.POST.get('account_type',)
>
> Bank = bank(name=name,dob=dob,age=age,gender=gender,phone_no=phone_no,
> mail_id=mail_id,address=address,district=district,
> branch=branch,account_type=account_type,)
>
> Bank.save()
> messages.info(request, 'Bank added successfully')
> return redirect('home')
> return render(request,'add.html')
>
> This is my views.py page.
> 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 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 +
>>
>> 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, 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 o
