Phoca Forum

При попытке зайти в раздел Покупатели выдается ошибка:
Обнаружена ошибка.
500 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups FROM `#__users` AS u LEFT JOIN #__phocacart_users AS a ON a.user_' at line 1 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups FROM `#__users` AS u LEFT JOIN #__phocacart_users AS a ON a.user_' at line 1

Подскажите пожалуйста как исправить.

Конфигурация:
Joomla 3.9.2
PHP 7.2
MySQL 5.8

Hi, which version of Phoca Cart do you use? Do you get the problem with 3.1.7 version?

Jan

Hi, Phoca Cart 3.1.6 version

updated to version 3.1.7 the error did not disappear

I changed the database to MySQL 5.7 and it all worked! Thank!

Hi, thank you for the info.

Jan