Can't create notifications from the manager with DBI backend
Concerned version
Version: 2.0.1
Platform: Nginx / CentOS 7 / MariaDB 10.3
Summary
I've configured DBI backend for notifications, as explains in the doc. But I can't create new notifications from the manager (I just get a message saying that the notification wasn't saved.
The test notification I'm trying to create has:
{
"title": "Test Title",
"subtitle": "Test subtitle",
"text": "Test text",
"check": [ "Test check" ]
}
Logs
févr. 04 10:56:33 proxyin2 llng-fastcgi-server[12613]: Use of uninitialized value in concatenation (.) or string at /usr/share/perl5/vendor_perl/Lemonldap/NG/Common/Notifications/DBI.pm line 101.
févr. 04 10:56:33 proxyin2 llng-fastcgi-server[12613]: DBD::mysql::st execute failed: 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 'WHERE done IS NULL ORDER BY date' at line 1 at /usr/share/perl5/vendor_perl/Lemonldap/NG/Common/Notifications/DBI.pm line 209.
févr. 04 10:57:28 proxyin2 llng-fastcgi-server[12613]: Use of uninitialized value in concatenation (.) or string at /usr/share/perl5/vendor_perl/Lemonldap/NG/Common/Notifications/DBI.pm line 167.
févr. 04 10:57:28 proxyin2 llng-fastcgi-server[12613]: DBD::mysql::st execute failed: 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 '(date,uid,ref,xml) VALUES('2019-02-04','dani','test_1','{\"uid\":\"dani\",\"date' at line 1 at /usr/share/perl5/vendor_perl/Lemonldap/NG/Common/Notifications/DBI.pm line 209.
févr. 04 10:57:28 proxyin2 LLNG[12619]: Notification not created: DBD::mysql::st execute failed: 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 '(date,uid,ref,xml) VALUES('2019-02-04','dani','test_1','{\"uid\":\"dani\",\"date' at line 1 at /usr/share/perl5/vendor_perl/Lemonldap/NG/Common/Notifications/DBI.pm line 209.
févr. 04 10:57:28 proxyin2 LLNG[12619]: [dani] Notification not created:
févr. 04 10:57:28 proxyin2 LLNG[12619]: Error 200: Notification not created:
Backends used
MySQL for everything. With DBI selected for notifications storage, and dbiChain, dbiUser, dbiPassword configured (table kept as default, table notifications exists in the DB)