https://bugs.kde.org/show_bug.cgi?id=426807
Raphaël G. <k...@rapsys.eu> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |k...@rapsys.eu
Ever confirmed|0 |1
Status|REPORTED |CONFIRMED
--- Comment #4 from Raphaël G. <k...@rapsys.eu> ---
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/<user>/Musique/<path>')
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/<user>/Musique/<path>')
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/<user>/Musique/<path>':
drwxr-xr-x 1 <user> <user> 3.8K Dec 31 1969
LC_ALL=C stat '/home/<user>/Musique/<path>'
File: /home/<user>/Musique/<path>
Size: 3872 Blocks: 0 IO Block: 4096 directory
Device: 0,39 Inode: 270513 Links: 1
Access: (0755/drwxr-xr-x) Uid: ( <uid>/ <user>) Gid: ( <uid>/ <user>)
Access: 2024-02-15 21:54:41.937300905 +0000
Modify: 1969-12-31 23:00:00.000000000 +0000
Change: 2024-01-12 18:40:54.232067829 +0000
Birth: 2024-01-12 16:40:52.050847188 +0000
--
You are receiving this mail because:
You are watching all bug changes.
