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

    Greywolf

    @Greywolf

    0
    Reputation
    1
    Profile views
    2
    Posts
    0
    Followers
    0
    Following
    Joined Last Online

    Greywolf Unfollow Follow

    Latest posts made by Greywolf

    • RE: sqlite3 fails to load flac files from directory in Collection

      FOLLOWUP -- this only happens across NFS, which means I have to reproduce my music repo on my local box.

      posted in Technical Help
      G
      Greywolf
    • sqlite3 fails to load flac files from directory in Collection

      OS: NetBSD pre-10
      Collection: NFS mounted mostly FLAC, some .mp3
      Problems: SQLite3 fails to import some song records from the flac labels, keeps trying, and keeps failing:

      01:41:12.342 ERROR Database:502                     Unable to execute SQL query:  QSqlError("19", "Unable to fetch row", "NOT NULL constraint failed: songs.ctime")
      01:41:12.342 ERROR Database:503                     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 (Eat for Two, Blind Man's Zoo, 10,000 Maniacs, Blind Man's Zooartist, 1, 1, 1989, -1, , 0, , , , , , 10,000 Maniacs_id, Blind Man's Zoo_id, , 0, 212133000000, 919, 44100, 24, 2, 1, file:///mnt/music/+ALPHA_ARTIST/10,000_Maniacs/1989.Blind_Mans_Zoo/101.Eat_for_Two.flac, 2, 24388448, 1605390365, , 0, , 0, 0, -1, 1640079642, 0_detected, 0_on, 0_off, 0_effective, , , 10,000 Maniacs, 1989, , -1)"
      01:41:12.342 WARN  ScopedTransaction:37             Rolling back transaction
      
      

      ...and I end up with an empty collection, and no songs in my DB after exiting strawberry.
      Why would it end up with an occasional null ctime?

      posted in Technical Help
      G
      Greywolf