[kronolith] reminder stoped working

[Michael Menge]

Sorry for my self reply,

i found out that the Problem lies in listAllShares().
This Funktion iniciates the followin SQL Query
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,  
...
13961, 9801) [on line 993 of /htdocs/horde-3.1.3/lib/Horde/DataTree/sql.php"]

The ... replace the other 14470 numbers. This is about the number of  
users we have. Most of these calendars are empty, because most of oure  
user only uses Ingo and Imp.
I understand now that the query takes so long and i believe that the  
returned list is to big, so that the listAllShares() returns nothing.

Is it possible not to Query the DataTree but to query kronolith_events?

Regars

      Michael Menge



Quoting Michael Menge <michael.menge at zdv.uni-tuebingen.de>:

> Hi,
>
> im running kronolith H3 2.1.2, horde 3.1.3, until a few weeks ago the
> reminder was working fine. But now there are no reminder eMails send.
>
> Debuging showed that there are no calendars found.
> $this->_calendars = $shares->listAllShares(); in
> /kronolith/lib/Scheduler/kronolith.php takes about 7-8 minutes to run
> but returns nothing.
>
> I had some pear updates, but don't know at which time the reminder
> stoped working or if the reminders did work the moment before the
> updates or some time after the updates.
>
> Has anybody an idea why $shares->listAllShares() takes so long and
> returns nothing?
>
> regards
>
>     Michael Menge
> --------------------------------------------------------------------------------
> M.Menge                                 Tel.: (49) 7071/29-70316
> Universitaet Tuebingen                  Fax.: (49) 7071/29-5912
> Zentrum fuer Datenverarbeitung          mail:
> michael.menge at zdv.uni-tuebingen.de
> Waechterstrasse 76
> 72074 Tuebingen



--------------------------------------------------------------------------------
M.Menge                                 Tel.: (49) 7071/29-70316
Universitaet Tuebingen                  Fax.: (49) 7071/29-5912
Zentrum fuer Datenverarbeitung          mail:  
michael.menge at zdv.uni-tuebingen.de
Waechterstrasse 76
72074 Tuebingen
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 5469 bytes
Desc: S/MIME krytographische Unterschrift
Url : http://lists.horde.org/archives/kronolith/attachments/20070322/6f5bbf72/attachment.bin