RadioDJ - Free Radio Automation Software Forum

RadioDJ v2.0.0.9 Released!

Offline Marius

  • *****
  • 5577
    • Radio DJ
RadioDJ v2.0.0.9 Released!
« on: September 28, 2018, 07:43:15 AM »
CHANGES LIST:
- Fixed "tracks from SQL" rotation;
- Fixed now playing text file export;
- When loading (or reloading) a rotation, the AutoDJ will generate the playlist from the first item [NEW];
+ Other minor bugs fixed.

If updating from previous versions ( 2.0.0.7 or 2.0.0.8 ) it doesn't require any database changes.

PS: I forgot to mention that some changes occurred on SQL rotation queries:

The "$ForceRepeatRules$" variable should be added to the WHERE clause, like in the following example:

Code: (sql) [Select]
/*
ADD 10 MOST PLAYED TRACKS TO THE PLAYLIST
*/

SELECT `ID` FROM `songs` WHERE `song_type`=0 AND `enabled`=1 AND $ForceRepeatRules$ ORDER BY `count_played` DESC LIMIT 10;
« Last Edit: September 28, 2018, 02:30:48 PM by Marius »
DOWNLOADS PAGE

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

Offline spons

  • **
  • 88
  • Hilversum Drie || Perfecte Popmuziek!
    • HilversumDrie
Re: RadioDJ v2.0.0.9 Released!
« Reply #1 on: September 28, 2018, 10:23:46 AM »
Thanks for the quick update. No problems here with this version (too)  :-*
=========================================
www.hitsyndicaat.nl || Proud RadioDJ User since 2013

Offline DJ Garybaldy

  • *****
  • 3991
  • Never Get Angry At the Stupid People (Erasure)
    • DJ Garybaldy
Re: RadioDJ v2.0.0.9 Released!
« Reply #2 on: September 28, 2018, 10:32:02 AM »
Thanks Marius will run a test with it today.
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

Re: RadioDJ v2.0.0.9 Released!
« Reply #3 on: September 28, 2018, 10:58:46 AM »
Thanks Marius, all problems solved  :)

Re: RadioDJ v2.0.0.9 Released!
« Reply #4 on: September 28, 2018, 11:10:31 AM »
Hello

Decided to Updated Database changed from MySQL to MariaBD

Had no issue with 2.0.0.6

Tried 2.0.0.0.7/8

Still have problem with 2.0.0.9

Slow not clearing playlist for 20 plus seconds

Very slow in operation

Check I have no Repèat rules setup in rotations

Verfied Database .. all tracks complete



event log  found

Database Insert Error: PROCEDURE radiodj2.UpdateTracks does not exist (CALL UpdateTracks(203089,0,0,30,0);
UPDATE `songs` SET `artist_played`=NOW() WHERE `artist` REGEXP '[[:<:]]Bob Sinclar[[:>:]]';UPDATE `songs` SET `artist_played`=NOW() WHERE `artist` REGEXP '[[:<:]]Cutee B[[:>:]]';)

also

Database Insert Error: PROCEDURE radiodj2.UpdateTracks does not exist (CALL UpdateTracks(183128,1,0,30,0);
)

checked Db nothing missing


Any Ideas
Phil
« Last Edit: September 28, 2018, 12:00:43 PM by golf97fm »
Owner Reef FM - Tenerife
103 & 99.2 FM
Tenerife's Biggest Urban and Dance Station
www.reeffm-tenerife.com
http://109.236.85.141:7000/live

Offline plauri

  • *****
  • 1313
    • Funky Corner Radio
Re: RadioDJ v2.0.0.9 Released!
« Reply #5 on: September 28, 2018, 11:27:01 AM »
Thanks Marius, testing and works.
Tested: When loading (or reloading) a rotation, the AutoDJ will generate the playlist from the first item [NEW]

Now it's perfect  :cool:
Funky Corner Radio
http://www.funkycorner.it
http://www.radiofunkycorner.com

Re: RadioDJ v2.0.0.9 Released!
« Reply #6 on: September 28, 2018, 12:29:26 PM »
Super thanks for the quick update, Marius. Working like a charm now. You are the best!

Offline DJ Garybaldy

  • *****
  • 3991
  • Never Get Angry At the Stupid People (Erasure)
    • DJ Garybaldy
Re: RadioDJ v2.0.0.9 Released!
« Reply #7 on: September 28, 2018, 01:24:26 PM »
About 2 hours after i updated to and fired up 2.0.0.9 its started doing the not adding files to the queue thing just now and gave that .NET  Column ID error again,

I turned off AutoDJ and left it for a minute or two and turned it back to automated and autodj and it seems to have stopped the error in the windows logs and the queue is loading again

However I will be keeping an eye on the situation.will be keeping an eye on it this afternoon.

I'm just wondering if I should delete the current rotations and try again (will do some more testing)

**Update** I've created a simple 5/6 line rotation but it appears the "track from request" entry isn't loading requests into the queue the rotation appears to be loading songs as it should no errors since i recreated the rotation.
« Last Edit: September 28, 2018, 02:34:25 PM by DJ Garybaldy »
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

Re: RadioDJ v2.0.0.9 Released!
« Reply #8 on: September 28, 2018, 04:01:06 PM »
Installed version 2.0.9   
It works great, thanks Marius as always great job.  :cool: :cool: :cool:

Offline Chip Douglas Mosley

  • ****
  • 355
  • Retired disc jockey and radio programmer
    • Jukebox 92.7 WEPQ
Re: RadioDJ v2.0.0.9 Released!
« Reply #9 on: September 28, 2018, 05:07:23 PM »
Possible error in v2.0.0.9.

When I click on the maximize window icon in the lower right hand corner of the screen to view the Windows taskbar, the arrows at the bottom of plug-in zone 1 disappear. This didn't happen on any previous version of version 2. Did I do something wrong, or is this an error?

Thanks!
Chip Douglas Mosley
Jukebox 92.7 WEPQ
www.jukebox927.com
Radio DJ user since 2016, Live365 since 2019
Now using v2.0.2.0 since January 19, 2020

Offline Marius

  • *****
  • 5577
    • Radio DJ
Re: RadioDJ v2.0.0.9 Released!
« Reply #10 on: September 28, 2018, 05:18:06 PM »
**Update** I've created a simple 5/6 line rotation but it appears the "track from request" entry isn't loading requests into the queue the rotation appears to be loading songs as it should no errors since i recreated the rotation.

That's not nice  :)
Can you try this: http://www.radiodj.ro/download/latest_version/SetupRadioDJ2009f2.exe No database or other tweaking necessary, it will replace only the exe/dll files.
DOWNLOADS PAGE

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

Offline Marius

  • *****
  • 5577
    • Radio DJ
Re: RadioDJ v2.0.0.9 Released!
« Reply #11 on: September 28, 2018, 05:19:32 PM »
Possible error in v2.0.0.9.

When I click on the maximize window icon in the lower right hand corner of the screen to view the Windows taskbar, the arrows at the bottom of plug-in zone 1 disappear. This didn't happen on any previous version of version 2. Did I do something wrong, or is this an error?

Thanks!

Not sure, but here it displays correctly.
DOWNLOADS PAGE

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

Offline Jhonny

  • *****
  • 3676
  • Peace, enjoy life.it's over before you've lived it
    • Jhonny's RadioDJ tutorials.
Re: RadioDJ v2.0.0.9 Released!
« Reply #12 on: September 28, 2018, 07:18:23 PM »

PS: I forgot to mention that some changes occurred on SQL rotation queries:

The "$ForceRepeatRules$" variable should be added to the WHERE clause, like in the following example:

Code: (sql) [Select]
/*
ADD 10 MOST PLAYED TRACKS TO THE PLAYLIST
*/

SELECT `ID` FROM `songs` WHERE `song_type`=0 AND `enabled`=1 AND $ForceRepeatRules$ ORDER BY `count_played` DESC LIMIT 10;

Thanks,  ;D this make's it must simpler to explain how to make a simple query to start with. :cool: :cool:
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

Re: RadioDJ v2.0.0.9 Released!
« Reply #13 on: September 28, 2018, 09:58:56 PM »
Appears as if I spoke to soon - all worked well for a few hours and now the same problem as before - player and Recently played not upgrading again. Okay - uninstalled/reinstalled 2.0.0.9 - seems to be working now. Artist images still not appearing in radiodj, however. It worked for a few hours on 1st update - so will keep an eye on it and let you know. Hopefully not a temporary thing. :)
« Last Edit: September 28, 2018, 11:13:20 PM by skaggsy »

Offline Chip Douglas Mosley

  • ****
  • 355
  • Retired disc jockey and radio programmer
    • Jukebox 92.7 WEPQ
Re: RadioDJ v2.0.0.9 Released!
« Reply #14 on: September 28, 2018, 10:14:04 PM »
Possible error in v2.0.0.9.

When I click on the maximize window icon in the lower right hand corner of the screen to view the Windows taskbar, the arrows at the bottom of plug-in zone 1 disappear. This didn't happen on any previous version of version 2. Did I do something wrong, or is this an error?

Thanks!

I think I got it working...did an uninstall, reinstalled it and rebooted the computer, then started up v2.0.0.9 and the arrows showed up. I did a clean install so I have to put everything back into the program. I'll let you know if I have any other problems.

Thanks again, Marius, for being there when I need you!
Chip Douglas Mosley
Jukebox 92.7 WEPQ
www.jukebox927.com
Radio DJ user since 2016, Live365 since 2019
Now using v2.0.2.0 since January 19, 2020