no such table error while adding records

When i try to add record in table in the django admin page , i get Exception:-

No operational error and the Exception Value:no such table:main.auth_user_old

I am using sqlllite database ,please help me in resolving this error

Have you done your makemigrations and migrate?

If you have, and it’s still not working, we’ll need to see the models and the ModelAdmin classes involved.

I have did makemigrations and migrate but still not working,

from django.db import models

Create your models here.

class Employee(models.Model):

from django.contrib import admin
from testApp.models import Employee

Register your models here.;

First, when posting code, templates, html, error messages, etc, here, please enclose it between lines consisting of three backtick - ` characters. This means you’ll have a line of ```, then your code, then another line of ```. This maintains proper formatting.

There’s clearly some context missing here - whether it’s a change in another part of your application, or a third party app you have installed, or something beyond the information you’ve posted so far.

It may be helpful if you posted the complete traceback.

First thing I’d suggest to try would be to change your settings file to reference a new / different database and start from scratch.

This is the error i am getting ,attached in the photo, my django version is 2.0 , regarding and , I have pasted above, I have perform make migrations and migrate commands,and after that i have created superuser for login into django admin interface ,and when i login into the django admin interface and add the record into the employee table using django admin interface , I get the operational error attached in the photo ,and I am not understanding why i am getting this,This is the complete info i can provide

In the window where you’re running runserver, you’ll have the complete traceback from the error.

Is this from a brand-new database as suggested earlier? Or is this from the original database referenced in the original post?

This is the traceback i am getting

    'default': {
        'ENGINE': 'django.db.backends.sqlite3',
        'NAME': os.path.join(BASE_DIR, 'db.sqlite3'),

This is the database related info in the and this is the new database

Please do not post images here of code / html / templates / etc. They can’t be searched, quoted in replies, and are not legible on all devices people use to read the forum.
Copy / paste the text of the traceback, enclosing it in the lines of three backticks as described earlier.

It looks like you may be running Python 3.9, but Django 2.0 only officially supports up to Python 3.7 Also, Django 2.0 has passed its End-of-life date - You should be at least on Django 2.2, which does support Python 3.9 as of 2.2.17.

Traceback (most recent call last):
  File "C:\Users\HP\AppData\Local\Programs\Python\Python39\lib\site-packages\django\core\handlers\", line 35, in inner
    response = get_response(request)
  File "C:\Users\HP\AppData\Local\Programs\Python\Python39\lib\site-packages\django\core\handlers\", line 128, in _get_response
    response = self.process_exception_by_middleware(e, request)
  File "C:\Users\HP\AppData\Local\Programs\Python\Python39\lib\site-packages\django\core\handlers\", line 126, in _get_response
    response = wrapped_callback(request, *callback_args, **callback_kwargs)
  File "C:\Users\HP\AppData\Local\Programs\Python\Python39\lib\site-packages\django\contrib\admin\", line 574, in wrapper
    return self.admin_site.admin_view(view)(*args, **kwargs)
  File "C:\Users\HP\AppData\Local\Programs\Python\Python39\lib\site-packages\django\utils\", line 142, in _wrapped_view
    response = view_func(request, *args, **kwargs)
  File "C:\Users\HP\AppData\Local\Programs\Python\Python39\lib\site-packages\django\views\decorators\", line 44, in _wrapped_view_func
    response = view_func(request, *args, **kwargs)
  File "C:\Users\HP\AppData\Local\Programs\Python\Python39\lib\site-packages\django\contrib\admin\", line 223, in inner
    return view(request, *args, **kwargs)
  File "C:\Users\HP\AppData\Local\Programs\Python\Python39\lib\site-packages\django\contrib\admin\", line 1553, in add_view
    return self.changeform_view(request, None, form_url, extra_context)
  File "C:\Users\HP\AppData\Local\Programs\Python\Python39\lib\site-packages\django\utils\", line 62, in _wrapper
    return bound_func(*args, **kwargs)
  File "C:\Users\HP\AppData\Local\Programs\Python\Python39\lib\site-packages\django\utils\", line 142, in _wrapped_view
    response = view_func(request, *args, **kwargs)
  File "C:\Users\HP\AppData\Local\Programs\Python\Python39\lib\site-packages\django\utils\", line 58, in bound_func
    return func.__get__(self, type(self))(*args2, **kwargs2)
  File "C:\Users\HP\AppData\Local\Programs\Python\Python39\lib\site-packages\django\contrib\admin\", line 1450, in changeform_view
    return self._changeform_view(request, object_id, form_url, extra_context)
  File "C:\Users\HP\AppData\Local\Programs\Python\Python39\lib\site-packages\django\contrib\admin\", line 1494, in _changeform_view
    self.log_addition(request, new_object, change_message)
  File "C:\Users\HP\AppData\Local\Programs\Python\Python39\lib\site-packages\django\contrib\admin\", line 767, in log_addition
    return LogEntry.objects.log_action(
  File "C:\Users\HP\AppData\Local\Programs\Python\Python39\lib\site-packages\django\contrib\admin\", line 23, in log_action
    return self.model.objects.create(
  File "C:\Users\HP\AppData\Local\Programs\Python\Python39\lib\site-packages\django\db\models\", line 82, in manager_method
    return getattr(self.get_queryset(), name)(*args, **kwargs)
  File "C:\Users\HP\AppData\Local\Programs\Python\Python39\lib\site-packages\django\db\models\", line 417, in create, using=self.db)
  File "C:\Users\HP\AppData\Local\Programs\Python\Python39\lib\site-packages\django\db\models\", line 728, in save
    self.save_base(using=using, force_insert=force_insert,
  File "C:\Users\HP\AppData\Local\Programs\Python\Python39\lib\site-packages\django\db\models\", line 759, in save_base
    updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)
  File "C:\Users\HP\AppData\Local\Programs\Python\Python39\lib\site-packages\django\db\models\", line 842, in _save_table
    result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)
  File "C:\Users\HP\AppData\Local\Programs\Python\Python39\lib\site-packages\django\db\models\", line 879, in _do_insert
    return manager._insert([self], fields=fields, return_id=update_pk,
  File "C:\Users\HP\AppData\Local\Programs\Python\Python39\lib\site-packages\django\db\models\", line 82, in manager_method
    return getattr(self.get_queryset(), name)(*args, **kwargs)
  File "C:\Users\HP\AppData\Local\Programs\Python\Python39\lib\site-packages\django\db\models\", line 1125, in _insert
    return query.get_compiler(using=using).execute_sql(return_id)
  File "C:\Users\HP\AppData\Local\Programs\Python\Python39\lib\site-packages\django\db\models\sql\", line 1280, in execute_sql
    cursor.execute(sql, params)
  File "C:\Users\HP\AppData\Local\Programs\Python\Python39\lib\site-packages\django\db\backends\", line 100, in execute
    return super().execute(sql, params)
  File "C:\Users\HP\AppData\Local\Programs\Python\Python39\lib\site-packages\django\db\backends\", line 68, in execute
    return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
  File "C:\Users\HP\AppData\Local\Programs\Python\Python39\lib\site-packages\django\db\backends\", line 77, in _execute_with_wrappers
    return executor(sql, params, many, context)
  File "C:\Users\HP\AppData\Local\Programs\Python\Python39\lib\site-packages\django\db\backends\", line 85, in _execute
    return self.cursor.execute(sql, params)
  File "C:\Users\HP\AppData\Local\Programs\Python\Python39\lib\site-packages\django\db\", line 89, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "C:\Users\HP\AppData\Local\Programs\Python\Python39\lib\site-packages\django\db\backends\", line 85, in _execute
    return self.cursor.execute(sql, params)
  File "C:\Users\HP\AppData\Local\Programs\Python\Python39\lib\site-packages\django\db\backends\sqlite3\", line 303, in execute
    return Database.Cursor.execute(self, query, params)
django.db.utils.OperationalError: no such table: main.auth_user__old
[30/Apr/2021 00:11:06] "POST /admin/testApp/employee/add/ HTTP/1.1" 500 211822

ok I have put traceback in the backticks

Ok i will try installing django version 2.2

Thank you very much ,it worked while installing django version higher than 2.2