Getting Sql errors all of a sudden
When uploading new music, then <update changed folder collection> i get following errors ...
How to fix this?
Unable to execute SQL query: constraint failed Unable to fetch row<br />Failed query: INSERT INTO songs_fts (ROWID, ftstitle, ftsalbum, ftsartist, ftsalbumartist, ftscomposer, ftsperformer, ftsgrouping, ftsgenre, ftscomment) VALUES (20727, Sakanto, Mouneissa, Rokia Traorè, Mouneissaartist, , Rokia Traorè, , , )
New music isn't added anymore??
I was investigating the sqlite databases and tried eliminating the records for which the errors were given from the 'songs_fts' tabel .... however i see the songs_fts and songs_fts_content are populated also. What is their function? If there is a description somewhere on how the tables are relating to each other i could perhaps solve this problem without the need to reinstall everything.
I have about 20000 mp3/flac/... in the collection
jonas last edited by
FTS = Full-text search. It's a table only used for the collection search.
Error probably means that the rowid it's trying to insert into songs_fts already exists, which is very strange, unless you have manually modified the database.
Try re-creating the songs_fts data, with the following commands:
Remove all songs_fts data:
delete from songs_fts;
Re-create songs_fts data from songs:
INSERT INTO songs_fts (ROWID, ftstitle, ftsalbum, ftsartist, ftsalbumartist, ftscomposer, ftsperformer, ftsgrouping, ftsgenre, ftscomment) SELECT ROWID, title, album, artist, albumartist, composer, performer, grouping, genre, comment FROM songs;