Hello, i cant install script with mysql 8.0. I see database are uploaded in phpmyadmin but without users.
SQL Error (42000, 1064): 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, GROUP_CONCAT(g.name) AS groupNames, BIT_OR(g.canSuspend) AS canSuspe' at line 2
SELECT m.*,
GROUP_CONCAT(g.groupId) AS groups,
GROUP_CONCAT(g.name) AS groupNames,
BIT_OR(g.canSuspend) AS canSuspend
FROM et_member
m
LEFT JOIN et_member_group
mg ON (mg.memberId=m.memberId)
LEFT JOIN et_group
g ON (g.groupId=mg.groupId)
WHERE (m.memberId=1)
GROUP BY m.memberId
Any ideas?