Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre

Notices

Reply
 
Thread Tools Search this Thread
Old 04-14-2010, 07:13 PM   #1
Shadowjack
Member
Shadowjack began at the beginning.
 
Posts: 16
Karma: 10
Join Date: Apr 2009
Location: Champaign, IL
Device: Sony PRS-500, PRS-505, PRS-650, Kobo H2O
Problem with collections/tags

I have been using Calibre for years and its great, but I have recently had a problem. I have two books that for some reason are not showing up in their collection. When I view them in the Calibre library they look fine but when I upload them to my prs-505 they don't show up in their appropriate collection. When I view my reader from Calibre the tag field is blank for these two books. I have tried deleting the books from my reader and reloading them but that hasn't helped. I even tried removing every book belonging to the same collection I was adding to and reloading and that didn't help. The same two books still didn't show up. Suggestions?

Calibre v6.47
Sony prs-505
Shadowjack is offline   Reply With Quote
Old 04-14-2010, 10:46 PM   #2
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 26,432
Karma: 5383257
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
what format are these books in?
kovidgoyal is online now   Reply With Quote
Old 04-15-2010, 07:42 AM   #3
Shadowjack
Member
Shadowjack began at the beginning.
 
Posts: 16
Karma: 10
Join Date: Apr 2009
Location: Champaign, IL
Device: Sony PRS-500, PRS-505, PRS-650, Kobo H2O
One is lrx and the other is ebpub.
Shadowjack is offline   Reply With Quote
Old 04-15-2010, 08:39 AM   #4
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 26,432
Karma: 5383257
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
Odd, I don't have any ideas why that should be the case, then.
kovidgoyal is online now   Reply With Quote
Old 04-15-2010, 08:50 AM   #5
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 26,432
Karma: 5383257
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
Wait a sec, is the EPUB DRMed?
kovidgoyal is online now   Reply With Quote
Old 04-15-2010, 04:52 PM   #6
Shadowjack
Member
Shadowjack began at the beginning.
 
Posts: 16
Karma: 10
Join Date: Apr 2009
Location: Champaign, IL
Device: Sony PRS-500, PRS-505, PRS-650, Kobo H2O
Yes. Both were purchased through Sony site. But I have other DRM'd books that I am able to apply "tags" to and they work.
Shadowjack is offline   Reply With Quote
Old 04-16-2010, 05:20 AM   #7
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 26,432
Karma: 5383257
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
Hmm no other bright ideas I'm afraid.
kovidgoyal is online now   Reply With Quote
Old 04-16-2010, 04:57 PM   #8
Shadowjack
Member
Shadowjack began at the beginning.
 
Posts: 16
Karma: 10
Join Date: Apr 2009
Location: Champaign, IL
Device: Sony PRS-500, PRS-505, PRS-650, Kobo H2O
Okay. Final thought: could it be a corrupted database on the prs505 or on my pc? Would it help to "reload" my library? I only have about 200 books so it wouldn't take that long to reload the books. Is there a particular file I should delete before reloading the books?
Shadowjack is offline   Reply With Quote
Old 04-16-2010, 07:49 PM   #9
itimpi
Wizard
itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.itimpi ought to be getting tired of karma fortunes by now.
 
Posts: 4,102
Karma: 780247
Join Date: Nov 2008
Device: Sony PRS-950, iphone/ipad (Marvin/iBooks/QuickReader)
If you are going to reload the books onto the Sony then first reformat the internal memory (and SD card if you have one).
itimpi is offline   Reply With Quote
Old 04-20-2010, 07:06 PM   #10
Shadowjack
Member
Shadowjack began at the beginning.
 
Posts: 16
Karma: 10
Join Date: Apr 2009
Location: Champaign, IL
Device: Sony PRS-500, PRS-505, PRS-650, Kobo H2O
I did the following:
1. Rebuilt my calibre directory on my PC. I reloaded all of my books and re-entered my tags and series. I thought there might be a problem there since I had performed so many in place upgrades (starting at v5.6).
2. I formatted my internal memory and SD card.
3. Reuploaded my books.
4. Now there is a different book that won't upload its tag (format is epub).
5. Plus I get the following error when I run the calibre database integrity check:
ERROR: Error: Failed to check database integrity

Traceback (most recent call last):
File "site-packages\calibre\gui2\dialogs\config\__init__.py", line 786, in run
File "site-packages\calibre\library\database2.py", line 1431, in check_integrity
File "site-packages\calibre\library\caches.py", line 376, in refresh
File "site-packages\calibre\library\sqlite.py", line 163, in run
DatabaseException: no such table: meta2
RemoteTraceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 127, in run
File "site-packages\calibre\library\sqlite.py", line 76, in get
OperationalError: no such table: meta2
Shadowjack is offline   Reply With Quote
Old 04-20-2010, 07:42 PM   #11
chaley
"chaley", not "charley"
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 5,893
Karma: 1216548
Join Date: Jan 2010
Location: France
Device: Many android devices
Quote:
Originally Posted by Shadowjack View Post
ERROR: Error: Failed to check database integrity
OperationalError: no such table: meta2
Kovid said that this error is a regression that will be fixed in the next release. The meta2 table was introduced to support user-defined columns. The problem is that it must be recreated when calibre starts (columns could change), and the database integrity code doesn't know that.

As for the rest of the errors, I have no clue.
chaley is offline   Reply With Quote
Old 04-21-2010, 10:25 AM   #12
Starson17
Wizard
Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.
 
Posts: 4,004
Karma: 177841
Join Date: Dec 2009
Device: WinMo: IPAQ; Android: HTC HD2, Archos 7o; Java:Gravity T
Quote:
Originally Posted by chaley View Post
Kovid said that this error is a regression that will be fixed in the next release. The meta2 table was introduced to support user-defined columns. The problem is that it must be recreated when calibre starts (columns could change), and the database integrity code doesn't know that.
Thanks for the explanation.
Starson17 is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Tags/Collections Disappeared from Reader mypolar Calibre 18 04-11-2011 08:57 AM
Classic Collections, tags, etc with current softroot 1.3 nook DuncanWatson Nook Developer's Corner 4 08-28-2010 04:58 PM
Problem with <br /> tags Pablo Sigil 16 08-19-2010 05:06 AM
PRS-600 does not read Calibre tags as collections raenedaz Calibre 25 04-28-2010 09:48 PM
Calibre+Sony PRS 700 tags/collections prs700 Sony Reader 1 04-20-2009 10:08 PM


All times are GMT -4. The time now is 03:20 AM.


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