Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2559
  • Last Modified:

MySQL 1235 error on trigger to call a stored procedure

I am receiving the following error when calling a stored procedure in MySQL.  Is there a solution for this problem?

Error
SQL query:
CREATE trigger insert_tblTest AFTER INSERT ON aboutHITDatabase
FOR each
ROW
BEGIN CALL tblAudit(

'USER',
'aboutHITDatabase',
'Copyright',
'new record',
New.Copyright
);

END ;

MySQL said:  
#1235 - This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

My stored procedure is as follows:
 
CREATE procedure `tblAudit`(pUsername VARCHAR(50), pTableName VARCHAR(50), pFieldName VARCHAR(50), pOldValue LONGTEXT, pNewValue LONGTEXT)
BEGIN
INSERT INTO `History` (`username`,`tableName`, `fieldName`, `oldvalue`, `newvalue`)
VALUES (pUserName, pTableName, pFieldName, pOldValue, pNewValue);
END;

Open in new window

0
chaticathe
Asked:
chaticathe
1 Solution
 
Terry WoodsIT GuruCommented:
It looks like there's already a trigger for insert on the aboutHITDatabase table. Are you sure you haven't added it already?
0
 
chaticatheAuthor Commented:
Thank you so much.  I did not realize there was already an existing trigger on that table.  
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now