CodeIgniter Forums - Search Results

Search Results

Thread: Session error: "Query error: Commands out of sync; you can't run this command now..."
Post: RE: Session error: "Query error: Commands out of s...

On the server in mysql error log for each such release lock issue we get messages like: [Warning] Aborted connection 564845 to db: 'db' user: 'username' host: 'localhost' (Got an error reading commun...

Thread: Commands out of sync error on database session driver
Post: RE: Commands out of sync error on database session...

mehran.ranji Wrote: (12-21-2020, 06:04 AM) -- 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; ...

Thread: Session error: "Query error: Commands out of sync; you can't run this command now..."
Post: RE: Session error: "Query error: Commands out of s...

php_rocs Wrote: (09-01-2021, 08:01 AM) -- I mean is the data in the SQL input statement good data... or if you were to run the query directly in the database (phpMyAdmin) would it work or would it gi...

Thread: Session error: "Query error: Commands out of sync; you can't run this command now..."
Post: RE: Session error: "Query error: Commands out of s...

InsiteFX Wrote: (09-01-2021, 12:30 AM) -- Read: MySQL - B.3.2.12 Commands out of sync (https://dev.mysql.com/doc/refman/8.0/en/commands-out-of-sync.html) -- This is a general description when th...

Thread: Session error: "Query error: Commands out of sync; you can't run this command now..."
Post: RE: Session error: "Query error: Commands out of s...

ikesela Wrote: (08-31-2021, 09:31 PM) -- maybe you should investigate on this query: SELECT RELEASE_LOCK('868db8ea6235235edrgydrfg6b5d33ea77') AS ci_session_lock -- This is a query from the standar...

Thread: Session error: "Query error: Commands out of sync; you can't run this command now..."
Post: RE: Session error: "Query error: Commands out of s...

php_rocs Wrote: (08-31-2021, 02:18 PM) -- @"Volder" , Have you tried the query directly in the database (to see if an error appears)? Are you sure that the input data is clean? Has any of the dat...

Thread: Session error: "Query error: Commands out of sync; you can't run this command now..."
Post: Session error: "Query error: Commands out of sync;...

Hello everyone I face an issue with database session. The site was working fine on PHP 7.2 (Codeigniter 3.1.9) for a long time. As PHP 7.2 is deprecated the hosting updated to PHP 7.4 and then in th...

Thread: Session table redundant records problem
Post: RE: Session table redundant records problem

Hi Dave, Thanks for such detailed response. The error in my case was not the garbage collector, rather the logic how the sessions work (sess_regenerate_destroy = TRUE didn't behave as documented). ...

Thread: Session table redundant records problem
Post: Session table redundant records problem

Hi all, I've been using Codeigniter for many years since 1.x versions. The question I have is about Session library behavior, which I'm struggling to solve. We recently upgraded PHP to 7.2 and ...