• Welcome to RadioDJ - Free Radio Automation Software Forum. Please log in or sign up.

RadioDJ v2.0.0.9 Released!

Started by Marius, September 28, 2018, 07:43:15 AM

Marius

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

Thanks for the quick update. No problems here with this version (too)  :-*
=========================================
www.hitsyndicaat.nl || Proud RadioDJ User since 2013

DJ Garybaldy

Thanks Marius will run a test with it today.
Worlds Biggest Fan of RadioDJ

Install MariaDB https://djgarybaldy.blogspot.com/2020/08/installing-maria-db.html

Install RadioDJ: https://djgarybaldy.blogspot.com/2020/08/how-to-install-radiodj-free-radio.html

Into Internet radio for 25 years 1999-2024

RadioDJ 2045 MariaDB 11.2 Windows 11

absoluutfm

Thanks Marius, all problems solved  :)

golf97fm

#4
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 DMT FM - Tenerife
103 & 99.2 FM
www.dmt-fm.com
https://dc1.serverse.com/proxy/ywycfrxn/stream

plauri

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
Radiodj v.2.0.4.5 (Windows 10)
http://www.funkycorner.radio
https://www.funkycorner.it
http://www.radiofunkycorner.com

skaggsy

Super thanks for the quick update, Marius. Working like a charm now. You are the best!

DJ Garybaldy

#7
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.
Worlds Biggest Fan of RadioDJ

Install MariaDB https://djgarybaldy.blogspot.com/2020/08/installing-maria-db.html

Install RadioDJ: https://djgarybaldy.blogspot.com/2020/08/how-to-install-radiodj-free-radio.html

Into Internet radio for 25 years 1999-2024

RadioDJ 2045 MariaDB 11.2 Windows 11

Music Box

Installed version 2.0.9   
It works great, thanks Marius as always great job.  :cool: :cool: :cool:

Chip Douglas Mosley

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
jukebox927@yahoo,com
Radio DJ user since 2016, Live365 since 2019
Upgraded to v2.0.4.5 on January 25, 2024

Marius

Quote from: DJ Garybaldy on September 28, 2018, 01:24:26 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

Quote from: Chip Douglas Mosley 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!

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

Quote from: Marius on September 28, 2018, 07:43:15 AM

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.
Einstein says: Make things simple, but don't make simple things simpler! (wise) this is just my life lesson you know.

I don't do drugs ( ͡° ͜ʖ ͡°)
The Radiodj tutorials site is now managed by Domstad radio .nl still  Just in English

skaggsy

#13
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

Quote from: Chip Douglas Mosley 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!

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
jukebox927@yahoo,com
Radio DJ user since 2016, Live365 since 2019
Upgraded to v2.0.4.5 on January 25, 2024