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

 If it is still not working after you removed sqlite3 from /usr/local, it
 is still picking up the wrong headers from somewhere else or you did not
 actually rebuild from source. I am not sure if just running configure
 invalidates all previous build artifacts. Did you run `make clean` between
 the builds?

 No idea how the libraries were shipped on 10.5, but one of the
 `/usr/lib/libsqlite3*.dylib` files is usually just a symlink to the other.
 It is advised not to modify system files in general.

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