View Single Post
Old 02-09-2026, 07:28 PM   #50
PeterT
Grand Sorcerer
PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.PeterT ought to be getting tired of karma fortunes by now.
 
Posts: 13,900
Karma: 82113062
Join Date: Nov 2007
Location: Toronto
Device: Libra H2O, Libra Colour
Quote:
Originally Posted by GeniusJ View Post
I posted a Windows Powershell script which fixes it for me. It adds the 3 columns back to the db file, and only needs to be run once after every time Calibre updates and drops the tables again. Just quit Calibre, run the powershell, and viola the columns are back until the next time Calibre updates. My post is in another thread about this.
calibre will NOT drop the columns on each upgrade. The DB updates are based on the USER_VERSION stored in the database. If the upgrade contains a newer version than the actual database the required code is run once and the database USER_VERSION updated to reflect that change.
PeterT is offline   Reply With Quote