[horde] Error inserting new event in kronolith
Ruud Baart
r.j.baart at prompt.nl
Mon Mar 2 17:27:07 UTC 2026
Hi Dmitry, thanks for the help.
My database version is 29, 28_kronolith_icalendar_storage.php is present
and my table is:
Table "public.kronolith_icalendar_storage"
Column | Type | Collation | Nullable |
Default
-------------+------------------------+-----------+----------+--------------------------------------------------------------
ical_id | integer | | not null |
nextval('kronolith_icalendar_storage_ical_id_seq'::regclass)
calendar_id | character varying(255) | | not null |
event_uid | character varying(255) | | not null |
event_data | text | | not null |
As you can see there is an auto increment but that dus not work. Perhaps
a Postgres version problem? I use Postgres 17. I assume a statement
something like "select
nextval(pg_get_serial_sequence('kronolith_icalendar_storage',
'ical_id'));" must be added.
Op 2-3-2026 om 17:20 schreef Dmitry Petrov:
> Hi Ruud,
>
> Looks like the scheme of your kronolith_icalendar_storage table is
> incorrect. Specifically, ical_id should be auto-increment.
>
> This is what I have on my end (but I am using mariadb):
> +-------------+------------------+------+-----+---------+----------------+
> | Field | Type | Null | Key | Default | Extra |
> +-------------+------------------+------+-----+---------+----------------+
> | ical_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
> | calendar_id | varchar(255) | NO | MUL | NULL | |
> | event_uid | varchar(255) | NO | | NULL | |
> | event_data | text | NO | | NULL | |
> +-------------+------------------+------+-----+---------+----------------+
>
> Please check your version of horde/kronolith and also check if you
> have horde/kronolith/migration/28_kronolith_icalendar_storage.php.
> Check what versionvalue you have in kronolith_schema_infotable (try
> select version from kronolith_schema_info).
>
> It might be a good idea to check other tables as well.
>
> Regards,
> Dmitry
>
>
> On Sun, Mar 1, 2026 at 12:33 PM Ruud Baart <r.j.baart at prompt.nl> wrote:
>
> Thanks.
>
> Ok, that works, One error gone. The insert error still there.
>
>
> Op 1-3-2026 om 18:27 schreef Dmitry Petrov:
>> Hi Ruud,
>>
>> Looks like this was fixed in the dev version (
>> https://github.com/horde/Db/commit/af41feb432ff8ff82c74458ee31523971546ebd5
>> ), but there is no release yet.
>>
>> You can try composer require horde/db:dev-FRAMEWORK_6_0to use the
>> dev version.
>>
>> Regards,
>> Dmitry
>>
>>
>> On Sun, Mar 1, 2026 at 10:02 AM Ruud Baart <r.j.baart at prompt.nl>
>> wrote:
>>
>> Hi again,
>>
>> My system: Debian trixie, postgres 17, php 8.4, caldav
>> calendar, Horde
>> (horde)
>> <https://mail.tiswe.fr/horde/admin/config/config.php?app=horde>
>> 6.0.0-beta1 , Agenda (kronolith)
>> <https://mail.tiswe.fr/horde/admin/config/config.php?app=kronolith>
>>
>> 5.0.0-alpha9 , Horde_Dav 2.0.0alpha4
>>
>> There is an annoying, severe error while inserting and
>> updating an event
>> with kronolith - see logfile.
>>
>> 1. The first error seems to be that $result is not defined.
>> I assume
>> there must be something added as: if (defined ($results))
>> { } else {}
>> 2. Not null error means that ical_id is NULL. Either the databse
>> definition of kronolith_icalendar_storage id not correct
>> or ical_id
>> must have a value
>>
>> I inserted a very simple event. No recurrence, just "new
>> event at Mars
>> 2, between 16:00 adn 17:00" . Thats all. The caldav calendar
>> client
>> (Thunderbird 147 an 148) accept the new event but will not
>> show it.
>> Immediately the calendar involved changes to read-only. After
>> a forced
>> sync the new event is inserted in the calendar. Further, I'm
>> not sure
>> but for me all these timestamps - see logfile - seems to be
>> too much.
>>
>> Any help would be very welcome.
>>
>> ==============
>>
>> LOGFILE:
>>
>> ==============
>>
>> Log of the errors (1) insert new event and (2) update event:
>>
>> 1. Inserting new event
>>
>> 2026-03-01T15:24:18+01:00 WARN: HORDE [kronolith] PHP
>> ERROR: Undefined variable $results [pid 469414 on line 1242
>> of
>> "/xxx/yyy/zzz/horde/vendor/horde/db/lib/Horde/Db/Adapter/Postgresql/Schema.php"]
>> 2026-03-01T15:24:18+01:00 WARN: HORDE [kronolith] PHP
>> ERROR: Undefined variable $results [pid 469414 on line 1242
>> of
>> "/xxx/yyy/zzz/horde/vendor/horde/db/lib/Horde/Db/Adapter/Postgresql/Schema.php"]
>> 2026-03-01T15:24:18+01:00 WARN: HORDE [kronolith] PHP
>> ERROR: Undefined variable $results [pid 469414 on line 1242
>> of
>> "/xxx/yyy/zzz/horde/vendor/horde/db/lib/Horde/Db/Adapter/Postgresql/Schema.php"]
>> 2026-03-01T15:24:18+01:00 WARN: HORDE [kronolith] PHP
>> ERROR: Undefined variable $results [pid 469414 on line 1242
>> of
>> "/xxx/yyy/zzz/horde/vendor/horde/db/lib/Horde/Db/Adapter/Postgresql/Schema.php"]
>> 2026-03-01T15:24:18+01:00 ERR: HORDE [kronolith] SQL
>> QUERY FAILED: SQLSTATE[23502]: Not null violation: 7 ERROR:
>> null value in column "ical_id" of relation
>> "kronolith_icalendar_storage" violates not-null constraint
>> DETAIL: Failing row contains (null,
>> O72lQSaCnYpQP5ohZ5xBzaA, q-mA4rJ2N-Q9CqUpJqlTZbP, BEGIN:VCALENDAR
>> VERSION:2.0
>> PRODID:-//Mozilla.org/NONSGML Mozi...).
>> INSERT INTO "kronolith_icalendar_storage"
>> ("ical_id", "calendar_id",
>> "event_uid", "event_data") VALUES (NULL,
>> 'O72lQSaCnYpQP5ohZ5xBzaA',
>> 'q-mA4rJ2N-Q9CqUpJqlTZbP', 'BEGIN:VCALENDAR
>> VERSION:2.0
>> PRODID:-//Mozilla.org/NONSGML Mozilla Calendar
>> V1.1//EN
>>
>> DTSTAMP:20260301T142414Z
>> UID:18a03796-b305-4e9a-8081-bc15e0ac8ce5
>> SUMMARY:new event
>> DTSTART;TZID=Europe/Paris:20260302T160000
>> DTEND;TZID=Europe/Paris:20260302T170000
>> TRANSP:OPAQUE END:VEVENT
>> END:VCALENDAR ') RETURNING "ical_id" [pid
>> 469414 on line 244 of
>> "/xxx/yyy/zzz/horde/vendor/horde/db/lib/Horde/Db/Adapter/Pdo/Base.php"]
>>
>> 2. Updating the same event:
>>
>> 2026-03-01T15:47:52+01:00 ERR: HORDE [kronolith] SQL
>> QUERY FAILED: SQLSTATE[23502]: Not null violation: 7 ERROR:
>> null value in column "ical_id" of relation
>> "kronolith_icalendar_storage" violates not-null constraint
>> DETAIL: Failing row contains (null,
>> O72lQSaCnYpQP5ohZ5xBzaA, IxmVC0rpY2TqjVripojLEYE, BEGIN:VCALENDAR
>> VERSION:2.0
>> PRODID:-//Mozilla.org/NONSGML Mozi...).
>> INSERT INTO "kronolith_icalendar_storage"
>> ("ical_id", "calendar_id",
>> "event_uid", "event_data") VALUES (NULL,
>> 'O72lQSaCnYpQP5ohZ5xBzaA',
>> 'IxmVC0rpY2TqjVripojLEYE', 'BEGIN:VCALENDAR
>> VERSION:2.0
>> PRODID:-//Mozilla.org/NONSGML Mozilla Calendar
>> V1.1//EN
>> BEGIN:VTIMEZONE TZID:Europe/Paris
>> BEGIN:DAYLIGHT TZOFFSETFROM:+0100
>> TZOFFSETTO:+0200 DTSTART:20260329T030000
>> RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=3
>> TZNAME:CEST END:DAYLIGHT
>> BEGIN:STANDARD TZOFFSETFROM:+0200 TZOFFSETTO:+0100
>> DTSTART:20261025T030000
>> RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=10
>> TZNAME:CE-T END:STANDARD END:VTIMEZONE
>> BEGIN:VEVENT
>> CREATED:20260301T144529Z
>> LAST-MODIFIED:20260301T144748Z
>> DTSTAMP:20260301T144748Z
>> UID:bd1fdd65-c284-49c6-a20a-77bcc2a232e5
>> SUMMARY:new event STATUS:CONFIRMED
>> DTSTART;TZID=Europe/Paris:20260302T160500
>> DTEND;TZID=Europe/Paris:20260302T170500
>> CLASS:PUBLIC TRANSP:OPAQUE
>> SEQUENCE:1 X-MOZ-GENERATION:1 END:VEVENT
>> END:VCALENDAR ') RETURNING
>> "ical_id" [pid 469569 on line 244 of
>> "/home/websites/webmail.tiswe.fr/horde/vendor/horde/db/lib/Horde/Db/Adapter/Pdo/Base.php
>> <http://webmail.tiswe.fr/horde/vendor/horde/db/lib/Horde/Db/Adapter/Pdo/Base.php>"]
>>
More information about the horde
mailing list