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

 Replying to [comment:10 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.

 You used the binary installer, I take it?

 > 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).

 OK, so I guess the compiler is picking the later SDK unless told
 otherwise. The good news is that that situation should be handled
 correctly by [5a46743a6bd437d591985e514f471ed0441ea554/macports-base]. The
 bad news is that that doesn't help anyone selfupdating from 2.6.4.

 Would you mind compiling and running the attached test program on both
 your systems to confirm the nature of the issue? (Instructions in the
 comment at the top of the file.)

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