Error when trying to view orders from admin "New Orders" widget

[strelitzia]

When trying to view orders by clicking on one from the "New Orders" widget on admin index I get
WARNING: An Error occurred, please refresh the page and try again.If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Checking the logs shows me this:

PHP Fatal error: 2014:Commands out of sync; you can't run this command now :: insert into sessions (sesskey, expiry, `value`)
values ('d1429987a55f93ae90317a6fd29b260c', 1599827114, 'c2VjdXJpdHlUb2tlbnxzOjMyOiJjZTQzYzk2NjhmYmIzNGZmZGZlYmI3MTRiNzk2MjZjYiI7bGFuZ3V hZ2V8czo3OiJlbmdsaXNoIjtsYW5ndWFnZXNfaWR8aToxO2xhbmd1YWdlc19jb2RlfHM6MjoiZW4iO3N lbGVjdGVkX2JveHxzOjEzOiJjb25maWd1cmF0aW9uIjtodG1sX2VkaXRvcl9wcmVmZXJlbmNlX3N0YXR 1c3xzOjg6IkNLRURJVE9SIjtqc3dlYl9kb298czoxOiIxIjthZG1pbl9pZHxzOjI6IjMyIjtyZXNldF9 hZG1pbl9hY3Rpdml0eV9sb2d8YjoxOw==')
ON DUPLICATE KEY UPDATE `value`='c2VjdXJpdHlUb2tlbnxzOjMyOiJjZTQzYzk2NjhmYmIzNGZmZGZlYmI3MTRiNzk2MjZjYiI 7bGFuZ3VhZ2V8czo3OiJlbmdsaXNoIjtsYW5ndWFnZXNfaWR8aToxO2xhbmd1YWdlc19jb2RlfHM6Mjo iZW4iO3NlbGVjdGVkX2JveHxzOjEzOiJjb25maWd1cmF0aW9uIjtodG1sX2VkaXRvcl9wcmVmZXJlbmN lX3N0YXR1c3xzOjg6IkNLRURJVE9SIjtqc3dlYl9kb298czoxOiIxIjthZG1pbl9pZHxzOjI6IjMyIjt yZXNldF9hZG1pbl9hY3Rpdml0eV9sb2d8YjoxOw==', expiry=1599827114 ==> (as called by) /home/xxxxxxxx/public_html/dev/includes/functions/sessions.php on line 77 <== in /home/xxxxxxxx/public_html/dev/includes/classes/db/mysql/query_factory.php on line 170.

I tried a repair on the sessions table and it made no difference.

Strangely, when loading the exact same files and database to a localhost MAMP server I don't have this issue.

Any suggestions?

[mc12345678]

Not so sure that the action that caused the log is as important as the environment in which this is occurring. What is the php version, mysql version, etc.? When responding to this message, the information about where to find the requested data is provided in the posting tips. Addressing the other aspects of the posting tips may also help. There is information in a mysql manual related to this, but it is interesting that it hasn't cropped up en mass before if what I found is truly required.

[strelitzia]

What is the php version, mysql version, etc.?

Zen Cart 1.5.7 with any posted bug fixes applied
PHP Memory Limit: 128M
Database Engine: MySQL 5.6.47
PHP Version: 7.4.10 (Zend: 3.4.0)
Upload Max Size: 2M
POST Max Size: 8M
MySQL Mode: NO_ENGINE_SUBSTITUTION

[mc12345678]

Zen Cart 1.5.7 with any posted bug fixes applied
PHP Memory Limit: 128M
Database Engine: MySQL 5.6.47
PHP Version: 7.4.10 (Zend: 3.4.0)
Upload Max Size: 2M
POST Max Size: 8M
MySQL Mode: NO_ENGINE_SUBSTITUTION

Is this the information from the "server" that is working, the one that is not, or both? If different for each, which has what?

[strelitzia]

Is this the information from the "server" that is working, the one that is not, or both? If different for each, which has what?

This is the information for the server where the error occurs.

The localhost server where it does work is as follows:
PHP Memory Limit: 128M
Database Engine: MySQL 5.7.26
PHP Version: 7.4.2
Upload Max Size: 32M
POST Max Size: 8M
MySQL Mode: ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION