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 -- System Information: Debian Release: bookworm/sid APT prefers testing APT policy: (990, 'testing'), (500, 'unstable-debug'), (500, 'testing-debug'), (500, 'stable-updates'), (500, 'stable-security'), (500, 'unstable'), (500, 'stable'), (1, 'experimental') Architecture: amd64 (x86_64) Foreign Architectures: i386 Kernel: Linux 5.18.0-2-amd64 (SMP w/4 CPU threads; PREEMPT) Kernel taint flags: TAINT_PROPRIETARY_MODULE, TAINT_OOT_MODULE, TAINT_UNSIGNED_MODULE Locale: LANG=es_ES.UTF-8, LC_CTYPE=es_ES.UTF-8 (charmap=UTF-8), LANGUAGE=en_GB:en Shell: /bin/sh linked to /usr/bin/dash Init: systemd (via /run/systemd/system) LSM: AppArmor: enabled Versions of packages strawberry depends on: ii gstreamer1.0-plugins-base 1.20.3-2 ii gstreamer1.0-plugins-good 1.20.3-1 ii libasound2 1.2.6.1-2+b1 ii libc6 2.33-7 ii libcdio19 2.1.0-3 ii libchromaprint1 1.5.1-2+b1 ii libfftw3-double3 3.3.8-2 ii libgcc-s1 12.1.0-2 ii libgdk-pixbuf-2.0-0 2.42.8+dfsg-1 ii libglib2.0-0 2.72.2-2 ii libgnutls30 3.7.6-2 ii libgpod4 0.8.3-16 ii libgstreamer-plugins-base1.0-0 1.20.3-2 ii libgstreamer1.0-0 1.20.3-1 ii libmtp9 1.1.19-1 ii libprotobuf23 3.12.4-1+b3 ii libpulse0 15.0+dfsg1-4+b1 ii libqt5concurrent5 5.15.4+dfsg-3 ii libqt5core5a 5.15.4+dfsg-3 ii libqt5dbus5 5.15.4+dfsg-3 ii libqt5gui5 5.15.4+dfsg-3 ii libqt5network5 5.15.4+dfsg-3 ii libqt5sql5 5.15.4+dfsg-3 ii libqt5sql5-sqlite 5.15.4+dfsg-3 ii libqt5widgets5 5.15.4+dfsg-3 ii libqt5x11extras5 5.15.4-2 ii libsqlite3-0 3.38.5-1 ii libstdc++6 12.1.0-2 ii libtag1v5 1.12-1 ii libvlc5 3.0.17.4-4 ii libx11-6 2:1.7.5-1 Versions of packages strawberry recommends: ii gstreamer1.0-alsa 1.20.3-2 ii gstreamer1.0-pulseaudio 1.20.3-1 Versions of packages strawberry suggests: ii gstreamer1.0-plugins-bad 1.20.3-1 ii gstreamer1.0-plugins-ugly 1.20.3-1 -- no debconf information
