RadioDJ v2.0.1.6 Beta Released!

[Marius]

CHANGES LIST:

- Implemented separate associated artist field in database to allow users to manually edit them [NEW];
- Implemented option to mass change the start/end date of selected tracks in tracks editor [NEW];
- Implemented custom duration value for fade stopping the cart players [NEW];
- Completed implementing translation files for Tracks Manager plugin controls;
- Completed implementing translation files for NowPlayingInfo plugin controls;
- Completed implementing translation files for Playlist Builder plugin controls;
- Completed implementing translation files for RadioDJ options;
- Completed implementing translation files for Notes plugin controls;
- Completed implementing translation files for Audio Processing plugins;
- Implemented metadata export for IceCast v2, ShoutCast v2 and TuneIN in NowPlaying Info plugin [NEW] (DISABLED TEMPORARY!);
- Updated main program code to reflect REGEX changes of MySQL v8 and later [NEW];
- Updated the program to the newest version of BASS sound engine [NEW];
- Updated plugin Utils GUI for better design integration with the rest of the program [NEW];
- Fixed category copying for event duplication;
- When an event is duplicated, the new name will contain also the "(COPY)" string [NEW];
- Events filters will be retained after refreshing the event list for the session [NEW];
- Minor bug fixes;

This version requires some database changes to improve query speed in MySQL v8+. The update files are located in "Setup\Sql" folder. There are two files, one for updating from v2.0.0.6 ("2.0.0.6 TO 2.0.1.6.sql") and one for updating from the latest beta ("2.0.1.5 TO 2.0.1.6.sql").

For testing purposes only you can install a new database and import fresh files. This also my recommended procedure, because i saw many times users which are running incomplete databases resulted from failed updates etc so these users may report errors which are not present in a normal install.

NOTES:

- There is a new feature named "associated artists" for better handling the tracks which have multiple artists. You can manually update this field on import, or you can run Utilities - Update Associated Artists, which will try to detect the artists. It is very important to not leave the associated field empty, or the artist separation will fail and will result in playing same artists more often than you set in the repeat rules.

- While the translations should cover all the visual texts, some tooltips are not translated yet. I'm still working on them.

[Jhonny]

Thanks 

[Andrew]

Hi Guys,
If i use Maria DB the procedure in order to update database from 2.0.6 to 2.0.1.6. it is the same? Should i run the installer (for 2.0.1.6) over the folder where 2.0.6 is installed, and after that to follow the steps mentioned in Database Utility?
Thanks

[plauri]

Thanks Marius, but:
"For testing purposes only you can install a new database and import fresh files. This also my recommended procedure, because i saw many times users which are running incomplete databases resulted from failed updates etc so these users may report errors which are not present in a normal install."

It's ok testing a new db, but I'm still using 1.8.2 and the reason is in the last 5 years I have set more than 5000 intros, hooks in and out and I need them. No matter how many new events or rotations I have to set, but Intros are fundamental to me. Will ever be the chance to transfer db from 1.8.2 to the latest one?

Tonight I will start testing with a fresh install!     

[DJ Garybaldy]

Just installed and upgraded with the patch.

First things I've noticed are

1) The AutoDJ button keeps switching itself back to manual
2) Because of the AutoDJ button its not keeping 20 tracks in the queue

These were noticed within 2 minutes of first run.

[Marius]

Gary, please check the windows logs. I suspect it has to do with skipping rotations, but i'm not sure at this time.

[DJ Garybaldy]

There's very little to go on in the Windows error logs only thing I could see was this.

AUTODJ ROTATION FROM REQUEST NOTICE: There were no available reqests when the playlist was generated!

I've just fired 2016 back up and the autodj button still keeps switching itself off. Its not refilling the playlist when it is on AutoDJ. Doesn't appear to matter how many times I flick auotdj back from manual nothing is loading into the queue.

[Music Box]

Hi everyone, I have installed the new version with a new database with 1135 songs, for the moment everything works perfectly.   

[Anderson Clayton]

1000 songs working fine rotations, I can not save manual event to say time

[DJ Garybaldy]

Think you were onto something Marius. The rotations were screwed somehow as soon as I recreated them AutoDJ started playing as normal... PHEW!

Update: However it now keeps wanting to constantly load songs at the bottom of the queue that are already in the queue. Otis Redding is just an example of what's happening.

https://djgarybaldy.co.uk/wp-content/uploads/2019/06/Screenshot_2019-06-13_15-24-32.png

[DJ Garybaldy]

Database Insert Error: Unknown column 'ETA' in 'field list' (TRUNCATE `queuelist`; INSERT INTO `queuelist` SET `songID` = '14015',ETA = NOW() + INTERVAL 312.817278911564 SECOND, duration = 149.926485260771, `artist` = 'Jimmy Holiday & Clyde King',`associated_artists` = '',`title` = 'Ready, Willing And Able',`album` = ''

is what I'm seeing a lot of in the window s event viewer

[Vanlen]

Fresh install with MariaDB/Win 10

Testing rotations with events and jingles.  Over 3000 songs for testing over the weekend. 

Issue noticed:
Notes plugin when moved from disabled to plugins didn't show up so I took the notes dll and xml from 2.0.15 and is working now.

Thanks for the update Marius
Cheers

[Marius]

is what I'm seeing a lot of in the window s event viewer

That seems an incomplete database and would explain the repeating tracks/artists since the query fails. Can you run this query:

Code Select Expand

ALTER TABLE `queuelist`
ADD COLUMN `ETA` datetime DEFAULT '2002-01-01 00:00:01' AFTER `songID`;

[DJ Garybaldy]

Ran that query, Recreated Rotations from scratch and still I'm getting the same 2 songs trying to load into the queue it is also doing it with requested tracks.

I used the upgrade from 2006 to 2016 patch yesterday if that helps any.

https://djgarybaldy.co.uk/wp-content/uploads/2019/06/Screenshot_2019-06-14_09-12-54.png

Been testing about 30/40 minutes so far and I'm out out of ideas. I really don't want to have to start a fresh new database if I can avoid it.

To make matters worse Windows event viewer isn't playing nicely so I can't check if there are any errors related to RDJ.

[stevewa]

thanks for these updates to the events system!
i won't be able to test until next week