Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Numeric value out of range in the admin search #126

Open
verybigelephants opened this issue Sep 3, 2019 · 0 comments
Open

Numeric value out of range in the admin search #126

verybigelephants opened this issue Sep 3, 2019 · 0 comments
Labels

Comments

@verybigelephants
Copy link

verybigelephants commented Sep 3, 2019

hello, when trying to search for a number in the craftable's default generated CRUD interface like this:

image

it tries to automatically use this numeric value as a number over the integer columns (correctly), but does not check whether is the column within the range of the integer/unsigned, or biginteger/unsigned and tries to push this value into a query, producing this error:

    "message": "SQLSTATE[22003]: Numeric value out of range: 7 ERROR:  value \"835721723471873\" is out of range for type integer (SQL: select count(*) as aggregate from \"comments\" where (\"comments\".\"id\" = 835721723471873 or \"comments\".\"comment\" ilike %835721723471873% or \"comments\".\"user_name\" ilike %835721723471873% or \"comments\".\"user_link\" ilike %835721723471873% or \"comments\".\"user_image\" ilike %835721723471873%))"
@palypster palypster added the bug label Jan 19, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants