MacPorts 2.7.0 has been released

[raf]

On Thu, May 20, 2021 at 01:31:18AM +0200, Bjarne D Mathiesen <macintosh at mathiesen.info> wrote:

> Ryan Schmidt wrote:
> > Looks like support for the "ALTER TABLE ... RENAME COLUMN" syntax
> > first appeared in SQLite 3.25.0, and MacPorts base is coded only to
> > use the "RENAME COLUMN" syntax with SQLite 3.25.0 and later; for
> > earlier versions, a different method is used:
> >
> > What version of SQLite does your version of macOS have? Run:
> > 
> > /usr/bin/sqlite3 --version
> > 
> > I'm on macOS High Sierra with SQLite 3.19.3 and I haven't seen that problem.
> 
> Qs:
> 1) does MacPorts !explicitly! request /usr/bin/sqlite3
>    -or- does MacPorts use the one found in ${PATH}
> 2) is it advantagerous for MacPorts to use sqlite3 >= 3.25.0
> 
> eg for 10.6.8 I've got :
> 
> #=> /usr/bin/sqlite3 --version
> 3.6.12
> #=> which sqlite3
> /opt/local/bin/sqlite3
> #=> sqlite3 --version
> 3.35.5 2021-04-19 18:32:05 1b256d97b ... e98fae886
> 
> -- 
> Bjarne D Mathiesen
> Korsør ; Danmark ; Europa

I have the same problem on 10.14.6:

  > sqlite3 --version
  3.35.5 2021-04-19 18:32:05 1b256d97b553a9611efca188a3d995a2fff712759044ba480f9a0c9e98fae886
  > /usr/bin/sqlite3 --version
  3.24.0 2018-06-04 14:10:15 95fbac39baaab1c3a84fdfc82ccb7f42398b2e92f18a2a57bce1d4a713cbaapl

And every attempt to use the port command gives an error:

 > port help
  sqlite error: near "COLUMN": syntax error (1) while executing query: ALTER TABLE registry.ports RENAME COLUMN negated_variants TO requested_variants
      while executing
  "registry::open $db_path"
      (procedure "mportinit" line 712)
      invoked from within
  "mportinit ui_options global_options global_variations"
  Error: /opt/local/bin/port: 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

It won't even selfupdate. Do I need to disable SIP and fiddle with /usr/bin/sqlite3?

cheers,
raf