I created a system with Django. My model was working until I added a new field but when I add new field it gives an error. My new field is owner_id
OperationalError at /pdfs/ no such column:
financial_analysis_pdf.owner_id_id
How Can I fix it?
models.py
class Pdf(models.Model):
CHOICES = [
..
]
STAT = [
...
]
id = models.AutoField(primary_key=True)
title = models.CharField(max_length=200)
pdf = models.FileField(upload_to=user_directory_path)
type = models.CharField(max_length=200, default='Select', choices=CHOICES)
year = models.CharField(max_length=200, default='Select')
created_date = models.DateTimeField(default=datetime.now())
owner_id = models.ForeignKey(Customer, on_delete=models.CASCADE)
def __str__(self):
return self.title
pdfs.html
<tbody id="myTable">
{% for pdf in pdfs %}
<tr>
<td><a href="/ocr" >{{ pdf.title }} </a></td>
<td>{{ pdf.year }}</td>
<td>{{ pdf.type }}</td>
<td> <i class="fas fa-check-circle" style="color: #71ca51"></i></td>
<td>
<a href="{{ pdf.pdf.url }}" class="btn btn-primary btn-sm" target="_blank">Download</a>
</td>
<td>
<form method="post" action="{% url 'pdf_delete' pdf.pk %}">
{% csrf_token %}
<button class="btn btn-danger btn-sm" type="submit" onclick="return confirm('Are you sure you want to delete this analyse?');"><i class="fas fa-trash"></i></button>
</form>
</td>
</tr>
{% endfor %}
</tbody>
</table>
views.py
def pdf_list(request):
pdfs = Pdf.objects.all().order_by('-year')
return render(request, 'pdf_list.html', {'pdfs': pdfs})
customer/model.py
Class Customer(models.Model):
customer_name = models.CharField(max_length=20)
...
id = models.AutoField(primary_key=True)
traceback
Environment:
Request Method: GET
Request URL: http://127.0.0.1:8000/pdfs/
Django Version: 3.1.4
Python Version: 3.8.7
Installed Applications:
['django.contrib.admin',
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.messages',
'django.contrib.staticfiles',
'register',
'customer',
'financial_analysis',
'ocr',
'crispy_forms',
'ckeditor']
Installed Middleware:
['django.middleware.security.SecurityMiddleware',
'django.contrib.sessions.middleware.SessionMiddleware',
'django.middleware.common.CommonMiddleware',
'django.middleware.csrf.CsrfViewMiddleware',
'django.contrib.auth.middleware.AuthenticationMiddleware',
'django.contrib.messages.middleware.MessageMiddleware',
'django.middleware.clickjacking.XFrameOptionsMiddleware']
Template error:
In template C:UsersUSEROneDriveDocumentsGitHubotcemplatesase.html, error at line 0
no such column: financial_analysis_pdf.owner_id_id
1 : <link href="//maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" rel="stylesheet" id="bootstrap-css">
2 : <script src="//maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js"></script>
3 : <script src="//cdnjs.cloudflare.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
4 : <!------ Include the above in your HEAD tag ---------->
5 :
6 : <!DOCTYPE html>
7 : <html lang="en">
8 :
9 : <head>
10 : {% load static %}
Traceback (most recent call last):
File "C:UsersUSEROneDriveDocumentsGitHubotcmyvenvlibsite-packagesdjangodbackendsutils.py", line 84, in _execute
return self.cursor.execute(sql, params)
File "C:UsersUSEROneDriveDocumentsGitHubotcmyvenvlibsite-packagesdjangodbackendssqlite3ase.py", line 413, in execute
return Database.Cursor.execute(self, query, params)
The above exception (no such column: financial_analysis_pdf.owner_id_id) was the direct cause of the following exception:
File "C:UsersUSEROneDriveDocumentsGitHubotcmyvenvlibsite-packagesdjangocorehandlersexception.py", line 47, in inner
response = get_response(request)
File "C:UsersUSEROneDriveDocumentsGitHubotcmyvenvlibsite-packagesdjangocorehandlersase.py", line 179, in _get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "C:UsersUSEROneDriveDocumentsGitHubotcfinancial_analysisviews.py", line 8, in pdf_list
return render(request, 'pdf_list.html', {'pdfs': pdfs})
File "C:UsersUSEROneDriveDocumentsGitHubotcmyvenvlibsite-packagesdjangoshortcuts.py", line 19, in render
content = loader.render_to_string(template_name, context, request, using=using)
File "C:UsersUSEROneDriveDocumentsGitHubotcmyvenvlibsite-packagesdjangoemplateloader.py", line 62, in render_to_string
return template.render(context, request)
File "C:UsersUSEROneDriveDocumentsGitHubotcmyvenvlibsite-packagesdjangoemplateackendsdjango.py", line 61, in render
return self.template.render(context)
File "C:UsersUSEROneDriveDocumentsGitHubotcmyvenvlibsite-packagesdjangoemplatease.py", line 170, in render
return self._render(context)
File "C:UsersUSEROneDriveDocumentsGitHubotcmyvenvlibsite-packagesdjangoemplatease.py", line 162, in _render
return self.nodelist.render(context)
File "C:UsersUSEROneDriveDocumentsGitHubotcmyvenvlibsite-packagesdjangoemplatease.py", line 938, in render
bit = node.render_annotated(context)
File "C:UsersUSEROneDriveDocumentsGitHubotcmyvenvlibsite-packagesdjangoemplatease.py", line 905, in render_annotated
return self.render(context)
File "C:UsersUSEROneDriveDocumentsGitHubotcmyvenvlibsite-packagesdjangoemplateloader_tags.py", line 150, in render
return compiled_parent._render(context)
File "C:UsersUSEROneDriveDocumentsGitHubotcmyvenvlibsite-packagesdjangoemplatease.py", line 162, in _render
return self.nodelist.render(context)
File "C:UsersUSEROneDriveDocumentsGitHubotcmyvenvlibsite-packagesdjangoemplatease.py", line 938, in render
bit = node.render_annotated(context)
File "C:UsersUSEROneDriveDocumentsGitHubotcmyvenvlibsite-packagesdjangoemplatease.py", line 905, in render_annotated
return self.render(context)
File "C:UsersUSEROneDriveDocumentsGitHubotcmyvenvlibsite-packagesdjangoemplateloader_tags.py", line 62, in render
result = block.nodelist.render(context)
File "C:UsersUSEROneDriveDocumentsGitHubotcmyvenvlibsite-packagesdjangoemplatease.py", line 938, in render
bit = node.render_annotated(context)
File "C:UsersUSEROneDriveDocumentsGitHubotcmyvenvlibsite-packagesdjangoemplatease.py", line 905, in render_annotated
return self.render(context)
File "C:UsersUSEROneDriveDocumentsGitHubotcmyvenvlibsite-packagesdjangoemplatedefaulttags.py", line 168, in render
len_values = len(values)
File "C:UsersUSEROneDriveDocumentsGitHubotcmyvenvlibsite-packagesdjangodbmodelsquery.py", line 269, in __len__
self._fetch_all()
File "C:UsersUSEROneDriveDocumentsGitHubotcmyvenvlibsite-packagesdjangodbmodelsquery.py", line 1308, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "C:UsersUSEROneDriveDocumentsGitHubotcmyvenvlibsite-packagesdjangodbmodelsquery.py", line 53, in __iter__
results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "C:UsersUSEROneDriveDocumentsGitHubotcmyvenvlibsite-packagesdjangodbmodelssqlcompiler.py", line 1156, in execute_sql
cursor.execute(sql, params)
File "C:UsersUSEROneDriveDocumentsGitHubotcmyvenvlibsite-packagesdjangodbackendsutils.py", line 98, in execute
return super().execute(sql, params)
File "C:UsersUSEROneDriveDocumentsGitHubotcmyvenvlibsite-packagesdjangodbackendsutils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "C:UsersUSEROneDriveDocumentsGitHubotcmyvenvlibsite-packagesdjangodbackendsutils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "C:UsersUSEROneDriveDocumentsGitHubotcmyvenvlibsite-packagesdjangodbackendsutils.py", line 84, in _execute
return self.cursor.execute(sql, params)
File "C:UsersUSEROneDriveDocumentsGitHubotcmyvenvlibsite-packagesdjangodbutils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "C:UsersUSEROneDriveDocumentsGitHubotcmyvenvlibsite-packagesdjangodbackendsutils.py", line 84, in _execute
return self.cursor.execute(sql, params)
File "C:UsersUSEROneDriveDocumentsGitHubotcmyvenvlibsite-packagesdjangodbackendssqlite3ase.py", line 413, in execute
return Database.Cursor.execute(self, query, params)
Exception Type: OperationalError at /pdfs/
Exception Value: no such column: financial_analysis_pdf.owner_id_id
base.html
<li class="sidebar-dropdown">
{% load customer_list %}
{% get_customers request.user as customers %}
{% for customer in customers %}
<a href="#">
<i class="fa fa-building"></i>
<span>{{customer.customer_name}}</span>
</a>
<div class="sidebar-submenu">
<ul>
<li>
<a href="/customers/{{ customer.id }}/profile">View</a>
</li>
<li>
<a href="/customers/{{ customer.id }}/update"> Update</a>
</li>
<li>
<a href="/pdfs">Analyses</a>
</li>
</ul>
</div>
{% endfor %}
</li>
