Getting Sql errors all of a sudden

[Timpie]

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??

[Timpie]

@Timpie
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]

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;