ошибка в sql в панели администратора - Покупатели

[taishet03]

При попытке зайти в раздел Покупатели выдается ошибка:
Обнаружена ошибка.
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

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

[taishet03]

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

[Jan]

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

Jan

[taishet03]

Hi, Phoca Cart 3.1.6 version

[taishet03]

updated to version 3.1.7 the error did not disappear

[taishet03]

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

[Jan]

Hi, thank you for the info.

Jan