Insert Trigger Help Please

[Cinergy2050]

I'm sure I'm just doing something stupid, can anyone tell me why the following would result in an error?

 

create trigger d07_member_approval_insert

after insert on d07_member_approvals

for each row

begin

 

update jos_community_fields_values

set

value=1

where

jos_community_fields_values.user_id=NEW.applicant and jos_community_fields_values.field_id=31;

 

update jos_users

set

usertype="Clan Member"

where

id=NEW.applicant;

end;

 

 

The error I get is: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 10

[fenway]

I'm guessing it's a delimeter issue.