RadioDJ - Free Radio Automation Software Forum

RadioDJ v2.0.2.0 Beta Released!

Re: RadioDJ v2.0.2.0 Beta Released!
« Reply #90 on: February 26, 2020, 08:32:25 AM »
There was one other issue with my query... Artists like 'Hatfield & The North' are seperated as 'Hatfield' and 'The North' in the assiciated artist: 'hatfield, the north'. When you then check the artistname against the associated artists there is no match: 'Hatfield & The North' is not the same as 'hatfield' or 'the north'. So, instead of only checking the associated artists, you will have to check the artist name as well.

This is the final version of my query:
SELECT * FROM songs
 WHERE songs.enabled = 1 /* the track is 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()) > 120) /* don't play the same artist twice an hour */
   AND NOT songs.artist IN (SELECT artist FROM queuelist) /* Artist not in queuelist */
   AND (SELECT COUNT(*) FROM queuelist WHERE FIND_IN_SET(songs.artist, queuelist.associated_artists)) = 0 /* Associated artist not 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

Re: RadioDJ v2.0.2.0 Beta Released!
« Reply #91 on: February 26, 2020, 01:48:31 PM »
I changed the slash " / " with ", " and separation is not working in 'Search' (tracks aren't marked as 'played') and probably there are cases when two artists are played back to back.
I had three songs in a row from the same artists  ::) ::)


Re: RadioDJ v2.0.2.0 Beta Released!
« Reply #92 on: February 26, 2020, 08:32:51 PM »
Hi Calypso,

Thank you for your help, much appreciated!


Well we're helping eachother here - and most likely also Marius and the rest of the users - by trying to get the queries better. That's the whole idea of a community such as RDJ has  ;)

Offline chrismadog

  • ****
  • 289
  • Be part of the solution, not part of the problem !
    • Rose City FM
Re: RadioDJ v2.0.2.0 Beta Released!
« Reply #93 on: February 28, 2020, 02:49:25 AM »
Hi Marius,

I replicated the v2.0.1.5 database and then installed v2.0.2.0 and used the database update from 2.0.1.5 to 2.0.2.0

I checked usage and all seemed well.
However, I checked the procedures and found there were two procedures active.
UpdateTracks and UpdatTracks2.

I checked one against the other and then deleted the UpdateTracks procedure (I kept a text copy though just in case).

Everything still appears to work perfectly.

Have I done the right thing ?

Regards and thanks for all the wonderful things in v2.0.2.0 :)
Chris
Presenter - 4SDB - Rose City FM 89.3 - Warwick, QLD Australia.
Community Radio - Bringing you the best of local radio.
Head Technical Officer - http://rosecityfm.org.au

Offline chrismadog

  • ****
  • 289
  • Be part of the solution, not part of the problem !
    • Rose City FM
Re: RadioDJ v2.0.2.0 Beta Released!
« Reply #94 on: February 28, 2020, 03:07:27 AM »
I Understand that, but one or more SQL queries in your query mean a risk for repeated artists/songs, so that's why I'm stating that SQL Queries in a Rotation become unwanted because of that risk.

Hi Calypso,

I use SQL queries and my way to avoid repeats is to make the limit very high - enough to cover the time period I want to cover.
For instance:
I make the selection of tracks from whatever category with whatever filters I want using SQL and then use RAND(), LIMIT 80 for a 4 hour show.

That generates a random playlist from the desired criteria with 80 tracks in it and thanks to Marius's wizardry, it doesn't generate lag like it used to by having so many tracks in it.

After 4 hours, there are some tracks left - so I ensure that the next rotation clears the playlist (in an event) and generates a completely new playlist via a new or same rotation, thereby avoiding repeating a song that may have been in the playlist.
Does that make sense ??
Works here perfectly.

I hope this makes sense and works for you.

Regards,
Chris
Presenter - 4SDB - Rose City FM 89.3 - Warwick, QLD Australia.
Community Radio - Bringing you the best of local radio.
Head Technical Officer - http://rosecityfm.org.au

Re: RadioDJ v2.0.2.0 Beta Released!
« Reply #95 on: February 28, 2020, 06:45:13 AM »
I hope this makes sense and works for you.

Yes, it makes sense, but doesn't work for me  :hihi: - the reason is that I use rotations to make a selection of different categories in a certain mix, so I almost always wanto to have a limit of 1. But that's the fun thing of something like RDJ; it has several ways of doing things to make almost unlimited possibilities.

Re: RadioDJ v2.0.2.0 Beta Released!
« Reply #96 on: February 28, 2020, 06:47:05 AM »
Hi Marius,

I replicated the v2.0.1.5 database and then installed v2.0.2.0 and used the database update from 2.0.1.5 to 2.0.2.0

I checked usage and all seemed well.
However, I checked the procedures and found there were two procedures active.
UpdateTracks and UpdatTracks2.

I checked one against the other and then deleted the UpdateTracks procedure (I kept a text copy though just in case).

Everything still appears to work perfectly.

Have I done the right thing ?

What I remember is that UpdateTracks is there for historical reasons. AFAIK it isn't actively used in the latest versions.

Re: RadioDJ v2.0.2.0 Beta Released!
« Reply #97 on: February 28, 2020, 10:46:58 AM »
Hiya,

After todays (28-02-2020) update of Windows Defender Antivirus, Radiodj 2.0.2.0 is now longer downloadable. Windows Defender says the file is infected with a virus (Program:Win32/Unwaders.A!ml) and quarantaines it right away. Radiodj 2.0.1.6 can be downloaded without any problems though...

Thought I would let you know. It's probably a false positive again but it blocks the download which is annoying...

Adrian
« Last Edit: February 28, 2020, 11:32:40 AM by AdrianHondema »

Offline DJ Garybaldy

  • *****
  • 4271
  • Don't Shoot! I'm only the Moderator
    • DJ Garybaldy Blog
Re: RadioDJ v2.0.2.0 Beta Released!
« Reply #98 on: February 28, 2020, 10:50:11 AM »
Hiya,

After todays (28-02-2020) update of Windows Defender Antivirus, Radiodj 2.0.2.0 is now longer downloadable. Windows Defender says the file is infected with a virus and quarantaines it right away. Radiodj 2.0.1.6 can be downloaded without any problems though...

Thought I would let you know. It's probably a false positive again but it blocks the download which is annoying...

Adrian

If you can try adding the  RadioDJ folder and music files to the Exclude list in Windows defender or try disabling WD while you download and install.
Retired DJ & Proud USER of RadioDJ since 2010

Windows 10 Pro: 16GB AMD10 & 32GB Intel i5 processor

https://djgarybaldy.blogspot.com/

https://djgarybaldy.blogspot.com/p/about-me.html

Database repair: https://djgarybaldy.blogspot.com/2020/09/radiodj-database-maintenance-how-to.html

Offline Brodephat

  • ****
  • 430
  • Pushing content to the world via an ethernet cable
    • Free RadioDJ Video Tutorials
Re: RadioDJ v2.0.2.0 Beta Released!
« Reply #99 on: February 29, 2020, 01:58:51 AM »
Hey, just noticed that if RadioDJ plays a remote stream that is down, it freezes instead of kicking it out as in past times.
"Think Outside The Box And Make Something Truly Wonderful Happen"

My RadioDJ Stations:
NiaRadioNetwork.com
24HourPreachingNetwork.com
RealPeopleTalkRadio.com
TheTriadComeUp.com

Radio Imaging:
CarterScripts.com

Free RDJ Video tutorials
HowToUseRadioDJ.com

Offline Anton

Re: RadioDJ v2.0.2.0 Beta Released!
« Reply #100 on: March 01, 2020, 11:05:46 AM »
Hi everyone,
I’m having some problems with my Radiodj v2.0.2.0. It was working good all the time, now it freeze up or stop playing.

Is anyone also having the same problem?  And how can I get this problem resolved?

Offline DJ Garybaldy

  • *****
  • 4271
  • Don't Shoot! I'm only the Moderator
    • DJ Garybaldy Blog
Re: RadioDJ v2.0.2.0 Beta Released!
« Reply #101 on: March 01, 2020, 11:10:46 AM »
Have you recently updated windows? what operating system are you on?

There are few windows updates causing issues.


Retired DJ & Proud USER of RadioDJ since 2010

Windows 10 Pro: 16GB AMD10 & 32GB Intel i5 processor

https://djgarybaldy.blogspot.com/

https://djgarybaldy.blogspot.com/p/about-me.html

Database repair: https://djgarybaldy.blogspot.com/2020/09/radiodj-database-maintenance-how-to.html

Offline Anton

Re: RadioDJ v2.0.2.0 Beta Released!
« Reply #102 on: March 01, 2020, 11:19:33 AM »
Have you recently updated windows? what operating system are you on?

There are few windows updates causing issues.

Yes we have updated our windows 10

Offline DJ Garybaldy

  • *****
  • 4271
  • Don't Shoot! I'm only the Moderator
    • DJ Garybaldy Blog
Re: RadioDJ v2.0.2.0 Beta Released!
« Reply #103 on: March 01, 2020, 11:25:28 AM »
See Marius's post on this Topic [urll]https://www.radiodj.ro/community/index.php?topic=13906.0
Retired DJ & Proud USER of RadioDJ since 2010

Windows 10 Pro: 16GB AMD10 & 32GB Intel i5 processor

https://djgarybaldy.blogspot.com/

https://djgarybaldy.blogspot.com/p/about-me.html

Database repair: https://djgarybaldy.blogspot.com/2020/09/radiodj-database-maintenance-how-to.html

Re: RadioDJ v2.0.2.0 Beta Released!
« Reply #104 on: March 01, 2020, 02:10:44 PM »
Hi all,

Just downloaded the 2.0.2.0 beta version and I can't see all my music files in the Library Manager... Using Windows 10 and MySQL.

https://ibb.co/Dfn2VG7