[horde] horde_histories not-null constraint

[Hannes Tismer]

Hey,

PHP 7.4.

Am 14. Dezember 2022 10:41:30 schrieb Ralf Lang <ralf.lang at ralf-lang.de>:

> Hi Hannes,
>
> Am 13.12.2022 um 23:47 schrieb Hannes Tismer:
>> Dear Horde list,
>>
>> I've just noticed that my Horde Webmail instance hasn't added any
>> horde_histories entries since 2021. Looking at the logs any change I
>> make in Kronolith results in errors like these:
>>
>> ERR: HORDE [kronolith] SQL QUERY FAILED: SQLSTATE[23502]: Not null
>> violation: 7 ERROR:  null value in column "history_modseq" violates
>> not-null constraint
>> DETAIL:  Failing row contains (19117,
>> kronolith:xxxxxxxxxxxxx at xxxxx..., modify, 1670970360, null, xxxxx,
>> a:2:{s:3:"new";a:2:{s:11:"event_start";s:19:"2022-12-15 23:00:00...,
>> null).
>>         INSERT INTO horde_histories (object_uid, history_ts, history_who,
>>           history_desc, history_action, history_modseq, history_extra)
>> VALUES
>>           ('kronolith:xxxxxxxxxxxxxxxxxxxx', 1670970360, 'panni',
>> NULL, 'modify', NULL,
>>           'a:2:{s:3:"new";a:2:{s:11:"event_start";s:19:"2022-12-15
>>           23:00:00";s:9:"event_end";s:19:"2022-12-16
>> 00:00:00";}s:3:"old";a:2:{s:11:"event_start";N;s:9:"event_end";N;}}')
>> [pid 108 on line 243 of "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
>> 2022-12-13T23:26:00+01:00 ERR: HORDE [kronolith] SQLSTATE[23502]: Not
>> null violation: 7 ERROR:  null value in column "history_modseq"
>> violates not-null constraint
>>
>>
>>
>> All migrations are applied as far as I can see and when manually
>> inserting an entry into horde_histories_modseq, an incremented
>> history_modseq is created, just as Horde/History/Sql.php:_nextModSeq()
>> tries to
>> (https://github.com/horde/History/blob/c112235f0327baf7202d56236c8f823fb40b6741/lib/Horde/History/Sql.php#L358).
>>
>> Somehow it tries to insert a NULL value for history_modseq for the new
>> horde_histories entry.
>>
>>
>> Horde Version: Webmail Edition 5.2.22
>> PostgreSQL: 12.13 (Ubuntu 12.13-1.pgdg22.04+1)
>> OS: Ubuntu Server 18.04.4 LTS (bionic)
> that would be PHP 7.2?
>
> --
> Horde mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org