[MacPorts] #62929: error after selfupdate (was: error after update)

[MacPorts]

#62929: error after selfupdate
-------------------------+--------------------
  Reporter:  peterruoff  |      Owner:  (none)
      Type:  defect      |     Status:  new
  Priority:  Normal      |  Milestone:
 Component:  base        |    Version:  2.7.0
Resolution:              |   Keywords:
      Port:              |
-------------------------+--------------------

Old description:

> Hi,
>
> after updating today Macports to ver 2.7.0 by using selfupdate the port
> commands do not longer work. I get the following message:
>

> peter$ 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
> Peters-iMac:dropbox peter$
>

> Any other port command shows the same error.
> I use macOS Mojave version 10.14.6, iMac (Retina 4K, 21.5-inch, 2017).
>
> best wishes
> Peter Ruoff

New description:

 Hi,

 after updating today Macports to ver 2.7.0 by using selfupdate the port
 commands do not longer work. I get the following message:

 {{{
 peter$ 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
 Peters-iMac:dropbox peter$
 }}}

 Any other port command shows the same error.
 I use macOS Mojave version 10.14.6, iMac (Retina 4K, 21.5-inch, 2017).

 best wishes
 Peter Ruoff

--

Comment (by jmroot):

 Looks like the sqlite3 headers base was built against don't match the
 library. Can you show the output of `sudo port -df selfupdate`? And also
 this:
 {{{
 grep "#define SQLITE_VERSION_NUMBER"
 /Library/Developer/CommandLineTools/SDKs/MacOSX10.14.sdk/usr/include/sqlite3.h
 }}}

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