after insert trigger execution throws error 1548
Hi,
I created a trigger on table A that is supposed to insert a row in table B. The trigger seems to compile correctly, however, when I try to insert data in table A, I get error 1548.
Here is my trigger syntax:
-- Trigger DDL Statements
DELIMITER $$
USE `jira`$$
CREATE TRIGGER `jira`.`InsertVersionLog`
AFTER INSERT ON `jira`.`projectversion`
FOR EACH ROW
BEGIN
INSERT INTO ProjectVersionLog (
Timestamp,
VersionName,
ReleaseDate,
Type,
SentFlag
)
VALUES
(now(),
new.vname,
new.releasedate,
'Insert',
'N');
END$$
When I insert a row in table B (ProjectVersionLog) manually, to test the statement above, it works correctly. However, the trigger doesn't seem to be able to insert into the table.
What am I missing?
thank you so much!
-nicky