django.db.utils.DataError: numeric field overflow - django

Question

I am trying migrate using django but I get this error and I have no idea what to do to fix it.

I have google the error message but all it was talking about postgres.

I have this in my model

budget = models.DecimalField(max_digits=10, decimal_places=2, null=True, blank=True)
# I used to have this though
budget = models.IntegerField(null=True, blank=True)

I was using this command python manage.py makemigrations which generates the alter table fine but when I run the migrate python manage.py migrate this error would pop up.

Can someone please give me a hand?

Thanks in advance.

Selcuk · Accepted Answer · 2017-05-05 04:14:47Z

6

The error message indicates that you have existing numbers longer than 8 digits (10-2) in your table. You might try modifying the offending rows if possible, or increase the max_digits to allow larger numbers.

answered May 5, 2017 at 4:14

Selcuk

60.1k12 gold badges114 silver badges119 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

django.db.utils.DataError: numeric field overflow - django

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related