Hi, Run python manage.py makemigrations
python manage.py migrate Thanks and Regards J. Ranga Bharath Cell: 9110334114 On Tue, 26 Apr 2022, 1:07 pm Israel Lewis, <[email protected]> wrote: > Hello guys, > > I'm having an error in my models when I add the FK to the faculty or the > student. > model.py > from django.db import models > > # Create your models here. > > > class Student(models.Model): > first_name = models.CharField(max_length=100) > last_name = models.CharField(max_length=100) > reg_no = models.CharField(max_length=20, unique=True) > > def __str__(self): > return self.first_name > > > class Faculty(models.Model): > faculty_name = models.CharField(max_length=100) > student = models.ForeignKey(Student, on_delete=models.CASCADE) > > def __str__(self): > return self.faculty_name > > > class Course(models.Model): > course_name = models.CharField(max_length=100, unique=True) > faculty = models.ForeignKey(Faculty, on_delete=models.CASCADE) > > def __str__(self): > return self.course_name > > > class Dean(models.Model): > dean_name = models.CharField(max_length=100) > faculty = models.OneToOneField(Faculty, on_delete=models.CASCADE) > > def __str__(self): > return self.dean_name > > > class StudentRequest(models.Model): > student_name = models.CharField(max_length=100) > faculty = models.ForeignKey(Faculty, on_delete=models.CASCADE) > course = models.ForeignKey(Course, on_delete=models.CASCADE) > reg_no = models.CharField(max_length=20) > reasons = models.CharField(max_length=300, null=False) > > def __str__(self): > return f"{self.student_name}" > > > class FinancialRecords(models.Model): > ACADENIC_YEAR_CHOICES = [ > ('Year 3 Sem 2'), > ('Year 4 Sem 2') > ] > PAYMENT_PLAN_CHOICES = [ > ('Full'), > ('Follow'), > ('Fail'), > ] > > payment_plan_category = models.CharField( > PAYMENT_PLAN_CHOICES, max_length=10) > > student_reg = models.ForeignKey(Student, models.CASCADE) > academic_year = models.CharField(ACADENIC_YEAR_CHOICES, max_length=20) > course = models.ForeignKey(Course, on_delete=models.CASCADE) > > > > Errors > Traceback (most recent call last): > File > "/home/israel/Desktop/exams-clearance/env/lib/python3.8/site-packages/django/db/backends/utils.py", > line 89, in _execute > return self.cursor.execute(sql, params) > File > "/home/israel/Desktop/exams-clearance/env/lib/python3.8/site-packages/django/db/backends/sqlite3/base.py", > line 477, in execute > return Database.Cursor.execute(self, query, params) > sqlite3.OperationalError: no such column: exams_app_faculty.student_id > > The above exception was the direct cause of the following exception: > > Traceback (most recent call last): > File > "/home/israel/Desktop/exams-clearance/env/lib/python3.8/site-packages/django/core/handlers/exception.py", > line 55, in inner > response = get_response(request) > File > "/home/israel/Desktop/exams-clearance/env/lib/python3.8/site-packages/django/core/handlers/base.py", > line 197, in _get_response > response = wrapped_callback(request, *callback_args, **callback_kwargs) > File > "/home/israel/Desktop/exams-clearance/env/lib/python3.8/site-packages/django/contrib/admin/options.py", > line 683, in wrapper > return self.admin_site.admin_view(view)(*args, **kwargs) > File > "/home/israel/Desktop/exams-clearance/env/lib/python3.8/site-packages/django/utils/decorators.py", > line 133, in _wrapped_view > response = view_func(request, *args, **kwargs) > File > "/home/israel/Desktop/exams-clearance/env/lib/python3.8/site-packages/django/views/decorators/cache.py", > line 62, in _wrapped_view_func > response = view_func(request, *args, **kwargs) > File > "/home/israel/Desktop/exams-clearance/env/lib/python3.8/site-packages/django/contrib/admin/sites.py", > line 242, in inner > return view(request, *args, **kwargs) > File > "/home/israel/Desktop/exams-clearance/env/lib/python3.8/site-packages/django/utils/decorators.py", > line 46, in _wrapper > return bound_method(*args, **kwargs) > File > "/home/israel/Desktop/exams-clearance/env/lib/python3.8/site-packages/django/utils/decorators.py", > line 133, in _wrapped_view > response = view_func(request, *args, **kwargs) > File > "/home/israel/Desktop/exams-clearance/env/lib/python3.8/site-packages/django/contrib/admin/options.py", > line 2063, in changelist_view > "selection_note": _("0 of %(cnt)s selected") % {"cnt": > len(cl.result_list)}, > File > "/home/israel/Desktop/exams-clearance/env/lib/python3.8/site-packages/django/db/models/query.py", > line 302, in __len__ > self._fetch_all() > File > "/home/israel/Desktop/exams-clearance/env/lib/python3.8/site-packages/django/db/models/query.py", > line 1507, in _fetch_all > self._result_cache = list(self._iterable_class(self)) > File > "/home/israel/Desktop/exams-clearance/env/lib/python3.8/site-packages/django/db/models/query.py", > line 57, in __iter__ > results = compiler.execute_sql( > File > "/home/israel/Desktop/exams-clearance/env/lib/python3.8/site-packages/django/db/models/sql/compiler.py", > line 1361, in execute_sql > cursor.execute(sql, params) > File > "/home/israel/Desktop/exams-clearance/env/lib/python3.8/site-packages/django/db/backends/utils.py", > line 103, in execute > return super().execute(sql, params) > File > "/home/israel/Desktop/exams-clearance/env/lib/python3.8/site-packages/django/db/backends/utils.py", > line 67, in execute > return self._execute_with_wrappers( > File > "/home/israel/Desktop/exams-clearance/env/lib/python3.8/site-packages/django/db/backends/utils.py", > line 80, in _execute_with_wrappers > return executor(sql, params, many, context) > File > "/home/israel/Desktop/exams-clearance/env/lib/python3.8/site-packages/django/db/backends/utils.py", > line 89, in _execute > return self.cursor.execute(sql, params) > File > "/home/israel/Desktop/exams-clearance/env/lib/python3.8/site-packages/django/db/utils.py", > line 91, in __exit__ > raise dj_exc_value.with_traceback(traceback) from exc_value > File > "/home/israel/Desktop/exams-clearance/env/lib/python3.8/site-packages/django/db/backends/utils.py", > line 89, in _execute > return self.cursor.execute(sql, params) > File > "/home/israel/Desktop/exams-clearance/env/lib/python3.8/site-packages/django/db/backends/sqlite3/base.py", > line 477, in execute > return Database.Cursor.execute(self, query, params) > django.db.utils.OperationalError: no such column: > exams_app_faculty.student_id > > > > Thanks > > -- > 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/3d1f7c3f-70f9-49bf-ae8e-a90f3a239727n%40googlegroups.com > <https://groups.google.com/d/msgid/django-users/3d1f7c3f-70f9-49bf-ae8e-a90f3a239727n%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/CAK5m3144MPE1YcZWmHA-ooy3mLVoDF3yo_O%3D4EL5vFmRX1fKvA%40mail.gmail.com.
