[kronolith] kronolith Digest, Vol 789, Issue 1

Arelowo Alao aalao at ncmec.org
Wed Aug 3 12:15:25 PDT 2005


How did you get to the admin setting?

-----Original Message-----
From: kronolith-bounces at lists.horde.org
[mailto:kronolith-bounces at lists.horde.org] On Behalf Of
kronolith-request at lists.horde.org
Sent: Tuesday, August 02, 2005 3:00 PM
To: kronolith at lists.horde.org
Subject: kronolith Digest, Vol 789, Issue 1

Send kronolith mailing list submissions to
	kronolith at lists.horde.org

To subscribe or unsubscribe via the World Wide Web, visit
	http://lists.horde.org/mailman/listinfo/kronolith
or, via email, send a message with subject or body 'help' to
	kronolith-request at lists.horde.org

You can reach the person managing the list at
	kronolith-owner at lists.horde.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of kronolith digest..."


Today's Topics:

   1. Re: Calendar and PostgreSQL (?) (Morten Schmidt)
   2. Teething Problems (John)
   3. storing events that last a day at month's end. (Marc Fellman)
   4. Re: storing events that last a day at month's end. (Kevin M. Myer)


----------------------------------------------------------------------

Message: 1
Date: Mon, 1 Aug 2005 08:15:54 +0200
From: Morten Schmidt <smet at smet.dk>
Subject: Re: [kronolith] Calendar and PostgreSQL (?)
To: kronolith at lists.horde.org
Message-ID: <200508010815.54233.smet at smet.dk>
Content-Type: text/plain;  charset="iso-8859-1"

Sorry for the fuss...

I figured it out, and now I'm going to do a thing everybody that reports

problems should learn to do if they resolve it: TELL PEOPLE ABOUT IT ;o)

I figured out that in my administration setting I hadn't created a
DataTree 
for Horde...

I did this:
Administration -> Setup -> [TAB] DataTree System

In there it said: 
* What backend should we use for Horde DataTree storage?    None

I changed it to: SQL Database, called the table horde_datatree (which
was 
already in the db) and viola!!!

Thank you all anyways...

/morten

On Sunday 31 July 2005 13:45, Morten Schmidt wrote:
> I havn't been able to see anyone solving this issue, so I'll just try
> asking here....
>
> I have Horde3 and Kronolith2 configured with a PostgreSQL databse on
my
> Debian Sid. But the Calendar doesn't seem to be working with
PostgreSQL.
>
> This is what the log says when I click the "Calendar"
>
> [SNIP]
> Jul 31 13:38:49 HORDE [debug] [kronolith] Hook _horde_hook_share_init
in
> application horde not called. [on line 1418 of
> "/usr/share/horde3/lib/Horde.php"]
> Jul 31 13:38:50 HORDE [debug] [kronolith] SQL session setup by
> Administrator: query = "SET datestyle TO 'iso'" [on line 530 of
> "/usr/share/horde3/kronolith/lib/Driver/sql.php"]
> Jul 31 13:38:50 HORDE [debug] [kronolith] SQL event list by
Administrator:
> query = "SELECT event_id, event_uid, event_description,
event_location,
> event_status, event_attendees, event_keywords, event_title,
event_category,
> event_recurtype, event_recurenddate, event_recurinterval,
event_recurdays,
> event_start, event_end, event_alarm, event_modified, event_exceptions,
> event_creator_id FROM kronolith_events WHERE calendar_id = ? AND
> ((event_end
>
> > ? AND event_start < ?) OR (event_recurenddate >= ? AND event_start
<= ?
> > AND
>
> event_recurtype <> ?))" [on line 200 of
> "/usr/share/horde3/kronolith/lib/Driver/sql.php"]
> [SNAP]
>
> and this, when I hit "New Event":
>
> [SNIP]
> Jul 31 13:40:30 HORDE [debug] [kronolith] Hook _horde_hook_share_init
in
> application horde not called. [on line 1418 of
> "/usr/share/horde3/lib/Horde.php"]
> Jul 31 13:40:31 HORDE [debug] [kronolith] Hook _horde_hook_share_init
in
> application horde not called. [on line 1418 of
> "/usr/share/horde3/lib/Horde.php"]
> Jul 31 13:40:31 HORDE [debug] [kronolith] SQL session setup by
> Administrator: query = "SET datestyle TO 'iso'" [on line 530 of
> "/usr/share/horde3/kronolith/lib/Driver/sql.php"]
> Jul 31 13:40:31 HORDE [debug] [kronolith] SQL event list by
Administrator:
> query = "SELECT event_id, event_uid, event_description,
event_location,
> event_status, event_attendees, event_keywords, event_title,
event_category,
> event_recurtype, event_recurenddate, event_recurinterval,
event_recurdays,
> event_start, event_end, event_alarm, event_modified, event_exceptions,
> event_creator_id FROM kronolith_events WHERE calendar_id = ? AND
> ((event_end
>
> > ? AND event_start < ?) OR (event_recurenddate >= ? AND event_start
<= ?
> > AND
>
> event_recurtype <> ?))" [on line 200 of
> "/usr/share/horde3/kronolith/lib/Driver/sql.php"]
> Jul 31 13:40:31 HORDE [error] [kronolith] DB Error: unknown error:
SELECT
> event_id, event_uid, event_description, event_location, event_status,
> event_attendees, event_keywords, event_title, event_category,
> event_recurtype, event_recurenddate, event_recurinterval,
event_recurdays,
> event_start, event_end, event_alarm, event_modified, event_exceptions,
> event_creator_id FROM kronolith_events WHERE calendar_id =
'Administrator'
> AND ((event_end > '-001-11-27 00:00:00' AND event_start < '2005-01-02
> 00:00:00') OR (event_recurenddate >= '-001-11-27 00:00:00' AND
event_start
> <= '2005-01-02 00:00:00' AND event_recurtype <> 0)) [nativecode=ERROR:

> invalid input syntax for type timestamp: "-001-11-27 00:00:00"] [on
line
> 205 of "/usr/share/horde3/kronolith/lib/Driver/sql.php"]
> [SNAP]
>
> What is wrong here?
>
> Thank you in advance
>
> /morten
>
> --
> Powered by Debian GNU/Linux & PalmOS5

-- 
Powered by Debian GNU/Linux & PalmOS5


------------------------------

Message: 2
Date: Mon, 1 Aug 2005 10:38:16 +0100
From: John <john.shaw at gmail.com>
Subject: [kronolith] Teething Problems
To: kronolith at lists.horde.org
Message-ID: <709bc8bf0508010238601ffe96 at mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1

Hey guys.
 
I am new to Linux, the previous guy built the horde system , but it
then crashed.
 
I am using Horde-3.0.5-rc2 with imp-h3-4.0.3 and kronolith -h3-2.0.3
 
I have created a multiple install of horde, the old one and a new one.
 
Everything looks fine, until a user goes to kronolith and puts in a
recurring event.
 
The following errors occur:
 
 Notice: Only variable references should be returned by reference in
/var/www/localhost/htdocs/idulmail/kronolith/lib/Driver.php on line
139

Notice: Only variable references should be returned by reference in
/var/www/localhost/htdocs/idulmail/kronolith/lib/Kronolith.php on line
459
 
Would love some advice on this one, have racked google's brains and
come up with zip.
 
I oculd be wrong, but I think somewhere, the system is still trying to
point to a /horde directory, which doesn't exist, anyone ever seen
this before?


-- 
John Shaw

john.shaw at gmail.com


------------------------------

Message: 3
Date: Mon, 1 Aug 2005 13:21:52 +0200
From: Marc Fellman <marc.fellman at gmail.com>
Subject: [kronolith] storing events that last a day at month's end.
To: kronolith at lists.horde.org, marc at fellman.nl
Message-ID: <8e032bc30508010421c063fd1 at mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1

Hi,

Just tested it again against CVS HEAD version of kronolith. Horde
hangs if you add a day event at the end of the month. If I change it
to last form 00:00 till 23:55 (on the same day) I don't have a
problem.

Is this a known bug?

Could the day-long event be changed in an event that lasts from 00:00
till 23:55? (Or maybe ad a flag to the events table?)

I'will try to find out how to this myself but maybe this is allready
solved (or easely solved).

-- 
Met Vriendelijke Groet / With Kind Regards

Marc Fellman


------------------------------

Message: 4
Date: Mon,  1 Aug 2005 07:48:28 -0400
From: "Kevin M. Myer" <kevin_myer at iu13.org>
Subject: Re: [kronolith] storing events that last a day at month's
	end.
To: kronolith at lists.horde.org
Message-ID: <20050801074828.3sl5t740va8pw8k4 at webapps.iu13.org>
Content-Type: text/plain;	charset=ISO-8859-1;	format="flowed"

Quoting Marc Fellman <marc.fellman at gmail.com>:

> Hi,
>
> Just tested it again against CVS HEAD version of kronolith. Horde
> hangs if you add a day event at the end of the month. If I change it
> to last form 00:00 till 23:55 (on the same day) I don't have a
> problem.
>
> Is this a known bug?

I believe its this one:

http://bugs.horde.org/ticket/?id=2346

Kevin

-- 
Kevin M. Myer
Senior Systems Administrator
Lancaster-Lebanon Intermediate Unit 13  http://www.iu13.org




------------------------------


-- 
Kronolith mailing list
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: kronolith-unsubscribe at lists.horde.org


End of kronolith Digest, Vol 789, Issue 1
*****************************************


More information about the kronolith mailing list