Update: Interestingly, I could successfully copy Dirty>Work using the "Selected Books" option (32 books).
However, the above referenced error appeared again at the "Scrub at Author level" step:
Spoiler:
Starting job: Quarantine And Scrub: Author-Level Scrubbing
Library DB: /media/*user*/Library/Calibre_Libraries/QuarantineAndScrub_OfficialLibrary/metadata.db
Thu Apr 20 13:00:37 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: (, , [], []) {'notifications': , 'abort': , 'log': }