Commands out of sync Error

Phoca Cart - complex e-commerce extension
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47810
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Commands out of sync Error

Post by Jan »

You can try to test the latest Beta too (But I don't think, there will be some difference, as there were no changes regarding SQL queries):

https://github.com/PhocaCz/PhocaCart/re ... Beta16.zip

Jan
If you find Phoca extensions useful, please support the project
drmenzelit
Phoca Newbie
Phoca Newbie
Posts: 6
Joined: 24 Jan 2018, 11:45

Re: Commands out of sync Error

Post by drmenzelit »

I think the problem is server related (IONOS, but I don't know exactly which package, because I haven't access to it). Trying to run the query directly on the database I get:

Code: Select all

#1038 - Out of sort memory, consider increasing server sort buffer size
Tested Phoca Cart on a local installation (xampp, PHP 8, MariaDB) without problems...
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47810
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Commands out of sync Error

Post by Jan »

Hmmm, testing the query now, it takes twice as little memory as e.g.

SELECT *
FROM `jos_users`
WHERE `id` = :userid

So there even should not be a problem with the memory :idea:
If you find Phoca extensions useful, please support the project
christine
Phoca Hero
Phoca Hero
Posts: 2723
Joined: 28 Nov 2010, 17:20

Re: Commands out of sync Error

Post by christine »

Just only an idea:

IONOS also has Nextcloud if that is used. About the message: Here was a possible solution:

https://help.nextcloud.com/t/memory-all ... sql/120022 and here:
https://github.com/nextcloud/circles/issues/789 > to "disable circles".

Christine
smith
Phoca Newbie
Phoca Newbie
Posts: 2
Joined: 02 Aug 2022, 12:36

Re: Commands out of sync Error

Post by smith »

Hi Jan,
Have encountered ERROR Commands Out of Sync as above, same call stack. have tried v4.0.1 and beta. one product listing works fine front and backend as soon as two products listed, can't open products backend to edit (commands out of sync), front end products show in Category View (Product list layout) , can add to cart etc, but, if try to view product, command out of sync. Has anyone determined how to fix this? Thanks for any help.

Kind Regards
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47810
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Commands out of sync Error

Post by Jan »

Hi, it is a mysql problem and it should be OK with 4.0.2 Stable:
https://www.phoca.cz/download/category/ ... -component

Jan
If you find Phoca extensions useful, please support the project
smith
Phoca Newbie
Phoca Newbie
Posts: 2
Joined: 02 Aug 2022, 12:36

Re: Commands out of sync Error

Post by smith »

Hi Jan,

Many thanks, V 4.0.2 seems to be working fine. Problem solved.

Kind Regards
drmenzelit
Phoca Newbie
Phoca Newbie
Posts: 6
Joined: 24 Jan 2018, 11:45

Re: Commands out of sync Error

Post by drmenzelit »

For me 4.0.2 seems to be working fine too.
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47810
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Commands out of sync Error

Post by Jan »

Hi, great, thank you very much for the info.

Jan
If you find Phoca extensions useful, please support the project
Post Reply