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