[prev in list] [next in list] [prev in thread] [next in thread] 

List:       amarok-bugs-dist
Subject:    [amarok] [Bug 486084] New: Collection scan failure for tracks with "inf dB" in REPLAYGAIN_TRACK_GAIN
From:       EP <bugzilla_noreply () kde ! org>
Date:       2024-04-24 17:21:42
Message-ID: bug-486084-71684 () http ! bugs ! kde ! org/
[Download RAW message or body]

https://bugs.kde.org/show_bug.cgi?id=486084

            Bug ID: 486084
           Summary: Collection scan failure for tracks with "inf dB" in
                    REPLAYGAIN_TRACK_GAIN tag field
    Classification: Applications
           Product: amarok
           Version: unspecified
          Platform: Other
                OS: Linux
            Status: REPORTED
          Severity: normal
          Priority: NOR
         Component: Collections/Local
          Assignee: amarok-bugs-dist@kde.org
          Reporter: bertyfogs+kdebugs@gmail.com
                CC: ralf-engels@gmx.de
  Target Milestone: kf5

Created attachment 168877
  --> https://bugs.kde.org/attachment.cgi?id=168877&action=edit
A track with such tag value

SUMMARY
Some misbehaving software wrote `inf dB` into the `REPLAYGAIN_TRACK_GAIN` tag
field for "silence" tracks which feature on some albums for padding I guess.
Amarok's collection scanner doesn't account for that and tries to insert it
into the database as is:
```
amarok:     [ERROR__] [MySqlStorage] "MySQLe query failed! (1054) Unknown
column 'inf' in 'field list' on INSERT INTO tracks
(url,artist,album,genre,composer,year,title,comment,tracknumber,discnumber,bitrate,len \
gth,samplerate,filesize,filetype,bpm,createdate,modifydate,albumgain,albumpeakgain,trackgain,trackpeakgain)
 VALUES (118410,6375,8775,835,5187,159,'Pause
Track','',19,2,1,6467,44100,5614,3,NULL,0,1658593849,-2.63,1.62999,inf,-1);"
amarok:     [WARNING] [SqlRegistryP] Insert failed.
```

STEPS TO REPRODUCE
1. Create/add the test file to the collection
2. Scan the collection

OBSERVED RESULT
The scan fails on the test track.

EXPECTED RESULT
I think it should fall back to 0 for out-of-range values to keep the query
valid.

SOFTWARE/OS VERSIONS
OS: Manjaro
amarok-git: 2.9.82.r53.g4b4a4fc-1

ADDITIONAL INFORMATION
n/a

-- 
You are receiving this mail because:
You are the assignee for the bug.=


[prev in list] [next in list] [prev in thread] [next in thread]