Registry database disk image is malformed

[Jeremy Lavergne]

In the base/src/cregistry/sql.c of MacPorts, I see this command inside init_db():
sqlite3_create_collation(db, "VERSION", SQLITE_UTF8, NULL, sql_version);

Can you make the collation from that?

There is a db function defined by init_db() as well.

On Jan 16, 2014, at 13:43, John Ruschmeyer <jruschme at gmail.com> wrote:

> I was installing a large port when my system KP'd. Upon restart, I tried to continue installing the port, but get an error the the sqlite database registry.db is malformed.
> 
> The conventional wisdom in such cases seems to be to dump and restore the database. I can dump the database fine, but when I try to restore to a new db file, I get an error creating the PORTS table regarding an invalid text collation value of "VERSION".
> 
> Am I correct in assuming that this is a MacPorts extension to sqlite3? If so, is there a command line tool which understands that extension?
> 
> Thanks...
> John
> _______________________________________________
> macports-users mailing list
> macports-users at lists.macosforge.org
> https://lists.macosforge.org/mailman/listinfo/macports-users