error after selfupdate

[peterruoff]

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

[jmroot (Joshua Root)]

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