Database table name "group" reserved keyword

[Kai Bojens]

• piler 1.3.6, build 998, Janos SUTO [e-mail] Build Date: Thu Feb 6 15:41:27 CET 2020
• Fresh install from source

The database has a table named ‘group’ – this leads to problems as ‘group’ is a reserved keyword in MySQL/MariaDB:

‌

MariaDB [piler]> select * from group;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'group' at line 1

This is not so much a bug as an inconvenience. I’m trying to access the database with some scripts and errors like this makes the handling rather “interesting”.

[Janos SUTO]

You are right, I see your point. However, it’s more like a cosmetic annoyance, as you can you the back tick character to reach the table. Anyway, I’ll think about renaming it to something still usable. I didn’t find a better word for a group, than group.

[Janos SUTO]

I’ve just asked the mailing list members to suggest a resolution to the issue.

[Janos SUTO]

Fixed issue #1058 renamed table group to usergroup

Signed-off-by: Janos SUTO [e-mail]

→ <<cset ebab0eabcc02>>