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 <[email protected]> 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 > [email protected] > https://lists.macosforge.org/mailman/listinfo/macports-users _______________________________________________ macports-users mailing list [email protected] https://lists.macosforge.org/mailman/listinfo/macports-users
