On 07/07/2022 16:11, Alberto Fuentes wrote:
Package: strawberry
Version: 1.0.5-1
Severity: normal
X-Debbugs-Cc: paj...@gmail.com

Dear Maintainer,

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


Hi Alberto,

Please state exactly what you did to experience this problem. I cannot find 'index' or 'indexing' in the menus or command line options.
Did you mean a Collection Scan? There's nothing much I can do here without 
being able to reproduce.


Please check obvious things like disc space in the home partition and invalid 
mp3 files.

It would be interesting to know if the same problem occurs with upstream's 
build.
https://files.strawberrymusicplayer.org/strawberry_1.0.5-bookworm_amd64.deb

or Clementine which is similar
https://tracker.debian.org/pkg/clementine


Problems can also be reported at
https://forum.strawberrymusicplayer.org/category/5/technical-help


Cheers,
Peter

Reply via email to