• Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login

    Getting Sql errors all of a sudden

    Scheduled Pinned Locked Moved
    Technical Help
    2
    3
    301
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • T
      Timpie
      last edited by

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

      T 1 Reply Last reply Reply Quote 0
      • T
        Timpie @Timpie
        last edited by

        @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

        jonasJ 1 Reply Last reply Reply Quote 0
        • jonasJ
          jonas @Timpie
          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;
          
          1 Reply Last reply Reply Quote 0
          • First post
            Last post
          Powered by NodeBB | Contributors