6.0.0-beta1
7/21/25

[#2075] Kronolith does not find sequences table...
Summary Kronolith does not find sequences table...
Queue Kronolith
Queue Version 2.0.3
Type Bug
State Not A Bug
Priority 1. Low
Owners
Requester info (at) cybernet (dot) it
Created 06/04/2005 (7352 days ago)
Due
Updated 07/13/2005 (7313 days ago)
Assigned
Resolved 06/05/2005 (7351 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
07/13/2005 03:25:30 PM amoreno (at) icmab (dot) es Comment #3 Reply to this comment
I have exactly the same problem ...

I have the PEAR::DB correct (I guess),

I do pear info DB and I see it is correctly installed on version  1.7.6



In relation to the DB user i think it s ok. How can I test easily if a 
user can create a sequence??
Either your database user doesn't have permission to create
sequences, or you have some bug in PEAR::DB that's unrelated to Horde.
06/05/2005 11:02:11 PM Chuck Hagenbuch Comment #2
State ⇒ Not A Bug
Reply to this comment
Either your database user doesn't have permission to create sequences, 
or you have some bug in PEAR::DB that's unrelated to Horde.
06/04/2005 10:06:21 AM info (at) cybernet (dot) it Comment #1
State ⇒ Unconfirmed
Priority ⇒ 1. Low
Type ⇒ Bug
Summary ⇒ Kronolith does not find sequences table...
Queue ⇒ Kronolith
Reply to this comment
Hello,

I had setup latest version of horde, imp abd turba with Postgres 
backend on Fedora C3. All works fine...



Then I tried to setup kronolith...

these are the messages I got in my horde log:



Jun 04 11:19:02 HORDE [error] [kronolith] DB Error: unknown error: 
SELECT NEXTVAL('horde_datatree_seq') [nativecode=ERROR:  la relaz

ione "horde_datatree_seq" non esiste] [on line 350 of 
"/var/www/html/horde/lib/Horde/DataTree/sql.php"]

Jun 04 11:19:03 HORDE [error] [kronolith] DB Error: unknown error: 
SELECT NEXTVAL('horde_datatree_seq') [nativecode=ERROR:  la relaz

ione "horde_datatree_seq" non esiste] [on line 350 of 
"/var/www/html/horde/lib/Horde/DataTree/sql.php"]

Jun 04 11:19:03 HORDE [error] [kronolith] DB Error: unknown error: 
SELECT event_id, event_uid, event_description, event_location, ev

ent_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 = 'alfox' AND ((event_end > '-001-11-28 00:00:00' AND 
event_start < '2005-01-03 00:00:00') OR (event_recurenddate >= '-

001-11-28 00:00:00' AND event_start <= '2005-01-03 00:00:00' AND 
event_recurtype <> 0)) [nativecode=ERROR:  invalid input syntax for

  type timestamp: "-001-11-28 00:00:00"] [on line 205 of 
"/var/www/html/horde/kronolith/lib/Driver/sql.php"]



Thanks in advance for any suggestion.



Best Regards



Alessandro

Saved Queries