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-d...@kde.org
Reporter: bertyfogs+kdeb...@gmail.com
CC: ralf-eng...@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,length,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 watching all bug changes.
