Error django.db.utils.OperationalError: no such column:

[Israel Lewis]

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

[Miracle]

Did you run migrations???

You should run `python manage.py makemigrations` and then `python manage.py migrate`

--
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...@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.

[Israel Lewis]

Yes Collins. Thanks for the replied.

I have it working now. 

[RANGA BHARATH JINKA]

Hi,

Run python manage.py makemigrations

python manage.py migrate

Thanks and Regards

J. Ranga Bharath
Cell: 9110334114