Re: [sqlite] FTS4 Problem

On 12/25/2014 08:04 AM, Peter Truskier wrote: As I mentioned, I seem to have solved the problem by doing a "rebuild" command on the FTS4 table. But, as I thought about it further, I'm still confused as to why dropping, and then re-creating the virtual table didn't solve the problem as well.

Re: [sqlite] FTS4 Problem

As I mentioned, I seem to have solved the problem by doing a "rebuild" command on the FTS4 table. But, as I thought about it further, I'm still confused as to why dropping, and then re-creating the virtual table didn't solve the problem as well. What am I missing? Thanks, Peter > On Dec

Re: [sqlite] FTS4 Problem

Thanks so much for the quick AND HELPFUL response! I had run the pragma, but was unaware of the command. When I ran the 'integrity-check' command on the virtual table, I got a "database disk image is malformed Error Code 11" Running the 'rebuild' command seems to have fixed the problem. I

Re: [sqlite] FTS4 Problem

Have you run integrity checks on the database file ( https://www.sqlite.org/pragma.html#pragma_integrity_check) and on the FTS4 tables (https://www.sqlite.org/fts3.html#integcheck)? Do they all look correct? On Wed, Dec 24, 2014 at 2:40 PM, Peter Truskier wrote: > I have

[sqlite] FTS4 Problem

I have an sqlite database in which I've created a virtual table using FTS4. For nearly a year, we've been using it to do full text searching with no problem. The database contains a table of products (tblProducts) with columns id, SKU, itemDesc, etc. The virtual table is created like this: