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

 I think I have a successful test here. I set up a fresh Mojave VM in
 VMware, with Xcode 11.3.1 which I *think* uses macOS 10.15 SDK by default,
 installed MacPorts 2.6.4 on it, upgraded it to MacPorts 2.7.0 from the
 release-2.7 branch in Git, and it seemed to work.

 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`
 * `sudo port install wget` to test `port` functionality
 * Install MacPorts tip of release-2.7 branch on top of the 2.6.4 install
   * `cd ~/local/repos`
   * `git clone https://github.com/macports/macports-base`
   * `cd macports-base`
   * `git checkout release-2.7`
   * Install per https://guide.macports.org/#installing.macports.git
     * `./configure --enable-readline && make && sudo make install && make
 distclean`
 * Test `port` by installing sqlite
   * `sudo port install sqlite3`
   * → Success!



 {{{

 portia2:macports-base janke$ port -v
 MacPorts 2.7.0
 Entering shell mode... ("help" for help, "quit" to quit)
 portia2:macports-base janke$ sudo port install sqlite3
 --->  Computing dependencies for sqlite3
 --->  Fetching archive for sqlite3
 --->  Attempting to fetch sqlite3-3.35.5_0.darwin_18.x86_64.tbz2 from
 https://ywg.ca.packages.macports.org/mirror/macports/packages/sqlite3
 --->  Attempting to fetch sqlite3-3.35.5_0.darwin_18.x86_64.tbz2.rmd160
 from https://ywg.ca.packages.macports.org/mirror/macports/packages/sqlite3
 --->  Installing sqlite3 @3.35.5_0
 --->  Activating sqlite3 @3.35.5_0
 --->  Cleaning sqlite3
 --->  Scanning binaries for linking errors
 --->  No broken files found.
 --->  No broken ports found.
 portia2:macports-base janke$ sudo port upgrade outdated
 Nothing to upgrade.
 --->  Scanning binaries for linking errors
 --->  No broken files found.
 --->  No broken ports found.
 portia2:macports-base janke$

 }}}

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