Crash while editing profile in Forums

Brad and I saw something like this earlier, where the profile table had avatar id's that didn't correlate to entries in the avatar table.

The problem has morphed into an issue with the view mapping of the profile table. An update rule is needed:

CREATE OR REPLACE RULE profile_update_rule AS
ON UPDATE TO profile DO INSTEAD  
UPDATE _profile 
SET 
defaultavatarid = new.defaultavatarid, 
sig = new.sig, 
bio = new.bio, 
email = new.email, 
regdate = new.regdate, 
lastvisit = new.lastvisit
WHERE _profile.username::text = new.username::text;

Where "_profile" is the actual profile table.

CREATE OR REPLACE RULE profile_update_rule AS
ON UPDATE TO profile DO INSTEAD  
UPDATE phpbb_users 
SET 
user_avatar_type = new.defaultavatarid, 
user_sig = new.sig, 
user_interests = new.bio, 
user_email = new.email, 
user_regdate = new.regdate, 
user_lastvisit = new.lastvisit
WHERE phpbb_users.username::text = new.username::text;