mahara-contributors team mailing list archive

[Mahara Bot <805742@xxxxxxxxxxxxxxxxxx>]

Reviewed:  https://reviews.mahara.org/481
Committed: http://gitorious.org/mahara/mahara/commit/e8d02087ceabdbb77ac5dbb9bb86fbce872d7fbf
Submitter: Ruslan Kabalin (ruslan.kabalin@xxxxxxxxxxx)
Branch:    master

commit e8d02087ceabdbb77ac5dbb9bb86fbce872d7fbf
Author: Richard Mansfield <richard.mansfield@xxxxxxxxxxxxxxx>
Date:   Fri Jul 15 11:11:41 2011 +1200

    Remove profile icon from session on delete (see bug #805742)
    
    Commit 0c9774b9 added a foreign key constraint on the profile icon
    field of the user table.  But when a profile icon is deleted, this
    field isn't updated in the global $USER object, unless the icon is
    deleted from the profile icons page, so the bad profileicon can hang
    around in the session, and then cause an sql error the next time the
    usr table is updated from $USER.
    
    This change will fix that problem when a user deletes their own
    profile icon, however it may still be possible for the error to occur
    if for example the user is logged in twice.
    
    Change-Id: I2f8792fcd392be351b8ee9ac77337fd41b046a3d
    Signed-off-by: Richard Mansfield <richard.mansfield@xxxxxxxxxxxxxxx>

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
https://bugs.launchpad.net/bugs/805742

Title:
  Foreign key constraint missing for profile icons

Status in Mahara ePortfolio:
  In Progress

Bug description:
  The installation misses a foreign key (the profileicon field of the
  usr table should refer to the artefact table).  This is because of the
  order in which XMLDB creates tables and keys, but it seems reasonable
  to fix it up in the postinst function once all the tables exist.

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/805742/+subscriptions