RadioDJ - Free Radio Automation Software Forum

RadioDJ v2.0.2.0 Beta Released!

Re: RadioDJ v2.0.2.0 Beta Released!
« Reply #60 on: February 04, 2020, 01:44:12 PM »
repeat tracks, for sure it's a net framework, I've done these tests, :ok:

Offline DJ Garybaldy

  • *****
  • 3998
  • Never Get Angry At the Stupid People (Erasure)
    • DJ Garybaldy
Re: RadioDJ v2.0.2.0 Beta Released!
« Reply #61 on: February 06, 2020, 11:18:52 PM »
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.
USER of RadioDJ since 2010

Useful RadioDJ information : https://djgarybaldy.co.uk/category/radiodj/

I cannot give help and support via Private message!

I'm not as scary as I look Honest!

My little pet project: https://t.co/YyVaPOBYBK

Offline Jhonny

  • *****
  • 3679
  • Peace, enjoy life.it's over before you've lived it
    • Jhonny's RadioDJ tutorials.
Re: RadioDJ v2.0.2.0 Beta Released!
« Reply #62 on: February 08, 2020, 09:28:28 AM »
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');
)

 
R.T.F.M. means to me, Read The Fantastic Messages.
Make things simple, but don't make simple things simpler!
I don't do drugs, I do tuts. ( ͡° ͜ʖ ͡°) visit  https://radiodj.info

Testing RadioDJ v2.0.2.0 Beta

Offline znmd

Re: RadioDJ v2.0.2.0 Beta Released!
« Reply #63 on: February 12, 2020, 01:55:43 AM »
Seems that REST server is still unable to load track to RadioDJ playlist. It returns an 400 error code if I try

Offline Brodephat

  • ****
  • 422
  • Pushing content to the world via an ethernet cable
    • RadioDJ Video Tutorials
Re: RadioDJ v2.0.2.0 Beta Released!
« Reply #64 on: February 12, 2020, 06:17:59 AM »
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

"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 djclewes

  • ****
  • 311
  • Name is Rich feel free to say hi
    • South Lanarkshire Radio
Re: RadioDJ v2.0.2.0 Beta Released!
« Reply #65 on: February 13, 2020, 08:07:13 PM »
wish i could sort the display issue out  on the playlist.
Owner of South Lanarkshire

Offline Marius

  • *****
  • 5578
    • Radio DJ
Re: RadioDJ v2.0.2.0 Beta Released!
« Reply #66 on: February 13, 2020, 10:00:21 PM »
@brodephat, can you please tell me your history plugin settings?
@djclews: please be more specific.
DOWNLOADS PAGE

HOW TO FIX RADIODJ DATABASE
----------------
Please don't PM me for support requests. Use the forums instead.

Offline djclewes

  • ****
  • 311
  • Name is Rich feel free to say hi
    • South Lanarkshire Radio
Re: RadioDJ v2.0.2.0 Beta Released!
« Reply #67 on: February 13, 2020, 10:27:20 PM »
@marius

Owner of South Lanarkshire

Re: RadioDJ v2.0.2.0 Beta Released!
« Reply #68 on: February 13, 2020, 11:54:17 PM »
@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

Offline Brodephat

  • ****
  • 422
  • Pushing content to the world via an ethernet cable
    • RadioDJ Video Tutorials
Re: RadioDJ v2.0.2.0 Beta Released!
« Reply #69 on: February 15, 2020, 06:30:54 PM »
@marius

History plugins settings:

Zone: 3
Rows to display 100
Listener count checked pointing to a file that is updated from server.
"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

Re: RadioDJ v2.0.2.0 Beta Released!
« Reply #70 on: February 18, 2020, 05:24:10 AM »
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...  :D

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
« Last Edit: February 18, 2020, 05:33:49 AM by zandgame17 »

Offline Marius

  • *****
  • 5578
    • Radio DJ
Re: RadioDJ v2.0.2.0 Beta Released!
« Reply #71 on: February 18, 2020, 04:05:28 PM »
Thanks for letting me know zandgame17, i will look into this.
DOWNLOADS PAGE

HOW TO FIX RADIODJ DATABASE
----------------
Please don't PM me for support requests. Use the forums instead.

Re: RadioDJ v2.0.2.0 Beta Released!
« Reply #72 on: February 19, 2020, 09:02:52 AM »
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

Re: RadioDJ v2.0.2.0 Beta Released!
« Reply #73 on: February 20, 2020, 10:48:20 AM »
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.... :'(

Re: RadioDJ v2.0.2.0 Beta Released!
« Reply #74 on: February 20, 2020, 08:43:14 PM »
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