The database backend does not accept 0 as a value for AutoField.

[Mayur Bagul]

Hello guys,

im stucked with this error mentioned in subject.

below link redirect details about question.

https://stackoverflow.com/q/61427882/11351226

let me know how to get rid of this problem.

Thanking You.

[Antje Kazimiers]

setting default=False is odd for any field other than a BooleanField. I would take that out for the OneToOneField at least and see how things go.

Antje

--
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...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/cad442bf-e697-47c6-a0b4-3ce65bcef480%40googlegroups.com.

[Divash Singh]

Think you shouldn’t use false as a default for fields which are not bool

 

Sent from Mail for Windows 10

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/893f62fe-966e-d71b-8155-df9decf1786d%40gmail.com.

 

[Mayur Bagul]

Hey thanks for your response i did so because initially at the time of migration it was asking for default value and i just putted false in rush. that filed user from User model returns username as string autofield so what shall i put as default their?

i tried to put None for default value but while migrating it giving same error :-- 

 line 192, 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.

guys help me with this error .

On Sunday, April 26, 2020 at 9:10:41 PM UTC+5:30, Antje Kazimiers wrote:

setting default=False is odd for any field other than a BooleanField. I would take that out for the OneToOneField at least and see how things go.

Antje

On 4/26/20 4:19 PM, Mayur Bagul wrote:

Hello guys,

im stucked with this error mentioned in subject.

below link redirect details about question.

https://stackoverflow.com/q/61427882/11351226

let me know how to get rid of this problem.

Thanking You.

--
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.

[Divash Singh]

Also,

 

Please make sure that any foreign key fields are not default nulls

 

Sent from Mail for Windows 10

 

To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/7c34122c-0260-4a5b-8586-42c0037f8192%40googlegroups.com.

 

[Divash Singh]

Once you use the default argument for a model field, it cannot be removed even when u rerun migrations.

 

You need to provide a valid default input value for each specific field

[Antje Kazimiers]

how about adding null=True and blank=True to the field?

To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/7c34122c-0260-4a5b-8586-42c0037f8192%40googlegroups.com.

[Jorge Gimeno]

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/5dd77724-3b33-ee13-41b0-19bbcc927fd0%40gmail.com.

I would remove all the default=False options from your model fields in Owner. Re-run migrations, and try to submit the form again.

-Jorge

[Divash Singh]

You can try something like “no value”

Sent from my iPhone

On 26 Apr 2020, at 18:42, Divash Singh <singh...@gmail.com> wrote:



[Divash Singh]

Also,

 

Please make sure that any foreign key fields are not default nulls

 

Sent from Mail for Windows 10

[Mayur Bagul]

Hello Guys,

i have try to remove defaut attribute and again try to run migrations it didnt worked .

then i removed all migration files from app and tried running makemigrations it succeed but when trying to migrate it , it giving me error like wont reflect changes in migrations.

im also not getting what default value it should have as  Antj said using null i tried that also it didnt work as Divash singh already said dont keep it null.

after removing default attribute as jlgimeno71   said i did so and now its giving different error :---  1048, "Column 'user_id' cannot be null"

guys if you have any solutions on this please help me with it.

where i have to make changes and what?

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/7c34122c-0260-4a5b-8586-42c0037f8192%40googlegroups.com.

--
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/5dd77724-3b33-ee13-41b0-19bbcc927fd0%40gmail.com.