Welcome Guest, Not a member yet? Register   Sign In
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...
9,851 Views
10 Replies
09-16-2021, 06:08 AM
Volder
    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; ...
5,980 Views
4 Replies
09-13-2021, 12:36 PM
Volder
    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...
9,851 Views
10 Replies
09-02-2021, 12:46 AM
Volder
    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...
9,851 Views
10 Replies
09-01-2021, 01:29 AM
Volder
    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...
9,851 Views
10 Replies
09-01-2021, 12:20 AM
Volder
    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...
9,851 Views
10 Replies
09-01-2021, 12:18 AM
Volder
    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...
9,851 Views
10 Replies
08-31-2021, 05:32 AM
Volder
    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). ...
3,580 Views
2 Replies
10-07-2018, 03:34 PM
Volder
    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 ...
3,580 Views
2 Replies
10-07-2018, 12:49 AM
Volder

Theme © iAndrew 2016 - Forum software by © MyBB