Issue with dashboards (row column in users_widgets table)

Help
1

Hi,

I’m using the current version of librenms on Debian 9 with Percona 8.

I noticed issues trying to use/create dashboards, after a bit of digging, I saw that in the users_widgets table contains a columns named ‘row’. row is a reserved keyword, and shouldn’t / can’t be used:
https://dev.mysql.com/doc/refman/5.7/en/keywords.html#keywords-5-7-detailed-R

This goes back to at least 5.5, so I’m not sure how it worked before (or works for anyone?)

mysql> describe users_widgets;
+----------------+------------------+------+-----+---------+----------------+
| Field          | Type             | Null | Key | Default | Extra          |
+----------------+------------------+------+-----+---------+----------------+
| user_widget_id | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| user_id        | int(10) unsigned | NO   | MUL | NULL    |                |
| widget_id      | int(10) unsigned | NO   |     | NULL    |                |
| col            | tinyint(4)       | NO   |     | NULL    |                |
| row            | tinyint(4)       | NO   |     | NULL    |                |
| size_x         | tinyint(4)       | NO   |     | NULL    |                |
| size_y         | tinyint(4)       | NO   |     | NULL    |                |
| title          | varchar(255)     | NO   |     | NULL    |                |
| refresh        | tinyint(4)       | NO   |     | 60      |                |
| settings       | text             | NO   |     | NULL    |                |
| dashboard_id   | int(10) unsigned | NO   |     | NULL    |                |
+----------------+------------------+------+-----+---------+----------------+
11 rows in set (0.00 sec)

mysql>; SELECT row from users_widgets;
ERROR 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 'from users_widgets' at line 1
2