Deactivation error

[Ryan Schmidt]

On Feb 20, 2012, at 15:06, Blair Zajac wrote:

> # /usr/bin/sqlite3 registry.db
> SQLite version 3.7.7 2011-06-25 16:35:41
> Enter ".help" for instructions
> Enter SQL statements terminated with a ";"
> sqlite> select id from ports where name = 'mercurial';
> Error: no such collation sequence: VERSION

You can't just use vanilla sqlite to access MacPorts' database because it has a custom collation. Here's how you would work around that:

http://lists.macosforge.org/pipermail/macports-users/2010-July/020923.html