[kronolith] Errors creating recurring events with SQL driver

[Marcus I. Ryan]

I'm more than happy to mess with the code if someone wants to help
guide me, but I've only recently started to even learn PHP, and that
just because I am using Horde and it would be nice to know.  I am an
advanced PERL programmer, and a reasonably experienced sysadmin.  I'm
working on a test system, so if you like I can even rebuild it from
scratch (given time).  I just don't know enough about PHP and the
horde framework, etc., to really know where to start looking.

As for database, etc., I'll try not to overload you with too much
information, but here we go.  

Hardware:
PIII/700E, 256M RAM, 60G 7200RPM HDD, IDE CD-ROM
(i.e. beefy enough to handle the software, and then some *grin*)

Software:
FreeBSD 4.4-RELEASE w/ the following ports (from cvs'ed /usr/ports)
postgresql-7.1.3
openldap-2.0.17
apache+mod_ssl-1.3.22+2.8.5_1
mod_php4-4.0.6_5*
pear-devel-4.0.7*
libmcal-0.6*

* I originally tried to use mcal, but never managed to get mcal
working, let alone getting it to work with kronolith.  The marked
ports came from a search of groups.google.com for +freebsd +"ports
collection" +mcal.  NOTE: The mod_php4 port listed here is NOT the
same as actually appeared in the official FreeBSD Ports Collection
with the same revision number.

At any rate, after installing the above software (and other unrelated
ports), here is the procedure I went through to create my kronolith
installation.

$ cd /usr/local/src/horde
$ cvs -z3 -d :pserver:cvsread@anoncvs.horde.org:/repository co \
  kronolith
$ cd /usr/local/src/horde/kronolith/config

$ cp conf.php.dist conf.php
  $conf['calendar']['driver'] = 'sql';
  $conf['calendar']['params']['phptype'] = 'pgsql';
  $conf['calendar']['params']['hostspec'] = 'imp.riboflavin.net';
  $conf['calendar']['params']['protocol'] = 'unix';
  $conf['calendar']['params']['username'] = '<user>';
  $conf['calendar']['params']['password'] = '<pass>';
  $conf['calendar']['params']['database'] = 'horde';
  $conf['calendar']['params']['table'] = 'kronolith_events';
$ cp html.php.dist html.php
$ cp keywords.php.dist keywords.php
$ cp menu.php.dist menu.php
$ cp prefs.php.dist prefs.php

$ psql -f /usr/local/src/horde/kronolith/docs/kronolith.sql horde
$ psql -c 'REVOKE ALL ON kronolith_events FROM PUBLIC' horde
$ psql -c 'GRANT ALL ON kronolith_events TO horde' horde

I then logged into horde (uses LDAP auth, pgsql prefs; CVS Horde and
IMP from a week or so ago operating fine) and tried to create a
recurring event.  I got the errors described in my message.

Let me know what, if anything, you want me to try next.

Quoting Jan Schneider <jan@horde.org>:

> Zitat von "Marcus I. Ryan" <marcus@riboflavin.net>:
> 
> > Hi all.  I have installed Kronolith from CVS (last updated about
> 11:30am
> > CST). 
> > I am using the SQL driver (I'm using FreeBSD and have had a heck
> of a
> > time
> > getting libmcal working - it's compiled, I just can't seem to get
> it to
> > read the
> > mpasswd file).
> > 
> > At any rate, I can create single calendar events, but when I go
> to
> > create
> > recurring events I get the errors:
> > 
> > Warning: Undefined index: event_recurType in
> > /usr/local/src/horde/kronolith/lib/Driver/sql.php on line 391
> > 
> > Warning: Undefined index: event_recurInterval in
> > /usr/local/src/horde/kronolith/lib/Driver/sql.php on line 392
> 
> I can't reproduce this error message. What database do you use? Any
> chance 
> to dig a bit deeper in the code and find out what's causing this
> error?
> 
> Jan.
> 
> ::::::::::::::::::::::::::::::::::::::::
> AMMMa AG - discover your knowledge
> :::::::::::::::::::::::::::
> Detmolder Str. 25-33 :: D-33604 Bielefeld
> fon +49.521.96878-0 :: fax  +49.521.96878-20
> http://www.ammma.de
> ::::::::::::::::::::::::::::::::::::::::::::::
> 
> -- 
> Kronolith mailing list: http://horde.org/kronolith/
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: kronolith-unsubscribe@lists.horde.org
> 
> 


-- 
Marcus I. Ryan, marcus@riboflavin.net
-----------------------------------------------------------------------
 "Love is a snowmobile racing across the tundra and then suddenly it
 flips over, pinning you underneath.  At night, the ice weasels come."
                 -- Matt Groening
-----------------------------------------------------------------------

-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/