From: Alan Knowles Date: Mon, 28 Nov 2016 04:01:52 +0000 (+0800) Subject: mysql/core_notify_trigger_after_update.sql X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=d349777fb81b5aa9f7dc4a85e78eaac227e21c54 mysql/core_notify_trigger_after_update.sql --- diff --git a/mysql/core_notify_trigger_after_update.sql b/mysql/core_notify_trigger_after_update.sql index 9d542843..efa74cec 100644 --- a/mysql/core_notify_trigger_after_update.sql +++ b/mysql/core_notify_trigger_after_update.sql @@ -11,7 +11,7 @@ CREATE TRIGGER core_notify_trigger_after_update BEGIN -- make sure that act_start does not get modified if sent is set. IF OLD.sent IS NOT NULL AND ( NEW.act_start != OLD.act_start OR NEW.act_when != OLD.act_when ) THEN - UPDATE `Error: Can not update core_notify act_start or when after its set` SET x = 1; + UPDATE `Error: Can not update core_notify action dates after its set` SET x = 1; END IF; END;