https://bugs.kde.org/show_bug.cgi?id=426807
Bug ID: 426807
Summary: Out of range changedate prevents importing music
folder
Product: amarok
Version: 2.9.0
Platform: Other
OS: Linux
Status: REPORTED
Severity: normal
Priority: NOR
Component: general
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: kf5
SUMMARY
Im getting an error while scanning my music folder.
STEPS TO REPRODUCE
1. Have following folders with music in them:
$ stat * -t
AM 4096 8 41ed 1000 1000 fe00 3309571 2 0 0 0 -3600 1600607230 1600607229 4096
Tranquility Base Hotel & Casino 4096 8 41ed 1000 1000 fe00 3309570 2 0 0 0
-3600 1600607088 1600607087 4096
2. have your collection directory point to a root which includes these folders
3. use tools > update collections
OBSERVED RESULT
crashes with:
MySQLe query failed! (1264) Out of range value for column 'changedate' at row 1
on INSERT INTO directories(deviceid,changedate,dir) VALUES
(3,4294963696,'Music/Arctic Monkeys/AM');
MySQLe query failed! (1264) Out of range value for column 'changedate' at row 1
on INSERT INTO directories(deviceid,changedate,dir) VALUES
(3,4294963696,'Music/Arctic Monkeys/Tranquility Base Hotel & Casino');
the songs from these folders are not in the library
EXPECTED RESULT
should add the songs to the collection without error
SOFTWARE/OS VERSIONS
archlinux 5.8.10-arch1-1 #1 SMP PREEMPT Thu, 17 Sep 2020 18:01:06 +0000 x86_64
GNU/Linux
KDE Plasma Version: plasmashell 5.19.5
Qt: 5.15.1
KDE Frameworks: 5.74.0
--
You are receiving this mail because:
You are watching all bug changes.
