2.10.1 macports SQL error on 10.6

[Joshua Root]

Bill Cole wrote:

> On 2024-09-06 at 22:25:07 UTC-0400 (Sat, 7 Sep 2024 12:25:07 +1000)
> Joshua Root <jmr at macports.org  <https://lists.macports.org/mailman/listinfo/macports-users>>
> is rumored to have said:
>
> [...]
> > First install the macports.sqlext port. Then run this command (all one 
> > line):
> >
> > sqlite3 /opt/local/var/macports/registry/registry.db ".load
> > /opt/local/lib/sqlite3/macports.sqlext" "PRAGMA integrity_check"
>
>
> On Sonoma 14.6.1:
>
> 	skinnyclam:~ root# sqlite3 /opt/local/var/macports/registry/registry.db
> ".load /opt/local/lib/sqlite3/macports.sqlext" "PRAGMA integrity_check"
> 	Error: unknown command or invalid arguments:  "load". Enter ".help" for
> help
>
>
> This can be fixed by installing the sqlite3 port. The version of sqlite3
> in the base OS is 3.43, that in the port is 3.46

Yeah, Apple started disabling loadable extensions in the system sqlite3 
a few years ago, so the macports.sqlext port depends on the sqlite3 
port. But of course you still have to make sure you're running the right 
sqlite3, so specifying the full path in the command would have been more 
reliable.

- Josh