calibre2opds fatal error

[Bookies_favorite]

Hi, I've been using calibre2opds 3.6 (rev 424) for several years without problem on win10... but now - I've started getting "unexpected fatal error during catalog generation" error.

The error comes early in the generate catalog option (immediated it starts on the "Loading and filtering database" phase).

Annoyingly option "tools->view the current log" shows nothing... And if I manually search windows there seems to be no new logs generated... as though calibre2opds fails too early in the process to log anything??

I'm running calibre 9.7... to which I have updated recently
but calibre works fine and a calibre check of the library database shows no errors.

Any ideas to fix this?
thanks

[PeterT]

I think this might be related to calibre v9 changing the calibre database to remove the isbn column. Browsing the GitHub source code definitely shows the isbn column bring retrieved

[Bookies_favorite]

Originally Posted by PeterT

I think this might be related to calibre v9 changing the calibre database to remove the isbn column. Browsing the GitHub source code definitely shows the isbn column bring retrieved

Ah yes... I thought it might be down to some change to the metadata.db file...

do you know if calibre2opds is still maintained at all?
or how best to change the metadata.db file to become compatabile again?

thanks

[PeterT]

At one point for some experiments I used the following script

#!/usr/bin/env bash

sqlite3 /mnt/chromeos/GoogleDrive/MyDrive/DR/Books/metadata.db \
"alter table books add column isbn text" \
"alter table books add column lccn text"

This is of course unsupported. It will survive updates to calibre.

[PeterT]

Looking at GitHub I'd say it's a dead project. Repository is https://github.com/calibre2opds/calibre2opds

[Bookies_favorite]

Originally Posted by PeterT

At one point for some experiments I used the following script

#!/usr/bin/env bash

sqlite3 /mnt/chromeos/GoogleDrive/MyDrive/DR/Books/metadata.db \
"alter table books add column isbn text" \
"alter table books add column lccn text"

This is of course unsupported. It will survive updates to calibre.

Brilliant, adding those 2 columns to the books table in calibre's metadata.db database has got calibre2opds working again!

btw: I used the opensource db4s tool to successfully open and alter the database in windows.

thanks again