I would've thought other linux/any case sensitive os users would have the same issue???
Anyways, so far so good on the get custom columns button, NO error popups and the log says all good in attach, so it seems to be working
All of the test libraries show up, with their custom columns.
Here's the log, in case I missed something:
susan@localhost:~> calibre-debug --gui
calibre 6.11 embedded-python: False
Linux-6.1.8-1-default-x86_64-with-glibc2.36 Linux ('64bit', 'ELF')
('Linux', '6.1.8-1-default', '#1 SMP PREEMPT_DYNAMIC Tue Jan 24 06:29:25 UTC 2023 (baebfe0)')
Python 3.10.9
Interface language: None
Successfully initialized third party plugins: Consolidate All Library Metadata (2, 0, 45) && Job Spy (1, 0, 202) && MultiColumnSearch (1, 0, 96) && View Manager (1, 10, 2)
QPA platform: xcb
devicePixelRatio: 1.0
logicalDpi: 96.0 x 96.0
physicalDpi: 102.23899371069182 x 102.35820895522387
ApplicationPaletteChange event ignored
Using calibre Qt style: True
[0.00] Starting up...
[0.00] Showing splash screen...
[0.03] splash screen shown
[0.03] Initializing db...
[0.04] db initialized
[0.04] Constructing main UI...
Screens currently in system:
{'depth': 24,
'device_pixel_ratio': 1.0,
'geometry_in_logical_pixels': {'height': 1080, 'width': 1920, 'x': 0, 'y': 0},
'index_in_screens_list': 0,
'manufacturer': 'ViewSonic Corporation',
'model': 'VX2250 SERIES',
'name': 'DVI-I-1',
'serial': 'RWS102406078-',
'size_in_logical_pixels': {'height': 1080, 'width': 1920},
'virtual_geometry': {'height': 1080, 'width': 1920, 'x': 0, 'y': 0}}
Restoring geometry for: calibre_main_window_geometry
{'frame_geometry': {'height': 1036, 'width': 1920, 'x': 0, 'y': 0},
'full_screened': False,
'geometry': {'height': 1005, 'width': 1920, 'x': 0, 'y': 31},
'maximized': True,
'normal_geometry': {'height': 1005, 'width': 1920, 'x': 0, 'y': 31},
'screen': {'depth': 24,
'device_pixel_ratio': 1.0,
'geometry_in_logical_pixels': {'height': 1080,
'width': 1920,
'x': 0,
'y': 0},
'index_in_screens_list': 0,
'manufacturer': 'ViewSonic Corporation',
'model': 'VX2250 SERIES',
'name': 'DVI-I-1',
'serial': 'RWS102406078-',
'size_in_logical_pixels': {'height': 1080, 'width': 1920},
'virtual_geometry': {'height': 1080,
'width': 1920,
'x': 0,
'y': 0}}}
Matching screen: {'depth': 24,
'device_pixel_ratio': 1.0,
'geometry_in_logical_pixels': {'height': 1080, 'width': 1920, 'x': 0, 'y': 0},
'index_in_screens_list': 0,
'manufacturer': 'ViewSonic Corporation',
'model': 'VX2250 SERIES',
'name': 'DVI-I-1',
'serial': 'RWS102406078-',
'size_in_logical_pixels': {'height': 1080, 'width': 1920},
'virtual_geometry': {'height': 1080, 'width': 1920, 'x': 0, 'y': 0}}
Setting widget geometry to: {'height': 1005, 'width': 1920, 'x': 0, 'y': 31}
Restoring widget to maximized
CALM: initialization_complete............
Job Spy has begun initialization...
Calibre, and hence Job Spy, was gracefully shut down last time? True
Last time daemon started: never
Last time daemon failed: never
Total daemon starts inception_to_date: 0
Total daemon failures inception-to-date: 0
qt.gui.imageio: libpng warning: iCCP: known incorrect sRGB profile
JS: ===>>> change_gui_alternating_row_colors()
Job Spy has finished initialization...
[0] un-optimized number of undesirable characters accumulated: 756
[1] optimized number of undesirable characters accumulated: 596
MCS has finished initialization...
[1.60] main UI initialized...
[1.60] Hiding splash screen
Starting QuickView
[1.75] splash screen hidden
[1.75] Started up in 1.75 seconds with 467 books
CALM_DB_VERSION_METADATA_DB 2
CALM_DB_VERSION_METADATA_TOOLS_DB 2
CALM_DB_VERSION_UPGRADE_FORCE_UPGRADE False
CALM_DB_VERSION_UPGRADE_SUPPRESS_INFO_DIALOGS False
CALM_FORCE_RECONSOLIDATION False
CALM_LAST_CONSOLIDATION_JOB_DATETIME ...NEVER...
CALM_LAST_CONSOLIDATION_NUMBER_BOOKS 0
CALM_LAST_CONSOLIDATION_NUMBER_LIBRARIES 0
CALM_LAST_CONSOLIDATION_TARGET_DB_FULL_PATH ZZ:
CALM_MCS_INDEX_CONSOLIDATION False
CALM_TARGET_DB_FULL_PATH /home/susan/Calibre/CALM/metadata.db
CALM_TARGET_DB_GENERATING_NONCALM_LIBRARY_PATH ZZ:||>>>||ZZ:
CALM_TARGET_DB_LAST_CHOSEN_LIBRARY_DIRECTORY ZZ:
CALM_TARGET_DB_MUST_BE_REFRESHED False
CALM_TARGET_PARENT_DIRECTORY /home/susan/Calibre
CALM_USER_STATUS USER
Number of keys in self.mysourceprefs in 'load_source_prefs_init' : 128
Number of keys in self.mysourceprefs in 'load_source_prefs' : 128
my_db.library_path: /home/susan/Calibre/LanguageandWriting
self.target_db: /home/susan/Calibre/CALM/metadata.db
filesystem_encoding is: utf-8
filesystem_encoding is: utf-8
Attaching to Tools DB: /home/susan/Calibre/CALM/metadata_tools.db
n_tools_size = os.path.getsize(tools_path): 2260992
Number of keys in self.myparentprefs in 'child_invocation_of_save_real_prefs_parent' : 128
LIBRARY_PATH_03 : /home/susan/Calibre/LanguageandWriting
LIBRARY_PATH_04 : /home/susan/Calibre/New Library
LIBRARY_PATH_05 : /home/susan/Calibre/NewBooksForCalibre
LIBRARY_PATH_06 : /home/susan/Calibre/Testlibrary
number_source_libraries: 4
n_last_to_show: 6
n_tools_size = os.path.getsize(tools_path): 2260992
filesystem_encoding is: utf-8
metadata_tools.db is good to go.
CALM_DB_VERSION_METADATA_DB 2
CALM_DB_VERSION_METADATA_TOOLS_DB 2
CALM_DB_VERSION_UPGRADE_FORCE_UPGRADE False
CALM_DB_VERSION_UPGRADE_SUPPRESS_INFO_DIALOGS False
CALM_FORCE_RECONSOLIDATION False
CALM_LAST_CONSOLIDATION_JOB_DATETIME ...NEVER...
CALM_LAST_CONSOLIDATION_NUMBER_BOOKS 0
CALM_LAST_CONSOLIDATION_NUMBER_LIBRARIES 0
CALM_LAST_CONSOLIDATION_TARGET_DB_FULL_PATH ZZ:
CALM_MCS_INDEX_CONSOLIDATION False
CALM_TARGET_DB_FULL_PATH /home/susan/Calibre/CALM/metadata.db
CALM_TARGET_DB_GENERATING_NONCALM_LIBRARY_PATH ZZ:||>>>||ZZ:
CALM_TARGET_DB_LAST_CHOSEN_LIBRARY_DIRECTORY ZZ:
CALM_TARGET_DB_MUST_BE_REFRESHED False
CALM_TARGET_PARENT_DIRECTORY /home/susan/Calibre
CALM_USER_STATUS USER
Number of keys in self.mysourceprefs in 'load_source_prefs_init' : 128
Number of keys in self.mysourceprefs in 'load_source_prefs' : 128
my_db.library_path: /home/susan/Calibre/LanguageandWriting
self.target_db: /home/susan/Calibre/CALM/metadata.db
Number of keys in self.mysourceprefs in 'save_source_preferences' : 128
Number of keys in self.myparentprefs in 'child_invocation_of_save_real_prefs_parent' : 128
Number of keys in self.mysourceprefs in 'optimize_source_prefs' [1] : 128
Saved: LIBRARY_PATH_03 /home/susan/Calibre/LanguageandWriting
tmp_was_checked_dict[k] = unicode_type("True") LIBRARY_PATH_03_IS_ACTIVE True
Saved: LIBRARY_PATH_04 /home/susan/Calibre/New Library
tmp_was_checked_dict[k] = unicode_type("True") LIBRARY_PATH_04_IS_ACTIVE True
Saved: LIBRARY_PATH_05 /home/susan/Calibre/NewBooksForCalibre
tmp_was_checked_dict[k] = unicode_type("True") LIBRARY_PATH_05_IS_ACTIVE True
Saved: LIBRARY_PATH_06 /home/susan/Calibre/Testlibrary
tmp_was_checked_dict[k] = unicode_type("True") LIBRARY_PATH_06_IS_ACTIVE True
path_checked_status_dict[v1] = v2 : /home/susan/Calibre/LanguageandWriting True
path_checked_status_dict[v1] = v2 : /home/susan/Calibre/New Library True
path_checked_status_dict[v1] = v2 : /home/susan/Calibre/NewBooksForCalibre True
path_checked_status_dict[v1] = v2 : /home/susan/Calibre/Testlibrary True
for row in tmp_sorted_list: !00
for row in tmp_sorted_list: !01
for row in tmp_sorted_list: !02
for row in tmp_sorted_list: /home/susan/Calibre/LanguageandWriting
for row in tmp_sorted_list: /home/susan/Calibre/New Library
for row in tmp_sorted_list: /home/susan/Calibre/NewBooksForCalibre
for row in tmp_sorted_list: /home/susan/Calibre/Testlibrary
Number of keys in self.mysourceprefs in 'optimize_source_prefs' [2] : 128
Number of keys in self.mysourceprefs in 'save_real_prefs_source': 128
Number of keys in self.mysourceprefs in 'load_source_prefs' : 128
Number of keys in self.mysourceprefs in 'save_source_preferences' : 128
Number of keys in self.myparentprefs in 'child_invocation_of_save_real_prefs_parent' : 128
Number of keys in self.myparentprefs in 'child_invocation_of_save_real_prefs_parent' : 128
... def autopopulate_source_library_custom_columns_table() ...
Number of keys in self.myparentprefs in 'child_invocation_of_save_real_prefs_parent' : 128
Number of keys in self.myparentprefs in 'save_real_prefs_parent' : 128
autopopulate: k, : /home/susan/Calibre/LanguageandWriting /home/susan/calibre/languageandwriting
autopopulate: k, : /home/susan/Calibre/New Library /home/susan/calibre/new library
autopopulate: k, : /home/susan/Calibre/NewBooksForCalibre /home/susan/calibre/newbooksforcalibre
autopopulate: k, : /home/susan/Calibre/Testlibrary /home/susan/calibre/testlibrary
filesystem_encoding is: utf-8
Original Case Library Name used for APSW Path: /home/susan/Calibre/Testlibrary
filesystem_encoding is: utf-8
ATTACH DATABASE '/home/susan/Calibre/Testlibrary/metadata.db' AS 'SOURCE' ;
length of path: 43
Attaching to New Source Library: /home/susan/Calibre/Testlibrary/metadata.db
Now Attached to New Source Library: /home/susan/Calibre/Testlibrary/metadata.db
PRAGMA SOURCE.busy_timeout = 4000;
Finished: apsw_attach_to_source
number of rows found in source.custom_columns: 26
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (1, 'audiocomment', 'AudioBook Comments', 'comments', 0, 1, '{}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (2, 'audiolistened', 'Listened', 'datetime', 0, 1, '{"description": "", "date_format": "yyyy"}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (3, 'audiopubplusyear', 'Audio Publisher & Year', 'text', 0, 1, '{"is_names": false}', 1, 1)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (4, 'collection_bundle', 'Collection/Bundle', 'text', 0, 1, '{"use_decorations": 0}', 0, 1)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (5, 'contents', 'Contents', 'comments', 0, 1, '{}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (6, 'genre', 'Genre', 'text', 0, 1, '{"is_names": false, "description": ""}', 1, 1)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (7, 'koboreadpct', 'Kobo Read Percentage', 'int', 0, 1, '{"number_format": null}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (8, 'koboreadpctsusan', 'Kobo Read percentage Susan', 'int', 0, 1, '{"number_format": null, "description": ""}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (9, 'lastread', 'Last Read', 'datetime', 0, 1, '{"description": "", "date_format": null}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (10, 'lastreadsusan', 'Last Read Susan', 'datetime', 0, 1, '{"date_format": null, "description": ""}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (11, 'links', 'links', 'comments', 0, 1, '{}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (12, 'myshelves', 'My Shelves', 'text', 0, 1, '{"is_names": false}', 1, 1)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (13, 'narrator', 'Narrator', 'text', 0, 1, '{"is_names": true}', 1, 1)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (14, 'owner', 'Owner', 'comments', 0, 1, '{}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (15, 'price', 'Price', 'float', 0, 1, '{"number_format": null}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (16, 'pseudonym', 'Pen Name', 'text', 0, 1, '{"is_names": true}', 1, 1)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (17, 'purchase_date', 'Bought', 'datetime', 0, 1, '{"date_format": "dd MMM yyyy"}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (18, 'ratingsusan', 'Rating Susan', 'rating', 0, 1, '{"description": ""}', 0, 1)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (19, 'readstatus', 'Reading Status', 'composite', 0, 1, '{"composite_template": "{#koboreadpct:\'cmp($, 100, cmp($, 0, \'\', \'\', \'Reading\'), \'Finished\', \'\')\'}", "contains_html": false, "make_category": true, "use_decorations": 0, "composite_sort": "text"}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (20, 'readstatussusan', 'Read Status Susan', 'composite', 0, 1, '{"composite_template": "{#koboreadpctsusan:\'cmp($, 100, cmp($, 0, \'\', \'\', \'Reading\'), \'Finished\', \'\')\'}", "composite_sort": "text", "contains_html": false, "use_decorations": 0, "make_category": true, "description": ""}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (21, 'series_separate', 'Series Separate', 'series', 0, 1, '{}', 0, 1)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (22, 'shelfname', 'Shelf Name', 'composite', 0, 1, '{"composite_template": "{:\'first_non_empty(field(\'#myshelves\'), field(\'Series\'), \'Uncategorized\')\'}", "composite_sort": "text", "contains_html": false, "make_category": false, "use_decorations": 0}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (23, 'storesitesource', 'Source', 'text', 0, 1, '{"is_names": false}', 1, 1)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (24, 'tbr', 'TBR', 'text', 0, 1, '{"use_decorations": 0}', 0, 1)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (25, 'type', 'Type', 'text', 0, 1, '{"is_names": false}', 1, 1)
row of SOURCE.custom_columns: /home/susan/calibre/testlibrary --- (26, 'unabridged', 'Unabridged', 'bool', 0, 1, '{}', 0, 0)
Previously Attached Source Library Detached: /home/susan/Calibre/Testlibrary
Original Case Library Name used for APSW Path: /home/susan/Calibre/New Library
filesystem_encoding is: utf-8
ATTACH DATABASE '/home/susan/Calibre/New Library/metadata.db' AS 'SOURCE' ;
length of path: 43
Attaching to New Source Library: /home/susan/Calibre/New Library/metadata.db
Now Attached to New Source Library: /home/susan/Calibre/New Library/metadata.db
PRAGMA SOURCE.busy_timeout = 4000;
Finished: apsw_attach_to_source
Previously Attached Source Library Detached: /home/susan/Calibre/New Library
Original Case Library Name used for APSW Path: /home/susan/Calibre/NewBooksForCalibre
filesystem_encoding is: utf-8
ATTACH DATABASE '/home/susan/Calibre/NewBooksForCalibre/metadata.db' AS 'SOURCE' ;
length of path: 50
Attaching to New Source Library: /home/susan/Calibre/NewBooksForCalibre/metadata.db
Now Attached to New Source Library: /home/susan/Calibre/NewBooksForCalibre/metadata.db
PRAGMA SOURCE.busy_timeout = 4000;
Finished: apsw_attach_to_source
number of rows found in source.custom_columns: 28
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (1, 'price', 'Price', 'float', 0, 1, '{"number_format": null}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (2, 'narrator', 'Narrator', 'text', 0, 1, '{"is_names": true}', 1, 1)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (3, 'ratingsusan', 'Rating Susan', 'rating', 0, 1, '{"description": ""}', 0, 1)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (4, 'shelfname', 'Shelf Name', 'composite', 0, 1, '{"use_decorations": 0, "composite_template": "{:\'first_non_empty(field(\'#myshelves\'), field(\'Series\'), \'Uncategorized\')\'}", "composite_sort": "text", "contains_html": false, "make_category": false}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (5, 'tbr', 'TBR', 'text', 0, 1, '{"use_decorations": 0}', 0, 1)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (6, 'readstatus', 'Reading Status', 'composite', 0, 1, '{"use_decorations": 0, "composite_template": "{#koboreadpct:\'cmp($, 100, cmp($, 0, \'\', \'\', \'Reading\'), \'Finished\', \'\')\'}", "composite_sort": "text", "contains_html": false, "make_category": true}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (7, 'collection_bundle', 'Collection/Bundle', 'text', 0, 1, '{"use_decorations": 0}', 0, 1)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (8, 'koboreadpctsusan', 'Kobo Read percentage Susan', 'int', 0, 1, '{"number_format": null, "description": ""}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (9, 'audiopubplusyear', 'Audio Publisher & Year', 'text', 0, 1, '{"is_names": false}', 1, 1)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (10, 'audiocomment', 'AudioBook Comments', 'comments', 0, 1, '{}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (11, 'genre', 'Genre', 'text', 0, 1, '{"is_names": false, "description": ""}', 1, 1)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (12, 'lastreadsusan', 'Last Read Susan', 'datetime', 0, 1, '{"date_format": null, "description": ""}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (13, 'owner', 'Owner', 'comments', 0, 1, '{}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (14, 'series_separate', 'Series Separate', 'series', 0, 1, '{}', 0, 1)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (15, 'links', 'links', 'comments', 0, 1, '{}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (16, 'type', 'Type', 'text', 0, 1, '{"is_names": false}', 1, 1)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (17, 'koboreadpct', 'Kobo Read Percentage', 'int', 0, 1, '{"number_format": null}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (18, 'lastread', 'Last Read', 'datetime', 0, 1, '{"date_format": null, "description": ""}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (19, 'unabridged', 'Unabridged', 'bool', 0, 1, '{}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (20, 'audiolistened', 'Listened', 'datetime', 0, 1, '{"date_format": "yyyy", "description": ""}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (21, 'pseudonym', 'Pen Name', 'text', 0, 1, '{"is_names": true}', 1, 1)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (22, 'purchase_date', 'Bought', 'datetime', 0, 1, '{"date_format": "dd MMM yyyy"}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (23, 'readstatussusan', 'Read Status Susan', 'composite', 0, 1, '{"composite_template": "{#koboreadpctsusan:\'cmp($, 100, cmp($, 0, \'\', \'\', \'Reading\'), \'Finished\', \'\')\'}", "composite_sort": "text", "contains_html": false, "description": "", "use_decorations": 0, "make_category": true}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (24, 'storesitesource', 'Source', 'text', 0, 1, '{"is_names": false}', 1, 1)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (25, 'contents', 'Contents', 'comments', 0, 1, '{}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (26, 'myshelves', 'My Shelves', 'text', 0, 1, '{"is_names": false}', 1, 1)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (27, 'orig_backed_up', 'Originals Backed Up', 'bool', 0, 1, '{}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/newbooksforcalibre --- (28, 'printyear', 'Print Publisher & Year', 'text', 0, 1, '{"is_names": false}', 1, 1)
Previously Attached Source Library Detached: /home/susan/Calibre/NewBooksForCalibre
Original Case Library Name used for APSW Path: /home/susan/Calibre/LanguageandWriting
filesystem_encoding is: utf-8
ATTACH DATABASE '/home/susan/Calibre/LanguageandWriting/metadata.db' AS 'SOURCE' ;
length of path: 50
Attaching to New Source Library: /home/susan/Calibre/LanguageandWriting/metadata.db
Now Attached to New Source Library: /home/susan/Calibre/LanguageandWriting/metadata.db
PRAGMA SOURCE.busy_timeout = 4000;
Finished: apsw_attach_to_source
number of rows found in source.custom_columns: 26
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (1, 'audiolistened', 'Listened', 'datetime', 0, 1, '{"description": "", "date_format": "yyyy"}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (2, 'ratingsusan', 'Rating Susan', 'rating', 0, 1, '{"description": ""}', 0, 1)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (3, 'narrator', 'Narrator', 'text', 0, 1, '{"is_names": true}', 1, 1)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (4, 'koboreadpct', 'Kobo Read Percentage', 'int', 0, 1, '{"number_format": null}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (5, 'type', 'Type', 'text', 0, 1, '{"is_names": false}', 1, 1)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (6, 'genre', 'Genre', 'text', 0, 1, '{"description": "", "is_names": false}', 1, 1)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (7, 'lastread', 'Last Read', 'datetime', 0, 1, '{"description": "", "date_format": null}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (8, 'purchase_date', 'Bought', 'datetime', 0, 1, '{"date_format": "dd MMM yyyy"}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (9, 'series_separate', 'Series Separate', 'series', 0, 1, '{}', 0, 1)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (10, 'lastreadsusan', 'Last Read Susan', 'datetime', 0, 1, '{"description": "", "date_format": null}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (11, 'links', 'links', 'comments', 0, 1, '{}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (12, 'pseudonym', 'Pen Name', 'text', 0, 1, '{"is_names": true}', 1, 1)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (13, 'contents', 'Contents', 'comments', 0, 1, '{}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (14, 'readstatus', 'Reading Status', 'composite', 0, 1, '{"make_category": true, "composite_template": "{#koboreadpct:\'cmp($, 100, cmp($, 0, \'\', \'\', \'Reading\'), \'Finished\', \'\')\'}", "use_decorations": 0, "contains_html": false, "composite_sort": "text"}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (15, 'price', 'Price', 'float', 0, 1, '{"number_format": null}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (16, 'audiocomment', 'AudioBook Comments', 'comments', 0, 1, '{}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (17, 'koboreadpctsusan', 'Kobo Read percentage Susan', 'int', 0, 1, '{"description": "", "number_format": null}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (18, 'myshelves', 'My Shelves', 'text', 0, 1, '{"is_names": false}', 1, 1)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (19, 'unabridged', 'Unabridged', 'bool', 0, 1, '{}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (20, 'readstatussusan', 'Read Status Susan', 'composite', 0, 1, '{"make_category": true, "description": "", "composite_template": "{#koboreadpctsusan:\'cmp($, 100, cmp($, 0, \'\', \'\', \'Reading\'), \'Finished\', \'\')\'}", "use_decorations": 0, "contains_html": false, "composite_sort": "text"}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (21, 'collection_bundle', 'Collection/Bundle', 'text', 0, 1, '{"use_decorations": 0}', 0, 1)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (22, 'shelfname', 'Shelf Name', 'composite', 0, 1, '{"make_category": false, "composite_template": "{:\'first_non_empty(field(\'#myshelves\'), field(\'Series\'), \'Uncategorized\')\'}", "use_decorations": 0, "contains_html": false, "composite_sort": "text"}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (23, 'audiopubplusyear', 'Audio Publisher & Year', 'text', 0, 1, '{"is_names": false}', 1, 1)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (24, 'owner', 'Owner', 'comments', 0, 1, '{}', 0, 0)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (25, 'storesitesource', 'Source', 'text', 0, 1, '{"is_names": false}', 1, 1)
row of SOURCE.custom_columns: /home/susan/calibre/languageandwriting --- (26, 'tbr', 'TBR', 'text', 0, 1, '{"use_decorations": 0}', 0, 1)
Previously Attached Source Library Detached: /home/susan/Calibre/LanguageandWriting
filesystem_encoding is: utf-8
source library path added to set: /home/susan/Calibre/LanguageandWriting
source library path added to set: /home/susan/Calibre/New Library
source library path added to set: /home/susan/Calibre/NewBooksForCalibre
source library path added to set: /home/susan/Calibre/Testlibrary
adding source to table _source_libraries: /home/susan/Calibre/New Library
adding source to table _source_libraries: /home/susan/Calibre/LanguageandWriting
adding source to table _source_libraries: /home/susan/Calibre/NewBooksForCalibre
adding source to table _source_libraries: /home/susan/Calibre/Testlibrary
number_source_libraries_0: 4
number_source_libraries = unicode_type(col): 3
number_source_libraries = unicode_type(col): 3
Clicked all the other buttons, get, list and all the mass activate/deactivate seem ok, but got an error on Selectively activate: It doesn't like "float"
calibre, version 6.11.0
ERROR: Unhandled exception: <b>TypeError</b>:setColumnWidth(self, column: int, width: int): argument 2 has unexpected type 'float'
calibre 6.11 embedded-python: False
Linux-6.1.8-1-default-x86_64-with-glibc2.36 Linux ('64bit', 'ELF')
('Linux', '6.1.8-1-default', '#1 SMP PREEMPT_DYNAMIC Tue Jan 24 06:29:25 UTC 2023 (baebfe0)')
Python 3.10.9
Interface language: None
Successfully initialized third party plugins: Consolidate All Library Metadata (2, 0, 45) && Job Spy (1, 0, 202) && MultiColumnSearch (1, 0, 96) && View Manager (1, 10, 2)
Traceback (most recent call last):
File "calibre_plugins.consolidate_all_library_metadata. cc_activation_list_editor", line 210, in resizeEvent
self.table.setColumnWidth(c, w)
TypeError: setColumnWidth(self, column: int, width: int): argument 2 has unexpected type 'float'