[racktables-users] Re: RackTables 0.20.12
- From: "Kiss Gabor (Bitman)" <kissg@xxxxxxxxxxxxx>
- To: Denis Ovsienko <denis@xxxxxxxxxxxxx>
- Date: Fri, 10 Feb 2017 08:52:30 +0100 (CET)
Dear Denis,
RackTables 0.20.12 is available for download from the usual locations. Thank
I tried to upgrade from 0.20.10 but the upgrade module has some problem.
It cannot create the triggers.
MariaDB [racktables-test]> CREATE TRIGGER `Port-before-insert` BEFORE INSERT ON
`Port` FOR EACH ROW PortTrigger:BEGIN
-> IF (NEW.`l2address` IS NOT NULL AND (SELECT COUNT(*) FROM `Port` WHERE
-> `l2address` = NEW.`l2address` AND `object_id` != NEW.`object_id`) > 0)
THEN
-> CALL `Port-l2address-already-exists-on-another-object`;
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 ''
at line 4
MariaDB [racktables-test]>
I guess the CALL `Port-l2address-already-exists-on-another-object`
fails because there is no such stored procedure.
Did I miss something?
Gabor
Other related posts: