Ошибка: The database backend does not accept 0 as a value for AutoField
21.05.2019, 21:21. Показов 2260. Ответов 1
Здравствуйте, начинаю делать свой первый тренировочный проект на Django и столкнулся с такой ошибкой: "ValueError: The database backend does not accept 0 as a value for AutoField."
| Code | 1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
| python3 ./manage.py migrate
Operations to perform:
Apply all migrations: admin, auth, blog, contenttypes, sessions
Running migrations:
Applying contenttypes.0001_initial... OK
Applying auth.0001_initial... OK
Applying admin.0001_initial... OK
Applying admin.0002_logentry_remove_auto_add... OK
Applying admin.0003_logentry_add_action_flag_choices... OK
Applying contenttypes.0002_remove_content_type_name... OK
Applying auth.0002_alter_permission_name_max_length... OK
Applying auth.0003_alter_user_email_max_length... OK
Applying auth.0004_alter_user_username_opts... OK
Applying auth.0005_alter_user_last_login_null... OK
Applying auth.0006_require_contenttypes_0002... OK
Applying auth.0007_alter_validators_add_error_messages... OK
Applying auth.0008_alter_user_username_max_length... OK
Applying auth.0009_alter_user_last_name_max_length... OK
Applying auth.0010_alter_group_name_max_length... OK
Applying auth.0011_update_proxy_permissions... OK
Applying blog.0001_initial... OK
Applying blog.0002_auto_20190521_1735...Traceback (most recent call last):
File "./manage.py", line 21, in <module>
main()
File "./manage.py", line 17, in main
execute_from_command_line(sys.argv)
File "/home/mazahaler/.local/lib/python3.6/site-packages/django/core/management/__init__.py", line 381, in execute_from_command_line
utility.execute()
File "/home/mazahaler/.local/lib/python3.6/site-packages/django/core/management/__init__.py", line 375, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/home/mazahaler/.local/lib/python3.6/site-packages/django/core/management/base.py", line 323, in run_from_argv
self.execute(*args, **cmd_options)
File "/home/mazahaler/.local/lib/python3.6/site-packages/django/core/management/base.py", line 364, in execute
output = self.handle(*args, **options)
File "/home/mazahaler/.local/lib/python3.6/site-packages/django/core/management/base.py", line 83, in wrapped
res = handle_func(*args, **kwargs)
File "/home/mazahaler/.local/lib/python3.6/site-packages/django/core/management/commands/migrate.py", line 234, in handle
fake_initial=fake_initial,
File "/home/mazahaler/.local/lib/python3.6/site-packages/django/db/migrations/executor.py", line 117, in migrate
state = self._migrate_all_forwards(state, plan, full_plan, fake=fake, fake_initial=fake_initial)
File "/home/mazahaler/.local/lib/python3.6/site-packages/django/db/migrations/executor.py", line 147, in _migrate_all_forwards
state = self.apply_migration(state, migration, fake=fake, fake_initial=fake_initial)
File "/home/mazahaler/.local/lib/python3.6/site-packages/django/db/migrations/executor.py", line 245, in apply_migration
state = migration.apply(state, schema_editor)
File "/home/mazahaler/.local/lib/python3.6/site-packages/django/db/migrations/migration.py", line 124, in apply
operation.database_forwards(self.app_label, schema_editor, old_state, project_state)
File "/home/mazahaler/.local/lib/python3.6/site-packages/django/db/migrations/operations/fields.py", line 112, in database_forwards
field,
File "/home/mazahaler/.local/lib/python3.6/site-packages/django/db/backends/mysql/schema.py", line 44, in add_field
super().add_field(model, field)
File "/home/mazahaler/.local/lib/python3.6/site-packages/django/db/backends/base/schema.py", line 433, in add_field
definition, params = self.column_sql(model, field, include_default=True)
File "/home/mazahaler/.local/lib/python3.6/site-packages/django/db/backends/base/schema.py", line 161, in column_sql
default_value = self.effective_default(field)
File "/home/mazahaler/.local/lib/python3.6/site-packages/django/db/backends/base/schema.py", line 233, in effective_default
return field.get_db_prep_save(self._effective_default(field), self.connection)
File "/home/mazahaler/.local/lib/python3.6/site-packages/django/db/models/fields/related.py", line 937, in get_db_prep_save
return self.target_field.get_db_prep_save(value, connection=connection)
File "/home/mazahaler/.local/lib/python3.6/site-packages/django/db/models/fields/__init__.py", line 789, in get_db_prep_save
return self.get_db_prep_value(value, connection=connection, prepared=False)
File "/home/mazahaler/.local/lib/python3.6/site-packages/django/db/models/fields/__init__.py", line 958, in get_db_prep_value
value = connection.ops.validate_autopk_value(value)
File "/home/mazahaler/.local/lib/python3.6/site-packages/django/db/backends/mysql/operations.py", line 181, in validate_autopk_value
raise ValueError('The database backend does not accept 0 as a '
ValueError: The database backend does not accept 0 as a value for AutoField. |
|
models.py:
| Python | 1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
| from django.db import models
from django.contrib.auth.models import User
from django.db.models.signals import post_save
from django.dispatch import receiver
from django.utils import timezone
# Create your models here.
class Tag(models.Model):
title = models.CharField(max_length=150, db_index=True, blank=True)
slug = models.CharField(max_length=150, unique=True, blank=True)
meta_title = models.CharField(max_length=60, blank=True)
meta_description = models.CharField(max_length=158, blank=True)
class Article(models.Model):
title = models.CharField(max_length=150, db_index=True, blank=True)
slug = models.CharField(max_length=150, unique=True, blank=True)
description = models.TextField(null=True)
image = models.FilePathField(path='/static/images', max_length=250, blank=True)
tags = models.ManyToManyField('Tag', blank=True, related_name='posts')
meta_title = models.CharField(max_length=60, blank=True)
meta_description = models.CharField(max_length=158, blank=True) # MOBILE meta_description max_length = 120
created_at = models.DateTimeField(auto_created=True, default=timezone.now)
updated_at = models.DateTimeField(auto_created=True, default=timezone.now)
class Profile(models.Model):
user = models.OneToOneField(User, on_delete=models.CASCADE),
avatar = models.FilePathField(path='/static/images/avatars', max_length=250, blank=True)
vk_token = models.CharField(max_length=256, blank=True)
fb_token = models.CharField(max_length=256, blank=True)
tw_token = models.CharField(max_length=256, blank=True)
od_token = models.CharField(max_length=256, blank=True)
@receiver(post_save, sender=User)
def create_user_profile(sender, instance, created, **kwargs):
if created:
Profile.objects.create(user=instance)
@receiver(post_save, sender=User)
def save_user_profile(sender, instance, **kwargs):
instance.profile.save()
class Trainer(models.Model):
article = models.OneToOneField(Article, on_delete=models.CASCADE, null=True)
type = models.IntegerField(default=1) # 1 - Test, 2 - undefined, 3 - undefined...
class Question(models.Model):
question = models.CharField(max_length=250, db_index=True, blank=True)
trainer = models.ForeignKey(Trainer, on_delete=models.CASCADE)
class Answer(models.Model):
answer = models.CharField(max_length=250, db_index=True, blank=True)
question = models.ForeignKey(Question, on_delete=models.CASCADE)
class Results(models.Model):
answer = models.ForeignKey(Answer, on_delete=models.CASCADE)
profile = models.ForeignKey(Profile, on_delete=models.CASCADE)
result = models.BooleanField()
class Comment(models.Model):
text = models.TextField(max_length=1000, null=True)
comment_id = models.IntegerField()
user = models.ForeignKey(User, on_delete=models.CASCADE)
article = models.ForeignKey(Article, on_delete=models.CASCADE)
created_at = models.DateTimeField(auto_created=True, default=timezone.now)
updated_at = models.DateTimeField(auto_created=True, default=timezone.now) |
|
Python v3.6
Database - MySQL
Django 2.2.1
В чем может быть дело и как это исправить?
0
|
(
