Register Guidelines E-Books Today's Posts Search

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 03-24-2014, 10:05 AM   #1
spacemaster
Junior Member
spacemaster began at the beginning.
 
spacemaster's Avatar
 
Posts: 7
Karma: 10
Join Date: Mar 2014
Location: In my dreams
Device: iPad 2
Database trouble

Hi guys,
I would like to ask you for help. I have installed new calibre version recently (1.29) and since then every time I shut down my pc calibre won't open my library after rebooting.
When I start the calibre it opens but instead of loading my library with 1300+ books it just loads empty library. Plus it says it's the same library but doesn't load the books in it. It helped to load the database manually via Calibre->Library maintenance->Restore database but it takes hours.
Does anyone know any solutions or what to do? I am desperate.
Thanks
spacemaster is offline   Reply With Quote
Old 03-24-2014, 10:17 AM   #2
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 30,952
Karma: 60358908
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
No books showing in the list, means that Metadata.db is missing from the current Library location.

Just where do you keep the Library?
What OS?
theducks is offline   Reply With Quote
Advert
Old 03-24-2014, 10:44 AM   #3
spacemaster
Junior Member
spacemaster began at the beginning.
 
spacemaster's Avatar
 
Posts: 7
Karma: 10
Join Date: Mar 2014
Location: In my dreams
Device: iPad 2
My library is located in D:/Books/Calibre and I'm using Windows 7. Already tried to install lower version of calibre but without any improvement. Now it seems it can't load the database at all.
spacemaster is offline   Reply With Quote
Old 03-24-2014, 11:21 AM   #4
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 30,952
Karma: 60358908
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Quote:
Originally Posted by spacemaster View Post
My library is located in D:/Books/Calibre and I'm using Windows 7. Already tried to install lower version of calibre but without any improvement. Now it seems it can't load the database at all.
Open the Library folder in (the folder) Explorer.
Do you see Author name folders?
Do you see metadata.db? (how big is it in MB?)

If those are there, your Calibre installation or configuration is probably corrupt (installing new/old versions does not change the configuration) or you have a Malware or rogue A/V problem.

Rename(prior to a possible delete) the Calibre configuration folder (this will also remove all settings)

This folder is in the users AppData (hidden by default)\Roaming

C:\users\<logon name>\AppData\Roaming\calibre <-rename

This will be recreated with Defaults the next time you start Calibre. You will be asked for the Location of the Library (if it is not already the default name and location) . In your case: Simply use the Create/Switch:Use Existing option to point to the location of your Library
theducks is offline   Reply With Quote
Old 03-25-2014, 07:51 AM   #5
spacemaster
Junior Member
spacemaster began at the beginning.
 
spacemaster's Avatar
 
Posts: 7
Karma: 10
Join Date: Mar 2014
Location: In my dreams
Device: iPad 2
Thanks for your help but I found that the problem was somewhere else. I used MegaSync to backup my ebook library to Mega servers but thanks to my stupidity it replaced the database file every time I reboot. This happened only if the database file was different then the last stored file and renamed the existing file. That caused calibre not to be able o load the database file because it's name was different then the calibre expected.
I'm sorry for wasting your time but thank you a lot for your help.
spacemaster is offline   Reply With Quote
Advert
Old 03-25-2014, 10:30 AM   #6
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 30,952
Karma: 60358908
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Thanks for getting back.

Yes! Leaving the Cloud replicate active on a Library while using Calibre has caused all sorts of problems.

What I don't quite understand, is why.
Calibre Library (metadata.db) is the NEWER file. The cloud copy is the Stale version and it should have not overwritten a newer version. That is not optimum behavior.
theducks is offline   Reply With Quote
Old 03-25-2014, 10:54 AM   #7
spacemaster
Junior Member
spacemaster began at the beginning.
 
spacemaster's Avatar
 
Posts: 7
Karma: 10
Join Date: Mar 2014
Location: In my dreams
Device: iPad 2
Well, I actually don't understand it either. I believe that syncing was set to be both ways but not sure why. In settings I made sure that it will only copy the changes to server but not from the server to my hard drive. Probably a bug in syncing client itself. Or maybe I set it up badly but that's unlikely as it was pretty straight forward set up.
Anyway, now I know what's the cause of my troubles so the only thing left is to come up with solution so I can keep backup of my library in cloud server.
spacemaster is offline   Reply With Quote
Old 03-25-2014, 12:28 PM   #8
PeterT
Grand Sorcerer
PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.
 
Posts: 13,384
Karma: 78877538
Join Date: Nov 2007
Location: Toronto
Device: Libra H2O, Libra Colour
I wonder if a change in DST / est might have had an adverse effect and caused the unwanted copy?
PeterT is offline   Reply With Quote
Old 03-25-2014, 12:32 PM   #9
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 30,952
Karma: 60358908
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Quote:
Originally Posted by PeterT View Post
I wonder if a change in DST / est might have had an adverse effect and caused the unwanted copy?
Good thinking
IMHO another reason for filesystems to use UTC and just display with the current offset (the DST just modifies the offset)
theducks is offline   Reply With Quote
Old 03-25-2014, 10:47 PM   #10
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 21,672
Karma: 29711016
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by theducks View Post
IMHO another reason for filesystems to use UTC and just display with the current offset (the DST just modifies the offset)
Surely filesystems store dates as ticks since some starting date, from memory

NTFS - 64 bit integer, tick 100ns, start point 1601.
FATNN - 32bit integer, tick 2s, start point 1980.

I don't know what the other file systems use, google should be able to find

Its the OS that converts the ticks to clock time.

BR

Last edited by BetterRed; 03-26-2014 at 12:03 AM.
BetterRed is offline   Reply With Quote
Old 03-25-2014, 11:32 PM   #11
PeterT
Grand Sorcerer
PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.
 
Posts: 13,384
Karma: 78877538
Join Date: Nov 2007
Location: Toronto
Device: Libra H2O, Libra Colour
Quote:
Originally Posted by BetterRed View Post
Surely file systems store dates as ticks since some starting date, from memory

NTFS - 64 bit integer, tick 100ns, start point 1601.
FATNN - 32bit integer, tick 2s, start point 1980.

I don't know what the other file systems use, google should be able to find

Its the OS that converts the ticks to clock time.

BR
Its not so much what is stored, its how the file sync application interprets the date / time stamp.
PeterT is offline   Reply With Quote
Old 03-25-2014, 11:57 PM   #12
AnotherCat
....
AnotherCat ought to be getting tired of karma fortunes by now.AnotherCat ought to be getting tired of karma fortunes by now.AnotherCat ought to be getting tired of karma fortunes by now.AnotherCat ought to be getting tired of karma fortunes by now.AnotherCat ought to be getting tired of karma fortunes by now.AnotherCat ought to be getting tired of karma fortunes by now.AnotherCat ought to be getting tired of karma fortunes by now.AnotherCat ought to be getting tired of karma fortunes by now.AnotherCat ought to be getting tired of karma fortunes by now.AnotherCat ought to be getting tired of karma fortunes by now.AnotherCat ought to be getting tired of karma fortunes by now.
 
Posts: 1,547
Karma: 18068960
Join Date: May 2012
Device: ....
The Help file in the popular file syncing application FreeFileSync (which I use) describes in great detail how it handles all of the issues related to UTC, Local Time, and DST rollover, and the differences between NTFS and FAT as to how they handle File Time. Far too convoluted to try and describe in a post, so...

For much of that explanation the Help file refers to www.codeproject.com/KB/datetime/dstbugs.aspx (scroll a ways down to get to the UTC and DST rollover issues including how if not handled correctly confusion can occur in NTFS at rollover even though it uses UTC).

Happy reading .

EDIT: a little bit of elaboration for clarity

Last edited by AnotherCat; 03-26-2014 at 12:05 AM.
AnotherCat is offline   Reply With Quote
Old 03-26-2014, 12:05 AM   #13
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 21,672
Karma: 29711016
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by PeterT View Post
Its not so much what is stored, its how the file sync application interprets the date / time stamp.
I didn't think it would be necessary to quote theduck's post - corrected

I think have some code somewhere that harmonises FAT, HPFS, NTFS and NFS file system ticks to a lowest common resolution - I think its NFS ticks - it has methods to compare and convert one to the other. I wrote it about 20 years ago - for IBM!

BR

Last edited by BetterRed; 03-26-2014 at 12:22 AM.
BetterRed is offline   Reply With Quote
Reply


Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Database with 1.0... john_es Library Management 3 08-25-2013 04:37 PM
Calibre Database cp Kindle Database mitch13 Library Management 1 05-22-2011 07:33 PM
Database Integrity john_es Calibre 3 12-24-2010 11:42 PM
What Database? LadyLou Calibre 8 02-12-2010 06:32 AM


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


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