Solved

MySQL 1235 error on trigger to call a stored procedure

Posted on 2007-12-05
2
2,528 Views
Last Modified: 2010-08-05
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
Comment
Question by:chaticathe
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 35

Accepted Solution

by:
Terry Woods earned 500 total points
ID: 20417040
It looks like there's already a trigger for insert on the aboutHITDatabase table. Are you sure you haven't added it already?
0
 

Author Closing Comment

by:chaticathe
ID: 31413004
Thank you so much.  I did not realize there was already an existing trigger on that table.  
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on. …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question