[kronolith] Errors creating recurring events with SQL driver

Marcus I. Ryan marcus@riboflavin.net
Thu, 29 Nov 2001 14:00:23 -0600
Previous message: [kronolith] Errors creating recurring events with SQL driver
Next message: [kronolith] Errors creating recurring events with SQL driver
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Apparently this is a BAD idea...

I've done some more research.  Again, coding for the fix is better
left to someone that actually knows how to program PHP (*grin*) but it
appears that postgresql returns the field names from the database is
all lowercase, so looking for SQLEvent['event_recurType'] doesn't find
anything.  Instead, it needs to be SQLEvent['event_recurtype'], and
the same with the rest of the fields using mixed-case.

I know in the Perl DBI, you can specify whether you preserve the case
passed by the DB, or whether PERL/DBI forces it to upper or lowercase.
 In the meantime I went through and changed all SQLEvent['...'] fields
to lowercase, and it now works, so if someone can resolve a way to
handle that difference between pgsql and mysql, we should be safe.

However, putting the error message in there actually masks the
problem.  There really SHOULD be such errors, because without them
it's silent, but it's broken.

Quoting Jan Schneider <jan@horde.org>:

> I added an extra if statement that should avoid this error message,
> but if 
> recurring events doesn't work now for you, let me know. We have
> then to 
> find out where the problem is.
> 
> Jan.
> 
> Zitat von "Marcus I. Ryan" <marcus@riboflavin.net>:
> 
> > 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/
> > 
> > -- 
> > Kronolith mailing list: http://horde.org/kronolith/
> > Frequently Asked Questions: http://horde.org/faq/
> > To unsubscribe, mail: kronolith-unsubscribe@lists.horde.org
> > 
> > 
> 
> 
> 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
-----------------------------------------------------------------------
Previous message: [kronolith] Errors creating recurring events with SQL driver
Next message: [kronolith] Errors creating recurring events with SQL driver
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]