+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Development (https://forum.codeigniter.com/forumdisplay.php?fid=6)
+--- Forum: Issues (https://forum.codeigniter.com/forumdisplay.php?fid=19)
+--- Thread: Commands out of sync error on database session driver (/showthread.php?tid=78248)
Commands out of sync error on database session driver - mehran.ranji - 12-21-2020
Hi
I put the session driver on the database, The following error is frequently received in log files.
Code:
Query error: Commands out of sync; you can't run this command now - Invalid query: SELECT RELEASE_LOCK('690ff9aba88534c094a7efd3ea18f807') AS ci_session_lockI have no problem with other parts or other operations of the database and only receive this error in session mode on the database.
Please help me to solve this problem
Best regards
RE: Commands out of sync error on database session driver - InsiteFX - 12-22-2020
What version of CodeIgniter are you running?
RE: Commands out of sync error on database session driver - mehran.ranji - 12-23-2020
(12-22-2020, 02:51 AM)InsiteFX Wrote: What version of CodeIgniter are you running?
php: 7.3
codeigniter: 3
RE: Commands out of sync error on database session driver - InsiteFX - 12-23-2020
I would try to use the GitHub developer version 3.2 of CodeIgniter 3.
They may have fixed it on there.
CodeIgniter 3.2.0-dev
RE: Commands out of sync error on database session driver - Volder - 09-13-2021
(12-21-2020, 06:04 AM)mehran.ranji Wrote: Hi
I put the session driver on the database, The following error is frequently received in log files.
Code:Query error: Commands out of sync; you can't run this command now - Invalid query: SELECT RELEASE_LOCK('690ff9aba88534c094a7efd3ea18f807') AS ci_session_lock
I have no problem with other parts or other operations of the database and only receive this error in session mode on the database.
Hi Mehran
Have you been able to find what was the cause for this issue?
I get the same error.
Thank you!