On Sun, May 3, 2020 at 1:04 PM Iain Stewart <iain.a.stew...@gmail.com> wrote:
> Hi Famzaa, > > I have made migrations but the admin interface is not finding the database > perhaps? I get this exception: > > Exception Location: > C:\Users\user\PycharmProjects\JoanneShop\venv\lib\site-packages\django\db\backends\sqlite3\base.py > in execute, line 296 > > Any help much appreciated. > > Iain > > On Sunday, 3 May 2020 00:06:57 UTC+1, Famzaa wrote: >> >> first run makemigrations and then migrate to create table if you see the >> model name in admin section this means that the table is created sometimes >> this happens when you make changes to the model and don't run migrations. >> >> On Sat, May 2, 2020 at 10:33 PM Jorge Gimeno <jlgim...@gmail.com> wrote: >> >>> >>> >>> On Sat, May 2, 2020 at 7:43 AM Iain Stewart <iain.a...@gmail.com> wrote: >>> >>>> Hi Folks, >>>> >>>> I am a learner and am enjoying learning Django so far (about a month >>>> in). I am doing the Mosh Python Tutorial for Begnniners on You Tube and in >>>> trying to save my first product on the Django admin/ products page and got >>>> the following error. I suspect the problem is between Django and SQLite. >>>> Any possible solution would be appreciated. Thanks! >>>> Request Method: POST Request URL: >>>> http://127.0.0.1:8000/admin/products/product/add/ >>>> >>>> <https://www.youtube.com/redirect?q=http%3A%2F%2F127.0.0.1%3A8000%2Fadmin%2Fproducts%2Fproduct%2Fadd%2F&redir_token=ri7g7iQXEDVzCKUpVygfGVRdSNh8MTU4ODQ5ODI0OEAxNTg4NDExODQ4&event=comments&stzid=Ugzjv_AAC_iJQGZgxuB4AaABAg> >>>> Django >>>> Version: 2.1 Python Version: 3.7.7 Installed Applications: >>>> ['django.contrib.admin', >>>> 'django.contrib.auth', 'django.contrib.contenttypes', >>>> 'django.contrib.sessions', >>>> 'django.contrib.messages', 'django.contrib.staticfiles', >>>> 'products.apps.ProductsConfig'] >>>> 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\PycharmProjects\PyShop\venv\lib\site-packages\django\db\backends\ >>>> utils.py >>>> <https://www.youtube.com/redirect?q=http%3A%2F%2Futils.py%2F&redir_token=ri7g7iQXEDVzCKUpVygfGVRdSNh8MTU4ODQ5ODI0OEAxNTg4NDExODQ4&event=comments&stzid=Ugzjv_AAC_iJQGZgxuB4AaABAg>" >>>> in _execute 85. return self.cursor.execute(sql, params) File >>>> "C:\Users\user\PycharmProjects\PyShop\venv\lib\site-packages\django\db\backends\sqlite3\ >>>> base.py >>>> <https://www.youtube.com/redirect?q=http%3A%2F%2Fbase.py%2F&redir_token=ri7g7iQXEDVzCKUpVygfGVRdSNh8MTU4ODQ5ODI0OEAxNTg4NDExODQ4&event=comments&stzid=Ugzjv_AAC_iJQGZgxuB4AaABAg>" >>>> 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\PycharmProjects\PyShop\venv\lib\site-packages\django\core\handlers\ >>>> exception.py >>>> <https://www.youtube.com/redirect?q=http%3A%2F%2Fexception.py%2F&redir_token=ri7g7iQXEDVzCKUpVygfGVRdSNh8MTU4ODQ5ODI0OEAxNTg4NDExODQ4&event=comments&stzid=Ugzjv_AAC_iJQGZgxuB4AaABAg>" >>>> in inner 34. response = get_response(request) File >>>> "C:\Users\user\PycharmProjects\PyShop\venv\lib\site-packages\django\core\handlers\ >>>> base.py >>>> <https://www.youtube.com/redirect?q=http%3A%2F%2Fbase.py%2F&redir_token=ri7g7iQXEDVzCKUpVygfGVRdSNh8MTU4ODQ5ODI0OEAxNTg4NDExODQ4&event=comments&stzid=Ugzjv_AAC_iJQGZgxuB4AaABAg>" >>>> in _get_response 126. response = >>>> self.process_exception_by_middleware(e, request) File >>>> "C:\Users\user\PycharmProjects\PyShop\venv\lib\site-packages\django\core\handlers\ >>>> base.py >>>> <https://www.youtube.com/redirect?q=http%3A%2F%2Fbase.py%2F&redir_token=ri7g7iQXEDVzCKUpVygfGVRdSNh8MTU4ODQ5ODI0OEAxNTg4NDExODQ4&event=comments&stzid=Ugzjv_AAC_iJQGZgxuB4AaABAg>" >>>> in _get_response 124. response = wrapped_callback(request, >>>> *callback_args, **callback_kwargs) File >>>> "C:\Users\user\PycharmProjects\PyShop\venv\lib\site-packages\django\contrib\admin\ >>>> options.py >>>> <https://www.youtube.com/redirect?q=http%3A%2F%2Foptions.py%2F&redir_token=ri7g7iQXEDVzCKUpVygfGVRdSNh8MTU4ODQ5ODI0OEAxNTg4NDExODQ4&event=comments&stzid=Ugzjv_AAC_iJQGZgxuB4AaABAg>" >>>> in wrapper 607. return self.admin_site.admin_view(view)(*args, >>>> **kwargs) File >>>> "C:\Users\user\PycharmProjects\PyShop\venv\lib\site-packages\django\utils\ >>>> decorators.py >>>> <https://www.youtube.com/redirect?q=http%3A%2F%2Fdecorators.py%2F&redir_token=ri7g7iQXEDVzCKUpVygfGVRdSNh8MTU4ODQ5ODI0OEAxNTg4NDExODQ4&event=comments&stzid=Ugzjv_AAC_iJQGZgxuB4AaABAg>" >>>> in _wrapped_view 142. response = view_func(request, *args, **kwargs) File >>>> "C:\Users\user\PycharmProjects\PyShop\venv\lib\site-packages\django\views\decorators\ >>>> cache.py >>>> <https://www.youtube.com/redirect?q=http%3A%2F%2Fcache.py%2F&redir_token=ri7g7iQXEDVzCKUpVygfGVRdSNh8MTU4ODQ5ODI0OEAxNTg4NDExODQ4&event=comments&stzid=Ugzjv_AAC_iJQGZgxuB4AaABAg>" >>>> in _wrapped_view_func 44. response = view_func(request, *args, >>>> **kwargs) File >>>> "C:\Users\user\PycharmProjects\PyShop\venv\lib\site-packages\django\contrib\admin\ >>>> sites.py >>>> <https://www.youtube.com/redirect?q=http%3A%2F%2Fsites.py%2F&redir_token=ri7g7iQXEDVzCKUpVygfGVRdSNh8MTU4ODQ5ODI0OEAxNTg4NDExODQ4&event=comments&stzid=Ugzjv_AAC_iJQGZgxuB4AaABAg>" >>>> in inner 223. return view(request, *args, **kwargs) File >>>> "C:\Users\user\PycharmProjects\PyShop\venv\lib\site-packages\django\contrib\admin\ >>>> options.py >>>> <https://www.youtube.com/redirect?q=http%3A%2F%2Foptions.py%2F&redir_token=ri7g7iQXEDVzCKUpVygfGVRdSNh8MTU4ODQ5ODI0OEAxNTg4NDExODQ4&event=comments&stzid=Ugzjv_AAC_iJQGZgxuB4AaABAg>" >>>> in add_view 1647. return self.changeform_view(request, None, form_url, >>>> extra_context) File >>>> "C:\Users\user\PycharmProjects\PyShop\venv\lib\site-packages\django\utils\ >>>> decorators.py >>>> <https://www.youtube.com/redirect?q=http%3A%2F%2Fdecorators.py%2F&redir_token=ri7g7iQXEDVzCKUpVygfGVRdSNh8MTU4ODQ5ODI0OEAxNTg4NDExODQ4&event=comments&stzid=Ugzjv_AAC_iJQGZgxuB4AaABAg>" >>>> in _wrapper 45. return bound_method(*args, **kwargs) File >>>> "C:\Users\user\PycharmProjects\PyShop\venv\lib\site-packages\django\utils\ >>>> decorators.py >>>> <https://www.youtube.com/redirect?q=http%3A%2F%2Fdecorators.py%2F&redir_token=ri7g7iQXEDVzCKUpVygfGVRdSNh8MTU4ODQ5ODI0OEAxNTg4NDExODQ4&event=comments&stzid=Ugzjv_AAC_iJQGZgxuB4AaABAg>" >>>> in _wrapped_view 142. response = view_func(request, *args, **kwargs) File >>>> "C:\Users\user\PycharmProjects\PyShop\venv\lib\site-packages\django\contrib\admin\ >>>> options.py >>>> <https://www.youtube.com/redirect?q=http%3A%2F%2Foptions.py%2F&redir_token=ri7g7iQXEDVzCKUpVygfGVRdSNh8MTU4ODQ5ODI0OEAxNTg4NDExODQ4&event=comments&stzid=Ugzjv_AAC_iJQGZgxuB4AaABAg>" >>>> in changeform_view 1536. return self._changeform_view(request, >>>> object_id, form_url, extra_context) File >>>> "C:\Users\user\PycharmProjects\PyShop\venv\lib\site-packages\django\contrib\admin\ >>>> options.py >>>> <https://www.youtube.com/redirect?q=http%3A%2F%2Foptions.py%2F&redir_token=ri7g7iQXEDVzCKUpVygfGVRdSNh8MTU4ODQ5ODI0OEAxNTg4NDExODQ4&event=comments&stzid=Ugzjv_AAC_iJQGZgxuB4AaABAg>" >>>> in _changeform_view 1579. self.log_addition(request, new_object, >>>> change_message) File >>>> "C:\Users\user\PycharmProjects\PyShop\venv\lib\site-packages\django\contrib\admin\ >>>> options.py >>>> <https://www.youtube.com/redirect?q=http%3A%2F%2Foptions.py%2F&redir_token=ri7g7iQXEDVzCKUpVygfGVRdSNh8MTU4ODQ5ODI0OEAxNTg4NDExODQ4&event=comments&stzid=Ugzjv_AAC_iJQGZgxuB4AaABAg>" >>>> in log_addition 813. change_message=message, File >>>> "C:\Users\user\PycharmProjects\PyShop\venv\lib\site-packages\django\contrib\admin\ >>>> models.py >>>> <https://www.youtube.com/redirect?q=http%3A%2F%2Fmodels.py%2F&redir_token=ri7g7iQXEDVzCKUpVygfGVRdSNh8MTU4ODQ5ODI0OEAxNTg4NDExODQ4&event=comments&stzid=Ugzjv_AAC_iJQGZgxuB4AaABAg>" >>>> in log_action 35. change_message=change_message, File >>>> "C:\Users\user\PycharmProjects\PyShop\venv\lib\site-packages\django\db\models\ >>>> manager.py >>>> <https://www.youtube.com/redirect?q=http%3A%2F%2Fmanager.py%2F&redir_token=ri7g7iQXEDVzCKUpVygfGVRdSNh8MTU4ODQ5ODI0OEAxNTg4NDExODQ4&event=comments&stzid=Ugzjv_AAC_iJQGZgxuB4AaABAg>" >>>> in manager_method 82. return getattr(self.get_queryset(), name)(*args, >>>> **kwargs) File >>>> "C:\Users\user\PycharmProjects\PyShop\venv\lib\site-packages\django\db\models\ >>>> query.py >>>> <https://www.youtube.com/redirect?q=http%3A%2F%2Fquery.py%2F&redir_token=ri7g7iQXEDVzCKUpVygfGVRdSNh8MTU4ODQ5ODI0OEAxNTg4NDExODQ4&event=comments&stzid=Ugzjv_AAC_iJQGZgxuB4AaABAg>" >>>> in create 413. obj.save(force_insert=True, using=self.db) File >>>> "C:\Users\user\PycharmProjects\PyShop\venv\lib\site-packages\django\db\models\ >>>> base.py >>>> <https://www.youtube.com/redirect?q=http%3A%2F%2Fbase.py%2F&redir_token=ri7g7iQXEDVzCKUpVygfGVRdSNh8MTU4ODQ5ODI0OEAxNTg4NDExODQ4&event=comments&stzid=Ugzjv_AAC_iJQGZgxuB4AaABAg>" >>>> in save 717. force_update=force_update, update_fields=update_fields) File >>>> "C:\Users\user\PycharmProjects\PyShop\venv\lib\site-packages\django\db\models\ >>>> base.py >>>> <https://www.youtube.com/redirect?q=http%3A%2F%2Fbase.py%2F&redir_token=ri7g7iQXEDVzCKUpVygfGVRdSNh8MTU4ODQ5ODI0OEAxNTg4NDExODQ4&event=comments&stzid=Ugzjv_AAC_iJQGZgxuB4AaABAg>" >>>> in save_base 747. updated = self._save_table(raw, cls, force_insert, >>>> force_update, using, update_fields) File >>>> "C:\Users\user\PycharmProjects\PyShop\venv\lib\site-packages\django\db\models\ >>>> base.py >>>> <https://www.youtube.com/redirect?q=http%3A%2F%2Fbase.py%2F&redir_token=ri7g7iQXEDVzCKUpVygfGVRdSNh8MTU4ODQ5ODI0OEAxNTg4NDExODQ4&event=comments&stzid=Ugzjv_AAC_iJQGZgxuB4AaABAg>" >>>> in _save_table 830. result = self._do_insert(cls._base_manager, using, >>>> fields, update_pk, raw) File >>>> "C:\Users\user\PycharmProjects\PyShop\venv\lib\site-packages\django\db\models\ >>>> base.py >>>> <https://www.youtube.com/redirect?q=http%3A%2F%2Fbase.py%2F&redir_token=ri7g7iQXEDVzCKUpVygfGVRdSNh8MTU4ODQ5ODI0OEAxNTg4NDExODQ4&event=comments&stzid=Ugzjv_AAC_iJQGZgxuB4AaABAg>" >>>> in _do_insert 868. using=using, raw=raw) File >>>> "C:\Users\user\PycharmProjects\PyShop\venv\lib\site-packages\django\db\models\ >>>> manager.py >>>> <https://www.youtube.com/redirect?q=http%3A%2F%2Fmanager.py%2F&redir_token=ri7g7iQXEDVzCKUpVygfGVRdSNh8MTU4ODQ5ODI0OEAxNTg4NDExODQ4&event=comments&stzid=Ugzjv_AAC_iJQGZgxuB4AaABAg>" >>>> in manager_method 82. return getattr(self.get_queryset(), name)(*args, >>>> **kwargs) File >>>> "C:\Users\user\PycharmProjects\PyShop\venv\lib\site-packages\django\db\models\ >>>> query.py >>>> <https://www.youtube.com/redirect?q=http%3A%2F%2Fquery.py%2F&redir_token=ri7g7iQXEDVzCKUpVygfGVRdSNh8MTU4ODQ5ODI0OEAxNTg4NDExODQ4&event=comments&stzid=Ugzjv_AAC_iJQGZgxuB4AaABAg>" >>>> in _insert 1133. return >>>> query.get_compiler(using=using).execute_sql(return_id) File >>>> "C:\Users\user\PycharmProjects\PyShop\venv\lib\site-packages\django\db\models\sql\ >>>> compiler.py >>>> <https://www.youtube.com/redirect?q=http%3A%2F%2Fcompiler.py%2F&redir_token=ri7g7iQXEDVzCKUpVygfGVRdSNh8MTU4ODQ5ODI0OEAxNTg4NDExODQ4&event=comments&stzid=Ugzjv_AAC_iJQGZgxuB4AaABAg>" >>>> in execute_sql 1285. cursor.execute(sql, params) File >>>> "C:\Users\user\PycharmProjects\PyShop\venv\lib\site-packages\django\db\backends\ >>>> utils.py >>>> <https://www.youtube.com/redirect?q=http%3A%2F%2Futils.py%2F&redir_token=ri7g7iQXEDVzCKUpVygfGVRdSNh8MTU4ODQ5ODI0OEAxNTg4NDExODQ4&event=comments&stzid=Ugzjv_AAC_iJQGZgxuB4AaABAg>" >>>> in execute 100. return super().execute(sql, params) File >>>> "C:\Users\user\PycharmProjects\PyShop\venv\lib\site-packages\django\db\backends\ >>>> utils.py >>>> <https://www.youtube.com/redirect?q=http%3A%2F%2Futils.py%2F&redir_token=ri7g7iQXEDVzCKUpVygfGVRdSNh8MTU4ODQ5ODI0OEAxNTg4NDExODQ4&event=comments&stzid=Ugzjv_AAC_iJQGZgxuB4AaABAg>" >>>> in execute 68. return self._execute_with_wrappers(sql, params, >>>> many=False, executor=self._execute) File >>>> "C:\Users\user\PycharmProjects\PyShop\venv\lib\site-packages\django\db\backends\ >>>> utils.py >>>> <https://www.youtube.com/redirect?q=http%3A%2F%2Futils.py%2F&redir_token=ri7g7iQXEDVzCKUpVygfGVRdSNh8MTU4ODQ5ODI0OEAxNTg4NDExODQ4&event=comments&stzid=Ugzjv_AAC_iJQGZgxuB4AaABAg>" >>>> in _execute_with_wrappers 77. return executor(sql, params, many, >>>> context) File >>>> "C:\Users\user\PycharmProjects\PyShop\venv\lib\site-packages\django\db\backends\ >>>> utils.py >>>> <https://www.youtube.com/redirect?q=http%3A%2F%2Futils.py%2F&redir_token=ri7g7iQXEDVzCKUpVygfGVRdSNh8MTU4ODQ5ODI0OEAxNTg4NDExODQ4&event=comments&stzid=Ugzjv_AAC_iJQGZgxuB4AaABAg>" >>>> in _execute 85. return self.cursor.execute(sql, params) File >>>> "C:\Users\user\PycharmProjects\PyShop\venv\lib\site-packages\django\db\ >>>> utils.py >>>> <https://www.youtube.com/redirect?q=http%3A%2F%2Futils.py%2F&redir_token=ri7g7iQXEDVzCKUpVygfGVRdSNh8MTU4ODQ5ODI0OEAxNTg4NDExODQ4&event=comments&stzid=Ugzjv_AAC_iJQGZgxuB4AaABAg>" >>>> in _exit_ 89. raise dj_exc_value.with_traceback(traceback) from >>>> exc_value File >>>> "C:\Users\user\PycharmProjects\PyShop\venv\lib\site-packages\django\db\backends\ >>>> utils.py >>>> <https://www.youtube.com/redirect?q=http%3A%2F%2Futils.py%2F&redir_token=ri7g7iQXEDVzCKUpVygfGVRdSNh8MTU4ODQ5ODI0OEAxNTg4NDExODQ4&event=comments&stzid=Ugzjv_AAC_iJQGZgxuB4AaABAg>" >>>> in _execute 85. return self.cursor.execute(sql, params) File >>>> "C:\Users\user\PycharmProjects\PyShop\venv\lib\site-packages\django\db\backends\sqlite3\ >>>> base.py >>>> <https://www.youtube.com/redirect?q=http%3A%2F%2Fbase.py%2F&redir_token=ri7g7iQXEDVzCKUpVygfGVRdSNh8MTU4ODQ5ODI0OEAxNTg4NDExODQ4&event=comments&stzid=Ugzjv_AAC_iJQGZgxuB4AaABAg>" >>>> in execute 296. return Database.Cursor.execute(self, query, params) >>>> Exception >>>> Type: OperationalError at /admin/products/product/add/ Exception >>>> Value: no such table: main.auth_user__old >>>> >>>> -- >>>> 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...@googlegroups.com. >>>> To view this discussion on the web visit >>>> https://groups.google.com/d/msgid/django-users/b1f1de4b-8851-4b5a-b04d-58cad1bc1124%40googlegroups.com >>>> <https://groups.google.com/d/msgid/django-users/b1f1de4b-8851-4b5a-b04d-58cad1bc1124%40googlegroups.com?utm_medium=email&utm_source=footer> >>>> . >>>> >>> >>> Have you run migrations yet? >>> >>> -Jorge >>> >>> -- >>> 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...@googlegroups.com. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/django-users/CANfN%3DK868-XUzFz9XeWZ0OWnGhh8YDy0%2BUd2StFdfsGjgMBpmA%40mail.gmail.com >>> <https://groups.google.com/d/msgid/django-users/CANfN%3DK868-XUzFz9XeWZ0OWnGhh8YDy0%2BUd2StFdfsGjgMBpmA%40mail.gmail.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/dfeb6eb4-20ec-44fe-b872-e383afc6d24e%40googlegroups.com > <https://groups.google.com/d/msgid/django-users/dfeb6eb4-20ec-44fe-b872-e383afc6d24e%40googlegroups.com?utm_medium=email&utm_source=footer> > . > Would you be able to copy and paste the traceback, please? It got cut off. -Jorge -- 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/CANfN%3DK_6gk1w39h8urcrcCEdrTUW0F%3D6Ppmcy31ke8SSFLXzoQ%40mail.gmail.com.
