I have a field called "blog_post_guid" and it is set as Integer.

Recently, it is throwing this error:

PDOException: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'blog_post_guid_value' at row 1: INSERT INTO {field_data_blog_post_guid} (entity_type, entity_id, revision_id, bundle, delta, language, blog_post_guid_value)

Running a search revealed this article.

Based on this information I thought I should install and enable BigInt.

Is there any other relevant solution to this issue for Integer field and Drupal 7?

1 Answer 1


Using bigInt module is the best way for achieve this job, there is another solution like altering database table but it not recommanded


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.