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
