• Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login
    1. Strawberry Music Player Forums
    2. pajaro
    3. Posts
    P
    • Profile
    • Following 0
    • Followers 0
    • Topics 1
    • Posts 4
    • Best 0
    • Controversial 0
    • Groups 0

    Posts made by pajaro

    • RE: Fails to index a few songs

      @peterb

      Yes, this worked! Thanks!

      Also, i believe it imported correctly the "bad" songs 🙂

      posted in Technical Help
      P
      pajaro
    • RE: Fails to index a few songs

      Sorry, im out

      I will do more specific test when i can

      In the meantime, the file system is ext4

      coreutils: /usr/bin/stat

      returns a valid ctime (which is maybe corrected by the program)

      I tried to auto tag the song (so maybe strawberry was able to "fix" whatever is wrong in the file, but it gives the same error

      Clementine is able to index these bad files

      Even if there is some error, like this, shouldnt strawberry try to recover by fixing the ctime? (and maybe reporting it to the user)

      Even if strawberry doesnt "fix" the file, shouldnt it just import the rest of the files that doesnt have the problem? (or maybe all do, its hard to tell, because if i remove a bad file, it reports another one

      posted in Technical Help
      P
      pajaro
    • RE: Fails to index a few songs

      Song works perfectly fine in clementine

      And even if the song is faulty, it only shows 1 song that is faulty and doesnt let me import the rest

      Trying to Auto tag the song gives the same error

      posted in Technical Help
      P
      pajaro
    • Fails to index a few songs

      When i try to index my music collection i get this error

      Unable to execute SQL query: NOT NULL constraint failed: songs.ctime Unable to
      fetch row<br />Failed query: INSERT INTO songs (title, album, artist,
      albumartist, track, disc, year, originalyear, genre, compilation, composer,
      performer, grouping, comment, lyrics, artist_id, album_id, song_id, beginning,
      length, bitrate, samplerate, bitdepth, source, directory_id, url, filetype,
      filesize, mtime, ctime, unavailable, fingerprint, playcount, skipcount,
      lastplayed, lastseen, compilation_detected, compilation_on, compilation_off,
      compilation_effective, art_automatic, art_manual, effective_albumartist,
      effective_originalyear, cue_path, rating) VALUES (The Ecstacy Of Gold, S&M with
      the San Francisco Symphony, Metallica, S&M with the San Francisco
      Symphonyartist, 1, 1, 1999, -1, Rock, 0, , Metallica, , 0, , Metallica_id, S&M
      with the San Francisco Symphony_id, , 0, 150674000000, 320, 44100, -1, 2, 1,
      file:///home/pajaro/Music/onerandomsong.mp3, 8, 6029210, 1335652082, , 0, , 0,
      0, -1, 1657206086, 0_detected, 0_on, 0_off, 0_effective, , , Metallica, 1999, ,
      -1)

      And the then indexing stops

      It happened with a few songs and i try removing them, but then another diffrent
      song fails

      $ stats /home/pajaro/Music/onerandomsong.mp3 Give proper values for the file.
      I dont know what can be happening here

      posted in Technical Help
      P
      pajaro