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

Phoca Cart - complex e-commerce extension
taishet03
Phoca Newbie
Phoca Newbie
Posts: 5
Joined: 09 Feb 2019, 20:46

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

Post by 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

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

Tags:
taishet03
Phoca Newbie
Phoca Newbie
Posts: 5
Joined: 09 Feb 2019, 20:46

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

Post by taishet03 »

Конфигурация:
Joomla 3.9.2
PHP 7.2
MySQL 5.8
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47810
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

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

Post by Jan »

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

Jan
If you find Phoca extensions useful, please support the project
taishet03
Phoca Newbie
Phoca Newbie
Posts: 5
Joined: 09 Feb 2019, 20:46

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

Post by taishet03 »

Hi, Phoca Cart 3.1.6 version
taishet03
Phoca Newbie
Phoca Newbie
Posts: 5
Joined: 09 Feb 2019, 20:46

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

Post by taishet03 »

updated to version 3.1.7 the error did not disappear
taishet03
Phoca Newbie
Phoca Newbie
Posts: 5
Joined: 09 Feb 2019, 20:46

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

Post by taishet03 »

I changed the database to MySQL 5.7 and it all worked! Thank!
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47810
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

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

Post by Jan »

Hi, thank you for the info.

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