Latest Media Handler v2.4.X.000 (2 Viewers)

[joEhSuper]

Good morning!
Will do so in the afternoon/evening (now at work )

 

[ajs]

Will do so in the afternoon/evening (now at work )

That this version (on the way to work, an idea)
Check as:

1. Run MP
2. Check latests
3. if not populated play any music track
4. stop music playing
5. Wait
6. Check latests
7. if not populated give me MP and LMH Debug log.

 

[joEhSuper]

Hi @ajs !
Took https://forum.team-mediaportal.com/attachments/latestmediahandler-20151113-04-debug-zip.171758/ but same behaviour as before only one = first entry visible...

 

[ajs]

no idea why?

but same behaviour as before only one = first entry visible...

MP return:

13-Nov-2015 16:49:19 Debug [  LatestMusicHandler]: GetLatestMusic: Mode: Latest Played Music Received: 1 songs.
13-Nov-2015 16:49:19 Debug [  LatestMusicHandler]: *** GetLatestMusic: [ ] AlbumArtist: Various Artists Album: Trainspotting #2 Date: /12.11.2015 23:09:11 sPath: 1129 Genre:Soundtrack
13-Nov-2015 16:49:19 Debug [  LatestMusicHandler]: *** GetLatestMusic: Key: Various Artists#Trainspotting #2#mp3 - False

MP back one line (Received: 1 songs). I do not know why. LMH Select returns 10 rows.

strAlbumArtist    strAlbum    strFileType    dateAdded    iTimesPlayed    dateLastPlayed    strGenre    strPath    strLyrics
| Darryl Purpose |         mp3    2015-08-25 16:05:13    4    2015-07-28 20:29:36    |  |    F:\Musiksammlung\22_Männer\_sonstige\Darryl Purpose - Right Side Of Zero.mp3    Darryl Purpose was a late arrival to the folk explosion of the 1990s. By the time he became a full-time folk singer in 1996, the competition among acoustic troubadours scrambling to find a place in the wake left by monster success stories like Tracy Chapman, Shawn Colvin, and the Indigo Girls was intense and daunting. But folk music is, after all, a storytelling genre. And when Purpose did finally hit the folk scene, he came with an unusually eclectic resume that provided him with a wealth of compelling stories to tell. His songs, which have drawn liberally from his experiences as a highly regarded professional blackjack player and a well-traveled peace activist, garnered considerable attention from the outset of his career. After the 1996 release of his debut album, Right Side of Zero, Purpose began an impressive prize-inning run in songwriting contests around the country. His sophomore effort, a one-take acoustic recording with violinist Daryl S., was released in December of 1997 with the title darryl PURPOSE; it was later reissued as Same River Twice. By the time he recorded his third album, Traveler's Code in 1999, Purpose had made enough of an impact in American folk circles to score guest appearances from well-established artists like Ellis Paul, David Miner, and Lucy Kaplansky. The confident, rich Crooked Line appeared in summer 2001, followed by the Christmas release Gift of the Magi in 2002.
| Brüder, Die |         wma    2015-06-04 16:20:50    2    2015-06-11 12:37:42    |  |    F:\Musiksammlung\35_Hard\_Sonstiges\Die Brüder - last ray of sunshine.wma   
| Madonna |         mp3    2015-06-04 16:30:35    2    2015-07-22 12:27:53    |  |    F:\Musiksammlung\21_Frauen\Madonna\Music\Madonna - American Pie (Full Version).mp3    [INVALID_DATA]
| Märchen |     056/Der kleine Muck    mp3    2015-06-04 16:23:04    2    2015-06-24 01:18:43    | Miscellaneous |    F:\Musiksammlung\85_Märchen\Der kleine Muck\01 - Der kleine Muck.mp3   
| Ulla Meinecke |     Hommage an Reinhard Mey    mp3    2015-06-04 16:25:03    2    2015-09-19 00:56:19    | Liedermacher |    F:\Musiksammlung\10_Deutschsprachig\Reinhard Mey\Hommage an Reinhard Mey\209. Ulla Meinecke - Der Mörder ist immer der Gärtner.mp3    Born in 1953 in Usingen/Taunus, Germany, self-described "rock poet" Ulla Meinecke has spent much of her career shaping, deconstructing, and ultimately delivering the complexities of love from a distinctly female perspective. Her albums include Von Toten Tigern und Nassen Katzen, Meinecke Fuchs, Uberdosis Grosstadt, Nachtelang, Löwen, Die Luft Ist Rein, and (most recently) Ulla Meinecke -- Das Album.
| Various Artists |     Cruel Intentions    mp3    2015-06-04 16:21:07    1    2015-07-22 11:22:36    |  |||  |||  |||  |||  |||  |||  |||  |||  |||  |||  |||  |||  |||  |    F:\Musiksammlung\50_OST & Musical\Eiskalte Engel (Cruel Intentions)\01. Placebo - Every You Every Me (Single Mix).mp3|F:\Musiksammlung\50_OST & Musical\Eiskalte Engel (Cruel Intentions)\02. Fatboy Slim - Praise You (Radio Edit).mp3|F:\Musiksammlung\50_OST & Musical\Eiskalte Engel (Cruel Intentions)\03. Blur - Coffee & TV.mp3|F:\Musiksammlung\50_OST & Musical\Eiskalte Engel (Cruel Intentions)\04. Day One - Bedroom Dancing (First Recording).mp3|F:\Musiksammlung\50_OST & Musical\Eiskalte Engel (Cruel Intentions)\05. Counting Crows - Colorblind.mp3|F:\Musiksammlung\50_OST & Musical\Eiskalte Engel (Cruel Intentions)\06. Kristen Barry - Ordinary Life.mp3|F:\Musiksammlung\50_OST & Musical\Eiskalte Engel (Cruel Intentions)\07. Marcy Playground - Comin' Up From Behind.mp3|F:\Musiksammlung\50_OST & Musical\Eiskalte Engel (Cruel Intentions)\08. Skunk Anansie - Secretly.mp3|F:\Musiksammlung\50_OST & Musical\Eiskalte Engel (Cruel Intentions)\09. Craig Armstrong - This Love (featuring Elizabeth Fraser).mp3|F:\Musiksammlung\50_OST & Musical\Eiskalte Engel (Cruel Intentions)\10. Aimee Mann - You Could Make a Killing.mp3|F:\Musiksammlung\50_OST & Musical\Eiskalte Engel (Cruel Intentions)\11. Faithless - Addictive.mp3|F:\Musiksammlung\50_OST & Musical\Eiskalte Engel (Cruel Intentions)\12. Abra Moore - Trip On Love.mp3|F:\Musiksammlung\50_OST & Musical\Eiskalte Engel (Cruel Intentions)\13. Bare Junior - You Blew Me Off.mp3|F:\Musiksammlung\50_OST & Musical\Eiskalte Engel (Cruel Intentions)\14. The Verve - Bitter Sweet Symphony.mp3    [INVALID_DATA]
| Pink Floyd |     Dark Side Of The Moon    mp3    2015-06-04 16:28:26    1    2015-08-26 17:39:46    |  |||  |||  |||  |||  |||  |||  |||  |||  |    F:\Musiksammlung\20_Gruppen\Pink Floyd\Dark Side Of The Moon\01. Pink Floyd - a) Speak To Me - b) Breathe In The Air.mp3|F:\Musiksammlung\20_Gruppen\Pink Floyd\Dark Side Of The Moon\02. Pink Floyd - On The Run.mp3|F:\Musiksammlung\20_Gruppen\Pink Floyd\Dark Side Of The Moon\03. Pink Floyd - Time.mp3|F:\Musiksammlung\20_Gruppen\Pink Floyd\Dark Side Of The Moon\04. Pink Floyd - The Great Gig In The Sky.mp3|F:\Musiksammlung\20_Gruppen\Pink Floyd\Dark Side Of The Moon\05. Pink Floyd - Money.mp3|F:\Musiksammlung\20_Gruppen\Pink Floyd\Dark Side Of The Moon\06. Pink Floyd - Us And Them.mp3|F:\Musiksammlung\20_Gruppen\Pink Floyd\Dark Side Of The Moon\07. Pink Floyd - Any Colour You Like.mp3|F:\Musiksammlung\20_Gruppen\Pink Floyd\Dark Side Of The Moon\08. Pink Floyd - Brain Damage.mp3|F:\Musiksammlung\20_Gruppen\Pink Floyd\Dark Side Of The Moon\09. Pink Floyd - Eclipse.mp3    [INVALID_DATA]
| Eros Ramazzotti |     Cuori Agitati    mp3    2015-06-04 16:36:57    1    2015-08-25 19:42:56    |  |||  |||  |||  |||  |||  |||  |||  |||  |||  |    F:\Musiksammlung\45_Italia\Eros Ramazzotti\Cuori Agitati\01 - Eros Ramazzotti - Cuori Agitati.mp3|F:\Musiksammlung\45_Italia\Eros Ramazzotti\Cuori Agitati\02 - Eros Ramazzotti - Respiro Nel Blu.mp3|F:\Musiksammlung\45_Italia\Eros Ramazzotti\Cuori Agitati\03 - Eros Ramazzotti - Buongiorno Bambina.mp3|F:\Musiksammlung\45_Italia\Eros Ramazzotti\Cuori Agitati\04 - Eros Ramazzotti - Ora.mp3|F:\Musiksammlung\45_Italia\Eros Ramazzotti\Cuori Agitati\05 - Eros Ramazzotti - Volare Navigare Camminare.mp3|F:\Musiksammlung\45_Italia\Eros Ramazzotti\Cuori Agitati\06 - Eros Ramazzotti - Una Storia Importante.mp3|F:\Musiksammlung\45_Italia\Eros Ramazzotti\Cuori Agitati\07 - Eros Ramazzotti - Quando L'amore.mp3|F:\Musiksammlung\45_Italia\Eros Ramazzotti\Cuori Agitati\08 - Eros Ramazzotti - Dritto Per Quel L'unica Via.mp3|F:\Musiksammlung\45_Italia\Eros Ramazzotti\Cuori Agitati\09 - Eros Ramazzotti - Libertà Libertà.mp3|F:\Musiksammlung\45_Italia\Eros Ramazzotti\Cuori Agitati\10 - Eros Ramazzotti - Terra Promessa.mp3    [INVALID_DATA]
| Eric Clapton |     Just One Night (Disc 2)    mp3    2015-06-04 16:32:20    1    2015-08-24 12:34:31    | Rock ||| Rock ||| Rock ||| Rock ||| Rock ||| Rock |    F:\Musiksammlung\22_Männer\Eric Clapton\Just One Night\2-01 Double Trouble.mp3|F:\Musiksammlung\22_Männer\Eric Clapton\Just One Night\2-02 Setting Me Up.mp3|F:\Musiksammlung\22_Männer\Eric Clapton\Just One Night\2-03 Blues Power.mp3|F:\Musiksammlung\22_Männer\Eric Clapton\Just One Night\2-04 Rambling On My Mind.mp3|F:\Musiksammlung\22_Männer\Eric Clapton\Just One Night\2-05 Cocaine.mp3|F:\Musiksammlung\22_Männer\Eric Clapton\Just One Night\2-06 Further On Up the Road.mp3    [INVALID_DATA]
| George Winston |     Autumn    mp3    2015-06-04 16:39:16    1    2015-06-09 20:13:24    | Meditative ||| Meditative ||| Meditative ||| Meditative ||| Meditative ||| Meditative ||| Meditative |    F:\Musiksammlung\65_Meditation & Instrumental\George Winston\Autumn\01 - George Winston - ColorsDance.mp3|F:\Musiksammlung\65_Meditation & Instrumental\George Winston\Autumn\02 - George Winston - Woods.mp3|F:\Musiksammlung\65_Meditation & Instrumental\George Winston\Autumn\03 - George Winston - LongingLove.mp3|F:\Musiksammlung\65_Meditation & Instrumental\George Winston\Autumn\04 - George Winston - Road.mp3|F:\Musiksammlung\65_Meditation & Instrumental\George Winston\Autumn\05 - George Winston - Moon.mp3|F:\Musiksammlung\65_Meditation & Instrumental\George Winston\Autumn\06 - George Winston - Sea.mp3|F:\Musiksammlung\65_Meditation & Instrumental\George Winston\Autumn\07 - George Winston - Stars.mp3    George Winston grew up mainly in Montana, and also spent his formative years in Mississippi and Florida. During this time, his favorite music was instrumental rock and instrumental R&B, including Floyd Cramer, the Ventures, Booker T & The MG's, Jimmy Smith, and many more. Inspired by R&B, jazz, Blues and rock (especially the Doors), George began playing organ in 1967. In 1971 he switched to the acoustic piano after hearing recordings from the 1920s and the 1930s by the legendary stride pianists Thomas "Fats" Waller and the late Teddy Wilson. In addition to working on stride piano, he also at this time came up with this own style of melodic instrumental music on solo piano, called folk piano. In 1972, he recorded his first solo piano album, BALLADS AND BLUES 1972, for the late guitarist John Fahey's Takoma label.  His latest solo piano release is LOVE WILL COME - THE MUSIC OF VINCE GUARALDI, VOL. 2 (to be released 2/2/10), which features compositions by the late jazz pianist, including pieces from the Peanuts® TV specials.  Since 1980 George has released ten other solo piano albums: AUTUMN (1980), WINTER INTO SPRING (1982), DECEMBER (1982), SUMMER (1991), FOREST (1994), LINUS & LUCY-THE MUSIC OF VINCE GUARALDI (1996), which features compositions by the late jazz pianist, including Cast Your Fate to the Wind and pieces from the Peanuts® TV specials; PLAINS (1999), which was inspired by his Eastern Montana upbringing, NIGHT DIVIDES THE DAY - THE MUSIC OF THE DOORS (2002), and MONTANA - A LOVE STORY (2004) and GULF COAST BLUES & IMPRESSIONS - A HURRICANE RELIEF BENEFIT (2006).   Also, in 2001 George released REMEMBRANCE - A MEMORIAL BENEFIT, a six song CD of piano, guitar and harmonica solos, to benefit those affected by 9/11.  He has also worked with the late George Levenson of Informed Democracy (www.informeddemocracy.com) on three projects: a solo guitar soundtrack for SADAKO AND THE THOUSAND PAPER CRANES, and soundtracks of piano, guitar and, harmonica solos for PUMPKIN CIRCLE, and BREAD COMES TO LIFE. In 1984 he also did the solo piano soundtrack for the children's story THE VELVETEEN RABBIT for Rabbit Ears Productions.  George is presently concentrating mainly on live  performances, and most of the time he is touring playing solo piano concerts (the Summer Show or the Winter Show), solo guitar concerts, solo harmonica concerts, and solo piano dances (with R&B and slow dance songs).   He is also studying the playing of the great New Orleans pianists Henry Butler, James Booker, Professor Longhair, Dr. John, and Jon Cleary, and he is also working on interpreting pieces on solo piano by his favorite composers, including Vince Guaraldi, Professor Longhair, the Doors, Frank Zappa, Randy Newman, Sam Cooke, Curtis Mayfield, Laura Nyro, Al Kooper, Dr. John, Henry Butler, James Booker, Jon Cleary, Ralph Towner, Arthur Lee, Milt Jackson, John Hartford, Oliver Schroer, Taj Mahal, Philip Aaberg, and others, to play at concerts, and at his solo piano dances.  George is also working on solo guitar and is recording the masters of the Hawaiian Slack Key guitar for an extensive series of albums for Dancing Cat Records (www.dancingcat.com). Slack Key is the name for the beautiful solo fingerstyle guitar tradition, unique to Hawaii, which began in the early 1800s and predated the steel guitar by over half a century. He is also recording his main inspirations for his harmonica playing, Sam Hinton, Rick Epping, and Curt Bouterse.

@Developers @hwahrmann
No idea why?
Select:

[2015-11-13 16:48:54,073] [Log    ] [RefreshWorker-LatestMediaHandler.LatestMusicHandler] [DEBUG] - MusicDatabase: GetSongsByFilter - SQL: SELECT strAlbumArtist, strAlbum, strFileType, dateAdded, iTimesPlayed, dateLastPlayed, strGenre, strPath, (SELECT strAMGBio FROM artistinfo WHERE LOWER(TRIM(T.strAlbumArtist,'| ')) = LOWER(TRIM(strArtist))) AS strLyrics FROM (SELECT strAlbumArtist, strAlbum, strFileType, MAX(dateAdded) AS dateAdded, CAST(ROUND(AVG(iTimesPlayed)) AS INTEGER) AS iTimesPlayed, MAX(dateLastPlayed) AS dateLastPlayed, GROUP_CONCAT(strGenre,'|') AS strGenre, GROUP_CONCAT(strPath,'|') AS strPath FROM tracks WHERE strAlbumArtist IS NOT null AND TRIM(strAlbumArtist) <> '' GROUP BY strAlbumArtist, strAlbum, strFileType ORDER BY dateLastPlayed DESC LIMIT 10) AS T, Filter: tracks
[2015-11-13 16:48:54,105] [Log    ] [RefreshWorker-LatestMediaHandler.LatestPictureHandler] [INFO ] - SQLiteClient: Closing database: PictureDatabase.db3

 

[hwahrmann]

Sorry guys. Can't confirm.
Using Latest Git Build, which is Mp 1.13-Pre with the dll posted 2 posts above.

 

[joEhSuper]

no idea why?

All I can say is: wit 3.2.0.42 (and older versions) there is no problem...

 

[Hawkeye]

Hi @ajs, at the moment I try my luck creating a mod for Apollo. Here I'd like to have 4 latest media tiles (series and movies/videos). Would you be so kind to add a fourth item for those?

EDIT: Another thing: As the screenshot of the latest seasons and series by @catavolt here shows, the value for

#latestMediaHandler.tvseries.latest[1,2,3(,4 if you add it ;))].episodeName

is empty for latest seasons and equal to the series title for latest series. I know that it says latest seasons/series and thus no episode name should be needed but I thought it should be used to have episodes from distinct seasons/series only.
So I suggest to have

#latestMediaHandler.tvseries.latest[1,2,3,4].episodeName

filled by the name of either the latest or better the first unwatched episode of the season/series if that's possible ...

 

[ajs]

Sorry guys. Can't confirm.

I just do not have such problems. But why the media portal (m_db.GetSongsByFilter(sqlQuery, out songInfo, "tracks") returns a single row instead of 10.? Can have any ideas?

PS: I put @joEhSuper music database to my test comp. and get:

GetSongsByFilter - It does not return an incorrect result.

Here I'd like to have 4 latest media tiles (series and movies/videos).

No problem.

filled by the name of either the latest

No problem.
Try

 

[ajs]

All I can say is: wit 3.2.0.42 (and older versions) there is no problem...

Musically module changes I made in the 47 build.

 

[ajs]

@joEhSuper
Try and get me LMH debug log.