[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
 Keywords:          |       Port:
--------------------+----------------------------
 I'm a new MacPorts user, having tried to compile from source dependencies
 on my ancient 10.5 install. I've installed some successfully, like
 openssl, so I have the gcc tools needed. Because GitHub has upgraded their
 TLS stack, I'm unable to upgrade git and compile it from source.
 MacPorts-2.4.2
 I've set ./configure --prefix=$HOME --with-openssl=/usr/local/bin/openssl
 and got through a successful install.
 So after successfully running sudo ~/bin/port -v selfupdate
 I attempted this:
 sudo ~/bin/port -v install git
 The error returned:
 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'
 I've searched the trac system and Google to see anything close to this
 error.
 I've attempted other port installs but still get the same error.
 Reading this forum I've attempted
 sudo ~/bin/port clean
 Can't map the URL 'file://.' to a port description file
 Looking around, I find I should try this:
 sudo ~/bin/port -f uninstall ncursesw
 Warning: no such port: ncursesw, skipping uninstall
 which is understandable since this is a new install.
 So, what should I do next? thx, sam

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