Corrupt sqlite database

Random stuff about serendipity. Discussion, Questions, Paraphernalia.
Post Reply
sonichouse
Regular
Posts: 196
Joined: Sun May 11, 2008 2:53 am
Contact:

Corrupt sqlite database

Post 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 ?
Steve is occasionally blogging here
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Corrupt sqlite database

Post 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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
sonichouse
Regular
Posts: 196
Joined: Sun May 11, 2008 2:53 am
Contact:

Re: Corrupt sqlite database

Post 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:
Steve is occasionally blogging here
Post Reply