Problems with using triggers with

[John Steuber]

•Software version: 5.1.66-0ubuntu0.10.04.1

Hey guys I added a trigger to a table and its crashing giving a 500 error on any pages that uses the table.


it works fine on my local server which i use mysql 5.5

but on 5.1.66 it does this

BEGIN
IF NEW.endurance > 1 THEN
SET NEW.endurance = 1;
END IF;
END



No idea whats going on :( is this a known bug or something