[kronolith] Re: Reminders not working, help wanted.

[John H. Bennett III]

>>another thought (this presumes mysql and I am not a mysql guru)

>>try running (host/user/database - adjust for your setup)

>>echo "select * from kronolith_events where event_alarm !=0;" \
>>| mysql horde -h localhost -u root -p

>>and see if you really have values for alarms in kronolith_events and
>>that an sql search will return them...

>>Craig

When I run the above I get this:

mysql>  select * from kronolith_events where event_alarm !=0;
+----------------------------------+----------------------------------------
-------------+---------------------------+---------------------------+------
-------------+----------------+--------------+-----------------+------------
----+------------------+-------------+----------------+-----------------+---
------------------+-----------------+--------------------+------------------
---+---------------------+-------------+----------------+
| event_id                         | event_uid
| calendar_id               | event_creator_id          | event_description
| event_location | event_status | event_attendees | event_keywords |
event_exceptions | event_title | event_category | event_recurtype |
event_recurinterval | event_recurdays | event_recurenddate | event_start
| event_end           | event_alarm | event_modified |
+----------------------------------+----------------------------------------
-------------+---------------------------+---------------------------+------
-------------+----------------+--------------+-----------------+------------
----+------------------+-------------+----------------+-----------------+---
------------------+-----------------+--------------------+------------------
---+---------------------+-------------+----------------+
| 2ba9f71cb1fe1bf142423ad08e728d62 |
20050223195903.7blvr0xsdmv4 at www.testing.com | admin at testing.com |
admin at testing.com | hello all         | the bed        |            2 |
a:0:{}          |                |                  | an event    |
| 0               | NULL                | NULL            | NULL
| 2005-02-23 20:05:00 | 2005-02-23 21:05:00 |           5 |     1109210343 |
+----------------------------------+----------------------------------------
-------------+---------------------------+---------------------------+------
-------------+----------------+--------------+-----------------+------------
----+------------------+-------------+----------------+-----------------+---
------------------+-----------------+--------------------+------------------
---+---------------------+-------------+----------------+
1 row in set (0.00 sec)


Thanks, again

John