Page 2 of 2

Re: Commands out of sync Error

Posted: 27 Jul 2022, 14:22
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

Re: Commands out of sync Error

Posted: 27 Jul 2022, 15:10
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...

Re: Commands out of sync Error

Posted: 27 Jul 2022, 16:02
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:

Re: Commands out of sync Error

Posted: 27 Jul 2022, 17:21
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

Re: Commands out of sync Error

Posted: 02 Aug 2022, 13:01
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

Re: Commands out of sync Error

Posted: 03 Aug 2022, 22:55
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

Re: Commands out of sync Error

Posted: 04 Aug 2022, 20:52
by smith
Hi Jan,

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

Kind Regards

Re: Commands out of sync Error

Posted: 05 Aug 2022, 19:24
by drmenzelit
For me 4.0.2 seems to be working fine too.

Re: Commands out of sync Error

Posted: 09 Aug 2022, 23:43
by Jan
Hi, great, thank you very much for the info.

Jan