Calibre metadata.db contains errors... Calibre2opds cannot open file. - Page 2

anamardoll · 01-15-2012, 01:44 PM

Chaley, thank you -- I'll send you an email now. (It looks like backing up the metadata didn't clear up the problem.)

And, of course, you're right -- there's all kinds of Windows (I'm running Win 7) issues I'm probably unaware of. Thank you -- I know it's hard to diagnose problems over the internet.

anamardoll · 01-15-2012, 01:57 PM

Quote:

Originally Posted by kovidgoyal

You need to provide an actual error message that occurs when you try to open the database. The one you provided is meaningless as it is caused by trying to use functions that are not available.

If you want to test the validity of the sqlite database use the official sqlite3 command line client from sqlite.org

sqlite3 metadata.db .dump > dump.sql

You will see that the sqlite database is converted into SQL statements with no issues. calibre itself uses the official sqlite3 libraries.

This seemed to create a valid dump file, thank you.

So I'm still not sure why my Calibre2opds isn't working, but I guess this means my metadata is okay after all?

chaley · 01-15-2012, 02:11 PM

Quote:

Originally Posted by anamardoll

Chaley, thank you -- I'll send you an email now. (It looks like backing up the metadata didn't clear up the problem.)

And, of course, you're right -- there's all kinds of Windows (I'm running Win 7) issues I'm probably unaware of. Thank you -- I know it's hard to diagnose problems over the internet.

As I said in a reply to your email, I have no problem opening that DB with either calibre or SQLiteSpy. Looks like you need to work more with the calibre2opds people. Sorry I can't help more.

anamardoll · 01-15-2012, 02:16 PM

Quote:

Originally Posted by chaley

As I said in a reply to your email, I have no problem opening that DB with either calibre or SQLiteSpy. Looks like you need to work more with the calibre2opds people. Sorry I can't help more.

Well, I'm relieved to hear that my database isn't corrupted, thank you!

I'll keep working with Dave on Calibre2opds and hope that he can pinpoint why the tool and my database folder aren't working and playing nicely.

DoctorOhh · 01-15-2012, 10:23 PM

Moderator Notice
Moved thread to the Catalogs sub-forum with other calibre2opds issues.

botmtl · 02-12-2018, 12:09 AM

Quote:

Originally Posted by kovidgoyal

calibre itself uses the official sqlite3 libraries.

** EDITED: THIS IS WRONG, SEE BELOW. **

sorry to dredge up this old thread but I found it while trying to debug and spent an extra couple hours hacking away before I realised that that statement may have been true back in the day but now calibre does indeed use it's own custom built sqlite driver.

As to why sqllite's own sort and concat methods were not good enough, I have no idea. Also clueless why it prevents a lot of tools from reading calibre's database, but it does.

BetterRed · 02-12-2018, 12:33 AM

Quote:

Originally Posted by botmtl

Also clueless why it prevents a lot of tools from reading calibre's database, but it does.

Are you able to state which tools and which features.

I use both "DB Browser for SQLite" and "SQLite Expert" quite frequently (at least monthly) without any issues. I've also used other tools, whose names escape me, from time to time, don't recall any of them failing to read the db.

BR

kovidgoyal · 02-12-2018, 12:54 AM

No, calibre still uses the official sqlite3 libraries. Sorting in calibre is not done via sqlite, because sorting in calibre is far more sophisticated than what sqlite is capable of.

itimpi · 02-12-2018, 02:28 AM

Also, since the original posts mentioned Calibre2opds i thought it was worth mentioning that Calibre2opds has no problems accessing the Calibre metadata.db file either.

botmtl · 02-12-2018, 01:42 PM

Quote:

Originally Posted by kovidgoyal

No, calibre still uses the official sqlite3 libraries. Sorting in calibre is not done via sqlite, because sorting in calibre is far more sophisticated than what sqlite is capable of.

Oh! Sorry, seems like a series of wrong assumptions. Now i'm double-sorry about reviving this. What's the sortconcat function then? I really thought I had found proof of said assumptions when I found calibre/src/calibre/library/sqlite_custom.c. Some database readers, like SqlCeToolbox complain about this function being undefined when reading the database.

kovidgoyal · 02-12-2018, 09:33 PM

It is a function that calibre used to use a long time ago (pre 1.0 I think), it's still around for forwards compat (so that new databases can still be opened with older versions of calibre). calibre tries hard to keep the database both forwards and backwards compatible, as much as possible. backwards compatibility (opening old databases with new versions of calibre) is absolute and forwards compatibility is best-effort.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Metadata and Calibre2Opds	evanbernstein	Library Management	4	01-09-2012 10:23 AM
Delete 1 books format of open file gives DB errors ?	pchrist7	Library Management	3	12-09-2011 01:03 PM
Where is the .exe file in the zip Calibre2opds file?	chilady1	Related Tools	4	09-17-2011 12:56 PM
So I have this PDB file... Calibre can't open or convert it.	HelenaJole	Calibre	4	01-01-2011 09:20 PM
calibre2opds won't open	jhempel24	Calibre	5	11-06-2010 05:58 AM

01-15-2012, 01:44 PM	#16
anamardoll Chasing Butterflies Posts: 3,132 Karma: 5074169 Join Date: Mar 2011 Location: American Southwest Device: Uses batteries.	Chaley, thank you -- I'll send you an email now. (It looks like backing up the metadata didn't clear up the problem.) And, of course, you're right -- there's all kinds of Windows (I'm running Win 7) issues I'm probably unaware of. Thank you -- I know it's hard to diagnose problems over the internet.

01-15-2012, 10:23 PM	#20
DoctorOhh US Navy, Retired Posts: 9,879 Karma: 13806776 Join Date: Feb 2009 Location: North Carolina Device: Icarus Illumina XL HD, Kindle PaperWhite SE 11th Gen	Moderator Notice Moved thread to the Catalogs sub-forum with other calibre2opds issues.

02-12-2018, 12:54 AM	#23
kovidgoyal creator of calibre Posts: 44,808 Karma: 25490602 Join Date: Oct 2006 Location: Mumbai, India Device: Various	No, calibre still uses the official sqlite3 libraries. Sorting in calibre is not done via sqlite, because sorting in calibre is far more sophisticated than what sqlite is capable of.

02-12-2018, 02:28 AM	#24
itimpi Wizard Posts: 4,553 Karma: 950151 Join Date: Nov 2008 Device: Sony PRS-950, iphone/ipad (Marvin/iBooks/QuickReader)	Also, since the original posts mentioned Calibre2opds i thought it was worth mentioning that Calibre2opds has no problems accessing the Calibre metadata.db file either.

02-12-2018, 09:33 PM	#26
kovidgoyal creator of calibre Posts: 44,808 Karma: 25490602 Join Date: Oct 2006 Location: Mumbai, India Device: Various	It is a function that calibre used to use a long time ago (pre 1.0 I think), it's still around for forwards compat (so that new databases can still be opened with older versions of calibre). calibre tries hard to keep the database both forwards and backwards compatible, as much as possible. backwards compatibility (opening old databases with new versions of calibre) is absolute and forwards compatibility is best-effort.

Advert

Advert