[kronolith] Not showing events using MySql

[Matjaz Kljun]

So - I'm using MySql with Kronilith 1.1.1. The conf.php file looks like
this (showing only uncommented lines):

<?php
$conf['calendar']['driver'] = 'sql';
$conf['calendar']['params']['phptype'] = 'mysql';
$conf['calendar']['params']['hostspec'] = 'localhost';
$conf['calendar']['params']['username'] = 'horde';
$conf['calendar']['params']['password'] = 'horde';
$conf['calendar']['params']['database'] = 'horde';
$conf['calendar']['params']['table'] = 'kronolith_events';

$conf['metadata']['keywords'] = false;
$conf['menu']['import_export'] = true;
$conf['menu']['apps'] = array('imp','turba');
?>

When I add new event to calendar the event doesn't show up. I log
manually in to mysql and get this results:

mypc# mysql -u root -p horde
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 28 to server version: 4.1.0-alpha

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show table;
+----------------------+
| Tables_in_horde      |
+----------------------+
| horde_categories     |
| horde_prefs          |
| horde_users          |
| kronolith_events     |
| kronolith_events_seq |
| turba_objects        |
+----------------------+
6 rows in set (0.00 sec)

mysql> select * from kronolith_events;
+----------+---------------------+-------------------+----------------+
----------------+------------------+-------------+----------------+----
-------------+---------------------+-----------------+-----------------
---+---------------------+---------------------+-------------+---------
-------+
| event_id | calendar_id         | event_description | event_location |
event_keywords | event_exceptions | event_title | event_category |
event_recurtype | event_recurinterval | event_recurdays |
event_recurenddate | event_start         | event_end           |
event_alarm | event_modified |
+----------+---------------------+-------------------+----------------+
----------------+------------------+-------------+----------------+----
-------------+---------------------+-----------------+-----------------
---+---------------------+---------------------+-------------+---------
-------+
|        1 | mkljun at zaliv.upr.si | d                 | d              |
               |                  | d           | 0              | 0
         | NULL                | NULL            | NULL   | 2004-03-10 
13:00:00 |
  2004-03-10 14:00:00 |           0 | 1078909191 |
+----------+---------------------+-------------------+----------------+
----------------+------------------+-------------+----------------+----
-------------+---------------------+-----------------+-----------------
---+---------------------+---------------------+-------------+---------
-------+
1 row in set (0.00 sec)

mysql> show grants for horde at localhost;
+-------------------------------------------------------------------+
| Grants for horde at localhost                                            |
+-------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'horde'@'localhost' IDENTIFIED BY PASSWORD
'*1caa955042592ba220950339f3ec315eb929757ff480' |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON `horde`.* TO
'horde'@'localhost'                           |
| GRANT SELECT, INSERT, UPDATE, DELETE ON horde.horde_prefs TO
'horde'@'localhost'                                 |
| GRANT SELECT, INSERT, UPDATE, DELETE ON horde.horde_users TO
'horde'@'localhost'                                 |
| GRANT SELECT, INSERT, UPDATE, DELETE ON horde.kronolith_events TO
'horde'@'localhost'                            |
| GRANT SELECT, INSERT, UPDATE, DELETE ON horde.horde_categories TO
'horde'@'localhost'                            |
+-------------------------------------------------------------------+

So the thing is that the events are entered into the DB but the
Kronolith doesn't show them.

Any Idea would be gratefully appreciated!

Thanks