[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:  closed
  Priority:  Normal      |  Milestone:
 Component:  base        |    Version:  2.4.2
Resolution:  worksforme  |   Keywords:
      Port:              |
-------------------------+--------------------

Comment (by sam452):

 OK, here's my output of
 otool -L macports/libexec/macports/lib/registry2.0/registry.dylib
 macports/libexec/macports/lib/registry2.0/registry.dylib:
         @loader_path/../registry2.0/registry.dylib (compatibility version
 0.0.0, current version 0.0.0)
         /usr/lib/libsqlite3.0.dylib (compatibility version 9.0.0, current
 version 9.6.0)
         /usr/lib/libgcc_s.1.dylib (compatibility version 1.0.0, current
 version 1.0.0)
         /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current
 version 111.1.7)

 So I've zipped up that copy of sqlite3 in the /usr/local noted above,
 Pointed to my sqlite install in /usr/include/
 This is my latest configure

 {{{
 ./configure --prefix=$HOME/macports --with-openssl=/usr/local/bin/openssl
 --with-sqlite3prefix=/usr/include/
 }}}

 But still nothing changes. I cannot install any port. I'm unsure what to
 try next.

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