1741: Cannot upgrade to 0.20.12 due to missing stored procedure

ID	Project	Category	View Status	Date Submitted	Last Update

1741	RackTables	default	public	2017-03-04 10:35	2017-03-04 14:39

Reporter	kissg	Assigned To
Priority	normal	Severity	major	Reproducibility	have not tried
Status	closed	Resolution	duplicate
Platform	VM	OS	Linux	OS Version	Debian 7
Product Version	0.20.12

Summary	1741: Cannot upgrade to 0.20.12 due to missing stored procedure
Description	Upgrade from 0.20.10 failed with some database error. I had not enough permissions. Then I tried to create missing triggers by hand as root: 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.
Tags	No tags attached.

Date Modified	Username	Field	Change
2017-03-04 10:35	kissg	New Issue
2017-03-04 14:38	infrastation	Relationship added	duplicate of 1733
2017-03-04 14:39	infrastation	Status	new => closed
2017-03-04 14:39	infrastation	Resolution	open => duplicate