| Summary: | MySQL error while adding music to collection | ||
|---|---|---|---|
| Product: | [Applications] amarok | Reporter: | momo <momo.cao> |
| Component: | Collections/Local | Assignee: | Amarok Bugs <amarok-bugs-null> |
| Status: | RESOLVED DUPLICATE | ||
| Severity: | normal | CC: | ralf-engels, tuomas |
| Priority: | NOR | ||
| Version First Reported In: | 3.1.0 | ||
| Target Milestone: | kf5 | ||
| Platform: | Arch Linux | ||
| OS: | Linux | ||
| Latest Commit: | Version Fixed In: | ||
| Sentry Crash Report: | |||
| Attachments: | logfile | ||
Thank you for the report! Seems that the modification timestamp for the files, 2147483648 is in year 2038, so I believe this one is a duplicate of https://bugs.kde.org/show_bug.cgi?id=426807 - a previously known bug of files modified after year 2038 getting rejected during collection scan. *** This bug has been marked as a duplicate of bug 426807 *** |
Created attachment 172313 [details] logfile SUMMARY I am trying to add some music to my collection and getting a MySQL error when scanning the folders. STEPS TO REPRODUCE 1. Find some mp3 file 2. Add to collection 3. Get warning dialog OBSERVED RESULT Dialog saying MySQLe query failed! (1264) Out of range value for column 'changedate' at row 1 on INSERT INTO directories(deviceid,changedate,dir) VALUES (1,2147483648,'home/momocao/Música/metroid-prime-fusion-original-soundtracks/CD 1'); MySQLe query failed! (1264) Out of range value for column 'changedate' at row 1 on INSERT INTO directories(deviceid,changedate,dir) VALUES (1,2147483648,'home/momocao/Música/metroid-prime-fusion-original-soundtracks/CD 2'); EXPECTED RESULT Music added to collection. SOFTWARE/OS VERSIONS Operating System: Arch Linux KDE Plasma Version: 6.1.3 KDE Frameworks Version: 6.4.0 Qt Version: 6.7.2 Kernel Version: 6.10.2-arch1-1 (64-bit) Graphics Platform: Wayland ADDITIONAL INFORMATION You can find the output of amarok --debug in the file attached.