[GUI Plugin] Multi-Column Search

[dunhill]

DaltonST I am using the plugin on linux mint and it won't let me reload saved configurations. Is it a linux problem?
How can I show the problem?

[DaltonST]

Run in debug mode from the command line, then post the log.

It could be Linux permissions for full file operations for MCS/Calibre. Settings for MCS are saved in the calibre/... /plugins directory where the MCS .zip lives.

[dunhill]

Originally Posted by DaltonST

Run in debug mode from the command line, then post the log.

It could be Linux permissions for full file operations for MCS/Calibre. Settings for MCS are saved in the calibre/... /plugins directory where the MCS .zip lives.

Spoiler:

Using calibre Qt style: True
Traceback (most recent call last):
File "calibre/gui2/ui.py", line 137, in __init__
File "calibre/gui2/ui.py", line 155, in init_iaction
File "calibre/customize/__init__.py", line 612, in load_actual_plugin
File "importlib/__init__.py", line 126, in import_module
File "<frozen importlib._bootstrap>", line 1050, in _gcd_import
File "<frozen importlib._bootstrap>", line 1027, in _find_and_load
File "<frozen importlib._bootstrap>", line 1006, in _find_and_load_unlocked
File "<frozen importlib._bootstrap>", line 688, in _load_unlocked
File "calibre/customize/zipplugin.py", line 206, in exec_module
File "calibre_plugins.wikipage_ebook.ui", line 18, in <module>
from calibre_plugins.wikipage_ebook.main import DemoDialog
File "<frozen importlib._bootstrap>", line 1027, in _find_and_load
File "<frozen importlib._bootstrap>", line 1006, in _find_and_load_unlocked
File "<frozen importlib._bootstrap>", line 688, in _load_unlocked
File "calibre/customize/zipplugin.py", line 199, in exec_module
File "calibre/customize/zipplugin.py", line 195, in get_code
File "calibre_plugins.wikipage_ebook.main", line 312
_(' completes the book will be added to your calibre library.')
^
SyntaxError: invalid syntax
qt.gui.imageio: libpng warning: iCCP: known incorrect sRGB profile
qt.gui.imageio: libpng warning: iCCP: known incorrect sRGB profile
qt.gui.imageio: libpng warning: iCCP: known incorrect sRGB profile
qt.gui.imageio: libpng warning: iCCP: known incorrect sRGB profile
qt.gui.imageio: libpng warning: iCCP: known incorrect sRGB profile
qt.gui.imageio: libpng warning: iCCP: known incorrect sRGB profile
qt.gui.imageio: libpng warning: iCCP: known incorrect sRGB profile
qt.gui.imageio: libpng warning: iCCP: known incorrect sRGB profile
qt.gui.imageio: libpng warning: iCCP: known incorrect sRGB profile
qt.gui.imageio: libpng warning: iCCP: known incorrect sRGB profile
qt.gui.imageio: libpng warning: iCCP: known incorrect sRGB profile
qt.gui.imageio: libpng warning: iCCP: known incorrect sRGB profile
qt.gui.imageio: libpng warning: iCCP: cHRM chunk does not match sRGB
qt.gui.imageio: libpng warning: iCCP: known incorrect sRGB profile
qt.svg: Cannot open file '/home/walter/.config/calibre/resources/images/WordDumb/starfish.svg', because: No such file or directory
qt.svg: Cannot open file '/home/walter/.config/calibre/resources/images/WordDumb/starfish.svg', because: No such file or directory
calibre Registro de depuración
calibre 6.8 embedded-python: True
Linux-5.4.0-131-generic-x86_64-with-glibc2.31 Linux ('64bit', 'ELF')
('Linux', '5.4.0-131-generic', '#147-Ubuntu SMP Fri Oct 14 17:07:22 UTC 2022')
Python 3.10.1
Interface language: es
Successfully initialized third party plugins: DeACSM (0, 0, 16) && LCPL Input (0, 0, 5) && Gather KFX-ZIP (from KFX Input) (1, 49, 0) && DeDRM (10, 0, 3) && Package KFX (from KFX Input) (1, 49, 0) && Action Chains (1, 18, 0) && Actualizador Biblioteca LDS (1, 8, 0) && AudioBook_Duration (1, 0, 9) && Author Book Count (2, 2, 2) && Barnes & Noble (1, 4, 0) && Biblioteca EPL (2, 8, 0) && BookFusion Plugin (0, 7, 0) && Busca en internet (1, 8, 1) && Clean Comments (0, 2, 1) && Comments Cleaner (1, 8, 0) && Count Pages (1, 12, 0) && Extract ISBN (1, 6, 0) && Favourites Menu (1, 3, 0) && Find Duplicates (1, 10, 7) && Generate Cover (2, 3, 0) && Goodreads (1, 7, 1) && Goodreads Sync (1, 16, 2) && Hyphenate This! (0, 1, 3) && ISFDB (3, 0, 0) && Import List (1, 9, 0) && Job Spy (1, 0, 193) && KFX metadata reader (from KFX Input) (1, 49, 0) && KFX Input (1, 49, 0) && Set KFX metadata (from KFX Output) (1, 64, 0) && KFX Output (1, 64, 0) && KePub Input (3, 6, 3) && KePub Output (3, 6, 3) && Kindle Collections (1, 7, 29) && Kindle hi-res covers (0, 5, 0) && KindleUnpack - The Plugin (0, 83, 1) && LanguageTool (0, 1, 2) && Last Modified (0, 8, 4) && Mass Search-Replace (1, 6, 1) && Media File Importer (1, 0, 26) && Modify ePub (1, 8, 1) && MultiColumnSearch (1, 0, 93) && Obok DeDRM (10, 0, 3) && Open With (1, 8, 0) && Quality Check (1, 13, 2) && Quick Preferences (1, 7, 0) && Reading List (1, 14, 0) && Resize Cover (1, 2, 0) && Search The Internet (1, 10, 0) && SmartEject (2, 5, 0) && Sum Column (0, 3, 3) && Tematika_Pricecheck (1, 0, 0) && User Category (1, 6, 0) && Wiki Reader (2, 2, 1) && WordDumb (3, 25, 0) && ePub Extended Metadata {Writer} (0, 8, 1) && ePub Extended Metadata {Reader} (0, 8, 1) && ePub Extended Metadata (0, 8, 1)
calibre 6.8 embedded-python: True
Linux-5.4.0-131-generic-x86_64-with-glibc2.31 Linux ('64bit', 'ELF')
('Linux', '5.4.0-131-generic', '#147-Ubuntu SMP Fri Oct 14 17:07:22 UTC 2022')
Python 3.10.1
Interface language: es
Successfully initialized third party plugins: DeACSM (0, 0, 16) && LCPL Input (0, 0, 5) && Gather KFX-ZIP (from KFX Input) (1, 49, 0) && DeDRM (10, 0, 3) && Package KFX (from KFX Input) (1, 49, 0) && Action Chains (1, 18, 0) && Actualizador Biblioteca LDS (1, 8, 0) && AudioBook_Duration (1, 0, 9) && Author Book Count (2, 2, 2) && Barnes & Noble (1, 4, 0) && Biblioteca EPL (2, 8, 0) && BookFusion Plugin (0, 7, 0) && Busca en internet (1, 8, 1) && Clean Comments (0, 2, 1) && Comments Cleaner (1, 8, 0) && Count Pages (1, 12, 0) && Extract ISBN (1, 6, 0) && Favourites Menu (1, 3, 0) && Find Duplicates (1, 10, 7) && Generate Cover (2, 3, 0) && Goodreads (1, 7, 1) && Goodreads Sync (1, 16, 2) && Hyphenate This! (0, 1, 3) && ISFDB (3, 0, 0) && Import List (1, 9, 0) && Job Spy (1, 0, 193) && KFX metadata reader (from KFX Input) (1, 49, 0) && KFX Input (1, 49, 0) && Set KFX metadata (from KFX Output) (1, 64, 0) && KFX Output (1, 64, 0) && KePub Input (3, 6, 3) && KePub Output (3, 6, 3) && Kindle Collections (1, 7, 29) && Kindle hi-res covers (0, 5, 0) && KindleUnpack - The Plugin (0, 83, 1) && LanguageTool (0, 1, 2) && Last Modified (0, 8, 4) && Mass Search-Replace (1, 6, 1) && Media File Importer (1, 0, 26) && Modify ePub (1, 8, 1) && MultiColumnSearch (1, 0, 93) && Obok DeDRM (10, 0, 3) && Open With (1, 8, 0) && Quality Check (1, 13, 2) && Quick Preferences (1, 7, 0) && Reading List (1, 14, 0) && Resize Cover (1, 2, 0) && Search The Internet (1, 10, 0) && SmartEject (2, 5, 0) && Sum Column (0, 3, 3) && Tematika_Pricecheck (1, 0, 0) && User Category (1, 6, 0) && Wiki Reader (2, 2, 1) && WordDumb (3, 25, 0) && ePub Extended Metadata {Writer} (0, 8, 1) && ePub Extended Metadata {Reader} (0, 8, 1) && ePub Extended Metadata (0, 8, 1)
QPA platform: xcb
devicePixelRatio: 1.0
logicalDpi: 96.0 x 96.0
physicalDpi: 141.35652173913041 x 141.4020618556701
[0.00] Starting up...
[0.00] Showing splash screen...
[0.08] splash screen shown
[0.08] Initializing db...
[2.47] db initialized
[2.47] Constructing main UI...
Using QT6
Ya existen las librerias mutagen y rarfile
DEBUG: 0.0 Clean Comments::config.py - loading translations
DEBUG: 0.0 CleanComment::action.py - loading translations
DEBUG: 0.0 obok::utilities.py - loading translations
DEBUG: 0.0 obok::dialogs.py - loading translations
DEBUG: 0.0 obok::config.py - loading translations
DEBUG: 0.0 obok::action_err.py - loading translations
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': 'LGD',
'model': '',
'name': 'LVDS-1-1',
'serial': '',
'size_in_logical_pixels': {'height': 1080, 'width': 1920},
'virtual_geometry': {'height': 1080, 'width': 1920, 'x': 0, 'y': 0}}
Restoring geometry for: jobs_dialog_geometry
{'frame_geometry': {'height': 570, 'width': 1350, 'x': 162, 'y': 280},
'full_screened': False,
'geometry': {'height': 542, 'width': 1348, 'x': 163, 'y': 307},
'maximized': False,
'normal_geometry': {'height': 542, 'width': 1348, 'x': 163, 'y': 307},
'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': 'LGD',
'model': '',
'name': 'LVDS-1-1',
'serial': '',
'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': 'LGD',
'model': '',
'name': 'LVDS-1-1',
'serial': '',
'size_in_logical_pixels': {'height': 1080, 'width': 1920},
'virtual_geometry': {'height': 1080, 'width': 1920, 'x': 0, 'y': 0}}
Setting widget geometry to: {'height': 542, 'width': 1348, 'x': 163, 'y': 307}
Restoring geometry for: calibre_main_window_geometry
{'frame_geometry': {'height': 1080, 'width': 1920, 'x': 0, 'y': 0},
'full_screened': False,
'geometry': {'height': 1053, 'width': 1920, 'x': 0, 'y': 27},
'maximized': True,
'normal_geometry': {'height': 1053, 'width': 1920, 'x': 0, 'y': 27},
'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': 'LGD',
'model': '',
'name': 'LVDS-1-1',
'serial': '',
'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': 'LGD',
'model': '',
'name': 'LVDS-1-1',
'serial': '',
'size_in_logical_pixels': {'height': 1080, 'width': 1920},
'virtual_geometry': {'height': 1080, 'width': 1920, 'x': 0, 'y': 0}}
Setting widget geometry to: {'height': 1053, 'width': 1920, 'x': 0, 'y': 27}
Restoring widget to maximized
Job Spy has begun initialization...
Calibre, and hence Job Spy, was gracefully shut down last time? True
Last time daemon started: Wed Oct 26 20:25:36 2022
Last time daemon failed: never
Total daemon starts inception_to_date: 1
qt.gui.imageio: libpng warning: iCCP: known incorrect sRGB profile
Total daemon failures inception-to-date: 0
JS: ===>>> change_gui_alternating_row_colors()
Job Spy has finished initialization...
DEBUG MassSearchReplace: Rebuilding menu
[0] un-optimized number of undesirable characters accumulated: 756
[1] optimized number of undesirable characters accumulated: 596
MCS has finished initialization...
[8.79] main UI initialized...
[8.79] Hiding splash screen
Action chains: _get_plugins_resources(): start
Action Chains: _get_plugins_resources(): finished
Action chains: formulas: running on_templates_update()
Action chains: _call_plugins_on_modules_update(): start
Action Chains: _call_plugins_on_modules_update(): finished
Starting QuickView
inotify_add_watch(/home/walter/Escritorio/Automatica) failed: (No space left on device)
SMART_DEV ( 0.00: 0.001) _attach_to_port try ip address "" on port 9090
SMART_DEV ( 0.97: 0.807) _startup_on_demand listening on port 9090
SMART_DEV ( 1.02: 0.000) _attach_to_port try ip address "" on port 54982
SMART_DEV ( 1.05: 0.000) _startup_on_demand broadcast socket listening on port 54982
SMART_DEV ( 2.09: 1.002) run All IP addresses {'lo': [{'addr': '127.0.0.1', 'netmask': '255.0.0.0', 'peer': '127.0.0.1'}], 'wlp2s0': [{'addr': '192.168.0.142', 'netmask': '255.255.255.0', 'broadcast': '192.168.0.255'}], 'virbr0': [{'addr': '192.168.122.1', 'netmask': '255.255.255.0', 'broadcast': '192.168.122.255'}]}
[12.36] splash screen hidden
[12.36] Started up in 12.36 seconds with 18607 books
TXT_QUERIES parm: 2022-nov-04-20:44:43❟TXT_QUERIES❟EPUB [rv][0-9.]+...#0
TXT_QUERIES parm: 2022-nov-04-20:46:54❟TXT_QUERIES❟(epub r{0,1}v{0,1}[0-9].[0-9])...#1
TXT_QUERIES parm: 2022-nov-04-20:51:48❟TXT_QUERIES❟EPUB [rv][0-9.]+...#2
TXT_QUERIES parm: 2022-nov-04-20:55:25❟TXT_QUERIES❟[0-9.]+...#3
TXT_QUERIES parm: 2022-nov-04-20:56:22❟TXT_QUERIES❟[0-9.]+...#4
TXT_QUERIES parm: 2022-nov-05-17:12:18❟TXT_QUERIES❟(\s?|1|2)\d?\d\d[-\.](\s?|0|1)\d[-\.](\d?\d+)|(\d?\d+)[-\.](\s?|0|1...#5
TXT_QUERIES parm: 2022-nov-05-17:23:13❟TXT_QUERIES❟(\s?|1|2)\d?\d\d[-\.](\s?|0|1)\d[-\.](\d{3,4})|(\d{3,4})[-\.](\s?|0...#6
TXT_QUERIES parm: 2022-nov-05-17:42:22❟TXT_QUERIES❟[0-9.]+...#7
TXT_QUERIES parm: 2022-nov-05-17:43:39❟TXT_QUERIES❟("tfecha">)([0-9].{7})...#8
TXT_QUERIES parm: 2022-nov-05-17:44:51❟TXT_QUERIES❟("tfecha">)([0-9].{7})...#9
TXT_QUERIES parm: 2022-nov-05-17:47:38❟TXT_QUERIES❟([0-9].{7})...#10
TXT_QUERIES parm: 2022-nov-05-17:55:49❟TXT_QUERIES❟([0-9.-]{8,10})...#11
TXT_QUERIES parm: 2022-nov-05-18:13:51❟TXT_QUERIES❟(\d \d [ - /. ] \d \d [ - /. ] \d \d)...#12
TXT_QUERIES parm: 2022-nov-05-18:15:25❟TXT_QUERIES❟(\d\d[- /.]\d\d[- /.]\d\d)...#13
TXT_QUERIES parm: 2022-nov-05-18:20:04❟TXT_QUERIES❟([01]\d[- /.][0-3]\d[- /.]\d\d)...#14
TXT_QUERIES parm: 2022-nov-05-18:23:04❟TXT_QUERIES❟((0?[1-9]|[12][0-9])(\.|\-)(0?[1-9]|1[012])(\.|\-)(0[1-9]|[12][0-9]...#15
TXT_QUERIES parm: 2022-nov-05-19:11:54❟TXT_QUERIES❟(0?[1-9]|[12][0-9])(\.|-)(0?[1-9]|1[012])(\.|-)([12][0-9])[0-9][0-9...#16
TXT_QUERIES parm: 2022-nov-05-19:12:44❟TXT_QUERIES❟(0?[1-9]|[12][0-9])(\.|-)(0?[1-9]|1[012])(\.|-)([12][0-9])[0-9][0-9...#17
TXT_QUERIES parm: 2022-nov-05-19:14:14❟TXT_QUERIES❟[0-9.]+...#18
TXT_QUERIES parm: 2022-nov-05-19:44:06❟TXT_QUERIES❟(0?[1-9]|[12][0-9])(\.|-)(0?[1-9]|1[012])(\.|-)([1][9]|[2][0])?[0-9...#19
TXT_QUERIES parm: 2022-nov-12-16:32:02❟TXT_QUERIES❟((0?[1-9]|[123]\d)[-](0?[1-9]|1[012])[-]([1][9]|[2][0])?\d\d)|((0?[...#20
TXT_QUERIES parm: 2022-nov-12-16:36:24❟TXT_QUERIES❟^EPUB [rv.][0-9.]+$...#21
TXT_SEARCH_TERMS = [0-9.]+
OPTIONS_TEXT_ACTIVATE = False
OPTIONS_COMPARE_FOUND_TEXT = False
OPTIONS_COMPARE_FOUND_TEXT_CC =
OPTIONS_COMPARE_FOUND_TEXT_REGEX =
OPTIONS_UPDATE_FOUND_TEXT = False
OPTIONS_UPDATE_FOUND_TEXT_CC =
OPTIONS_UPDATE_FOUND_TEXT_REGEX =
ALL_AUTHORS_BOOKS = False
USE_FINAL_FILTERS = False
TXT_QUERIES = TXT_QUERIES
*** All virtualcolumntxttab widgets have been reset per loaded criteria selected by user ***
self.mcs_dialog.managesavedcriteria_dialog.close()
Saving geometry for: calibre_main_window_geometry
{'frame_geometry': {'height': 1080, 'width': 1920, 'x': 0, 'y': 0},
'full_screened': False,
'geometry': {'height': 1053, 'width': 1920, 'x': 0, 'y': 27},
'maximized': True,
'normal_geometry': {'height': 1053, 'width': 1920, 'x': 0, 'y': 27},
'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': 'LGD',
'model': '',
'name': 'LVDS-1-1',
'serial': '',
'size_in_logical_pixels': {'height': 1080, 'width': 1920},
'virtual_geometry': {'height': 1080,
'width': 1920,
'x': 0,
'y': 0}}}

[DaltonST]

It won't let me reload saved configurations

I am not sure what your issue exactly is yet, but be aware that MCS will not save duplicate copies of preexisting saved criteria. It checks for prior existence, and only then saves the current criteria in the Tab.

To clarify, when you click the "Load Previously Saved Criteria?" pushbutton, it does not show a list for you to select and load, correct?

According to your debug log, you have ~22 saved TXT Query named criteria.

You debug log shows that you were using the "Manage Saved Criteria" pushbutton. That is entirely different from the "Load Previously Saved Criteria?" pushbutton. Where is your issue? Managing or Loading?

I need a debug log showing when you clicked the "Load Previously Saved Criteria?" pushbutton, and selected an item in the displayed list. Then, exit MCS (but not Calibre yet, since your debug terminal session might disappear.).

Your debug log was not created from the command line, and there was nothing after you exited "Manage Saved Criteria" which is not what you described as an issue. I need to see a debug log just for clicking the "Load Previously Saved Criteria?" pushbutton.

Run "calibre-debug -g" in a terminal command line, perform the steps described above, and then select all of the terminal debug log text, copy it, and then paste it into a .txt file. Post that .txt file.


ADDED:
I just released a new version of MCS that forces Qt to immediately update the MCS GUI rather than waiting until it got around to doing it (if it ever did), which might be the cause of your issue. I also improved DEBUG logging related to your issue.



DaltonST

[DaltonST]

Version 1.0.94 - 15 November 2022 TXT Queries Tab: technical tweaks for Qt behavior.


DaltonST

[dunhill]

Thank you!! With the last update, the issue of loading saved instances was solved.
And every time I start the translation of the plugin, into Spanish, you send me an update.

[DaltonST]

I will always be making random updates to my plugins. Your translations will be constantly breaking.

DaltonST

[dunhill]

Originally Posted by DaltonST

I will always be making random updates to my plugins. Your translations will be constantly breaking.

DaltonST

I was saying it as a joke and how fast you solve and maintain the plugins. Thank you for your work.

[ownedbycats]

Is Date not an available column for searching, or is this a glitch? It's not in the dropdown and manually entering 'date' or 'timestamp' in makes an error about unsupported column name.

EDIT: I was able to do my search with a template, so it's not a big deal unless it's unintednedned.

[DaltonST]

Originally Posted by ownedbycats

Is Date not an available column for searching, or is this a glitch? It's not in the dropdown and manually entering 'date' or 'timestamp' in makes an error about unsupported column name.

EDIT: I was able to do my search with a template, so it's not a big deal unless it's unintednedned.

The OP under 'Scope' answers your question.




DaltonST

[ownedbycats]

Thanks. Is there technical reason it's excluded? I was wanting to compare it against a custom datetime column.

[DaltonST]

Originally Posted by ownedbycats

Thanks. Is there technical reason it's excluded? I was wanting to compare it against a custom datetime column.

When I was developing the very first Tab in MCS, I intentionally excluded that column from the Scope of MCS, and nothing has changed in the intervening 7.5 years.



Your simple solution is to create a new datetime custom column, and use S&R to copy the unsupported datetime field you wish to it. Then, use MCS to compare that new column to another datetime column of your choosing. Afterwards, purge the data in, or delete entirely, that new custom column, and compress your Library's metadata.db.





DaltonST

[DaltonST]

Version 1.0.95 - 03 December 2022 Raw SQL Queries Tab: fixed regression error when selecting Final Filters to be used; added support for using the FTS db for completeness. However, the TXT Queries Tab is still the preferred MCS tool for FTS queries because of its greater functionality and flexibility.


DaltonST

[shauntih]

I want to use MCS to do the following, but without seeing the db structure, I'm not quite sure how to word it properly. What I WANT is to: SELECT * FROM books WHERE author IN (SELECT author WHERE #category='>Purchased'). So, "find all the books where I've purchased at least one book by that author, for any author in my library".

This plugin does so many things that I want to do, but no matter how many times I read the tutorial, I'm still confused. Any help is GREATLY appreciated!