[Tickets #10241] Re: removing user data doesn't work

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/10241
------------------------------------------------------------------------------
  Ticket             | 10241
  Updated By         | vilius at lnk.lt
  Summary            | removing user data doesn't work
  Queue              | Horde Framework Packages
  Version            | Git master
  Type               | Bug
  State              | Resolved
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             | Michael Rubinsky
------------------------------------------------------------------------------


vilius at lnk.lt (2011-09-04 07:19) wrote:

>> Uf, this a little bit bad, but I just noticed that removeUserData for
>> kronolith and mnemo removes shares of the admin who is deleting the
>> data, not the user's data.
>
> My fault. Over zealous refactoring :) Should be fixed now.

Works now.

>> Also during debuging I've noticed that horde does spit a lot of these
>> messages:
>>        DELETE FROM horde_prefs WHERE pref_uid = 'turba3 at lnk.lt' AND  
>> pref_name
>
> This one is confusing me. removeUserData() is supposed to remove the  
> user's prefs for all applications. At most this should only be  
> called N number of times where N is the number of applications  
> installed. It also shouldn't be appending the pref_name clause.  
> Following the code, I don't see why that would be happening.  Are  
> the user's prefs removed from storage?

That's what I thought. Yes they are removed, but DELETE is executed  
for every preference in every application:

2011-09-04T10:14:28+03:00 DEBUG: HORDE [horde] SQL  (0,0007s)
         DELETE FROM horde_prefs WHERE pref_uid = 'turba3 at lnk.lt' AND pref_name
           = 'id' AND pref_scope = 'horde' [pid 11789 on line 801 of  
"/usr/share/pear/Horde/Db/Adapter/Base.php"]
2011-09-04T10:14:28+03:00 DEBUG: HORDE [horde] SQL  (0,0005s)
         DELETE FROM horde_prefs WHERE pref_uid = 'turba3 at lnk.lt' AND pref_name
           = 'fullname' AND pref_scope = 'horde' [pid 11789 on line  
801 of "/usr/share/pear/Horde/Db/Adapter/Base.php"]
2011-09-04T10:14:28+03:00 DEBUG: HORDE [horde] SQL  (0,0005s)
         DELETE FROM horde_prefs WHERE pref_uid = 'turba3 at lnk.lt' AND pref_name
           = 'from_addr' AND pref_scope = 'horde' [pid 11789 on line  
801 of "/usr/share/pear/Horde/Db/Adapter/Base.php"]
2011-09-04T10:14:28+03:00 DEBUG: HORDE [horde] SQL  (0,0005s)
         DELETE FROM horde_prefs WHERE pref_uid = 'turba3 at lnk.lt' AND pref_name
           = 'location' AND pref_scope = 'horde' [pid 11789 on line  
801 of "/usr/share/pear/Horde/Db/Adapter/Base.php"]
2011-09-04T10:14:28+03:00 DEBUG: HORDE [horde] SQL  (0,0005s)
         DELETE FROM horde_prefs WHERE pref_uid = 'turba3 at lnk.lt' AND pref_name
           = 'default_identity' AND pref_scope = 'horde' [pid 11789 on  
line 801 of "/usr/share/pear/Horde/Db/Adapter/Base.php"]


etc. etc.