[MacPorts] #56205: Unable to execute port: sqlite error: near "BY"

[MacPorts]

#56205: Unable to execute port: sqlite error: near "BY"
---------------------+----------------------------
  Reporter:  sam452  |      Owner:  (none)
      Type:  defect  |     Status:  new
  Priority:  Normal  |  Milestone:  MacPorts 2.4.3
 Component:  ports   |    Version:  2.4.2
Resolution:          |   Keywords:
      Port:          |
---------------------+----------------------------

Comment (by raimue):

 This is an error when trying to query the SQLite3 database at
 `${prefix}/var/macports/registry/registry.db`.

 With which SQLite3 library did you link MacPorts? This looks like a
 mismatch of header and library. The build assumed you have SQLite3 >=
 3.6.4 based on the header, but apparently at runtime the library does not
 support this syntax.

 Do you maybe have a sqlite3 in `/usr/local/` that could interfere?

-- 
Ticket URL: <https://trac.macports.org/ticket/56205#comment:1>
MacPorts <https://www.macports.org/>
Ports system for macOS