Register Guidelines E-Books Today's Posts Search

Go Back   MobileRead Forums > E-Book Readers > Amazon Kindle > Kindle Developer's Corner

Notices

Reply
 
Thread Tools Search this Thread
Old 02-02-2016, 11:19 AM   #1
GriMel
Junior Member
GriMel began at the beginning.
 
Posts: 2
Karma: 10
Join Date: Feb 2016
Device: Amazon Kindle 3 Wi-Fi
How shoud I properly clear VocabBuilder?

Hi, guys.
Sometimes I want to clear my vocab.db but I have 2 problems with this. Let me tell you what I do.

For clearing database I use sqlite3 and the following queries
Code:
DELETE FROM WORDS;
DELETE FROM LOOKUPS;
UPDATE METADATA SET sscnt = 0 WHERE id in ('WORDS', 'LOOKUPS');
VACUUM;
Everything is OK, the base is empty, but after some time I see that all words, deleted from the base are back. I know, that Amazon stores this base but I didn't know it'll give me back all my words in this case. But it is not the main problem

After a couple of deletions I detected that I can't delete anything anymore.
Sqlite3 gives me the following error.
Quote:
Error: database disk image is malformed
Question 1: Are my queries correct? Should I add something more?
Question 2: What do I do wrong? Why my database got malformed?
GriMel is offline   Reply With Quote
Old 02-14-2016, 05:45 PM   #2
GriMel
Junior Member
GriMel began at the beginning.
 
Posts: 2
Karma: 10
Join Date: Feb 2016
Device: Amazon Kindle 3 Wi-Fi
Hey, guys. Nobody knows how to deal with this?
GriMel is offline   Reply With Quote
Advert
Old 02-14-2016, 06:01 PM   #3
Cinisajoy
Just a Yellow Smiley.
Cinisajoy ought to be getting tired of karma fortunes by now.Cinisajoy ought to be getting tired of karma fortunes by now.Cinisajoy ought to be getting tired of karma fortunes by now.Cinisajoy ought to be getting tired of karma fortunes by now.Cinisajoy ought to be getting tired of karma fortunes by now.Cinisajoy ought to be getting tired of karma fortunes by now.Cinisajoy ought to be getting tired of karma fortunes by now.Cinisajoy ought to be getting tired of karma fortunes by now.Cinisajoy ought to be getting tired of karma fortunes by now.Cinisajoy ought to be getting tired of karma fortunes by now.Cinisajoy ought to be getting tired of karma fortunes by now.
 
Cinisajoy's Avatar
 
Posts: 19,161
Karma: 83862859
Join Date: Jul 2015
Location: Texas
Device: K4, K5, fire, kobo, galaxy
It is a Sunday. It is Valentine's Day.
Please have a little patience. I am pretty sure someone will be by tomorrow with an answer.
Note: The guys with all the answers do not get paid but volunteer their time here.
Cinisajoy is offline   Reply With Quote
Reply


Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
No "open" ereaders? Shoud I buy the iPad Mini instead? N3rd Which one should I buy? 21 12-19-2013 07:03 AM
Shoud I be surprised or am I missing something (New Yorker Newsfeed)? jbee Calibre 1 03-22-2009 08:55 PM
1 Shelf Clear, Many to Go RWood Lounge 29 12-04-2007 10:44 AM


All times are GMT -4. The time now is 09:27 AM.


MobileRead.com is a privately owned, operated and funded community.