Re: [Davical-general] SQL error after upgrade: ":collection_id" => "-1"

[Andrew R. <an...@et...>]

On Tue, 2023-06-13 at 11:59 +0200, Giuseppe Sacco via Davical-general wrote:
> Hello,
> I just updated my machine from Debian 10 to 11, so Davical has been
> updated
> from version 1.1.8 do 1.1.10.

Good news there, Debian 12 has just been released as well! :)

> Now, after the upgrade, I see this error when synchronizing the calendar
> using the Android DAVx5 app:
[snip errors]
> 2023-06-13 11:25:51 CEST [89117-6] davical_app@davical DETTAGLI:  La
> chiave (collection_id)=(-1) non è presente nella tabella "collection".
> 2023-06-13 11:25:51 CEST [89117-7] davical_app@davical CONTESTO: 
> istruzione SQL "INSERT INTO sync_tokens(collection_id, sync_token) VALUES(
> in_collection_id, new_token )"
>         funzione PL/pgSQL new_sync_token(bigint,bigint) riga 31 a
> istruzione SQL
> 2023-06-13 11:25:51 CEST [89117-8] davical_app@davical ISTRUZIONE:  SELECT
> new_sync_token( 0, -1) AS sync_token
> 
> Is this a know error? How may I fix it?

It seems that collection_id is -1. I'm going to hazard that you don't have
any collections with a collection_id with -1. How is you SQL, can you
perform some database queries for me?

Cheers,
Andrew
-- 
Andrew Ruthven, Wellington, New Zealand
an...@et... |
Catalyst Cloud: | This space intentionally left blank
https://catalystcloud.nz |