django.db.utils.DataError: integer out of range

Question

I have a Postgres Database in my django project. I have a model called enquiry

class Enquiry(models.Model):
    product_name = models.CharField(max_length = 100)
    product_id = models.ForeignKey(List, on_delete = models.CASCADE)
    user_name = models.CharField(max_length = 100)
    user_email = models.CharField(max_length = 50)
    user_address = models.CharField(max_length = 200)
    user_mobile = models.IntegerField(default=0)

And I createed a ffunction to create a new enquiry

Enquiry.objects.create(
            product_name = product_name,
            product_id = product_id,
            user_name = user_name,
            user_email = user_email,
            user_address="None",
            user_mobile = user_mobile
    )

But I get an error

django.db.utils.DataError: integer out of range

how to solve this?

Please mark this answer as correct if it solved your problem — Coderio
– Coderio, Commented Sep 29, 2022 at 3:33

Coderio · Accepted Answer · 2022-09-28 06:14:27Z

4

Try using BigIntegerField if your integers are that big. From the documentation:

A 64-bit integer, much like an IntegerField except that it is guaranteed to fit numbers from -9223372036854775808 to 9223372036854775807. The admin represents this as an (a single-line input).

answered Sep 28, 2022 at 6:14

Coderio

4522 silver badges11 bronze badges

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

Collectives™ on Stack Overflow

django.db.utils.DataError: integer out of range

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