[OGDev] Upgrade broke my DB, I think

[Dominic Hargreaves]

On Thu, Aug 24, 2006 at 03:49:52PM +0100, Rev Simon Rumble wrote:
> You may have noticed that the Tourist Engineer has been spammed to hell 
> and back.  I just tried upgrading to the latest version using apt-get 
> and, after accepting the new wiki.conf (there seems to be a bunch of new 
> stuff) I got this:
> 
> Processing config file /etc/openguides/default/wiki.conf ...
> Checking database schema...
> DBD::SQLite::db prepare failed: file is encrypted or is not a 
> database(26) at dbdimp.c line 269 at 
> /usr/share/perl5/Wiki/Toolkit/Setup/SQLite.pm line 156.
> DBD::SQLite::db prepare failed: file is encrypted or is not a 
> database(26) at dbdimp.c line 269 at 
> /usr/share/perl5/Wiki/Toolkit/Setup/SQLite.pm line 156.
> dpkg: error processing openguides (--configure):
>  subprocess post-installation script returned error exit status 2
>  Errors were encountered while processing:
>   openguides
>   E: Sub-process /usr/bin/dpkg returned an error code (1)
> 
> Has the upgrade munched my database?  I've got a backup, so how should I 
> go about recovery?

This looks like a change in SQLite version.

Sadly the DB format change and compatibility was not well managed
upstream.

Does /usr/share/doc/libwiki-toolkit-perl/NEWS.Debian.gz help?

Dominic.

-- 
Dominic Hargreaves | http://www.larted.org.uk/~dom/
PGP key 5178E2A5 from the.earth.li (keyserver,web,email)