https://bugs.kde.org/show_bug.cgi?id=405241
Bug ID: 405241
Summary: MySQLe error when importing directory with far future
modification / changedate
Product: amarok
Version: 2.9.0
Platform: Archlinux Packages
OS: Linux
Status: REPORTED
Severity: normal
Priority: NOR
Component: Collections/Local
Assignee: amarok-bugs-d...@kde.org
Reporter: spa...@gmail.com
CC: ma...@laitl.cz, ralf-eng...@gmx.de
Target Milestone: kf5
SUMMARY
Attempting to import a directory with a modification date in the far future
(threshold somewhere between 2022 and 2042) yields a mysql range error.
STEPS TO REPRODUCE
1. set folder mtime to 2042 or later
2. add folder to local collection
3. scan
OBSERVED RESULT
MySQLe query failed! (1264) Out of range value for column 'changedate' at row 1
on INSERT INTO directories(deviceid,changedate,dir) VALUES
(1,3136466608,'path/to/future/directory');
EXPECTED RESULT
successful import
SOFTWARE/OS VERSIONS
Qt Version: 5.12.1
Frameworks Version: 5.55.0
Operating System: Linux 5.0.0-arch1-1-ARCH x86_64
Distribution (Platform): Archlinux Packages
--
You are receiving this mail because:
You are watching all bug changes.
