On Thu, May 20, 2021 at 01:31:18AM +0200, Bjarne D Mathiesen <macint...@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