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
And why would this be an Amarok error? I don't really see the point of having fake modification dates, especially in the future.
Dear Bug Submitter, This bug has been in NEEDSINFO status with no change for at least 15 days. Please provide the requested information as soon as possible and set the bug status as REPORTED. Due to regular bug tracker maintenance, if the bug is still in NEEDSINFO status with no change in 30 days the bug will be closed as RESOLVED > WORKSFORME due to lack of needed information. For more information about our bug triaging procedures please read the wiki located here: https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging If you have already provided the requested information, please mark the bug as REPORTED so that the KDE team knows that the bug is ready to be confirmed. Thank you for helping us make KDE software even better for everyone!
This bug has been in NEEDSINFO status with no change for at least 30 days. The bug is now closed as RESOLVED > WORKSFORME due to lack of needed information. For more information about our bug triaging procedures please read the wiki located here: https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging Thank you for helping us make KDE software even better for everyone!