[ERROR11] Database disk image is malformed

Ideas? Suggestions?

Or report any bugs about GreatNews here

Moderators: justauser, MysteryFCM

User avatar
Narga
Posts: 15
Joined: Tue May 30, 2006 4:16 pm
Contact:

[ERROR11] Database disk image is malformed

Postby Narga » Fri Jul 17, 2009 11:05 pm

My newsfeed.db was 338MB, I'm running on XP SP3, it is work well to yesterday. Now when I click a feed or delete it I got the alert: [ERROR11] Database disk image is malformed
I has 863 feed in list and 5 feeds has that error.
How to fix it? Pls help me 'cause I got 86147 topic labeled, don't tell me create a new feed list :(
Last edited by Narga on Mon Jul 20, 2009 5:28 am, edited 2 times in total.
Narga - http://www.narga.net
Ideas and inspiration in my opinion!

MysteryFCM
Posts: 143
Joined: Tue Feb 21, 2006 1:56 pm
Location: Tyneside, UK
Contact:

Re: [ERROR11] Database disk image is malformed

Postby MysteryFCM » Sat Jul 18, 2009 6:02 pm

I believe GN uses sqlite for the database, so you should be able to repair the corruption;

http://www.sqlite.org/faq.html#q21

You'll need the SQLite CLI to repair it;

http://www.sqlite.org/download.html
Regards
Steven Burn
I.T. Mate / hpHosts
it-mate.co.uk / hosts-file.net

User avatar
Narga
Posts: 15
Joined: Tue May 30, 2006 4:16 pm
Contact:

Re: [ERROR11] Database disk image is malformed

Postby Narga » Sun Jul 19, 2009 4:05 am

How can I do it step by step?
Narga - http://www.narga.net

Ideas and inspiration in my opinion!

MysteryFCM
Posts: 143
Joined: Tue Feb 21, 2006 1:56 pm
Location: Tyneside, UK
Contact:

Re: [ERROR11] Database disk image is malformed

Postby MysteryFCM » Sun Jul 19, 2009 9:56 am

Place your db in the same folder as the SQLite CLI, then type the following;

Code: Select all

echo ".dump" | sqlite old.db | sqlite new.db


Replacing the filename with the name of your .db file :)

Then copy your new .db file back to the GN folder.
Regards
Steven Burn
I.T. Mate / hpHosts
it-mate.co.uk / hosts-file.net

User avatar
Narga
Posts: 15
Joined: Tue May 30, 2006 4:16 pm
Contact:

Re: [ERROR11] Database disk image is malformed

Postby Narga » Mon Jul 20, 2009 1:59 am

I'm place sqlite3.exe to Greatnews folder then type:

Code: Select all

echo ".dump" | sqlite newsfeed.db | sqlite new.db
then it display for me the

Code: Select all

...>

I also enter the folder path but it's same result
Nothing happened. How can I do it?
Narga - http://www.narga.net

Ideas and inspiration in my opinion!

User avatar
Narga
Posts: 15
Joined: Tue May 30, 2006 4:16 pm
Contact:

Re: [Solved] - [ERROR11] Database disk image is malformed

Postby Narga » Mon Jul 20, 2009 3:01 am

OK, This problem has been solved with below steps: (I'm using cmd)
Dump newsfeed.db to sql file:

Code: Select all

sqlite3 newsfeed.db .dump > newsfeed.sql

Dump newsfeed.sql to new database

Code: Select all

sqlite3 newsfeed.db < newsfeed.sql

It's very simple then compact my old file from 394MB to 57MB then clean up all my entries :(
Narga - http://www.narga.net

Ideas and inspiration in my opinion!


Return to “Suggestions & Bug Reports”

Who is online

Users browsing this forum: No registered users and 9 guests