[MacPorts] #62929: Failed to initialize MacPorts, sqlite error: near "COLUMN": syntax error (1) while executing query: ALTER TABLE registry.ports RENAME COLUMN negated_variants TO requested_variants

[MacPorts]

#62929: Failed to initialize MacPorts, sqlite error: near "COLUMN": syntax error
(1) while executing query: ALTER TABLE registry.ports RENAME COLUMN
negated_variants TO requested_variants
-------------------------+--------------------
  Reporter:  peterruoff  |      Owner:  (none)
      Type:  defect      |     Status:  new
  Priority:  Normal      |  Milestone:
 Component:  base        |    Version:  2.7.0
Resolution:              |   Keywords:  mojave
      Port:              |
-------------------------+--------------------

Comment (by peterruoff):

 After installing MacPorts for Mojave again (after the above suggestion by
 Ryan; thanks!) and then doing the selfupdate and the upgrade, all is
 working fine now on my iMac.

 I have another machine, a Mac Pro (Late 2013), running the same Mojave
 version as my iMac, but there no problems occurred at all; there I could
 upgrade MacPorts via selfupdate to the new version 2.7.0 without problems.

 There was a difference, however, between the two machines: on the MacPro
 only 10.14 SDK was installed, while on the iMac there was an additional
 10.15 SDK install (by some reason I no longer recall). Perhaps the
 additional 10.15 SDK caused the trouble during the upgrade by selfupdate?
 But both are still there after the successful reinstall of MacPorts on the
 iMac.

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