Damaged database?

[Rainer Müller]

Hello,

On 2013-02-22 19:18, Adam Dershowitz wrote:
> Error: org.macports.deactivate for port gst-plugins-base returned:
> sqlite error: database disk image is malformed (11) while executing
> query: SELECT actual_path FROM registry.files WHERE id=? AND active
> ORDER BY actual_path

Your SQLite DB was probably in an inconsistent state when your computer
had a problem. This means the data on disk is damaged and SQLite is
unable to recover from this by itself.

Although it might require some time to rebuild some ports, the easiest
of your options would be to wipe the installation and start from scratch.

First check the list of requested ports to get an idea what you have
installed and write down anything important to you:

  port echo requested and active

Then follow the instructions given in the guide for uninstalling [1].
Ignore the first step as you cannot properly run 'port uninstall' with a
damaged database. Afterwards reinstall from the disk image [2] and
reinstall any ports noted down previously.

Rainer

[1] http://guide.macports.org/#installing.macports.uninstalling
[2] https://www.macports.org/install.php