[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 raimue):

 Check with which library MacPorts was linked. If this still says
 `/usr/lib/libsqlite3.dylib`, something went wrong. For example, on my
 system with macOS 10.12 Sierra:
 {{{
 $ otool -L /opt/local/libexec/macports/lib/registry2.0/registry.dylib
 /opt/local/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.dylib (compatibility version 9.0.0, current
 version 254.8.0)
         /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current
 version 1238.60.2)
 }}}

 Another solution would of course be to remove the custom sqlite3 from
 /usr/local as that leaves only the system version to be linked.

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