Where are saved searches and VLs kept in the database?

ownedbycats · 04-15-2021, 01:00 PM

I mistakenly created a VL-saved search recursive loop in Calibre, causing things to crash pretty hard.

To get things running again, I went into the database and wanted to edit either the VL or saved search. However, I couldn't find them in the database. Where exactly are they?

(Thankfully, I got things working again by editing the custom_columns table to remove a reference to virtual_libraries(). It's also been fixed in master so it shouldn't happen again.)

chaley · 04-15-2021, 01:19 PM

Quote:

Originally Posted by ownedbycats

I mistakenly created a VL-saved search recursive loop in Calibre, causing things to crash pretty hard.

To get things running again, I went into the database and wanted to edit either the VL or saved search. However, I couldn't find them in the database. Where exactly are they?

(Thankfully, I got things working again by editing the custom_columns table to remove a reference to virtual_libraries(). It's also been fixed in master so it shouldn't happen again.)

They are in the preferences table.

ownedbycats · 04-15-2021, 01:20 PM

Thank you

04-15-2021, 01:00 PM	#1
ownedbycats Custom User Title Posts: 11,332 Karma: 79528341 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	Where are saved searches and VLs kept in the database? I mistakenly created a VL-saved search recursive loop in Calibre, causing things to crash pretty hard. To get things running again, I went into the database and wanted to edit either the VL or saved search. However, I couldn't find them in the database. Where exactly are they? (Thankfully, I got things working again by editing the custom_columns table to remove a reference to virtual_libraries(). It's also been fixed in master so it shouldn't happen again.)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Saved Searches: Recursing hierarchical searches	ownedbycats	Library Management	7	01-18-2021 05:33 AM
Combining saved searches for VLs	ownedbycats	Library Management	1	12-04-2020 05:46 AM
Saved Searches?	jim3692	Sigil	3	04-26-2020 06:10 PM
Saved searches	abecedarian	Sigil	5	04-14-2017 06:48 PM
Where are searches saved?	travger	Calibre	2	08-26-2012 01:37 PM

04-15-2021, 01:20 PM	#3
ownedbycats Custom User Title Posts: 11,332 Karma: 79528341 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	Thank you

Advert