segfault

[Roger Pack]

>> $ sudo port installed
>>
>> Error: port installed failed: sqlite error: SQL logic error or missing
>> database (1) while executing query: SELECT name FROM registry.ports
>> WHERE id=111
>> No ports are installed.
>>
>> (I did mess with it a bit, though, so I may have done something).
>
> Do you remember what you changed?

I had renamed registry.db, run this command once, then moved the "bad"
registry.db back.  After doing this, I think macports still
segfaulted, so I think the problem was still present, it just didn't
segfault with this command for whatever reason.

> This might make MacPorts think no ports are installed, though they still are, which will cause you problems. Uninstalling MacPorts cleanly, using the instructions in the Guide, and then reinstalling MacPorts and the ports you want, would clean this up.

Good to know thanks!
-r