[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,length,samplerate,files \
ize,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]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic