Malformed database (but only when using

[Liudprand]

I have a problem which (I think!) is slightly different from the usual "malformed database" thing.

It doesn't seem to be anything to do with the devices (I have two that I use with the same Calibre library). I only get the popup telling me the database is malformed (image attached) when I try to use the Full Text Search facility - specifically, after I enter a search term and then click the button to the right.

My assumption is that this uses a different, bespoke database that's distinct from the main database for the library (this is because I remember how long it took to compile in the first place!). Assuming that's the case, is there a way of getting Calibre to just generate this database again, and overwrite the old one? Would that be a matter of just deleting the relevant file.

Or, am I wrong about that? Does it mean "the" database is malformed, and I have to find a backup, assuming I've got one?

I'd be very grateful for any tips...

[kovidgoyal]

You can simply delete the full-text-search.db file in your calibre database and it will be rebuilt.

[Liudprand]

I should have mentioned that I know which file to delete, if that's the solution - full-text-search.db. I'd just be grateful if someone could let me know whether just deleting it from the file system in Windows is the way to go, or whether that will just confuse Calibre. If there's a way of deleting it from within the Calibre interface, I can't seem to find it...

[Liudprand]

Ah - thanks very much! That was the quickest reply I've ever had on here, or maybe anywhere else!