Hi,

I have a wierd scenario happening here. i am currently using mysql version 5.0.51 locally for development and my domain uses 5.0.45. I was having this error while trying to create a trigger which i didnt have problems with creating locally:

Code:
DELIMITER //
CREATE TRIGGER au_mem_dj_grapher AFTER UPDATE
ON members
FOR EACH ROW
BEGIN

DECLARE who_isphoto INT;
DECLARE who_idphoto INT;
DECLARE who_isdj INT;
DECLARE who_idDj INT;

SELECT MemberID INTO who_idphoto FROM
members WHERE MemberID=OLD.MemberID AND IsPhotographer !=OLD.IsPhotographer;

SELECT IsPhotographer INTO who_isphoto
FROM Members WHERE
MemberID=who_idphoto;

IF who_isphoto = 1 THEN
INSERT INTO Photographers (PhotographerID, JoinDate) Values
(who_idphoto,NOW());

ELSEIF who_isphoto = 0  THEN
DELETE FROM Photographers WHERE PhotographerID = who_idphoto;
END IF;

SELECT MemberID INTO who_idDj FROM
members WHERE
MemberID=OLD.MemberID AND IsDJ!=OLD.IsDJ;

SELECT IsDJ INTO who_isdj FROM Members
WHERE MemberID=who_idDj;

IF who_isdj = 1 THEN
INSERT INTO DJs (DJID, JoinDate) Values
(who_idDj,NOW());

ELSEIF who_isdj = 0  THEN
DELETE FROM DJs WHERE DJID = who_idDj;
DELETE FROM EventDJ WHERE DJID = who_idDj;
END IF;
END
//
Error: ERROR 1235 (42000): This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

the wierd part is that i had the version of mysql upgraded to 5.0.67 on my domain but am still having this error. Why is this so??