MobileRead Forums - View Single Post - PRS-T1 Showing "Removing" in booklist?

mochaiso · 06-04-2012, 12:32 AM

Thanks for this info. I got bit by it as well. Just wanted to point out that if you're running Linux you can install sqlite3 from your package manager, mount the SD card from the PRS-T1 or a separate card reader, navigate to the location of books.db in the terminal, execute "sqlite3 books.db", execute

Code:

DELETE FROM collections WHERE content_id NOT IN (select _id FROM books);

at the sqlite3 prompt, then ".quit" and you're finished.

06-04-2012, 12:32 AM	#29
mochaiso Member Posts: 16 Karma: 14 Join Date: Apr 2012 Device: Sony PRS-T1	Thanks for this info. I got bit by it as well. Just wanted to point out that if you're running Linux you can install sqlite3 from your package manager, mount the SD card from the PRS-T1 or a separate card reader, navigate to the location of books.db in the terminal, execute "sqlite3 books.db", execute Code: DELETE FROM collections WHERE content_id NOT IN (select _id FROM books); at the sqlite3 prompt, then ".quit" and you're finished.