Database Error: 2014 Commands out of sync; you can't run this command now

[s980845]

From CEO:

Database Error: 2014 - Commands out of sync; you can't run this command now.
Query: select count(*) as total from app_sessions where sesskey = '23475c3788c8b5b23e77e7e2dd2xxxxx
Page: /**REDACTED**/index.php?module=items/&action=save&id=417&token=twhovxxxxx
[3:23 PM]
Message from CEO: "every time i try to work on the **REDACTED** program this is the message i receive."

Some information may have been redacted due to security reasons.

[s980845]

Possible Fixes:
See the following page related to mysqli and unbuffered commands.
https://www.php.net/manual/en/mysqli.query.php#102904

In particular, see the following clip from that page.

[s980845]

Any updates on this?
It's kinda important that this be fixed.

[support]

Hard to say what is it. Try to change session handler.
Open config/server.php and set

Code: Select all

define('STORE_SESSIONS', '');

[s980845]

This worked fine. We haven't seen it occur again since making this change.
Thanks.