[kronolith] cannot add new events (id's not constructed)

Akom lists@akom2.2y.net
Tue, 20 Aug 2002 19:50:24 -0400


I am having a problem with kronolith - I cannot add any events (events are not
added, no errors).  It displays existing events (migrated from old installation).

I am running on 100% up to date CVS code (as of this writing) and using mysql
for backend.  All tables have been recently created.  

Setup: Mandrake 9.0 beta, apache-1.3.26-5mdk, php-4.2.1-8mdk, MySQL-3.23.51-3mdk

I tried to debug this by throwing prints into the relevant code
(Drivers/sql.php) and found that the event ID is not being constructed properly
(returns DB_error "unknown error" instead).  Not knowing enough about all this I
am asking for help...

Here is my mod'd code:
====================================
   229             Horde::logMessage(sprintf('SQL event update with no ID by %s,
trying to get nextId for '.$        this->_params['table'],
    230                                       Auth::getAuth()),
    231                               __FILE__, __LINE__, LOG_DEBUG);
    232             $id = $this->_db->nextId($this->_params['table']);
    233             if (DB::isError($id)) {
    234                 Horde::logMessage(sprintf('SQL event update DB error by
%s error is '.$id->message,
    235                                       Auth::getAuth()),
    236                               __FILE__, __LINE__, LOG_DEBUG);
    237                 return $id;
    238             }
=====================================


And the output:
========================================
Aug 20 19:36:30 HORDE [debug] [kronolith] SQL event update with no ID by
akom@akom2.2y.net, trying to get nextId for kronolith_events [on line 231 of
"/var/www/htmls/horde/kronolith/lib/Driver/sql.php"]

Aug 20 19:36:30 HORDE [debug] [kronolith] SQL event update DB error by
akom@akom2.2y.net error is DB Error: unknown error [on line 236 of
"/var/www/htmls/horde/kronolith/lib/Driver/sql.php"]
=========================================

Any ideas? 

Any help would be great,
Akom

PS: I'd love to switch to mcal but I've never been able to build mcal properly
on Mandrake, nor are rpms available (php-mcal?)... Just whining...

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