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, <lewisisra...@gmail.com> 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 django-users+unsubscr...@googlegroups.com.
> 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 django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/CAK5m3144MPE1YcZWmHA-ooy3mLVoDF3yo_O%3D4EL5vFmRX1fKvA%40mail.gmail.com.
