Fehlermeldung Admin Bereich Django

[FelixGoesPython]

Hallo Zusammen,

ich habe ein Problem bei dem ich nicht weiterkomme. Ich "programmiere" einen Onlineshop mit dem Youtube Tutorial Pythons for Beginners von Mosh. Ich habe den Superuser und auch die Class Products mit den Werten: Name, Preis, Auf Lager und URL angelegt. Einloggen und anzeigen der Produkte-Class funktioniert. Wenn ich im Admin-Bereich über den Browser die Werte für das erste Produkt anlege kommt beim klick auf "SAVE" eine Fehlermeldung:

Environment:


Request Method: POST
Request URL: http://127.0.0.1:8000/admin/products/product/add/

Django Version: 2.1
Python Version: 3.7.4
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 "/Users/felixgoebs/PycharmProjects/PyShop/venv/lib/python3.7/site-packages/django/db/backends/utils.py" in _execute
85. return self.cursor.execute(sql, params)

File "/Users/felixgoebs/PycharmProjects/PyShop/venv/lib/python3.7/site-packages/django/db/backends/sqlite3/base.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 "/Users/felixgoebs/PycharmProjects/PyShop/venv/lib/python3.7/site-packages/django/core/handlers/exception.py" in inner
34. response = get_response(request)

File "/Users/felixgoebs/PycharmProjects/PyShop/venv/lib/python3.7/site-packages/django/core/handlers/base.py" in _get_response
126. response = self.process_exception_by_middleware(e, request)

File "/Users/felixgoebs/PycharmProjects/PyShop/venv/lib/python3.7/site-packages/django/core/handlers/base.py" in _get_response
124. response = wrapped_callback(request, *callback_args, **callback_kwargs)

File "/Users/felixgoebs/PycharmProjects/PyShop/venv/lib/python3.7/site-packages/django/contrib/admin/options.py" in wrapper
607. return self.admin_site.admin_view(view)(*args, **kwargs)

File "/Users/felixgoebs/PycharmProjects/PyShop/venv/lib/python3.7/site-packages/django/utils/decorators.py" in _wrapped_view
142. response = view_func(request, *args, **kwargs)

File "/Users/felixgoebs/PycharmProjects/PyShop/venv/lib/python3.7/site-packages/django/views/decorators/cache.py" in _wrapped_view_func
44. response = view_func(request, *args, **kwargs)

File "/Users/felixgoebs/PycharmProjects/PyShop/venv/lib/python3.7/site-packages/django/contrib/admin/sites.py" in inner
223. return view(request, *args, **kwargs)

File "/Users/felixgoebs/PycharmProjects/PyShop/venv/lib/python3.7/site-packages/django/contrib/admin/options.py" in add_view
1647. return self.changeform_view(request, None, form_url, extra_context)

File "/Users/felixgoebs/PycharmProjects/PyShop/venv/lib/python3.7/site-packages/django/utils/decorators.py" in _wrapper
45. return bound_method(*args, **kwargs)

File "/Users/felixgoebs/PycharmProjects/PyShop/venv/lib/python3.7/site-packages/django/utils/decorators.py" in _wrapped_view
142. response = view_func(request, *args, **kwargs)

File "/Users/felixgoebs/PycharmProjects/PyShop/venv/lib/python3.7/site-packages/django/contrib/admin/options.py" in changeform_view
1536. return self._changeform_view(request, object_id, form_url, extra_context)

File "/Users/felixgoebs/PycharmProjects/PyShop/venv/lib/python3.7/site-packages/django/contrib/admin/options.py" in _changeform_view
1579. self.log_addition(request, new_object, change_message)

File "/Users/felixgoebs/PycharmProjects/PyShop/venv/lib/python3.7/site-packages/django/contrib/admin/options.py" in log_addition
813. change_message=message,

File "/Users/felixgoebs/PycharmProjects/PyShop/venv/lib/python3.7/site-packages/django/contrib/admin/models.py" in log_action
35. change_message=change_message,

File "/Users/felixgoebs/PycharmProjects/PyShop/venv/lib/python3.7/site-packages/django/db/models/manager.py" in manager_method
82. return getattr(self.get_queryset(), name)(*args, **kwargs)

File "/Users/felixgoebs/PycharmProjects/PyShop/venv/lib/python3.7/site-packages/django/db/models/query.py" in create
413. obj.save(force_insert=True, using=self.db)

File "/Users/felixgoebs/PycharmProjects/PyShop/venv/lib/python3.7/site-packages/django/db/models/base.py" in save
717. force_update=force_update, update_fields=update_fields)

File "/Users/felixgoebs/PycharmProjects/PyShop/venv/lib/python3.7/site-packages/django/db/models/base.py" in save_base
747. updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)

File "/Users/felixgoebs/PycharmProjects/PyShop/venv/lib/python3.7/site-packages/django/db/models/base.py" in _save_table
830. result = self._do_insert(cls._base_manager, using, fields, update_pk, raw)

File "/Users/felixgoebs/PycharmProjects/PyShop/venv/lib/python3.7/site-packages/django/db/models/base.py" in _do_insert
868. using=using, raw=raw)

File "/Users/felixgoebs/PycharmProjects/PyShop/venv/lib/python3.7/site-packages/django/db/models/manager.py" in manager_method
82. return getattr(self.get_queryset(), name)(*args, **kwargs)

File "/Users/felixgoebs/PycharmProjects/PyShop/venv/lib/python3.7/site-packages/django/db/models/query.py" in _insert
1133. return query.get_compiler(using=using).execute_sql(return_id)

File "/Users/felixgoebs/PycharmProjects/PyShop/venv/lib/python3.7/site-packages/django/db/models/sql/compiler.py" in execute_sql
1285. cursor.execute(sql, params)

File "/Users/felixgoebs/PycharmProjects/PyShop/venv/lib/python3.7/site-packages/django/db/backends/utils.py" in execute
100. return super().execute(sql, params)

File "/Users/felixgoebs/PycharmProjects/PyShop/venv/lib/python3.7/site-packages/django/db/backends/utils.py" in execute
68. return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)

File "/Users/felixgoebs/PycharmProjects/PyShop/venv/lib/python3.7/site-packages/django/db/backends/utils.py" in _execute_with_wrappers
77. return executor(sql, params, many, context)

File "/Users/felixgoebs/PycharmProjects/PyShop/venv/lib/python3.7/site-packages/django/db/backends/utils.py" in _execute
85. return self.cursor.execute(sql, params)

File "/Users/felixgoebs/PycharmProjects/PyShop/venv/lib/python3.7/site-packages/django/db/utils.py" in __exit__
89. raise dj_exc_value.with_traceback(traceback) from exc_value

File "/Users/felixgoebs/PycharmProjects/PyShop/venv/lib/python3.7/site-packages/django/db/backends/utils.py" in _execute
85. return self.cursor.execute(sql, params)

File "/Users/felixgoebs/PycharmProjects/PyShop/venv/lib/python3.7/site-packages/django/db/backends/sqlite3/base.py" 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

[jinroo]

Hi,

schwer zu sagen ganz ohne Code.

Hast du etwas an den Models angepasst?

Exception Type: OperationalError at /admin/products/product/add/
Exception Value: no such table: main.auth_user__old

Da möchte etwas auf auth_user__old zugreifen, aber es exiasitert nicht (mehr)

[FelixGoesPython]

Ja, folgendes steht in PyShop -> products -> models.py (PyShop ist der Name des Projekts)


</>
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()


</>

[FelixGoesPython]

"Da möchte etwas auf auth_user__old zugreifen, aber es exiasitert nicht (mehr)" Habe ich mir gedacht, aber was ist das? ist das ein Befehl, eine Datei.

[jinroo]

Das ist eine Tabelle in der Datenbank, kann unter umständen zustande gekommen sein, wenn du etwas in deinen Settings bei user angepasst hast.

Währe es möglich das Projekt in github hochzuladen?

[FelixGoesPython]

Habe versucht das bei GitHub aus PyCharm hochzuladen. Obwohl ich mir dafür ein Tool runtergeladen habe und die Schutzeinstellung für den Mac ausgehebelt habe, kriege ich immer noch eine Fehlermeldung. Im Manual steht:

When you run `git`, you might see this message:

'The "git" command requires the command line developer
tools. Would you like to install the tools now?"

This is because OS X ships with stubs, and these stubs are taking
precedence over /usr/local/bin.

To resolve, run the following:

sudo mv /usr/bin/git /usr/bin/git-system

This should not be a problem in OS X 10.11 (El Capitan), as
/usr/local/bin takes precedence over /usr/bin


Ich weiß nicht was das heisst. kann ich das nicht einfacher hochladen?

[FelixGoesPython]

Achse, ich soll das ins terminal eingeben.

aber da kriege ich als Antwort: "Operation not permitted"

mehr sagt er nicht dazu

[FelixGoesPython]

Ich habe alles noch mal von vorne wie folgt konfiguriert und bekomme wieder den Fehler:


New Django Project called „PyShop“


# Terminal Window:

„pip install django==2.1“

„django-admin startproject pyshop .“

„python3 manage.py runserver“


# When opening http://127.0.0.1:8000 in Safari I see a django page


# Open new Terminal Window:
„python3 manage.py startapp products“

# Open: PyShop -> products -> views.py

from django.http import HttpResponse
from django.shortcuts import render


def index(request):
return HttpResponse('Hello World')


# Add new python file to PhyShop -> products folder called „urls“ (-> urls.py)

from django.urls import path
from . import views

urlpatterns = [
path('', views.index)
]

# Open: PyShop -> pyshop -> urls.py


"""pyshop URL Configuration

The `urlpatterns` list routes URLs to views. For more information please see:
https://docs.djangoproject.com/en/2.1/topics/http/urls/
Examples:
Function views
1. Add an import: from my_app import views
2. Add a URL to urlpatterns: path('', views.home, name='home')
Class-based views
1. Add an import: from other_app.views import Home
2. Add a URL to urlpatterns: path('', Home.as_view(), name='home')
Including another URLconf
1. Import the include() function: from django.urls import include, path
2. Add a URL to urlpatterns: path('blog/', include('blog.urls'))
"""
from django.contrib import admin
from django.urls import path, include

urlpatterns = [
path('admin/', admin.site.urls),
path('products/', include('products.urls'))
]



# PyShop -> products -> models.py
# Video Timecode 5:25:53 (oder direkt zu Timecode 5:36:14 springen)

</>
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)

</>

# PyShop -> pyshop -> settings.py Zeile 40
# Video Timecode 5:30:16

</>
'products.apps.ProductsConfig',
</>


#Terminal Input

python3 manage.py makemigrations
python3 manage.py migrate

# PyShop -> products -> models.py
# Video Timecode 5:36:14

</>
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()


</>


# Terminal

python3 manage.py migrate

# Admin User im Terminal anlegen

python3 manage.py createsuperuser

# PyShop -> products -> admin.py
# Video Timecode 5:40:31

</>
from django.contrib import admin
from .models import Product

admin.site.register(Product)

# Admin Zugang ¸ber 127.0.0.1:8000/login
# Produkt im Admin-Bereich anlegen

[noisefloor]

Hallo,

der letzte Post ist nicht wirklich lesbar. Mach' doch mal bitte mit der passende Formatierung lesbar, was Python Quelltext, was Terminaleingaben und was Fließtext ist.

Gruß, noisefloor

[jinroo]

Wenn du einen Beitrag schreibst, den vollständigen Editor verwenden, dann hast du oben ein Menü.

Markiere deinen Code und dann kannst oben dieses Symbol anklicken </>
Oder bei Fehlermeldung nehme ich z.B. immer Zitat. “


Das macht es für alle einfacher deine Beiträge zu lesen. Und dann versteht man auch worum es geht und es kann dir geholfen werden