Another oddity is that sometimes the spotify tracks are added to the dynamicplaylist_history table with an incorrect id (large negative number). The insert seems to be done here
my $sth = $dbh->prepare( "INSERT INTO dynamicplaylist_history (client,id,url,added,skipped) values (?,".$track->id.", ?, ".$addedTime.",".$skipped.")" ); So it would see something is wrong with the track object, the url is always correct though. I suspect the only problematic behaviour this could cause is that tracks could be played twice. Dump of dynamicplaylist_history table client,position,id,url,added,skipped "a0:c5:89:a4:80:3a","145","290","file:///music/Catherine_Wheel/Ferment/06-Shallow.mp3","1609671471","0" "a0:c5:89:a4:80:3a","146","261","file:///music/Belle_and_Sebastian/The_Boy_with_the_Arab_Strap/03-Is_It_Wicked_Not_to_Care.mp3","1609671471","0" "a0:c5:89:a4:80:3a","147","526","spotify:track:1oblFfkg4d9hWVMQU1c7NW","1609671471","0" "a0:c5:89:a4:80:3a","148","322","file:///music/The_Charlatans/Over_Rising/2-Way_Up_There.mp3","1609671471","0" "a0:c5:89:a4:80:3a","149","330","file:///music/The_Jesus_and_Mary_Chain/Automatic/02-Coast_to_Coast.mp3","1609671471","0" "a0:c5:89:a4:80:3a","150","-94324255552160","spotify:track:3JhqGTUex2ob29p2JzxjPW","1609671471","0" "a0:c5:89:a4:80:3a","151","297","file:///music/Catherine_Wheel/I_Want_To_Touch_You/1-I_Want_To_Touch_You.mp3","1609671471","0" "a0:c5:89:a4:80:3a","152","356","file:///music/The_Railway_Children/Reunion_Wilderness/04-Careful.mp3","1609671471","0" "a0:c5:89:a4:80:3a","153","-94324255647288","spotify:track:3LTW2YfXpslc5PXPVv4cut","1609671471","0" "a0:c5:89:a4:80:3a","154","274","file:///music/Belle_and_Sebastian/Tigermilk/04-You%27re_Just_a_Baby.mp3","1609671471","0" "a0:c5:89:a4:80:3a","155","346","file:///music/The_Jesus_and_Mary_Chain/Honey%27s_Dead/06-Tumbledown.mp3","1609671531","0" "a0:c5:89:a4:80:3a","156","320","file:///music/The_Charlatans/Isolation_21.2.91/12-Between_10th_And_11th.mp3","1609671531","0" "a0:c5:89:a4:80:3a","157","304","file:///music/Catherine_Wheel/Painful_Thing/4-I_Want_To_Touch_You.mp3","1609671531","0" "a0:c5:89:a4:80:3a","158","307","file:///music/Catherine_Wheel/She%27s_My_Friend/3-Wish.mp3","1609671531","0" "a0:c5:89:a4:80:3a","159","-94324255678024","spotify:track:2drtd6SptpMJ1KylMQ7mrE","1609671531","0" "a0:c5:89:a4:80:3a","160","343","file:///music/The_Jesus_and_Mary_Chain/Honey%27s_Dead/03-Far_Gone_and_Out.mp3","1609671531","0" "a0:c5:89:a4:80:3a","161","611","spotify:track:34n2YY1Cbz4zxb3k1Fy4W6","1609671531","0" "a0:c5:89:a4:80:3a","162","-94324273035488","spotify:track:4FshsnilOPi1ER1P8Iihrx","1609671531","0" "a0:c5:89:a4:80:3a","163","280","file:///music/Belle_and_Sebastian/Tigermilk/10-Mary_Jo.mp3","1609671786","0" "a0:c5:89:a4:80:3a","164","-94324274286488","spotify:track:4A2OuywV9m5FS6g4Z0BizY","1609672008","0" "a0:c5:89:a4:80:3a","165","600","spotify:track:1no87hV1zqsHR4Ej1029Gj","1609672258","0" "a0:c5:89:a4:80:3a","166","534","spotify:track:2aAz3rX2PvxNprxIVXNYpi","1609672258","0" "a0:c5:89:a4:80:3a","167","623","spotify:track:3NEeKJm8LcdaDG98oZwSZx","1609672452","0" "a0:c5:89:a4:80:3a","168","589","spotify:track:3kT4PCJknuAGQsu6PYFpjj","1609672757","0" "a0:c5:89:a4:80:3a","169","-94324255552160","spotify:track:3JhqGTUex2ob29p2JzxjPW","1609672953","0" "a0:c5:89:a4:80:3a","170","545","spotify:track:7flddd1C83qKY0PFqoU0bt","1609673233","0" "a0:c5:89:a4:80:3a","171","605","spotify:track:2qkOCCITKSDI4f8kflTq5T","1609673233","0" "a0:c5:89:a4:80:3a","172","272","file:///music/Belle_and_Sebastian/Tigermilk/02-Expectations.mp3","1609673403","0" "a0:c5:89:a4:80:3a","173","608","spotify:track:0gMOWmnILhS3D965LCeaCh","1609673663","0" ------------------------------------------------------------------------ mhsparks's Profile: http://forums.slimdevices.com/member.php?userid=64142 View this thread: http://forums.slimdevices.com/showthread.php?t=49483 _______________________________________________ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
