RadioDJ v2.0.2.0 Beta Released!

[Anderson Clayton]

repeat tracks, for sure it's a net framework, I've done these tests,

[DJ Garybaldy]

I've come across a problem and I don't know if its happening to anyone else...

Played one rotation and I noticed the tracks weren't being marked as played, Yet when it switched to another rotation its marking the songs as played.

I've ran a repair/optimise I've also gone into the database and manually deleted the rotation that was causing the repeating artists I will rebuild that tomorrow and see what comes of it.

I'm wondering its it time to actually rebuild the database from Scratch again or not.

[Jhonny]

RDJ stop with playing on a artist played update. screen on black.

Database Insert Error: FUNCTION radiodj2020.REGEXP_INSTR does not exist (CALL UpdateTracks2(4498,'Charles Aznavour','Yesterday When I Was Young',0,0,30,0.1);
UPDATE `songs` SET `artist_played`=NOW() WHERE REGEXP_INSTR(songs.associated_artists, '\\b(Charles Aznavour)\\b');
)

 

[znmd]

Seems that REST server is still unable to load track to RadioDJ playlist. It returns an 400 error code if I try

[Brodephat]

I Saw this but not sure if it's due to version 2020 because it is the same as an earlier date of December 27 2019


1 Feb 2020 22:22:26
Object reference not set to an instance of an object.   at Plugin_History.HistoryControl.??(String )
   at Plugin_History.HistoryControl.??(Object , EventArgs )
   at System.Windows.Forms.Timer.OnTick(EventArgs e)
   at System.Windows.Forms.Timer.TimerNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


Updated from v2016 to v2020 on Win7 64bit system

[djclewes]

wish i could sort the display issue out  on the playlist.

[Marius]

@brodephat, can you please tell me your history plugin settings?
@djclews: please be more specific.

[djclewes]

@marius

[zandgame17]

@marius

Just go to the settings > Plugins > double click Playlist > and then set "slots  number" to 5-6 or whatever u want till the problem fixed

[Brodephat]

@marius

History plugins settings:

Zone: 3
Rows to display 100
Listener count checked pointing to a file that is updated from server.

[zandgame17]

The latest beta is available to download!
It uses the same database schema as the previous beta release, so to update it, just replace the files with the new ones.

I strongly recommend to test the version first and if everything is fine, to put it in production, because i may missed some bugs in my tests.

PS: Some antivirus may continue to alert you, but it's a false positive. Sorry for that. Soon the application will be digitally signed and hopefully this will be history.
PPS: The version jumped a bit for internal reasons... 

hi marius, rdj 2020 is awesome.

i already set up my teaser, and it works perfectly. But lately, i found that we can set hook in and hook out directly from playlist, but when i press the shortcut to make teaser it didn't work (rdj 2020). i have set it up from search utility or track manager, and reload to playlist, and it works. previous rdj i can set it up from playlist,.. thx

[Marius]

Thanks for letting me know zandgame17, i will look into this.

[AdrianHondema]

Regarding your reply #31 where you asked for a SQL Track Rotation query, this is what I use:

/*
Select a random track from the top2000 category where:
  1. the track is valid for the current date
  2. the track has not yet been played today
  3. the artist has not been played in the last 60 minutes
  4. the artist is not already in the queuelist
  5. with the lowest count_played
*/
SELECT * FROM songs
    LEFT JOIN queuelist ON ( songs.artist = queuelist.artist)
WHERE songs.enabled = 1 /* enabled */
    AND songs.song_type = 0 /* Music */
    AND songs.id_subcat = 33 /* Top2000 */
    AND ((`songs`.`start_date` <= Now()) AND (`songs`.`end_date` >= NOW() OR `songs`.`end_date` = '2002-01-01 00:00:01')) /* only tracks that are valid for the current date */
    AND (TIMESTAMPDIFF(MINUTE, songs.date_played, NOW()) > 3600) /* don't play the same track twice a day */
    AND (TIMESTAMPDIFF(MINUTE, songs.artist_played, NOW()) > 60) /* don't play the same artist twice an hour */
    AND queuelist.artist IS NULL /* Artist not yet selected in queuelist */
    AND count_played = (select min(count_played) from songs where id_subcat = 33) /* select the least played tracks */
ORDER BY RAND()
  LIMIT 1

[Calypso]

Regarding your reply #31 where you asked for a SQL Track Rotation query, this is what I use:

/*
Select a random track from the top2000 category where:
  1. the track is valid for the current date
  2. the track has not yet been played today
  3. the artist has not been played in the last 60 minutes
  4. the artist is not already in the queuelist
  5. with the lowest count_played
*/
SELECT * FROM songs
    LEFT JOIN queuelist ON ( songs.artist = queuelist.artist)
WHERE songs.enabled = 1 /* enabled */
    AND songs.song_type = 0 /* Music */
    AND songs.id_subcat = 33 /* Top2000 */
    AND ((`songs`.`start_date` <= Now()) AND (`songs`.`end_date` >= NOW() OR `songs`.`end_date` = '2002-01-01 00:00:01')) /* only tracks that are valid for the current date */
    AND (TIMESTAMPDIFF(MINUTE, songs.date_played, NOW()) > 3600) /* don't play the same track twice a day */
    AND (TIMESTAMPDIFF(MINUTE, songs.artist_played, NOW()) > 60) /* don't play the same artist twice an hour */
    AND queuelist.artist IS NULL /* Artist not yet selected in queuelist */
    AND count_played = (select min(count_played) from songs where id_subcat = 33) /* select the least played tracks */
ORDER BY RAND()
  LIMIT 1

This way you take the artist into consideration, but not the associated artists. In the current beta, the artist seperation is also put into the associated artist logic, so what basically happens is that you could get a song by "Paul Simon And Art Garfunkel" just after a song by "Art Garfunkel" and followed by a song by "Paul Simon". And this one is obvious, but the associated artists field makes it possible (and I use it extensively) to prevent a song by "Paul McCartney" following a song by "The Beatles". But currently I'm getting there, it's only not as neat as I was hoping. Have to put some stuff into a stored procedure to make it usable - why are there only 24 hours in a day....

[AdrianHondema]

Hi Calypso,

That is true, I don't take the associated artists into consideration. For that I would need to put all that information into the database, which is an enormous task. There are only 24 hours in a day here as well, so there is no time for that. I do make sure though that the artist names are as consequent as possible though, so no 'Simon and Garfunkel' and 'Simon & Garfunkel' and 'Paul Simon and Art Garfunkel' and whatever variation on this in my database: only one combination. That is doable. It works for me this way. Of course, it is still possible to have the Beatles. Wings and Paul McCartney back to back, but I really don't mind that. With around 30000 tracks that risk is rather small. My biggest concern was to select the tracks that were least played. Over time I tried several solutions in this query, this one (the last 'and' in the query) does the job the best. I'm always open for better options though...

Adrian