MacPorts 2.7.0 has been released

[Ryan Schmidt]

On May 19, 2021, at 18:08, Ryan Schmidt wrote:
> 
> On May 19, 2021, at 11:04, Henning Hraban Ramm wrote:
> 
>> $ sudo port upgrade outdated
>> Password:
>> 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
>> 
>> 
>> What can I do to fix this?
> 
> 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:
> 
> https://github.com/macports/macports-base/commit/19c933969bc62ee54c86fbadaf4d98252b3df5ee#diff-780a9c883e001748860d3ed6b65f88c3be24a21feb1e71a408898f6243149b18R752-R753
> 
> 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.

And I see we already have a ticket for this:

https://trac.macports.org/ticket/62929

So it would be best to add your information there, and Cc yourself there if you would like updates about this issue.