Hei there.
My periodic queries in which I try to send E-Mails listing all items of a bookmarked search query are failing with the following error:
Sa.. 7. März 2026, 22:59: Loaded bookmark '3N4TNhZJCSc-2HQiCyTdPjX-JKLSkd9QAzj-RTakvm2nsLq': Some(Right((& due<=today;+7d f:erledigt="false" )))
Sa.. 7. März 2026, 22:59: Using bookmark: Right((& due<=today;+7d f:erledigt="false" ))
Sa.. 7. März 2026, 22:59: Running query: Query(Fix(AccountInfo(CollectiveId(1),Ident(<redacted>),Ident(dD52JQvu3K4-oRtaJMnZeyF-9WvTJkJK1XN-ZrusKTqwWf),Ident(<redacted>)),Some(ValidItemStates),None),QueryExpr(Some(AndExpr(NonEmptyList(SimpleExpr(Lte,DateProperty(DueDate,Calc(Today,Plus,P7D))), CustomFieldMatch(erledigt,Eq,false))))))
Sa.. 7. März 2026, 22:59: Job FbutKfTF7.../1/periodic-query-notify2/Low execution failed. Retrying later.: The column index is out of range: 13, number of columns: 12.
In the job executor logs I find:
2026-03-07T21:59:49.663286844Z 2026.03.07 22:59:49:0000 [io-comp...] [ERROR] docspell.store.impl.DoobieLogging.run:27 - SQL processing failed: SELECT useremail.id, useremail.uid, useremail.name, useremail.smtp_host, useremail.smtp_port, useremail.smtp_user, useremail.smtp_password, useremail.smtp_ssl, useremail.smtp_certcheck, useremail.mail_from, useremail.mail_replyto, useremail.created FROM useremail WHERE useremail.id = ? (NonBatch(List(Ident(ErL2PH2XNEP-eh8EUtWZcsJ-DZRhhP3Dhte-UFisEr5UAgk))))
2026-03-07T21:59:49.663341810Z org.postgresql.util.PSQLException: The column index is out of range: 13, number of columns: 12.
I run Docspell 0.43.0 with a Postgres database.
I tried to recreate my SMTP settings, but ran into #3099.
Any help with this would be greatly appreciated.
Hei there.
My periodic queries in which I try to send E-Mails listing all items of a bookmarked search query are failing with the following error:
In the job executor logs I find:
I run Docspell 0.43.0 with a Postgres database.
I tried to recreate my SMTP settings, but ran into #3099.
Any help with this would be greatly appreciated.