SQL Server LIMIT / OFFSET SQL Injection in laravel/framework and illuminate/database

HIGHGHSA-4mg9-vhxq-vm7j · Published 29/04/2021 · updated 02/12/2024

Package	Affected versions	Patched versions
illuminate/database Packagist	`≥ 8.0.0, < 8.40.0< 6.20.26`	`8.40.06.20.26`
laravel/framework Packagist	`≥ 8.0.0, < 8.40.0< 6.20.26`	`8.40.06.20.26`

Description

Impact

Those using SQL Server with Laravel and allowing user input to be passed directly to the limit and offset functions are vulnerable to SQL injection. Other database drivers such as MySQL and Postgres are not affected by this vulnerability.

Patches

This problem has been patched on Laravel versions 6.20.26, 7.30.5, and 8.40.0.

Workarounds

You may workaround this vulnerability by ensuring that only integers are passed to the limit and offset functions, as well as the skip and take functions.

References

laravel/framework security advisory · WEB
laravel/framework · PACKAGE
packagist.org/packages/illuminate/database · WEB
packagist.org/packages/laravel/framework · WEB

Running one of these products? Scan your site to see whether it exposes a vulnerable version.

Scan my site free