I suggest you restore (rebulld) the database - it's in the Library Maintenance menu, it runs in two phases - the first phase is usually quite quick, but the second phase can take a while if its a big library.
You may lose preferences you've defined since April, but you probably won't lose book metadata because that's restored from the metadata.opf files in the book folders.
The library specific preference data - (custom columns, view manager, reading list, virtual library definitions) is contained in table called 'preferences', there's not much point in trying to look at the table in the database itself - more useful to look at the backup json file.
BR
|