Re: 2.10.1 macports SQL error on 10.6

2024-09-13 Thread Riccardo Mottola via macports-users
Hi Joshua, Joshua Root wrote: > > 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" > > That will check that the database is internall

Re: 2.10.1 macports SQL error on 10.6

2024-09-07 Thread 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 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

Re: 2.10.1 macports SQL error on 10.6

2024-09-07 Thread Bill Cole
On 2024-09-06 at 22:25:07 UTC-0400 (Sat, 7 Sep 2024 12:25:07 +1000) Joshua Root 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" "PRA

Re: 2.10.1 macports SQL error on 10.6

2024-09-06 Thread Joshua Root
On 7/9/2024 02:14, Riccardo Mottola wrote: The first step toward fixing it is to find out which ports' db rows are affected. Try running this: sqlite3 /opt/local/var/macports/registry/registry.db "select * from ports where id=726" sqlite3 /opt/local/var/macports/registry/registry.db "select

Re: 2.10.1 macports SQL error on 10.6

2024-09-06 Thread Riccardo Mottola via macports-users
Hi, thanks, Joshua Root wrote: This looks like database inconsistency. The id column is a primary key and so should always be unique, meaning there shouldn't be more than one row that has a given id. Hard to say how it happened. The problem could potentially have been there for some time, on

Re: 2.10.1 macports SQL error on 10.6

2024-09-02 Thread Joshua Root
on my MacBook (64bit) after upgrading to macports 2.10.1, "port selfupdate" yields: ---> Checking for newer releases of MacPorts MacPorts base version 2.10.1 installed, MacPorts base version 2.10.1 available. ---> MacPorts base is already the latest version ---> Updating the ports tree The p

2.10.1 macports SQL error on 10.6

2024-09-02 Thread Riccardo Mottola via macports-users
Hi! on my MacBook (64bit) after upgrading to macports 2.10.1, "port selfupdate" yields: ---> Checking for newer releases of MacPorts MacPorts base version 2.10.1 installed, MacPorts base version 2.10.1 available. ---> MacPorts base is already the latest version ---> Updating the ports tree