Did you remember to add the models to the admin.py? >From .models import Product, Offer
admin.site.register(Product) admin.site.register(Offer) On Mon, May 4, 2020, 8:02 AM i...@serenityscotland.co.uk/webmail < i...@serenityscotland.co.uk> wrote: > Hi Folks, > > Here is models.py: > > from django.db import models > > class Product(models.Model): > name = models.CharField(max_length=255) > price = models.FloatField() > stock = models.IntegerField() > image_url = models.CharField(max_length=2083) > > > class Offer(models.Model): > code = models.CharField(max_length=10) > description = models.CharField(max_length=255) > discount = models.FloatField() > > > Thank you for any help! > > > Iain > > > On Sun, 3 May 2020 at 23:13, Adedotun Richard <dotun.sm...@gmail.com> > wrote: > >> Can you paste your model.py class for products? >> There is probability that you are getting the write-up wrong. >> >> >> On Sat, May 2, 2020, 3:43 PM Iain Stewart <iain.a.stew...@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-users+unsubscr...@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> >>> . >>> >> -- >> 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/CA%2BndhOM3bTLkJLLBWeYVwo_uAAW--riP3XQ4VnBZ%3D0HWkg-5UQ%40mail.gmail.com >> <https://groups.google.com/d/msgid/django-users/CA%2BndhOM3bTLkJLLBWeYVwo_uAAW--riP3XQ4VnBZ%3D0HWkg-5UQ%40mail.gmail.com?utm_medium=email&utm_source=footer> >> . >> > > > -- > > Iain Stewart > BA (U.C. Berkeley), MLitt with Distinction (University of Aberdeen) > Tour Operator, Director and Guide > > Serenity Scotland Ltd. > 2b Priestfield Road > EDINBURGH EH16 5HH SCOTLAND > www.serenityscotland.co.uk > i...@serenityscotland.co.uk > > telephone: 0044 131 662 9123 > mobile: 0044 7728 752824 > > <http://www.facebook.com/pages/Serenity-Scotland/128007840549952> > <http://www.linkedin.com/profile/edit?trk=tab_pro> > Serenity Scotland Ltd. 2020 (trading since 2003) > Company No. SC 460598 > > Our VAT Registration Number is 317 0442 34 - VAT is accounted for using > the Tour Operators Margin Scheme (TOMS) > > a member of the Scottish Destination Management Association > please print this email only if entirely necessary > > > -- > 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/CAAAU1KQ2uEYoNE_ZVrdoBGwgiuaroTY1sBbVHE8vcb%3D8%2BdLoeA%40mail.gmail.com > <https://groups.google.com/d/msgid/django-users/CAAAU1KQ2uEYoNE_ZVrdoBGwgiuaroTY1sBbVHE8vcb%3D8%2BdLoeA%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/CA%2BndhOOtYi2A7Whgu3YpP83J1ArqcH9Pp2M4zow7roQntaD8oA%40mail.gmail.com.
