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

 Yes, what you say makes sense. So from my user account I’ve located
 Sqlite3 and have gone through the install steps again with this setup
 after removing the bin and support files.


 {{{
 ./configure --prefix=$HOME/macports --with-openssl=/usr/local/bin/openssl
 --with-sqlite3prefix=/usr/local/Cellar/sqlite/3.7.10/

 }}}

 From the .configure output I find this:

 {{{
 checking for target platform... darwin 9
 checking for curl-config... /usr/bin/curl-config
 checking sqlite3ext.h usability... yes
 checking sqlite3ext.h presence... yes
 checking for sqlite3ext.h... yes
 checking for SQLite >= 3003011... yes
 }}}


 All seem ok and no obvious errors through the configure, make, sudo make
 install process. And successfully run the selfupdate

 Yet again when I

 {{{
 sudo ~/macports/bin/port -v install git
 }}}

 returns:

 {{{
 Portfile changed since last build; discarding previous state.
 Error: Unable to execute port: sqlite error: near "BY": syntax error (1)
 while executing query: SELECT id FROM registry.ports INDEXED BY port_name
 WHERE state='installed' AND name='xz'
 }}}


 This sqlite3 install works. What should I do next to get this working?,
 sam

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