Integer overflow in `limitstart` or `start` parameter - Githubissues

FLEXIcontent / flexicontent-cck

Advanced content management for Joomla

http://www.flexicontent.org

82 stars 53 forks source link

Integer overflow in `limitstart` or `start` parameter #1110

Closed akunzai closed 1 year ago

akunzai commented 1 year ago

The overflowed integer in start parameter generating problematic SQL statement like OFFSET 9.2233720368548E+18

Steps to reproduce

pass query string ?start=99999999999999999999 to the category view form URL

Errors

mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '9.2233720368548E+18' at line 1