search

gmo-media / mikasafabric

mikasafabric for MySQL is fork product of MySQL Fabric.
https://example.com/
GNU General Public License v2.0
3 stars 3 forks source link

Can't run `mikasafabric manage setup` with MySQL 8.0 backing store. #11

Open yoku0825 opened 6 years ago

yoku0825 commented 6 years ago 
[root@ip-172-31-41-117 mikasafabric]# mikasafabric manage setup
[INFO] 2018-09-06 08:07:53,000 - MainThread - Initializing persister: user (fabric), server (localhost:3306), database (fabric).
Error: Command (INSERT INTO permissions (permission_id, subsystem, component, function, description) VALUES (%(permission_id)s, %(subsystem)s, %(component)s, %(function)s, %(description)s), {'subsystem': 'core', 'function': None, 'permission_id': 1, 'component': None, 'description': 'Full access to all core Fabric functionality'}) failed accessing (localhost:3306). 1064 (42000): 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 'function, description) VALUES (1, 'core', NULL, NULL, 'Full access to all core F' at line 1.
yoku0825 commented 6 years ago

FUNCTION (R); became reserved in 8.0.1

https://dev.mysql.com/doc/refman/8.0/en/keywords.html#keywords-8-0-detailed-F