[Bug 278249] mail/evolution: malfunctions when databases/sqlite3 is build with option DQS off

From: <bugzilla-noreply_at_freebsd.org>
Date: Mon, 08 Apr 2024 08:59:23 UTC
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=278249

            Bug ID: 278249
           Summary: mail/evolution: malfunctions when databases/sqlite3 is
                    build with option DQS off
           Product: Ports & Packages
           Version: Latest
          Hardware: Any
                OS: Any
            Status: New
          Severity: Affects Some People
          Priority: ---
         Component: Individual Port(s)
          Assignee: ports-bugs@FreeBSD.org
          Reporter: fuz@FreeBSD.org
                CC: gnome@FreeBSD.org, pavelivolkov@gmail.com
                CC: gnome@FreeBSD.org

As a result of bug #277610, the DQS compatibility option of port
databases/sqlite3 was disabled by default.  This change had been announced for
quite a while in UPDATING after an initial attempt at changing this option (bug
#269798, bug #270064) exposed a variety of compatibility issues.

Turns out mail/evolution is also among them.  With option DQS disabled, no new
mail is received and things fail with the spurious error message:

    no such column: %s

Rebuilding databases/sqlite3 with DQS enabled fixes the issue.

See also:
https://forums.freebsd.org/threads/evolution-glib-error-prevent-new-messages-from-being-displayed.88246/

There's probably a query somewhere that needs to be patched.  Shouldn't be too
hard once it's found.

I was unable to find a corresponding upstream bug report, but will file one
once I find it.

-- 
You are receiving this mail because:
You are on the CC list for the bug.