View Single Post
Old 04-20-2023, 11:14 PM   #186
thelastclown
Junior Member
thelastclown began at the beginning.
 
Posts: 7
Karma: 10
Join Date: Jul 2020
Device: none
I'm using Q&S 3.6.122.

Here is the calibre debug log after running:

purge all work data (success)>
copy dirty to work "all books" (fail)>
copy dirty to work "selected" (success)>
scrub all books at author level (fail)

Spoiler:
QColorSpace attempted constructed from invalid primaries: QPointF(0.313477,0.329102) QPointF(0.692383,0.318359) QPointF(0.266602,0.682617) QPointF(0.151367,0.0546875)
ApplicationPaletteChange event ignored
Using calibre Qt style: True
qt.gui.imageio: libpng warning: iCCP: known incorrect sRGB profile
calibre Debug log
calibre 6.14 embedded-python: True
Linux-5.15.0-70-generic-x86_64-with-glibc2.35 Linux ('64bit', 'ELF')
('Linux', '5.15.0-70-generic', '#77-Ubuntu SMP Tue Mar 21 14:02:37 UTC 2023')
Python 3.10.1
Interface language: None
Successfully initialized third party plugins: Gather KFX-ZIP (from KFX Input) (1, 51, 0) && DeDRM (10, 0, 3) && Package KFX (from KFX Input) (1, 51, 0) && Audit Log (1, 0, 19) && Author Book Count (2, 2, 3) && Author Book Count Hierarchy (1, 2, 5) && CalibreSpy (1, 0, 92) && Consolidate All Library Metadata (2, 0, 46) && Drop Search Results (1, 0, 14) && English Noun Frequency (1, 0, 16) && Entities Manager (1, 0, 19) && Extract RIS Citations (1, 0, 15) && Favourites Menu (1, 3, 0) && Job Spy (1, 0, 234) && KFX metadata reader (from KFX Input) (1, 51, 0) && KFX Input (1, 51, 0) && Set KFX metadata (from KFX Output) (1, 67, 0) && KFX Output (1, 67, 0) && Library Codes (1, 0, 65) && Library Splitter (1, 0, 7) && Media File Importer (1, 0, 27) && MultiColumnSearch (1, 0, 96) && Open With (1, 8, 1) && Quality Check (1, 13, 4) && QuarantineAndScrub (3, 6, 122) && Reading List (1, 15, 1) && View Manager (1, 10, 2)
calibre 6.14 embedded-python: True
Linux-5.15.0-70-generic-x86_64-with-glibc2.35 Linux ('64bit', 'ELF')
('Linux', '5.15.0-70-generic', '#77-Ubuntu SMP Tue Mar 21 14:02:37 UTC 2023')
Python 3.10.1
Interface language: None
Successfully initialized third party plugins: Gather KFX-ZIP (from KFX Input) (1, 51, 0) && DeDRM (10, 0, 3) && Package KFX (from KFX Input) (1, 51, 0) && Audit Log (1, 0, 19) && Author Book Count (2, 2, 3) && Author Book Count Hierarchy (1, 2, 5) && CalibreSpy (1, 0, 92) && Consolidate All Library Metadata (2, 0, 46) && Drop Search Results (1, 0, 14) && English Noun Frequency (1, 0, 16) && Entities Manager (1, 0, 19) && Extract RIS Citations (1, 0, 15) && Favourites Menu (1, 3, 0) && Job Spy (1, 0, 234) && KFX metadata reader (from KFX Input) (1, 51, 0) && KFX Input (1, 51, 0) && Set KFX metadata (from KFX Output) (1, 67, 0) && KFX Output (1, 67, 0) && Library Codes (1, 0, 65) && Library Splitter (1, 0, 7) && Media File Importer (1, 0, 27) && MultiColumnSearch (1, 0, 96) && Open With (1, 8, 1) && Quality Check (1, 13, 4) && QuarantineAndScrub (3, 6, 122) && Reading List (1, 15, 1) && View Manager (1, 10, 2)
QPA platform: xcb
devicePixelRatio: 1.0
logicalDpi: 96.0 x 96.0
physicalDpi: 127.66492146596858 x 127.59069767441859
[0.00] Starting up...
[0.00] Showing splash screen...
[0.05] splash screen shown
[0.05] Initializing db...
[0.07] db initialized
[0.07] Constructing main UI...
CalibreSpy: initialization_complete
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
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.88] main UI initialized...
[1.88] Hiding splash screen
Starting QuickView
Starting job: Quarantine And Scrub: Author-Level Scrubbing
Library DB: /media/***/Library/Calibre_Libraries/QuarantineAndScrub_OfficialLibrary/metadata.db
Thu Apr 20 20:12:06 2023
Python: Linux CPython 3.10.1
SQLite Version: 3036000 [APSW]
SQLite DB Locking Mode: EXCLUSIVE [GUI Is Locked]

══════════════════════════════════════════════════ ══════════════════════════════════════════════════ ═════════════════════════════════════════════
Beginning Author Level Scrubbing
══════════════════════════════════════════════════ ══════════════════════════════════════════════════ ═════════════════════════════════════════════
Work Authors title-cased: 32
SQLError: table custom_column_4 has 2 columns but 3 values were supplied
Job: "Quarantine And Scrub: Author-Level Scrubbing" failed with error:
Traceback (most recent call last):
File "calibre_plugins.quarantine_and_scrub.authorlevel" , line 757, in execute_mysql_with_commit_generic
my_cursor.execute(mysql)
apsw.SQLError: SQLError: table custom_column_4 has 2 columns but 3 values were supplied

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "calibre/gui2/threaded_jobs.py", line 82, in start_work
File "calibre_plugins.quarantine_and_scrub.authorlevel" , line 107, in main_scrub_author_level
scrub_control(my_db, my_cursor, my_book_ids, notifications, log,scrubbed_books_final)
File "calibre_plugins.quarantine_and_scrub.authorlevel" , line 118, in scrub_control
explode_custom_column_4_if_needed(my_db, my_cursor, log)
File "calibre_plugins.quarantine_and_scrub.authorlevel" , line 1164, in explode_custom_column_4_if_needed
raise e
File "calibre_plugins.quarantine_and_scrub.authorlevel" , line 1142, in explode_custom_column_4_if_needed
execute_mysql_with_commit_generic(my_db,my_cursor, log,mysql,book=None)
File "calibre_plugins.quarantine_and_scrub.authorlevel" , line 770, in execute_mysql_with_commit_generic
raise e
File "calibre_plugins.quarantine_and_scrub.authorlevel" , line 765, in execute_mysql_with_commit_generic
my_cursor.execute(mysql)
apsw.SQLError: SQLError: table custom_column_4 has 2 columns but 3 values were supplied

Called with args: (<calibre_plugins.quarantine_and_scrub.ui.Quaranti neAndScrub object at 0x7f727712fc70>, <calibre.db.legacy.LibraryDatabase object at 0x7f72aec12da0>, [], []) {'notifications': <queue.Queue object at 0x7f7276522350>, 'abort': <threading.Event object at 0x7f7276522260>, 'log': <calibre.utils.logging.GUILog object at 0x7f7276522050>}

[5.16] splash screen hidden
[5.16] Started up in 5.16 seconds with 32 books
/media/***/Library/Calibre_Libraries/QuarantineAndScrub_OfficialLibrary/metadata.db
Job: 0 Quarantine And Scrub: Purge Work Data finished
Starting job: Quarantine And Scrub: Purge Work Data
/media/***/Library/Calibre_Libraries/QuarantineAndScrub_OfficialLibrary/metadata.db
Thu Apr 20 20:11:07 2023
Python: Linux CPython 3.10.1
SQLite Version: 2.6.0
SQLite DB Locking Mode: EXCLUSIVE [GUI Is Locked]

══════════════════════════════════════════════════ ══════════════════════════════════════════════════ ═════════════════════════════════════════════
Beginning Purge of All Work Data
══════════════════════════════════════════════════ ══════════════════════════════════════════════════ ═════════════════════════════════════════════

Erasing All Work Custom Column Data plus Transient Q&S Table Data

All Work Data Has Been Purged

Work Tables: Sequence Numbers Reset to 1


=============
Job complete.

/media/***/Library/Calibre_Libraries/QuarantineAndScrub_OfficialLibrary/metadata.db
18,status
4,work_author
16,work_freeze
10,work_series
12,work_series_number
13,work_tags
8,work_title
custom column number for work_author is: 4
custom column number for work_title is: 8
custom column number for work_series is: 10
custom column number for work_series_number is: 12
custom column number for work_tags is: 13
custom column number for work_freeze is: 16
custom column number for status is: 18
sleep 1
SQLError: table custom_column_4 has 2 columns but 3 values were supplied
Job: 1 Quarantine And Scrub: Copy Real to Work finished
Starting job: Quarantine And Scrub: Copy Real to Work
/media/***/Library/Calibre_Libraries/QuarantineAndScrub_OfficialLibrary/metadata.db
Erasing All Work Custom Column Data
Populating All Work Custom Columns From Real Metadata
SQLError: table custom_column_4 has 2 columns but 3 values were supplied

Job: 2 Quarantine And Scrub: Author-Level Scrubbing finished
Starting job: Quarantine And Scrub: Author-Level Scrubbing
Library DB: /media/***/Library/Calibre_Libraries/QuarantineAndScrub_OfficialLibrary/metadata.db
Thu Apr 20 20:12:06 2023
Python: Linux CPython 3.10.1
SQLite Version: 3036000 [APSW]
SQLite DB Locking Mode: EXCLUSIVE [GUI Is Locked]

══════════════════════════════════════════════════ ══════════════════════════════════════════════════ ═════════════════════════════════════════════
Beginning Author Level Scrubbing
══════════════════════════════════════════════════ ══════════════════════════════════════════════════ ═════════════════════════════════════════════
Work Authors title-cased: 32
SQLError: table custom_column_4 has 2 columns but 3 values were supplied
Job: "Quarantine And Scrub: Author-Level Scrubbing" failed with error:
Traceback (most recent call last):
File "calibre_plugins.quarantine_and_scrub.authorlevel" , line 757, in execute_mysql_with_commit_generic
my_cursor.execute(mysql)
apsw.SQLError: SQLError: table custom_column_4 has 2 columns but 3 values were supplied

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "calibre/gui2/threaded_jobs.py", line 82, in start_work
File "calibre_plugins.quarantine_and_scrub.authorlevel" , line 107, in main_scrub_author_level
scrub_control(my_db, my_cursor, my_book_ids, notifications, log,scrubbed_books_final)
File "calibre_plugins.quarantine_and_scrub.authorlevel" , line 118, in scrub_control
explode_custom_column_4_if_needed(my_db, my_cursor, log)
File "calibre_plugins.quarantine_and_scrub.authorlevel" , line 1164, in explode_custom_column_4_if_needed
raise e
File "calibre_plugins.quarantine_and_scrub.authorlevel" , line 1142, in explode_custom_column_4_if_needed
execute_mysql_with_commit_generic(my_db,my_cursor, log,mysql,book=None)
File "calibre_plugins.quarantine_and_scrub.authorlevel" , line 770, in execute_mysql_with_commit_generic
raise e
File "calibre_plugins.quarantine_and_scrub.authorlevel" , line 765, in execute_mysql_with_commit_generic
my_cursor.execute(mysql)
apsw.SQLError: SQLError: table custom_column_4 has 2 columns but 3 values were supplied

Called with args: (<calibre_plugins.quarantine_and_scrub.ui.Quaranti neAndScrub object at 0x7f727712fc70>, <calibre.db.legacy.LibraryDatabase object at 0x7f72aec12da0>, [], []) {'notifications': <queue.Queue object at 0x7f7276522350>, 'abort': <threading.Event object at 0x7f7276522260>, 'log': <calibre.utils.logging.GUILog object at 0x7f7276522050>}
thelastclown is offline   Reply With Quote