Skip site navigation (1)Skip section navigation (2)
Date:      Sat, 25 May 2024 08:18:10 +0000
From:      bugzilla-noreply@freebsd.org
To:        ports-bugs@FreeBSD.org
Subject:   [Bug 279284] audio/mixxx: Unable to upgrade your database schema to version 32
Message-ID:  <bug-279284-7788@https.bugs.freebsd.org/bugzilla/>

next in thread | raw e-mail | index | archive | help
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D279284

            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 datab=
ase
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:=20

Critical [Main]: FwdSqlQuery - Failed to prepare "DELETE FROM settings WHERE
name=3D\"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 ver=
sion
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 disabl=
ed
for -CURRENT).

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

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



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-279284-7788>