MobileRead Forums - View Single Post

echoui · 03-06-2021, 10:41 AM

Hi Dalton,

Hope my question hasn't been posted before, I haven't found any reference to this issue. I just installed your LC plugin, thanks for your work! I'm looking to use it to derive DDC codes from ISBN, and then map them to genres in another custom column. I followed the instructions from the tooltip and created a custom #ddc column as text (not tag-like) and enabled the ddc option in the plugin settings. I then tried to derive ddc from ISBN for single books, trying a few to make sure the problem wasn't with a particular ISBN. I always get the following error:

calibre, version 5.12.0
ERREUR : Exception non gérée: <b>SQLError</b>:SQLError: no such table: custom_columns

calibre 5.12 [64bit] embedded-python: True is64bit: True
Windows-10-10.0.19041 Windows ('64bit', 'WindowsPE')
('Windows', '10', '10.0.19041')
Python 3.8.5
Windows: ('10', '10.0.19041', '', 'Multiprocessor Free')
Interface language: fr
Successfully initialized third party plugins: Gather KFX-ZIP (from KFX Input) (1, 36, 0) && Package KFX (from KFX Input) (1, 36, 0) && Clean Comments (0, 1, 0) && Clean Metadata (0, 0, 6) && Count Pages (1, 11, 0) && EpubSplit (3, 0, 0) && Extract ISBN (1, 5, 0) && Find Duplicates (1, 8, 5) && Goodreads (1, 5, 1) && Goodreads_Rating (3, 1, 0) && Import List (1, 5, 4) && KFX metadata reader (from KFX Input) (1, 36, 0) && KFX Input (1, 36, 0) && Kobo Utilities (2, 12, 3) && Library Codes (1, 0, 50) && Quality Check (1, 11, 0) && Reading List (1, 7, 1)
Traceback (most recent call last):
File "calibre_plugins.library_codes.ui", line 305, in derive_from_isbn_issn
File "calibre_plugins.library_codes.ui", line 398, in derive_all_library_codes_control
File "calibre_plugins.library_codes.ui", line 444, in populate_ddc_lcc_oclc_using_classify_api
File "calibre_plugins.library_codes.ui", line 921, in get_isbn_identifiers_for_selected_books
apsw.SQLError: SQLError: no such table: custom_columns

Any idea what I'm doing wrong or of things I could try to fix this issue? I have other custom columns in my library and they are working fine. Why would the associated table not be found? Do you think it's an access problem? I have a CALIBRE_OVERRIDE_DATABASE_PATH environment variable configured so that my actual books are on a different disk than my metadata.db. Is this the culprit?

03-06-2021, 10:41 AM	#262
echoui Junior Member Posts: 1 Karma: 10 Join Date: Mar 2021 Device: Kobo Libra	SQLError: no such table:custom_columns Hi Dalton, Hope my question hasn't been posted before, I haven't found any reference to this issue. I just installed your LC plugin, thanks for your work! I'm looking to use it to derive DDC codes from ISBN, and then map them to genres in another custom column. I followed the instructions from the tooltip and created a custom #ddc column as text (not tag-like) and enabled the ddc option in the plugin settings. I then tried to derive ddc from ISBN for single books, trying a few to make sure the problem wasn't with a particular ISBN. I always get the following error: calibre, version 5.12.0 ERREUR : Exception non gérée: <b>SQLError</b>:SQLError: no such table: custom_columns calibre 5.12 [64bit] embedded-python: True is64bit: True Windows-10-10.0.19041 Windows ('64bit', 'WindowsPE') ('Windows', '10', '10.0.19041') Python 3.8.5 Windows: ('10', '10.0.19041', '', 'Multiprocessor Free') Interface language: fr Successfully initialized third party plugins: Gather KFX-ZIP (from KFX Input) (1, 36, 0) && Package KFX (from KFX Input) (1, 36, 0) && Clean Comments (0, 1, 0) && Clean Metadata (0, 0, 6) && Count Pages (1, 11, 0) && EpubSplit (3, 0, 0) && Extract ISBN (1, 5, 0) && Find Duplicates (1, 8, 5) && Goodreads (1, 5, 1) && Goodreads_Rating (3, 1, 0) && Import List (1, 5, 4) && KFX metadata reader (from KFX Input) (1, 36, 0) && KFX Input (1, 36, 0) && Kobo Utilities (2, 12, 3) && Library Codes (1, 0, 50) && Quality Check (1, 11, 0) && Reading List (1, 7, 1) Traceback (most recent call last): File "calibre_plugins.library_codes.ui", line 305, in derive_from_isbn_issn File "calibre_plugins.library_codes.ui", line 398, in derive_all_library_codes_control File "calibre_plugins.library_codes.ui", line 444, in populate_ddc_lcc_oclc_using_classify_api File "calibre_plugins.library_codes.ui", line 921, in get_isbn_identifiers_for_selected_books apsw.SQLError: SQLError: no such table: custom_columns Any idea what I'm doing wrong or of things I could try to fix this issue? I have other custom columns in my library and they are working fine. Why would the associated table not be found? Do you think it's an access problem? I have a CALIBRE_OVERRIDE_DATABASE_PATH environment variable configured so that my actual books are on a different disk than my metadata.db. Is this the culprit?