Author Topic: RadioDJ v2.0.0.9 Released!  (Read 1773 times)

Marius

  • Administrator
  • Hero Member

  • Online
  • *****
  • 5307
    • Radio DJ Romania
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;
DOWNLOADS PAGE

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

spons

  • Jr. Member

  • Offline
  • **
  • 81
  • Personal Text
    Het Hitsyndicaat || Alle hits en meer!
    • Het Hitsyndicaat
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

DJ Garybaldy

  • Global Moderator
  • Hero Member

  • Offline
  • *****
  • 3580
  • Personal Text
    I do NOT compile code for RadioDJ I'm just a USER!
    • 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.
Proud USER of RadioDJ since 2011

https://djgarybaldy.co.uk/maria-db-radiodj/
https://djgarybaldy.co.uk/help-cant-install-radiodj/
https://djgarybaldy.co.uk/radiodj-php-request-script-basic/
https://www.facebook.com/DJGarybaldy/

I cannot support older versions - Currently Beta Testing 2.0.1.3

absoluutfm

  • New User

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

golf97fm

  • New User

  • Offline
  • *
  • 39
    • Reef FM Tenerife
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
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

plauri

  • Hero Member

  • Offline
  • *****
  • 1016
    • 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

skaggsy

  • New User

  • Offline
  • *
  • 48
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!

DJ Garybaldy

  • Global Moderator
  • Hero Member

  • Offline
  • *****
  • 3580
  • Personal Text
    I do NOT compile code for RadioDJ I'm just a USER!
    • 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.
Proud USER of RadioDJ since 2011

https://djgarybaldy.co.uk/maria-db-radiodj/
https://djgarybaldy.co.uk/help-cant-install-radiodj/
https://djgarybaldy.co.uk/radiodj-php-request-script-basic/
https://www.facebook.com/DJGarybaldy/

I cannot support older versions - Currently Beta Testing 2.0.1.3

Music Box

  • Jr. Member

  • Offline
  • **
  • 64
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:

Chip Douglas Mosley

  • Full Member

  • Offline
  • ***
  • 183
  • Personal Text
    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
jukebox927.radiostream321.com
jukebox927.wixsite.com/wepq
Radio DJ user since 2016

Marius

  • Administrator
  • Hero Member

  • Online
  • *****
  • 5307
    • Radio DJ Romania
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.

Marius

  • Administrator
  • Hero Member

  • Online
  • *****
  • 5307
    • Radio DJ Romania
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.

Jhonny

  • Hero Member

  • Offline
  • *****
  • 3216
  • Personal Text
    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

skaggsy

  • New User

  • Offline
  • *
  • 48
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. :)

Chip Douglas Mosley

  • Full Member

  • Offline
  • ***
  • 183
  • Personal Text
    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
jukebox927.radiostream321.com
jukebox927.wixsite.com/wepq
Radio DJ user since 2016