[GUI Plugin] Pocketbook Collections

[Capricorn]

I use an older pocketbook touch hd (version U631.5.20.1527) with an sd-card. I would like to transfer data like the % read, the position where I am at in a book, ..etc to Calibre (v7.25 on windows 11 pro with the latest updates). I have created the custom plugins in Calibre, I then installed the plugin (latest version).
On the Pocketbook I created a test collection with two books. All my books are on the sd-card.
When I execute any action in the plugin, I get the message "Unknown Errror".
I ejected the pocketbook in Calibre. Shutdown Calibre, restarted it, and reconnected the pocketbook, but I still get "Unknown error".
What can I do to solve this?

[Reaty]

Can you send me the logs?

[Reaty]

Originally Posted by Readirect

I have a lot of outdated genre entries: they no longer exist in the column I've designated for PBC but they still appear in the listings. I've tried changing columns and removing/reinstalling PBC; all without joy.

How can I get rid of those old entries?

Sorry, but my plugin does not have anything to do with genres, it only affects custom collections. The genres are saved inside the book file itself, as far as I know. You may try to reupload the books to your device.

Or if you actually mean collections, the plugin will not delete existing collections from the device, it can only remove books from them, but deleting collections themselves must be done manually from the device. It is on purpose, because one can want to have a collection that is not synced.

[Reaty]

Originally Posted by reuerendo

Is it possible to make this plugin work on wireless connection like KOreader sync calibre plugin?

I am not exactly sure if I can make it work, but I'll try to look into this.

[Quoth]

Can this work over OPDS with a Pocketbook app on Android? Or connecting via USB MTP to Android?

[Reaty]

No, this plugin is only for Pocketbook devices. I don't know how to get access to the database on Android app, or if it even uses the same type of database at all. It seems to work very differently in general.

[Quoth]

Originally Posted by Reaty

No, this plugin is only for Pocketbook devices. I don't know how to get access to the database on Android app, or if it even uses the same type of database at all. It seems to work very differently in general.

Thanks, I suspected that.

[YumiYumi]

Hello,
I'm having the same problem as others with "Unknown error," even though it worked before. I ran some tests and the collection was on the e-reader. Now I still get this message.

Sending collections to Pocketbook
Traceback (most recent call last):
File "runpy.py", line 198, in _run_module_as_main
File "runpy.py", line 88, in _run_code
File "site.py", line 83, in <module>
File "site.py", line 78, in main
File "site.py", line 50, in run_entry_point
File "calibre\utils\ipc\worker.py", line 215, in main
File "calibre\utils\ipc\worker.py", line 130, in arbitrary
File "calibre_plugins.pocketbook_collections.main", line 242, in sync_metadata
File "calibre_plugins.pocketbook_collections.main", line 336, in send_collections
sqlite3.OperationalError: near "Attaque": syntax error

[YumiYumi]

@Reaty ?

Do you have any idea about what's wrong on this ? Thx.

[Reaty]

I'm not sure yet. It may be something related to unconventional symbols in book names.
I will try to fix it when I can.

[mooserita]

FYI I was also getting an unknown error about missing an sd card every time I tried to sync collections over to my Pocketbook Era after the very first time I tried it, but uninstalling the plugin from Calibre and installing the test version you linked on page 2 of this forum fixed the issue. You might want to consider updating the version available in Calibre with that version, if it doesn't have a workaround that would break other devices?

I'm also very curious as to how the Kobo plugin does manage to sync collections to a custom column synced to the device when first adding books to the device, whereas I did have to sync the books, eject it and let it load locally on the device, and then plug it in again and use the plugin to send the collections/other custom metadata to the device. I might poke around the github when I have time and see if I can figure out how it's doing that.

[zrkrlc]

BTW, I learned this the hard way. But try not to put quotes (') and other special symbols in your Collections since the SQL expression isn't sanitised. I think semicolons (;) would also wreak havoc on your database, though empirically using colons (:), underscores (_), and spaces ( ) have turned out fine for me.

I was getting the same Unknown Error as everyone until I removed the offending character from one of my (as of this writing) 57 Collections lol

[AndreasS]

I do get an 'Unknown Error' while trying to get the read status from my PocketBook Touch HD

PB-COLLECTIONS: Start syncing metadata
Worker Launch took: 0.00 seconds
Job: 3 Loading read statuses from Pocketbook finished
Loading read statuses from Pocketbook
Traceback (most recent call last):
File "runpy.py", line 198, in _run_module_as_main
File "runpy.py", line 88, in _run_code
File "site.py", line 83, in <module>
File "site.py", line 78, in main
File "site.py", line 50, in run_entry_point
File "calibre\utils\ipc\worker.py", line 213, in main
File "calibre\utils\ipc\worker.py", line 130, in arbitrary
File "calibre_plugins.pocketbook_collections.main", line 95, in sync_metadata
sqlite3.OperationalError: no such table: books_fast_hashes
No card in the device

Any ideas?

[AndreasS]

Sorry, forgot to add the debug log

[mooserita]

Originally Posted by zrkrlc

BTW, I learned this the hard way. But try not to put quotes (') and other special symbols in your Collections since the SQL expression isn't sanitised. I think semicolons ( would also wreak havoc on your database, though empirically using colons (, underscores (_), and spaces ( ) have turned out fine for me.

I was getting the same Unknown Error as everyone until I removed the offending character from one of my (as of this writing) 57 Collections lol

Oh interesting, I do have either a forward- or backslash in several of my collection names, maybe they're causing me issues too. I'll have to try that and see if it stops my issues too...