#python-3.x #django #git #django-models #django-forms
Вопрос:
Я уже целый день пытаюсь решить эту проблему… и, кажется, не могу понять, почему.
Итак, после того, как я поработаю на двух компьютерах. Компьютер А работает нормально. не выдаю никаких ошибок.
но компьютер B после клонирования git продолжает выдавать эту ошибку, хотя я думаю, что установил свой .gitignore нормально.
Вещи, которые я проверял/пробовал:
1.сделайте миграцию, мигрируйте — это выдает ту же ошибку.
2.убедитесь, что мой .gitignore установлен правильно.
3.Просмотрел весь код между двумя компьютерами. Поскольку все, что я сделал с компьютером B, было клонированием git, все, что мне нужно было сделать, — это перейти в ветку, которую я запустил после клонирования git, чтобы весь код был одинаковым. Я действительно не могу понять, почему он выдает эту ошибку.
- Снова удалил клонированный клон n git.
ВСЕ безрезультатно.
Это заставляет меня хотеть плакать, так как я понятия не имею, почему…. единственное, что я могу сказать наверняка, это то, что последнее, над чем я работал на компьютере А, было приложение «Цена».
ПОЖАЛУЙСТА, ПОМОГИТЕ, есть какие-нибудь подсказки? Что я могу сделать?
forms.py
from django import forms
from django.contrib.auth.models import User
from .models import Price, Category
choices= Category.objects.all().values_list('name', 'name')
choice_list= []
for item in choices:
choice_list.append(item)
class PriceForm(forms.ModelForm):
class Meta:
model= Price
fields= ('name', 'price','category')
widgets= {
'name': forms.TextInput(attrs={'class': 'form-control'}),
'category': forms.Select(choices=choice_list, attrs={'class': 'form-control'}),
}
models.py
from django.db import models
from django.utils import timezone
from django.contrib.auth.models import User
class Category(models.Model):
name= models.CharField(max_length=100)
def __str__(self):
return self.name
#kinda like redirect. but more info corey pt10 28:00
def get_absolute_url(self):
return reverse('home')
# Create your models here.
class Price(models.Model):
name= models.CharField(max_length=50)
price= models.DecimalField(max_digits= 5, decimal_places=2)
date_posted= models.DateTimeField(default=timezone.now)
author= models.ForeignKey(User, on_delete= models.CASCADE)
category= models.CharField(max_length=100, default= 'uncategorized')
def __str__(self):
return self.name
views.py
from django.shortcuts import render
from .models import Price
from django.contrib.auth.models import User
from .forms import PriceForm
from django.views.generic import (
ListView,
CreateView
)
class PriceListView(ListView):
model= Price
class PriceCreateView(CreateView):
form_class = PriceForm
model= Price
#fix the NULL author problem. Tell that the author is the current user
def form_valid(self, form):
form.instance.author = self.request.user
return super().form_valid(form)
urls.py
from django.urls import path
from . import views
from .views import (
PriceListView,
PriceCreateView,
)
urlpatterns = [
path('', views.PriceListView.as_view(), name='price-list'),
path('price-new/', views.PriceCreateView.as_view(), name='price-create'),
]
.gitignore
11_env/
__pycache__/
ll_env/
db.sqlite3
0001_initial.py
# Generated by Django 3.2.6 on 2021-08-27 06:58
from django.conf import settings
from django.db import migrations, models
import django.db.models.deletion
import django.utils.timezone
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Price',
fields=[
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=50)),
('price', models.DecimalField(decimal_places=2, max_digits=5)),
('date_posted', models.DateTimeField(default=django.utils.timezone.now)),
('author', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
),
]
0002_auto_20210828_1401.py
# Generated by Django 3.2.6 on 2021-08-28 05:01
from django.db import migrations, models
class Migration(migrations.Migration):
dependencies = [
('price', '0001_initial'),
]
operations = [
migrations.CreateModel(
name='Category',
fields=[
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=100)),
],
),
migrations.AddField(
model_name='price',
name='category',
field=models.CharField(default='uncategorized', max_length=100),
),
]
ошибка
Performing system checks...
Exception in thread django-main-thread:
Traceback (most recent call last):
File "/home/seantakei/Desktop/reds/11_env/lib/python3.8/site-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
File "/home/seantakei/Desktop/reds/11_env/lib/python3.8/site-packages/django/db/backends/sqlite3/base.py", line 423, in execute
return Database.Cursor.execute(self, query, params)
sqlite3.OperationalError: no such table: price_category
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/lib/python3.8/threading.py", line 932, in _bootstrap_inner
self.run()
File "/usr/lib/python3.8/threading.py", line 870, in run
self._target(*self._args, **self._kwargs)
File "/home/seantakei/Desktop/reds/11_env/lib/python3.8/site-packages/django/utils/autoreload.py", line 64, in wrapper
fn(*args, **kwargs)
File "/home/seantakei/Desktop/reds/11_env/lib/python3.8/site-packages/django/core/management/commands/runserver.py", line 118, in inner_run
self.check(display_num_errors=True)
File "/home/seantakei/Desktop/reds/11_env/lib/python3.8/site-packages/django/core/management/base.py", line 419, in check
all_issues = checks.run_checks(
File "/home/seantakei/Desktop/reds/11_env/lib/python3.8/site-packages/django/core/checks/registry.py", line 76, in run_checks
new_errors = check(app_configs=app_configs, databases=databases)
File "/home/seantakei/Desktop/reds/11_env/lib/python3.8/site-packages/django/core/checks/urls.py", line 13, in check_url_config
return check_resolver(resolver)
File "/home/seantakei/Desktop/reds/11_env/lib/python3.8/site-packages/django/core/checks/urls.py", line 23, in check_resolver
return check_method()
File "/home/seantakei/Desktop/reds/11_env/lib/python3.8/site-packages/django/urls/resolvers.py", line 412, in check
for pattern in self.url_patterns:
File "/home/seantakei/Desktop/reds/11_env/lib/python3.8/site-packages/django/utils/functional.py", line 48, in __get__
res = instance.__dict__[self.name] = self.func(instance)
File "/home/seantakei/Desktop/reds/11_env/lib/python3.8/site-packages/django/urls/resolvers.py", line 598, in url_patterns
patterns = getattr(self.urlconf_module, "urlpatterns", self.urlconf_module)
File "/home/seantakei/Desktop/reds/11_env/lib/python3.8/site-packages/django/utils/functional.py", line 48, in __get__
res = instance.__dict__[self.name] = self.func(instance)
File "/home/seantakei/Desktop/reds/11_env/lib/python3.8/site-packages/django/urls/resolvers.py", line 591, in urlconf_module
return import_module(self.urlconf_name)
File "/usr/lib/python3.8/importlib/__init__.py", line 127, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
File "<frozen importlib._bootstrap>", line 1014, in _gcd_import
File "<frozen importlib._bootstrap>", line 991, in _find_and_load
File "<frozen importlib._bootstrap>", line 975, in _find_and_load_unlocked
File "<frozen importlib._bootstrap>", line 671, in _load_unlocked
File "<frozen importlib._bootstrap_external>", line 848, in exec_module
File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
File "/home/seantakei/Desktop/reds/reds/urls.py", line 36, in <module>
path('price/', include('price.urls')),
File "/home/seantakei/Desktop/reds/11_env/lib/python3.8/site-packages/django/urls/conf.py", line 34, in include
urlconf_module = import_module(urlconf_module)
File "/usr/lib/python3.8/importlib/__init__.py", line 127, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
File "<frozen importlib._bootstrap>", line 1014, in _gcd_import
File "<frozen importlib._bootstrap>", line 991, in _find_and_load
File "<frozen importlib._bootstrap>", line 975, in _find_and_load_unlocked
File "<frozen importlib._bootstrap>", line 671, in _load_unlocked
File "<frozen importlib._bootstrap_external>", line 848, in exec_module
File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
File "/home/seantakei/Desktop/reds/price/urls.py", line 2, in <module>
from . import views
File "/home/seantakei/Desktop/reds/price/views.py", line 4, in <module>
from .forms import PriceForm
File "/home/seantakei/Desktop/reds/price/forms.py", line 9, in <module>
for item in choices:
File "/home/seantakei/Desktop/reds/11_env/lib/python3.8/site-packages/django/db/models/query.py", line 280, in __iter__
self._fetch_all()
File "/home/seantakei/Desktop/reds/11_env/lib/python3.8/site-packages/django/db/models/query.py", line 1324, in _fetch_all
self._result_cache = list(self._iterable_class(self))
File "/home/seantakei/Desktop/reds/11_env/lib/python3.8/site-packages/django/db/models/query.py", line 140, in __iter__
return compiler.results_iter(tuple_expected=True, chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
File "/home/seantakei/Desktop/reds/11_env/lib/python3.8/site-packages/django/db/models/sql/compiler.py", line 1130, in results_iter
results = self.execute_sql(MULTI, chunked_fetch=chunked_fetch, chunk_size=chunk_size)
File "/home/seantakei/Desktop/reds/11_env/lib/python3.8/site-packages/django/db/models/sql/compiler.py", line 1175, in execute_sql
cursor.execute(sql, params)
File "/home/seantakei/Desktop/reds/11_env/lib/python3.8/site-packages/django/db/backends/utils.py", line 98, in execute
return super().execute(sql, params)
File "/home/seantakei/Desktop/reds/11_env/lib/python3.8/site-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/home/seantakei/Desktop/reds/11_env/lib/python3.8/site-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/home/seantakei/Desktop/reds/11_env/lib/python3.8/site-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
File "/home/seantakei/Desktop/reds/11_env/lib/python3.8/site-packages/django/db/utils.py", line 90, in __exit__
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/home/seantakei/Desktop/reds/11_env/lib/python3.8/site-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
File "/home/seantakei/Desktop/reds/11_env/lib/python3.8/site-packages/django/db/backends/sqlite3/base.py", line 423, in execute
return Database.Cursor.execute(self, query, params)
django.db.utils.OperationalError: no such table: price_category
Комментарии:
1. На компьютере Б. Попробуйте зайти в папку миграции приложения. Удалите все файлы миграции, но сохраните 0001_initial.py . Беги
./manage.py makemigrations
и./manage.py migrate
еще раз ! И сообщите нам результат2. Это решено!!!! Спасибо!!!! @Rvector