[kronolith] stream pointer problem w/mcal?

[list-kronolith@dragon.net]

jan> If you are using mcal from cvs (the version number doesn't mean
jan> anything) and it still doesn't work you should use the sql driver
jan> instead (s. below).

It was the latest CVS as of yesterday and it was screwed...
 
paul> There was also some email in July from Luc Saillard with a MySQL
paul> backend as an alternate to mcal/mstore? Can someone (Luc?) give
paul> me an idea of where that stands? I'd certainly rather use MySQL
paul> for this, since I'm already using it for auth, prefs and other
paul> apps.

jan> The mysql driver has been replaced by a generic pear based sql
jan> driver. Take a look at kronolith's lib/Driver directory.

Well, after pulling up the old email for the table values and a bit of
tweaking on the conf.php, I can now save events in MySQL. Much
happier. /horde/kronolith/docs/kronolith.sql doesn't seem to be in
synch with what lib/Driver/mysql.php expects in the DB.

However, they don't display in day view gracefully. No matter what
start time or duration, it puts the event at the 15:30 line with
duration until 24:00. If I manually switch time zone to GMT
(Europe/London), I can fill the entire 08:00 to 24:00. That makes for
a hell of a long meeting. B^)

Suggestions?

Thanks for all the pointers so far. I'm dangerously close to done.

Kronolith is latest CVS as of this morning. Here's the actual SQL
record:

mysql> select * from events;
+----+----------+-------------+----------+----------+---------+----------+------------+----------------+------------+---------------------+---------------------+---------------+-------+
| id | groupid  | description | location | keywords | title   |
category | recur_type | recur_interval | recur_days | start
| end                 | recur_enddate | alarm |
+----+----------+-------------+----------+----------+---------+----------+------------+----------------+------------+---------------------+---------------------+---------------+-------+
|  2 | paul     |             |          | NULL     | Testing |
|          0 |           NULL |       NULL | 2001-09-07 10:00:00 |
2001-09-07 10:30:00 | NULL          |     0 |
+----+----------+-------------+----------+----------+---------+----------+------------+----------------+------------+---------------------+---------------------+---------------+-------+

Here is the table description:

mysql> describe events;
+----------------+--------------+------+-----+---------------------+----------------+
| Field          | Type         | Null | Key | Default             |
Extra          |
+----------------+--------------+------+-----+---------------------+----------------+
| id             | int(11)      |      | PRI | NULL                |
auto_increment |
| groupid        | varchar(100) |      |     |                     |
|
| description    | text         | YES  |     | NULL                |
|
| location       | text         | YES  |     | NULL                |
|
| keywords       | text         | YES  |     | NULL                |
|
| title          | varchar(80)  | YES  |     | NULL                |
|
| category       | varchar(80)  | YES  |     | NULL                |
|
| recur_type     | int(11)      | YES  |     | 0                   |
|
| recur_interval | int(11)      | YES  |     | NULL                |
|
| recur_days     | int(11)      | YES  |     | NULL                |
|
| start          | datetime     |      |     | 0000-00-00 00:00:00 |
|
| end            | datetime     |      |     | 0000-00-00 00:00:00 |
|
| recur_enddate  | date         | YES  |     | NULL                |
|
| alarm          | tinyint(4)   | YES  |     | 0                   |
|
+----------------+--------------+------+-----+---------------------+----------------+

Here is what my prefs are from horde_prefs:

 | paul     | kronolith  | date_format      | %A, %d. %B %Y
 | paul     | kronolith  | 24hr             | 1



>From janmailing@gmx.de Date: Mon,  3 Sep 2001 16:52:22 +0200
Return-Path: <janmailing@gmx.de>
Mailing-List: contact kronolith-help@lists.horde.org; run by ezmlm
Delivered-To: mailing list kronolith@lists.horde.org
Received: (qmail 45759 invoked from network); 3 Sep 2001 14:55:07 -0000
Received: from mailout01.sul.t-online.com (HELO mailout01.sul.t-online.de) (194.25.134.80)
  by horde.org with SMTP; 3 Sep 2001 14:55:07 -0000
Received: from fwd03.sul.t-online.de 
	by mailout01.sul.t-online.de with smtp 
	id 15dv7y-0002AV-01; Mon, 03 Sep 2001 16:55:06 +0200
Received: from linux.wg.de (320034214675-0001@[217.0.156.228]) by fmrl03.sul.t-online.com
	with esmtp id 15dv7w-16KNSyC; Mon, 3 Sep 2001 16:55:04 +0200
Received: from localhost (localhost [127.0.0.1])
	by linux.wg.de (8.11.0/8.11.0/SuSE Linux 8.11.0-0.4) with ESMTP id f83EqMV12983
	for <kronolith@lists.horde.org>; Mon, 3 Sep 2001 16:52:22 +0200
Received: from 62.225.101.66 ( [62.225.101.66])
	as user jan@mail.wg.de by jan.dip.ammma.net with HTTP;
	Mon,  3 Sep 2001 16:52:22 +0200
Message-ID: <999528742.3b9399267f0b5@jan.dip.ammma.net>
Date: Mon,  3 Sep 2001 16:52:22 +0200
From: Jan Schneider <janmailing@gmx.de>
To: kronolith@lists.horde.org
References: <200109031448.f83EmIL11198@ns1.pae.com>
In-Reply-To: <200109031448.f83EmIL11198@ns1.pae.com>
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 2.3.7-cvs
X-Sender: 320034214675-0001@t-dialin.net
Subject: Re: [kronolith] stream pointer problem w/mcal?

Zitat von list-kronolith@dragon.net:

> jan> The mysql driver has been replaced by a generic pear based sql
> jan> driver. Take a look at kronolith's lib/Driver directory.
> 
> Well, after pulling up the old email for the table values and a bit of
> tweaking on the conf.php, I can now save events in MySQL. Much
> happier. /horde/kronolith/docs/kronolith.sql doesn't seem to be in
> synch with what lib/Driver/mysql.php expects in the DB.

You should use sql.php as your driver not mysql.php. This one is deprecated.
sql.php still doesn't work perfect but is does its job.

Jan.