Skip site navigation (1)Skip section navigation (2)
Date:      Tue, 30 Apr 2024 19:22:09 +0000
From:      bugzilla-noreply@freebsd.org
To:        ports-bugs@FreeBSD.org
Subject:   [Bug 278669] games/xmoto: Crashes at startup if DQS option off for sqlite3
Message-ID:  <bug-278669-7788@https.bugs.freebsd.org/bugzilla/>

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

            Bug ID: 278669
           Summary: games/xmoto: Crashes at startup if DQS option off for
                    sqlite3
           Product: Ports & Packages
           Version: Latest
          Hardware: Any
                OS: Any
            Status: New
          Severity: Affects Only Me
          Priority: ---
         Component: Individual Port(s)
          Assignee: amdmi3@FreeBSD.org
          Reporter: dave@vasilevsky.ca
          Assignee: amdmi3@FreeBSD.org
             Flags: maintainer-feedback?(amdmi3@FreeBSD.org)

By default, the sqlite3 port has the DQS option off. Unfortunately, xmoto u=
ses
double-quoting for strings, for example in getXmParameterKey:
https://github.com/xmoto/xmoto/blob/v0.6.2/src/db/xmDatabase.cpp#L329

This causes xmoto to crash at startup with either:
- "no such column: siteKey" if no existing xmoto DB is present, or
- "no such column: xmdb_version" if there is an existing DB

This should be reported upstream, I'll look into it. For now, we could patch
xmDatabase::open to add `sqlite3_db_config(m_db, SQLITE_DBCONFIG_DQS_DML, 1
NULL);`

--=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-278669-7788>