I don't quite understand why there are permissions involved, but most of my

users don't use the notifications some don't use the calendar at all and have

only the default calendar.



Why not select the events with notification from all calendars and ceck the

permissons only for those? This may not be a solution for all DataTree 
Problems,

but could solve this  subproblem.

I know this isn't a very satisfying answer, but this is essentially a 
duplicate of bug 3046. When that's fixed, this will be, and until 
DataTree is taken out of the picture for shares and permissions, this 
will still be an issue - the threshold might change, but  not the 
underlying problem.

we had the reminders.php working for oure site. At some time, 
thescript did not send out

any mails.



Setting the loglevel to debug and adding some more debug statements 
showed, that

the script could not find any calendars to monitor 
kronolith-h3-2.1.5/lib/Scheduler/kronolith.php line 62



the function call

$this->_calendars = $shares->listAllShares();

in line 59 causes a ugly SQL query which takes very long.



SQL Query by DataTree_sql::getAttributes():

SELECT datatree_id, attribute_name AS name, attribute_key AS "key",

attribute_value AS value FROM horde_datatree_attributes WHERE 
datatree_id IN (647, 49077, 5295, 15892, 72276, 55905, 58293, 561, 
7103, 63809, 904, 49693,  ...

13961, 9801) [on line 993 of 
"/PATHTOHORDE/horde-3.1.3/lib/Horde/DataTree/sql.php"]



the ... stand for  ~14000 more numbers,  which is aboute the number of 
users we have in horde. The reminders.php takes about 8 minutes to 
run. Most of oure users don't use the calendar or the reminders



We had the Problem with horde-3.1.3 and kronolith-h3-2.1.2

and with horde-3.1.4 and kronolith-h3-2.1.5