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

[Giuseppe S. <giu...@sg...>]

Hello Andrew,

Il giorno mar, 13/06/2023 alle 23.33 +1200, Andrew Ruthven ha scritto:
> 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! :)

I was sure to already have 11 and wanted to upgrade to 12. Then I checked
the system and found it was at 11, so I decided to go one step at a time. I
am unsure about the best way now: should I try fix this problem while in
Debian 11, or should I complete the upgrade to 12 anche check the system at
the end?

> > 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?

Sure, I may query the database with psql.

Thank you,
Giuseppe