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

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

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

Post by taishet03 » 09 Feb 2019, 20:52

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

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

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

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

Post by Jan » 10 Feb 2019, 23:51

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 » 11 Feb 2019, 10:51

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 » 11 Feb 2019, 11:01

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 » 11 Feb 2019, 11:19

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

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

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

Post by Jan » 13 Feb 2019, 10:16

Hi, thank you for the info.

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

Post Reply