[GUI Plugin] Consolidate All Library Metadata (CALM)

[webdjoe]

First, I want to say thank you to DaltonST for your hard work!

I'm receiving an error when running execute (after following the previous steps listed in the UI):

Starting job: CALM Consolidation 
Starting CALM Consolidation 
CALM DB: G:/CALM/CALM/metadata.db 
Sun Nov 12 11:40:18 2023 
Python: Windows   CPython   3.10.1 
SQLite Version: 3043000    [APSW] 
PRAGMA main.locking_mode = EXCLUSIVE; 
  
Beginning 'Consolidate All Library Metadata'  
═════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════ 
  
  
Attaching to New Source Library: G:/Library/metadata.db 
Consolidating Source Standard Metadata: Sun Nov 12 11:40:18 2023 
---------------------------------------------------------------------------------------------- 
The current Source Library metadata.db is corrupted.  It cannot be processed further.  
---------------------------------------------------------------------------------------------- 
SQLError: table main.languages has 3 columns but 2 values were supplied 
---------------------------------------------------------------------------------------------- 
Previous Source Library Detached: G:/Library/metadata.db 
Consolidation Finished for Source Library: Sun Nov 12 11:40:18 2023 
Library SQLite memory usage (in bytes) --  Currently: 3,601,960  Job Maximum: 95,844,872

Calibre did not find any errors when checking the database. It is an old database that I've used for 8+ years with around 15k ebooks. I will rebuild the DB if necessary but I'm hoping there is a simple step that I missed.

[redlob]

Same problem here. Maybe related to Calibre 7.0?

[BetterRed]

The plugin author, DaltonST, hasn't logged on since July 5.

BR

[webdjoe]

I fixed the DB errors in the plugin to adapt to the new Calibre structure to the best of my knowledge. I used it successfully, but no guarantees. Remember to backup you library before using. Add using Install Plugin From File

https://drive.google.com/file/d/1dIy...ew?usp=sharing

[Findingaway]

February 2025: I tried the last released "official" version, and then Webdjoe's version.

With the official version, I got the same error as Webdjoe. With his version, that error disappeared, and I see no error messages, but the only a column structure is generated in the CALM (OR CSLM?) library, there is no data populated. I tried this with both one library and two as sources.

Is it possible I'm making some other error, anyone?

TIA.