Forum OpenACS Q&A: Response to Was SDM's audit ever working?

Collapse
3: Response to Was SDM's audit ever working? (response to 1)
Posted by Krzysztof Kowalczyk on 09/28/00 06:40 PM
In the order of appearance:
  • in 3.2.4 column "BY" in audit page is always empty (it's also the case on OpenACS site). The reason for that is that the trigger that updates baf_audit name column gets the name from bugs_and_features.last_modified_by. The problem is that last_modified_by is never set. The fix is to set this to $user_id in a few places (all INSERTs and UPDATEs into bugs_and_features table)
  • when you fix that you'll notice that the trigger trig_baf_audit in sdm.sql is always late by one person, ie. it uses OLD.last_modifed_by instead of NEW.last_modified_by