@Mike:
Quote:
Attaching to New Source Library: C:/Users/MIKE/Desktop/metadata.db
Consolidating Source Standard Metadata: Mon Feb 15 19:06:17 2016
Job: "CALM Consolidation" failed with error:
Traceback (most recent call last):
File "site-packages\calibre\gui2\threaded_jobs.py", line 83, in start_work
File "calibre_plugins.consolidate_all_library_metadata. calm_consolidation", line 94, in main_calm_consolidation
File "calibre_plugins.consolidate_all_library_metadata. calm_consolidation", line 193, in CALM_Control
File "calibre_plugins.consolidate_all_library_metadata. calm_consolidation", line 374, in source_control
File "calibre_plugins.consolidate_all_library_metadata. calm_consolidation", line 392, in source_copy_control
File "calibre_plugins.consolidate_all_library_metadata. calm_consolidation", line 450, in add_new_language_codes
File "c:\cygwin64\home\kovid\sw\build\apsw-3.8.2-r1\src\cursor.c", line 990, in APSWCursor_execute.sqlite3_prepare
File "c:\cygwin64\home\kovid\sw\build\apsw-3.8.2-r1\src\statementcache.c", line 386, in sqlite3_prepare
SQLError: SQLError: no such table: SOURCE.languages
|
The cause of your problem is very clear. Your Source Library is "C:/Users/MIKE/Desktop/metadata.db" which has no Standard Calibre Table languages. The languages table is the very, very first thing that CALM copies from a Source Library into the Target Library. Your Source Library is not a valid Calibre Library.
By the way, in Windows, the "Desktop" folder is a very special folder. I would not recommend using it as a Calibre library itself.
You need to use Calibre to create a 'real' Calibre Library using its proper menu path for doing so: Right Click the Library Icon> Switch/Create Library > Choose the parent directory which must already exist, and go from there.
Example: "C:\Users\Mike\Documents\eBooks\MyLibraryName" .
Then, switch to that new Library and test it. Add a book to it, and check its functionality.
Click the CALM icon. Refresh the Target Library. Change the Source Libraries to what they should now be, and that does not include C:/Users/MIKE/Desktop . Generate the Source Custom Columns. Then, run the Consolidation.
Note that you can Consolidate a particular Source Library only once for any single incarnation of the CALM Target Library, but that does not mean that you have to Consolidate all of the Source Libraries at once. The checkboxes on the Source Library Tab control which to consolidate at any particular time. The ToolTips say that too. You could try Consolidating only the OneDrive library to see what happens. Based on your attachments, it should work fine. If it does not, apply the Nuclear Option again, and start over from scratch again but using "C:\Users\Mike\Documents\eBooks\MyLibraryName" instead of "C:/Users/MIKE/Desktop/metadata.db".
The reason that only one (1) of your Source Libraries was "Generated" is that you have only one (1) Source Library with any Custom Columns whatsoever.
In summary, the problem is not CALM, but C:/Users/MIKE/Desktop/metadata.db.
Good luck.
DaltonST
Edit: I just noticed that your CALM DB path is C:/Users/MIKE/Desktop/CALM/metadata.db . The erroneous Source Library is C:/Users/MIKE/Desktop/metadata.db . That means that
your CALM Target Library is a "child" of your Source Library! That is not ever going to work as far as CALM is concerned. Your CALM Target Library path should be something like: "C:\Users\Mike\Documents\eBooks\CALM\metadata. db"