+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: CodeIgniter 4 (https://forum.codeigniter.com/forumdisplay.php?fid=28)
+--- Forum: CodeIgniter 4 Support (https://forum.codeigniter.com/forumdisplay.php?fid=30)
+--- Thread: SKIP LOCKED error SQL (/showthread.php?tid=89087)
SKIP LOCKED error SQL - FabriceL - 01-05-2024
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.
RE: SKIP LOCKED error SQL - InsiteFX - 01-05-2024
You should just be able to install the database version that you need.