[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:  jmroot
      Type:  defect      |     Status:  closed
  Priority:  Normal      |  Milestone:
 Component:  base        |    Version:  2.7.0
Resolution:  fixed       |   Keywords:  mojave
      Port:              |
-------------------------+--------------------

Comment (by jmroot):

 Replying to [comment:17 apjanke]:
 > Xcode 11.3.1 which I *think* uses macOS 10.15 SDK by default

 You can check that by running {{{plutil -p `xcrun --show-sdk-
 path`/SDKSettings.plist | fgrep CanonicalName}}} and by compiling and
 running the C test program attached to this ticket. (`xcrun --show-sdk-
 version` should theoretically also work but seems to encounter errors
 sometimes.)

 > Host name: portia2
 > Fresh macOS 10.14.6 install, with all system updates applied.
 >
 > Steps done:
 > * Install Xcode 11.3.1 from a downloaded .xzip file and run it to accept
 the EULA
 > * Install CLT with `xcode-select --install`
 > * System updates
 > * Install MacPorts 2.6.4 using the pkg file downloaded from the GitHub
 Releases page at https://github.com/macports/macports-
 base/releases/tag/v2.6.4
 > * Do NOT do `sudo port selfupdate`

 Unfortunately (for our current purpose) the pkg will run selfupdate as
 part of its postflight script. So if that succeeded, you would now have
 2.7.0. (Run `port version` to confirm.)

 > * `sudo port install wget` to test `port` functionality

 … and if you have 2.7.0 and this worked, you are not affected by the
 issue.

 The rest of the procedure looks fine. Thanks for your efforts.

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