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
