On 07/11/2018 04:04 AM, Nick wrote:
On 10 Jul 2018, at 21:17, Dan Kennedy wrote:
Try running the FTS5 integrity-check command with the 3.24.0 command line to
ensure it really is corrupt:
https://www.sqlite.org/fts5.html#the_integrity_check_command
The index can be rebuilt using the rebuild command:
https://www.sqlite.org/fts5.html#the_rebuild_command
3.13.0 was about 2 years ago. There have been a couple of fixes for fts5
corruption bugs since then. This one, for example:
https://www.sqlite.org/src/info/9a2de4f05fabf7e7
So you may have hit a known issue. Hard to say.
Dan.
Thanks Dan.
Reading the webpage it says it doesn't work for contentless FTS5 but ran the
commands anyway
Yours is not a contentless table. It is an "external content" table.
Dan.
sqlite> INSERT INTO [i_epg]([i_epg]) VALUES('integrity-check');
Error: database disk image is malformed
sqlite> INSERT INTO [i_epg]([i_epg]) VALUES('rebuild');
sqlite> INSERT INTO [i_epg]([i_epg]) VALUES('integrity-check');
sqlite>
Running previous commands also seem to show its been fixed
sqlite> SELECT * FROM [i_epg] WHERE [i_epg] MATCH '{ mangled_title } : big +
ban';
sqlite> SELECT * FROM [i_epg] WHERE [i_epg] MATCH '{ mangled_title } : big +
ban*';
<deleted lots of output>
sqlite> SELECT [mangled_title] FROM [i_epg] WHERE [i_epg] MATCH '{
mangled_title } : black + adder';
The Black Adder
The Black Adder
The Black Adder
The Black Adder
The Black Adder
The Black Adder
The Black Adder
The Black Adder
The Black Adder
The Black Adder
The Black Adder
The Black Adder
The Black Adder
sqlite>
Thanks again Dan.
Regards
Nick
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
