Internal Error: SQL Error: SQLSTATE[22003]: Numeric value out of range: 7 ERROR: value "9999999990" is out of range for type integer

Questions
1

Hi! I’m using POSTGRESQL as my DBMS. Everything works fine except when I search for whole numbers that are more than 10 digits. When I search for anything <=9999999999, it works but anything beyond that will give me this error:

Internal Error: SQL Error: SQLSTATE[22003]: Numeric value out of range: 7 ERROR: value “9999999990” is out of range for type integer

I know it has something to do with the search query being limited to using INT only when the search content are purely numbers. I’m hoping someone can help me change it to BIGINT or would recommend any other solutions otherwise?

Your help is much appreciated in advance :pray:

2

Bumping this in dire need of help :smiling_face_with_tear:

3

Up! Calling out the pros’ help! :pray:

4

Bump! Still unable to fix the problem :sweat: