[kronolith] error with kronolith-0.0.3

[Joshua E Warchol]

On Thu, Jan 03, 2002 at 05:40:39PM +0100, Jan Schneider wrote:
> > Warning: Undefined index: table in
> > /var/httpd/html/inboxdslnet/horde/kronolith/lib/Driver/sql.php on line
> > 125
> > object(db_error)(7) { ["error_message_prefix"]=> string(0) "" ["mode"]=>
> > int(1) ["level"]=> int(1024) ["code"]=> int(-18) ["message"]=> string(23)
> > "DB Error: no such table" ["userinfo"]=> string(362) "SELECT DISTINCT
> > e.event_id, e.event_recurtype FROM e WHERE e.calendar_id =
> > 'josh%runlevel7.net' AND ((e.event_start < '2002-02-01 00:00:00.000' AND
> > e.event_end > '2002-01-01 00:00:00.000') OR (e.event_recurenddate >=
> > '2002-01-01 00:00:00.000' AND e.event_start <= '2002-02-01 00:00:00.000'
> > AND e.event_recurtype != 0)) [nativecode=Table 'horde.e' doesn't exist]"
> > ["callback"]=> NULL }
> > 
> > What the heck is "horde.e"? 
> 
> There's something broken in you driver configuration in conf.php. Can you 
> post the driver secion here?

$conf['calendar']['driver'] = 'sql';
$conf['calendar']['params'] = array();
$conf['calendar']['params']['phptype'] = 'mysql';
$conf['calendar']['params']['hostspec'] = '******';
$conf['calendar']['params']['username'] = 'hordemgr';
$conf['calendar']['params']['password'] = '******';
$conf['calendar']['params']['database'] = 'horde';

The hostspec and password work great in imp and turba (3.0 and 1.0). In
kronolith-0.0.2 this was all I needed. It appears to need a table to work
with.

-- 
Joshua Warchol
UNIX Systems Administrator
DSL.net


>From jan@horde.org Date: Thu,  3 Jan 2002 17:54:34 +0100
Return-Path: <jan@horde.org>
Mailing-List: contact kronolith-help@lists.horde.org; run by ezmlm
Delivered-To: mailing list kronolith@lists.horde.org
Received: (qmail 14297 invoked from network); 3 Jan 2002 17:01:09 -0000
Received: from mailout09.sul.t-online.com (194.25.134.84)
  by clark.horde.org with SMTP; 3 Jan 2002 17:01:09 -0000
Received: from fwd00.sul.t-online.de 
	by mailout09.sul.t-online.de with smtp 
	id 16MBEp-0002x8-09; Thu, 03 Jan 2002 18:01:07 +0100
Received: from linux.wg.de (320034214675-0001@[217.225.46.126]) by fmrl00.sul.t-online.com
	with esmtp id 16MBEd-0iOIVtC; Thu, 3 Jan 2002 18:00:55 +0100
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 g03GsZ917674
	for <kronolith@lists.horde.org>; Thu, 3 Jan 2002 17:54:35 +0100
Received: from 192.168.60.1 ( [192.168.60.1])
	as user jan@linux by linux.wg.de with HTTP;
	Thu,  3 Jan 2002 17:54:34 +0100
Message-ID: <1010076874.3c348ccaf1c2f@linux.wg.de>
Date: Thu,  3 Jan 2002 17:54:34 +0100
From: Jan Schneider <jan@horde.org>
To: kronolith@lists.horde.org
References: <20020103161945.GC3015@dsl.net> <1010076039.3c3489871126f@linux.wg.de> <20020103164813.GD3015@dsl.net>
In-Reply-To: <20020103164813.GD3015@dsl.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 4.0-cvs
X-Sender: 320034214675-0001@t-dialin.net
Subject: Re: [kronolith] error with kronolith-0.0.3

Zitat von Joshua E Warchol <jwarchol@dsl.net>:

> On Thu, Jan 03, 2002 at 05:40:39PM +0100, Jan Schneider wrote:
> > > Warning: Undefined index: table in
> > > /var/httpd/html/inboxdslnet/horde/kronolith/lib/Driver/sql.php on
> line
> > > 125
> > > object(db_error)(7) { ["error_message_prefix"]=> string(0) ""
> ["mode"]=>
> > > int(1) ["level"]=> int(1024) ["code"]=> int(-18) ["message"]=>
> string(23)
> > > "DB Error: no such table" ["userinfo"]=> string(362) "SELECT
> DISTINCT
> > > e.event_id, e.event_recurtype FROM e WHERE e.calendar_id =
> > > 'josh%runlevel7.net' AND ((e.event_start < '2002-02-01 00:00:00.000'
> AND
> > > e.event_end > '2002-01-01 00:00:00.000') OR (e.event_recurenddate
> >=
> > > '2002-01-01 00:00:00.000' AND e.event_start <= '2002-02-01
> 00:00:00.000'
> > > AND e.event_recurtype != 0)) [nativecode=Table 'horde.e' doesn't
> exist]"
> > > ["callback"]=> NULL }
> > > 
> > > What the heck is "horde.e"? 
> > 
> > There's something broken in you driver configuration in conf.php. Can
> you 
> > post the driver secion here?
> 
> $conf['calendar']['driver'] = 'sql';
> $conf['calendar']['params'] = array();
> $conf['calendar']['params']['phptype'] = 'mysql';
> $conf['calendar']['params']['hostspec'] = '******';
> $conf['calendar']['params']['username'] = 'hordemgr';
> $conf['calendar']['params']['password'] = '******';
> $conf['calendar']['params']['database'] = 'horde';
> 
> The hostspec and password work great in imp and turba (3.0 and 1.0). In
> kronolith-0.0.2 this was all I needed. It appears to need a table to
> work
> with.

Correct. Add this:
$conf['calendar']['params']['table'] = 'kronolith_events';
to the configuration.

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
::::::::::::::::::::::::::::::::::::::::::::::