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

List:       amarok-bugs-dist
Subject:    [amarok] [Bug 426807] New: Out of range changedate prevents importing music folder
From:       bugzilla_noreply () kde ! org
Date:       2020-09-21 10:42:08
Message-ID: bug-426807-71684 () http ! bugs ! kde ! org/
[Download RAW message or body]

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

            Bug ID: 426807
           Summary: Out of range changedate prevents importing music
                    folder
           Product: amarok
           Version: 2.9.0
          Platform: Other
                OS: Linux
            Status: REPORTED
          Severity: normal
          Priority: NOR
         Component: general
          Assignee: amarok-bugs-dist@kde.org
          Reporter: thilo@kogge.net
  Target Milestone: kf5

SUMMARY

Im getting an error while scanning my music folder.


STEPS TO REPRODUCE
1.  Have following folders with music in them:
$ stat * -t
AM 4096 8 41ed 1000 1000 fe00 3309571 2 0 0 0 -3600 1600607230 1600607229 4096
Tranquility Base Hotel & Casino 4096 8 41ed 1000 1000 fe00 3309570 2 0 0 0
-3600 1600607088 1600607087 4096

2. have your collection directory point to a root which includes these folders
3. use tools > update collections  

OBSERVED RESULT
 crashes with: 
MySQLe query failed! (1264) Out of range value for column 'changedate' at row 1
on INSERT INTO directories(deviceid,changedate,dir) VALUES
(3,4294963696,'Music/Arctic Monkeys/AM');
MySQLe query failed! (1264) Out of range value for column 'changedate' at row 1
on INSERT INTO directories(deviceid,changedate,dir) VALUES
(3,4294963696,'Music/Arctic Monkeys/Tranquility Base Hotel & Casino');

the songs from these folders are not in the library

EXPECTED RESULT
should add the songs to the collection without error

SOFTWARE/OS VERSIONS
archlinux 5.8.10-arch1-1 #1 SMP PREEMPT Thu, 17 Sep 2020 18:01:06 +0000 x86_64
GNU/Linux
KDE Plasma Version: plasmashell 5.19.5
Qt: 5.15.1
KDE Frameworks: 5.74.0

-- 
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]