Download Reference Manual
The Developer's Library for D
About Wiki Forums Source Search Contact

Ticket #220 (closed defect: fixed)

Opened 14 years ago

Last modified 14 years ago

Crash while editing profile in Forums

Reported by: kris Assigned to: pragma
Priority: major Milestone: 0.95 Beta1
Component: Web frontend Version: 0.95 beta 1
Keywords: Cc:

Description

Python takes a dump when previewing or submitting a Profile change

Change History

02/01/07 02:15:56 changed by pragma

  • status changed from new to assigned.

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.

02/01/07 04:12:28 changed by pragma

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.

02/01/07 05:24:05 changed by brad

  • status changed from assigned to closed.
  • resolution set to fixed.
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;