Bug 491321 - MySQL error while adding music to collection
Summary: MySQL error while adding music to collection
Status: RESOLVED DUPLICATE of bug 426807
Alias: None
Product: amarok
Classification: Applications
Component: Collections/Local (show other bugs)
Version: 3.1.0
Platform: Arch Linux Linux
: NOR normal
Target Milestone: kf5
Assignee: Amarok Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-08-05 18:34 UTC by momo
Modified: 2024-08-06 19:14 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In:
Sentry Crash Report:


Attachments
logfile (8.76 KB, text/plain)
2024-08-05 18:34 UTC, momo
Details

Note You need to log in before you can comment on or make changes to this bug.
Description momo 2024-08-05 18:34:36 UTC
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.
Comment 1 Tuomas Nurmi 2024-08-06 19:14:15 UTC
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 ***