[RESOLVED] triggers don't always work

[pinkcow]

i use following trigger:

CREATE TRIGGER t_commentIns AFTER INSERT ON my_comments FOR EACH ROW BEGIN update my_myComments set seen=null where idNews=NEW.idNews; END;

my problem is that when i insert form my php-page the trigger doesn't work put when i insert from phpmyadmin the trigger works fine. how can that be?

i'm using mysql 5.0.45 and myisam-tables

CREATE TABLE IF NOT EXISTS `my_comments` (
`idNewsComment` int(10) unsigned NOT NULL auto_increment,
`idNews` int(10) unsigned NOT NULL default '0',
`uid` int(11) default '0',
`email` varchar(150) character set utf8 default NULL,
`txt` text character set utf8 NOT NULL,
`datum` int(9) unsigned NOT NULL default '0',
PRIMARY KEY (`idNewsComment`),
KEY `my_newsComment_idnews` (`idNews`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=180 ;


CREATE TABLE IF NOT EXISTS `my_myComments` (
`uid` int(11) NOT NULL,
`idNews` int(11) NOT NULL default '0',
`idNewsPool` int(11) NOT NULL default '0',
`seen` tinyint(1) default NULL,
PRIMARY KEY (`uid`,`idNews`,`idNewsPool`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[tomhath]

What else it happening on the page after the INSERT? My first guess is that the trigger fires, but then something else happens that resets my_myComments.seen.

[pinkcow]

thats exactly it! stupid mistake on my side :-/