SKIP LOCKED error SQL

Hello The Team,

Happy New Year to you and the whole CI4 team,
I use: codeigniter4/tail and I have a problem with the "FOR UPDATE SKIP LOCKED". CI4 returns an SQL error. My version is MYSQL 5.7 or mariadb 10.5

FOR UPDATE SKIP LOCKED is only supported for versions mysql 8.0 and maria 10.6

Do you have a solution for earlier versions?

Thank you for your feedback.

You should just be able to install the database version that you need.

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )