MySQL Forums
Forum List  »  Triggers

after insert trigger execution throws error 1548
Posted by: nicky van bulck
Date: September 07, 2011 06:58AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
after insert trigger execution throws error 1548
3379
September 07, 2011 06:58AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.