[prev in list] [next in list] [prev in thread] [next in thread] 

List:       amarok-bugs-dist
Subject:    [amarok] [Bug 405241] New: MySQLe error when importing directory with far future modification / chan
From:       "Clarence Risher" <bugzilla_noreply () kde ! org>
Date:       2019-03-08 20:06:21
Message-ID: bug-405241-71684 () http ! bugs ! kde ! org/
[Download RAW message or body]

https://bugs.kde.org/show_bug.cgi?id=405241

            Bug ID: 405241
           Summary: MySQLe error when importing directory with far future
                    modification / changedate
           Product: amarok
           Version: 2.9.0
          Platform: Archlinux Packages
                OS: Linux
            Status: REPORTED
          Severity: normal
          Priority: NOR
         Component: Collections/Local
          Assignee: amarok-bugs-dist@kde.org
          Reporter: sparr0@gmail.com
                CC: matej@laitl.cz, ralf-engels@gmx.de
  Target Milestone: kf5

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

-- 
You are receiving this mail because:
You are the assignee for the bug.=
[prev in list] [next in list] [prev in thread] [next in thread]