[Bug 279284] audio/mixxx: Unable to upgrade your database schema to version 32

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=279284

            Bug ID: 279284
           Summary: audio/mixxx: Unable to upgrade your database schema to
                    version 32
           Product: Ports & Packages
           Version: Latest
          Hardware: Any
                OS: Any
            Status: New
          Severity: Affects Some People
          Priority: ---
         Component: Individual Port(s)
          Assignee: acm@FreeBSD.org
          Reporter: saper@saper.info
             Flags: maintainer-feedback?(acm@FreeBSD.org)
          Assignee: acm@FreeBSD.org

On 15-CURRENT and a recent sqlite3 mixxx will not start with an empty database
reporting the following error:

Unable to upgrade your database schema to version 32
Your mixxxdb.sqlite file may be corrupt.
Try renaming it and restarting Mixxx.
For help with database issues contact:
mixxx-devel@lists.sourceforge.net

Click OK to exit.

The console output says: 

Critical [Main]: FwdSqlQuery - Failed to prepare "DELETE FROM settings WHERE
name=\"mixxx.db.model.library.header_state\"" : QSqlError("1", "Unable to
execute statement", "no such column: mixxx.db.model.library.header_state")
Critical [Main]: SchemaManager - Failed to upgrade database schema from version
6 to version 7

This is because we do not want to have double quotes for string literals
enabled (see /usr/ports/UPDATING entry 20230227, the feature is also disabled
for -CURRENT).

Currently affects only those user that have sqlite3 built without the
compatibility option.

-- 
You are receiving this mail because:
You are the assignee for the bug.