Mixing
OperationalError at /admin/myschoolweb/album/add/ - no such table: main.auth_user__old
0
I am trying to add new data in table, but every time it gives below error
Django Version: 2.1.4
Python Version: 3.7.1
Sqlite3 Version: 2.6.0
I have already gone through all the available answers here, but still the issue persists.
I have already followed the steps for 'python manage.py makemigrations' , 'python manage.py migrate'.
i tried to upgrade as well as "downgrade your version of sqlite to a version prior to 2.6 (e.g. 2.5.1)", but I don't know how to do this.
Can anyone help.
Environment:
Request Method: POST
Request URL: http://127.0.0.1:8000/admin/myschoolweb/album/add/
Django Version: 2.1.4
Python Version: 3.7.1
Installed Applications:
['django.contrib.admin',
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.messages',
'django.contrib.staticfiles',
'myschoolweb']
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']
Traceback:
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbbackendsutils.py" in _execute
85. return self.cursor.execute(sql, params)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbbackendssqlite3base.py" in execute
296. return Database.Cursor.execute(self, query, params)
The above exception (no such table: main.auth_user__old) was the direct cause of the following exception:
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangocorehandlersexception.py" in inner
34. response = get_response(request)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangocorehandlersbase.py" in _get_response
126. response = self.process_exception_by_middleware(e, request)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangocorehandlersbase.py" in _get_response
124. response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangocontribadminoptions.py" in wrapper
604. return self.admin_site.admin_view(view)(*args, **kwargs)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangoutilsdecorators.py" in _wrapped_view
142. response = view_func(request, *args, **kwargs)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangoviewsdecoratorscache.py" in _wrapped_view_func
44. response = view_func(request, *args, **kwargs)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangocontribadminsites.py" in inner
223. return view(request, *args, **kwargs)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangocontribadminoptions.py" in add_view
1637. return self.changeform_view(request, None, form_url, extra_context)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangoutilsdecorators.py" in _wrapper
45. return bound_method(*args, **kwargs)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangoutilsdecorators.py" in _wrapped_view
142. response = view_func(request, *args, **kwargs)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangocontribadminoptions.py" in changeform_view
1525. return self._changeform_view(request, object_id, form_url, extra_context)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangocontribadminoptions.py" in _changeform_view
1568. self.log_addition(request, new_object, change_message)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangocontribadminoptions.py" in log_addition
810. change_message=message,
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangocontribadminmodels.py" in log_action
35. change_message=change_message,
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbmodelsmanager.py" in manager_method
82. return getattr(self.get_queryset(), name)(*args, **kwargs)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbmodelsquery.py" in create
413. obj.save(force_insert=True, using=self.db)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbmodelsbase.py" in save
718. force_update=force_update, update_fields=update_fields)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbmodelsbase.py" in save_base
748. updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbmodelsbase.py" in _save_table
831. result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbmodelsbase.py" in _do_insert
869. using=using, raw=raw)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbmodelsmanager.py" in manager_method
82. return getattr(self.get_queryset(), name)(*args, **kwargs)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbmodelsquery.py" in _insert
1136. return query.get_compiler(using=using).execute_sql(return_id)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbmodelssqlcompiler.py" in execute_sql
1289. cursor.execute(sql, params)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbbackendsutils.py" in execute
100. return super().execute(sql, params)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbbackendsutils.py" in execute
68. return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbbackendsutils.py" in _execute_with_wrappers
77. return executor(sql, params, many, context)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbbackendsutils.py" in _execute
85. return self.cursor.execute(sql, params)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbutils.py" in __exit__
89. raise dj_exc_value.with_traceback(traceback) from exc_value
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbbackendsutils.py" in _execute
85. return self.cursor.execute(sql, params)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbbackendssqlite3base.py" in execute
296. return Database.Cursor.execute(self, query, params)
Exception Type: OperationalError at /admin/myschoolweb/album/add/
Exception Value: no such table: main.auth_user__old
python django sqlite3
asked Jan 1 at 9:48
Akshat ChaudharyAkshat Chaudhary
82
add a comment |
0
I am trying to add new data in table, but every time it gives below error
Django Version: 2.1.4
Python Version: 3.7.1
Sqlite3 Version: 2.6.0
I have already gone through all the available answers here, but still the issue persists.
I have already followed the steps for 'python manage.py makemigrations' , 'python manage.py migrate'.
i tried to upgrade as well as "downgrade your version of sqlite to a version prior to 2.6 (e.g. 2.5.1)", but I don't know how to do this.
Can anyone help.
Environment:
Request Method: POST
Request URL: http://127.0.0.1:8000/admin/myschoolweb/album/add/
Django Version: 2.1.4
Python Version: 3.7.1
Installed Applications:
['django.contrib.admin',
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.messages',
'django.contrib.staticfiles',
'myschoolweb']
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']
Traceback:
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbbackendsutils.py" in _execute
85. return self.cursor.execute(sql, params)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbbackendssqlite3base.py" in execute
296. return Database.Cursor.execute(self, query, params)
The above exception (no such table: main.auth_user__old) was the direct cause of the following exception:
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangocorehandlersexception.py" in inner
34. response = get_response(request)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangocorehandlersbase.py" in _get_response
126. response = self.process_exception_by_middleware(e, request)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangocorehandlersbase.py" in _get_response
124. response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangocontribadminoptions.py" in wrapper
604. return self.admin_site.admin_view(view)(*args, **kwargs)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangoutilsdecorators.py" in _wrapped_view
142. response = view_func(request, *args, **kwargs)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangoviewsdecoratorscache.py" in _wrapped_view_func
44. response = view_func(request, *args, **kwargs)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangocontribadminsites.py" in inner
223. return view(request, *args, **kwargs)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangocontribadminoptions.py" in add_view
1637. return self.changeform_view(request, None, form_url, extra_context)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangoutilsdecorators.py" in _wrapper
45. return bound_method(*args, **kwargs)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangoutilsdecorators.py" in _wrapped_view
142. response = view_func(request, *args, **kwargs)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangocontribadminoptions.py" in changeform_view
1525. return self._changeform_view(request, object_id, form_url, extra_context)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangocontribadminoptions.py" in _changeform_view
1568. self.log_addition(request, new_object, change_message)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangocontribadminoptions.py" in log_addition
810. change_message=message,
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangocontribadminmodels.py" in log_action
35. change_message=change_message,
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbmodelsmanager.py" in manager_method
82. return getattr(self.get_queryset(), name)(*args, **kwargs)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbmodelsquery.py" in create
413. obj.save(force_insert=True, using=self.db)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbmodelsbase.py" in save
718. force_update=force_update, update_fields=update_fields)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbmodelsbase.py" in save_base
748. updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbmodelsbase.py" in _save_table
831. result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbmodelsbase.py" in _do_insert
869. using=using, raw=raw)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbmodelsmanager.py" in manager_method
82. return getattr(self.get_queryset(), name)(*args, **kwargs)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbmodelsquery.py" in _insert
1136. return query.get_compiler(using=using).execute_sql(return_id)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbmodelssqlcompiler.py" in execute_sql
1289. cursor.execute(sql, params)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbbackendsutils.py" in execute
100. return super().execute(sql, params)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbbackendsutils.py" in execute
68. return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbbackendsutils.py" in _execute_with_wrappers
77. return executor(sql, params, many, context)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbbackendsutils.py" in _execute
85. return self.cursor.execute(sql, params)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbutils.py" in __exit__
89. raise dj_exc_value.with_traceback(traceback) from exc_value
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbbackendsutils.py" in _execute
85. return self.cursor.execute(sql, params)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbbackendssqlite3base.py" in execute
296. return Database.Cursor.execute(self, query, params)
Exception Type: OperationalError at /admin/myschoolweb/album/add/
Exception Value: no such table: main.auth_user__old
python django sqlite3
asked Jan 1 at 9:48
Akshat ChaudharyAkshat Chaudhary
82
run the following command,python manage.py migratethen try
– JPG
Jan 1 at 10:10
as i said earlier, i have already ran the command 'python manage.py makemigrations' and 'python manage.py migrate'
– Akshat Chaudhary
Jan 1 at 12:15
add a comment |
0
0
0
I am trying to add new data in table, but every time it gives below error
Django Version: 2.1.4
Python Version: 3.7.1
Sqlite3 Version: 2.6.0
I have already gone through all the available answers here, but still the issue persists.
I have already followed the steps for 'python manage.py makemigrations' , 'python manage.py migrate'.
i tried to upgrade as well as "downgrade your version of sqlite to a version prior to 2.6 (e.g. 2.5.1)", but I don't know how to do this.
Can anyone help.
Environment:
Request Method: POST
Request URL: http://127.0.0.1:8000/admin/myschoolweb/album/add/
Django Version: 2.1.4
Python Version: 3.7.1
Installed Applications:
['django.contrib.admin',
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.messages',
'django.contrib.staticfiles',
'myschoolweb']
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']
Traceback:
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbbackendsutils.py" in _execute
85. return self.cursor.execute(sql, params)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbbackendssqlite3base.py" in execute
296. return Database.Cursor.execute(self, query, params)
The above exception (no such table: main.auth_user__old) was the direct cause of the following exception:
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangocorehandlersexception.py" in inner
34. response = get_response(request)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangocorehandlersbase.py" in _get_response
126. response = self.process_exception_by_middleware(e, request)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangocorehandlersbase.py" in _get_response
124. response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangocontribadminoptions.py" in wrapper
604. return self.admin_site.admin_view(view)(*args, **kwargs)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangoutilsdecorators.py" in _wrapped_view
142. response = view_func(request, *args, **kwargs)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangoviewsdecoratorscache.py" in _wrapped_view_func
44. response = view_func(request, *args, **kwargs)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangocontribadminsites.py" in inner
223. return view(request, *args, **kwargs)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangocontribadminoptions.py" in add_view
1637. return self.changeform_view(request, None, form_url, extra_context)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangoutilsdecorators.py" in _wrapper
45. return bound_method(*args, **kwargs)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangoutilsdecorators.py" in _wrapped_view
142. response = view_func(request, *args, **kwargs)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangocontribadminoptions.py" in changeform_view
1525. return self._changeform_view(request, object_id, form_url, extra_context)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangocontribadminoptions.py" in _changeform_view
1568. self.log_addition(request, new_object, change_message)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangocontribadminoptions.py" in log_addition
810. change_message=message,
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangocontribadminmodels.py" in log_action
35. change_message=change_message,
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbmodelsmanager.py" in manager_method
82. return getattr(self.get_queryset(), name)(*args, **kwargs)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbmodelsquery.py" in create
413. obj.save(force_insert=True, using=self.db)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbmodelsbase.py" in save
718. force_update=force_update, update_fields=update_fields)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbmodelsbase.py" in save_base
748. updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbmodelsbase.py" in _save_table
831. result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbmodelsbase.py" in _do_insert
869. using=using, raw=raw)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbmodelsmanager.py" in manager_method
82. return getattr(self.get_queryset(), name)(*args, **kwargs)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbmodelsquery.py" in _insert
1136. return query.get_compiler(using=using).execute_sql(return_id)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbmodelssqlcompiler.py" in execute_sql
1289. cursor.execute(sql, params)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbbackendsutils.py" in execute
100. return super().execute(sql, params)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbbackendsutils.py" in execute
68. return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbbackendsutils.py" in _execute_with_wrappers
77. return executor(sql, params, many, context)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbbackendsutils.py" in _execute
85. return self.cursor.execute(sql, params)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbutils.py" in __exit__
89. raise dj_exc_value.with_traceback(traceback) from exc_value
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbbackendsutils.py" in _execute
85. return self.cursor.execute(sql, params)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbbackendssqlite3base.py" in execute
296. return Database.Cursor.execute(self, query, params)
Exception Type: OperationalError at /admin/myschoolweb/album/add/
Exception Value: no such table: main.auth_user__old
python django sqlite3
asked Jan 1 at 9:48
Akshat ChaudharyAkshat Chaudhary
82
I am trying to add new data in table, but every time it gives below error
Django Version: 2.1.4
Python Version: 3.7.1
Sqlite3 Version: 2.6.0
I have already gone through all the available answers here, but still the issue persists.
I have already followed the steps for 'python manage.py makemigrations' , 'python manage.py migrate'.
i tried to upgrade as well as "downgrade your version of sqlite to a version prior to 2.6 (e.g. 2.5.1)", but I don't know how to do this.
Can anyone help.
Environment:
Request Method: POST
Request URL: http://127.0.0.1:8000/admin/myschoolweb/album/add/
Django Version: 2.1.4
Python Version: 3.7.1
Installed Applications:
['django.contrib.admin',
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.messages',
'django.contrib.staticfiles',
'myschoolweb']
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']
Traceback:
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbbackendsutils.py" in _execute
85. return self.cursor.execute(sql, params)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbbackendssqlite3base.py" in execute
296. return Database.Cursor.execute(self, query, params)
The above exception (no such table: main.auth_user__old) was the direct cause of the following exception:
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangocorehandlersexception.py" in inner
34. response = get_response(request)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangocorehandlersbase.py" in _get_response
126. response = self.process_exception_by_middleware(e, request)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangocorehandlersbase.py" in _get_response
124. response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangocontribadminoptions.py" in wrapper
604. return self.admin_site.admin_view(view)(*args, **kwargs)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangoutilsdecorators.py" in _wrapped_view
142. response = view_func(request, *args, **kwargs)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangoviewsdecoratorscache.py" in _wrapped_view_func
44. response = view_func(request, *args, **kwargs)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangocontribadminsites.py" in inner
223. return view(request, *args, **kwargs)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangocontribadminoptions.py" in add_view
1637. return self.changeform_view(request, None, form_url, extra_context)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangoutilsdecorators.py" in _wrapper
45. return bound_method(*args, **kwargs)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangoutilsdecorators.py" in _wrapped_view
142. response = view_func(request, *args, **kwargs)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangocontribadminoptions.py" in changeform_view
1525. return self._changeform_view(request, object_id, form_url, extra_context)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangocontribadminoptions.py" in _changeform_view
1568. self.log_addition(request, new_object, change_message)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangocontribadminoptions.py" in log_addition
810. change_message=message,
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangocontribadminmodels.py" in log_action
35. change_message=change_message,
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbmodelsmanager.py" in manager_method
82. return getattr(self.get_queryset(), name)(*args, **kwargs)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbmodelsquery.py" in create
413. obj.save(force_insert=True, using=self.db)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbmodelsbase.py" in save
718. force_update=force_update, update_fields=update_fields)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbmodelsbase.py" in save_base
748. updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbmodelsbase.py" in _save_table
831. result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbmodelsbase.py" in _do_insert
869. using=using, raw=raw)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbmodelsmanager.py" in manager_method
82. return getattr(self.get_queryset(), name)(*args, **kwargs)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbmodelsquery.py" in _insert
1136. return query.get_compiler(using=using).execute_sql(return_id)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbmodelssqlcompiler.py" in execute_sql
1289. cursor.execute(sql, params)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbbackendsutils.py" in execute
100. return super().execute(sql, params)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbbackendsutils.py" in execute
68. return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbbackendsutils.py" in _execute_with_wrappers
77. return executor(sql, params, many, context)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbbackendsutils.py" in _execute
85. return self.cursor.execute(sql, params)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbutils.py" in __exit__
89. raise dj_exc_value.with_traceback(traceback) from exc_value
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbbackendsutils.py" in _execute
85. return self.cursor.execute(sql, params)
File "C:Users<USER>Miniconda3envsmywebsitelibsite-packagesdjangodbbackendssqlite3base.py" in execute
296. return Database.Cursor.execute(self, query, params)
Exception Type: OperationalError at /admin/myschoolweb/album/add/
Exception Value: no such table: main.auth_user__old
python django sqlite3
python django sqlite3
asked Jan 1 at 9:48
Akshat ChaudharyAkshat Chaudhary
82
asked Jan 1 at 9:48
Akshat ChaudharyAkshat Chaudhary
82
asked Jan 1 at 9:48
Akshat ChaudharyAkshat Chaudhary
82
asked Jan 1 at 9:48
Akshat ChaudharyAkshat Chaudhary
82
asked Jan 1 at 9:48
Akshat ChaudharyAkshat Chaudhary
82
82
run the following command,python manage.py migratethen try
– JPG
Jan 1 at 10:10
as i said earlier, i have already ran the command 'python manage.py makemigrations' and 'python manage.py migrate'
– Akshat Chaudhary
Jan 1 at 12:15
add a comment |
run the following command,python manage.py migratethen try
– JPG
Jan 1 at 10:10
as i said earlier, i have already ran the command 'python manage.py makemigrations' and 'python manage.py migrate'
– Akshat Chaudhary
Jan 1 at 12:15
run the following command,
python manage.py migrate then try– JPG
Jan 1 at 10:10
run the following command,
python manage.py migrate then try– JPG
Jan 1 at 10:10
as i said earlier, i have already ran the command 'python manage.py makemigrations' and 'python manage.py migrate'
– Akshat Chaudhary
Jan 1 at 12:15
as i said earlier, i have already ran the command 'python manage.py makemigrations' and 'python manage.py migrate'
– Akshat Chaudhary
Jan 1 at 12:15
add a comment |
1 Answer
1
active
oldest
votes
1
I'm having the same problem and apparently when Django 2.1.5 comes out, (which should've been today) the problem will be fixed. A lot of people have been answering the question, and questions have been marked as a duplicate but the original question didn't have a satisfactory answer.
People said to downgrade, it won't work. I've tried pip installing older versions of Django. I think it's incompatible with python 3.7.1
Postsql won't work with it either because similar errors come up when running this too.
I suggest waiting until Django 2.1.5 comes out. Someone on another post also recommended PRAGMA legacy_alter_table = ON which will seem to work, I just don't know where to enter this code. I searched through a lot of the files, but If anyone can help direct where we should input this line of code it would help a lot.
answered Jan 1 at 23:42
ZiiikZiiik
424
I guess, if there is any other free database we can use ?
– Akshat Chaudhary
Jan 2 at 13:51
Even after updating django to 2.1.5, the problem persists. Dont know how to proceed now. Can anyone help ?
– Akshat Chaudhary
Jan 5 at 8:31
1
Akshat, I was worried when I saw your comment. I was just able to check out the update and I'll tell you what I did, because it worked for me. Delete thedb.sqlit3file in your main project directory. Then go into your app's directory, in the migrations folder and delete everything in__pycache__and anything that isn't__init__.py. You then want tomanage.py makemigrations, manage.py migrate, manage.py createsuperuser, and then manage.py runserver. It should work after that. Good Luck!!!
– Ziiik
Jan 6 at 4:17
1
Thanks @Ziiik ... it worked.
– Akshat Chaudhary
Jan 6 at 14:06
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53994454%2foperationalerror-at-admin-myschoolweb-album-add-no-such-table-main-auth-use%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
1
I'm having the same problem and apparently when Django 2.1.5 comes out, (which should've been today) the problem will be fixed. A lot of people have been answering the question, and questions have been marked as a duplicate but the original question didn't have a satisfactory answer.
People said to downgrade, it won't work. I've tried pip installing older versions of Django. I think it's incompatible with python 3.7.1
Postsql won't work with it either because similar errors come up when running this too.
I suggest waiting until Django 2.1.5 comes out. Someone on another post also recommended PRAGMA legacy_alter_table = ON which will seem to work, I just don't know where to enter this code. I searched through a lot of the files, but If anyone can help direct where we should input this line of code it would help a lot.
answered Jan 1 at 23:42
ZiiikZiiik
424
I guess, if there is any other free database we can use ?
– Akshat Chaudhary
Jan 2 at 13:51
Even after updating django to 2.1.5, the problem persists. Dont know how to proceed now. Can anyone help ?
– Akshat Chaudhary
Jan 5 at 8:31
1
Akshat, I was worried when I saw your comment. I was just able to check out the update and I'll tell you what I did, because it worked for me. Delete thedb.sqlit3file in your main project directory. Then go into your app's directory, in the migrations folder and delete everything in__pycache__and anything that isn't__init__.py. You then want tomanage.py makemigrations, manage.py migrate, manage.py createsuperuser, and then manage.py runserver. It should work after that. Good Luck!!!
– Ziiik
Jan 6 at 4:17
1
Thanks @Ziiik ... it worked.
– Akshat Chaudhary
Jan 6 at 14:06
add a comment |
1
I'm having the same problem and apparently when Django 2.1.5 comes out, (which should've been today) the problem will be fixed. A lot of people have been answering the question, and questions have been marked as a duplicate but the original question didn't have a satisfactory answer.
People said to downgrade, it won't work. I've tried pip installing older versions of Django. I think it's incompatible with python 3.7.1
Postsql won't work with it either because similar errors come up when running this too.
I suggest waiting until Django 2.1.5 comes out. Someone on another post also recommended PRAGMA legacy_alter_table = ON which will seem to work, I just don't know where to enter this code. I searched through a lot of the files, but If anyone can help direct where we should input this line of code it would help a lot.
answered Jan 1 at 23:42
ZiiikZiiik
424
I guess, if there is any other free database we can use ?
– Akshat Chaudhary
Jan 2 at 13:51
Even after updating django to 2.1.5, the problem persists. Dont know how to proceed now. Can anyone help ?
– Akshat Chaudhary
Jan 5 at 8:31
1
Akshat, I was worried when I saw your comment. I was just able to check out the update and I'll tell you what I did, because it worked for me. Delete thedb.sqlit3file in your main project directory. Then go into your app's directory, in the migrations folder and delete everything in__pycache__and anything that isn't__init__.py. You then want tomanage.py makemigrations, manage.py migrate, manage.py createsuperuser, and then manage.py runserver. It should work after that. Good Luck!!!
– Ziiik
Jan 6 at 4:17
1
Thanks @Ziiik ... it worked.
– Akshat Chaudhary
Jan 6 at 14:06
add a comment |
1
1
1
I'm having the same problem and apparently when Django 2.1.5 comes out, (which should've been today) the problem will be fixed. A lot of people have been answering the question, and questions have been marked as a duplicate but the original question didn't have a satisfactory answer.
People said to downgrade, it won't work. I've tried pip installing older versions of Django. I think it's incompatible with python 3.7.1
Postsql won't work with it either because similar errors come up when running this too.
I suggest waiting until Django 2.1.5 comes out. Someone on another post also recommended PRAGMA legacy_alter_table = ON which will seem to work, I just don't know where to enter this code. I searched through a lot of the files, but If anyone can help direct where we should input this line of code it would help a lot.
answered Jan 1 at 23:42
ZiiikZiiik
424
I'm having the same problem and apparently when Django 2.1.5 comes out, (which should've been today) the problem will be fixed. A lot of people have been answering the question, and questions have been marked as a duplicate but the original question didn't have a satisfactory answer.
People said to downgrade, it won't work. I've tried pip installing older versions of Django. I think it's incompatible with python 3.7.1
Postsql won't work with it either because similar errors come up when running this too.
I suggest waiting until Django 2.1.5 comes out. Someone on another post also recommended PRAGMA legacy_alter_table = ON which will seem to work, I just don't know where to enter this code. I searched through a lot of the files, but If anyone can help direct where we should input this line of code it would help a lot.
answered Jan 1 at 23:42
ZiiikZiiik
424
answered Jan 1 at 23:42
ZiiikZiiik
424
answered Jan 1 at 23:42
ZiiikZiiik
424
answered Jan 1 at 23:42
ZiiikZiiik
424
424
I guess, if there is any other free database we can use ?
– Akshat Chaudhary
Jan 2 at 13:51
Even after updating django to 2.1.5, the problem persists. Dont know how to proceed now. Can anyone help ?
– Akshat Chaudhary
Jan 5 at 8:31
1
Akshat, I was worried when I saw your comment. I was just able to check out the update and I'll tell you what I did, because it worked for me. Delete thedb.sqlit3file in your main project directory. Then go into your app's directory, in the migrations folder and delete everything in__pycache__and anything that isn't__init__.py. You then want tomanage.py makemigrations, manage.py migrate, manage.py createsuperuser, and then manage.py runserver. It should work after that. Good Luck!!!
– Ziiik
Jan 6 at 4:17
1
Thanks @Ziiik ... it worked.
– Akshat Chaudhary
Jan 6 at 14:06
add a comment |
I guess, if there is any other free database we can use ?
– Akshat Chaudhary
Jan 2 at 13:51
Even after updating django to 2.1.5, the problem persists. Dont know how to proceed now. Can anyone help ?
– Akshat Chaudhary
Jan 5 at 8:31
1
Akshat, I was worried when I saw your comment. I was just able to check out the update and I'll tell you what I did, because it worked for me. Delete thedb.sqlit3file in your main project directory. Then go into your app's directory, in the migrations folder and delete everything in__pycache__and anything that isn't__init__.py. You then want tomanage.py makemigrations, manage.py migrate, manage.py createsuperuser, and then manage.py runserver. It should work after that. Good Luck!!!
– Ziiik
Jan 6 at 4:17
1
Thanks @Ziiik ... it worked.
– Akshat Chaudhary
Jan 6 at 14:06
I guess, if there is any other free database we can use ?
– Akshat Chaudhary
Jan 2 at 13:51
I guess, if there is any other free database we can use ?
– Akshat Chaudhary
Jan 2 at 13:51
Even after updating django to 2.1.5, the problem persists. Dont know how to proceed now. Can anyone help ?
– Akshat Chaudhary
Jan 5 at 8:31
Even after updating django to 2.1.5, the problem persists. Dont know how to proceed now. Can anyone help ?
– Akshat Chaudhary
Jan 5 at 8:31
1
1
Akshat, I was worried when I saw your comment. I was just able to check out the update and I'll tell you what I did, because it worked for me. Delete the
db.sqlit3 file in your main project directory. Then go into your app's directory, in the migrations folder and delete everything in __pycache__ and anything that isn't __init__.py. You then want to manage.py makemigrations, manage.py migrate, manage.py createsuperuser, and then manage.py runserver. It should work after that. Good Luck!!!– Ziiik
Jan 6 at 4:17
Akshat, I was worried when I saw your comment. I was just able to check out the update and I'll tell you what I did, because it worked for me. Delete the
db.sqlit3 file in your main project directory. Then go into your app's directory, in the migrations folder and delete everything in __pycache__ and anything that isn't __init__.py. You then want to manage.py makemigrations, manage.py migrate, manage.py createsuperuser, and then manage.py runserver. It should work after that. Good Luck!!!– Ziiik
Jan 6 at 4:17
1
1
Thanks @Ziiik ... it worked.
– Akshat Chaudhary
Jan 6 at 14:06
Thanks @Ziiik ... it worked.
– Akshat Chaudhary
Jan 6 at 14:06
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53994454%2foperationalerror-at-admin-myschoolweb-album-add-no-such-table-main-auth-use%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
run the following command,
python manage.py migratethen try– JPG
Jan 1 at 10:10
as i said earlier, i have already ran the command 'python manage.py makemigrations' and 'python manage.py migrate'
– Akshat Chaudhary
Jan 1 at 12:15