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: amarok-bugs-d...@kde.org Reporter: th...@kogge.net 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.