Page 1 of 1

Corrupt sqlite database

Posted: Mon Dec 29, 2008 12:46 am
by sonichouse
My blog is reporting
Warning: sqlite_query() [function.sqlite-query]: database disk image is malformed in /opt/share/www/cherokee/serendipity/include/db/sqlite.inc.php on line 229
when I try to view it.

When I log in as Administrator, I do not see any entries.

The blog is showing entries since september, which means I have lost about 15 entries.

Is there anything I can do ?

Re: Corrupt sqlite database

Posted: Mon Dec 29, 2008 1:39 am
by garvinhicking
Hi!

Sounds like a corruption of your FAT or filesystem. Did you run usual FAT/fsck system checks?

Other than that, maybe there are dedicated sqlite repair utilities?

The last resort would only be a backup, maybe even of your RSS feeds or the likes.

Regards,
Garvin

Re: Corrupt sqlite database

Posted: Mon Dec 29, 2008 12:33 pm
by sonichouse
garvinhicking wrote:Hi!

Sounds like a corruption of your FAT or filesystem. Did you run usual FAT/fsck system checks?

Other than that, maybe there are dedicated sqlite repair utilities?

The last resort would only be a backup, maybe even of your RSS feeds or the likes.

Regards,
Garvin
Thanks Garvin,
I suspected as much :?
I managed to export the database, create a new one and then import.
I have lost a few entries, but I can live with that.
I now have a backup to go back to :lol: