after insert trigger execution throws error 1548

[nicky van bulck]

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