[amarok] [Bug 426807] Out of range changedate prevents importing music folder
https://bugs.kde.org/show_bug.cgi?id=426807 --- Comment #5 from Raphaël G. --- Same bug as https://bugs.kde.org/show_bug.cgi?id=405241 too, which was invalidly closed as invalid. Amarok should support out of timestamp range creation/modification dates. -- You are receiving this mail because: You are watching all bug changes.
[amarok] [Bug 426807] Out of range changedate prevents importing music folder
https://bugs.kde.org/show_bug.cgi?id=426807 Raphaël G. changed: What|Removed |Added CC||k...@rapsys.eu Ever confirmed|0 |1 Status|REPORTED|CONFIRMED --- Comment #4 from Raphaël G. --- SUMMARY I set amarok to use my mariadb server at localhost. I get a sql error in the /var/lib/mysql/sql_error.log when amarok update the collection: 2024-02-15 22:14:22 amarok[amarok] @ localhost [] ERROR 1264: Out of range value for column 'changedate' at row 1 : INSERT INTO directories(deviceid,changedate,dir) VALUES (1,4294963696,'home//Musique/') STEPS TO REPRODUCE 1. Create directory with such timestamps 2. Update collection 3. See error in sql error log FIX SUGGESTION Change changedate from int(11) to datetime ? OBSERVED RESULT ERROR 1264: Out of range value for column 'changedate' at row 1 : INSERT INTO directories(deviceid,changedate,dir) VALUES (1,4294963696,'home//Musique/') EXPECTED RESULT No error SOFTWARE/OS VERSIONS Windows: macOS: Linux/KDE Plasma: (available in About System) KDE Plasma Version: KDE Frameworks Version: Qt Version: ADDITIONAL INFORMATION LC_ALL=C l -ldh '/home//Musique/': drwxr-xr-x 1 3.8K Dec 31 1969 LC_ALL=C stat '/home//Musique/' File: /home//Musique/ Size: 3872Blocks: 0 IO Block: 4096 directory Device: 0,39Inode: 270513 Links: 1 Access: (0755/drwxr-xr-x) Uid: ( / ) Gid: ( / ) Access: 2024-02-15 21:54:41.937300905 + Modify: 1969-12-31 23:00:00.0 + Change: 2024-01-12 18:40:54.232067829 + Birth: 2024-01-12 16:40:52.050847188 + -- You are receiving this mail because: You are watching all bug changes.
[amarok] [Bug 426807] Out of range changedate prevents importing music folder
https://bugs.kde.org/show_bug.cgi?id=426807 Heiko Becker changed: What|Removed |Added CC||heire...@exherbo.org --- Comment #3 from Heiko Becker --- stat without "-t" would have been nicer, but assuming you have the same implementation as I do, the change date of the file is the unix epoch minus 3600 seconds, which overflows somewhere to 4294963696 secs since the epoch, which is a bit in the future: "Sun 7 Feb 06:28:16 CET 2106" 1) Obviously this should be handled more robustly and 2) it also looks like Amarok has a year 2038 problem because the maximum value of mysql's INTEGER is 2147483647. -- You are receiving this mail because: You are watching all bug changes.
[amarok] [Bug 426807] Out of range changedate prevents importing music folder
https://bugs.kde.org/show_bug.cgi?id=426807 --- Comment #2 from th...@kogge.net --- A 'touch *' fixes the issue -- You are receiving this mail because: You are watching all bug changes.
[amarok] [Bug 426807] Out of range changedate prevents importing music folder
https://bugs.kde.org/show_bug.cgi?id=426807 --- Comment #1 from th...@kogge.net --- Additional info: $ stat * -tf AM 2c6731a50772e064 255 ef53 4096 4096 29277940 7414595 6095503 7454720 6240792 Tranquility Base Hotel & Casino 2c6731a50772e064 255 ef53 4096 4096 29277940 7414595 6095503 7454720 6240792 -- You are receiving this mail because: You are watching all bug changes.
