RadioDJ - Free Radio Automation Software Forum

RadioDJ v2.0.1.6 Beta Released!

Offline Marius

  • *****
  • 5649
    • Radio DJ
RadioDJ v2.0.1.6 Beta Released!
« on: June 13, 2019, 09:44:34 AM »
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.
« Last Edit: June 13, 2019, 10:32:41 AM by Marius »
DOWNLOADS PAGE

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

Offline Jhonny

  • *****
  • 3897
  • Peace, enjoy life, last sleep is longer than live!
    • Jhonny's RadioDJ tutorials.
Re: RadioDJ v2.0.1.6 Beta Released!
« Reply #1 on: June 13, 2019, 10:20:36 AM »
Thanks  :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, I do tuts. ( ͡° ͜ʖ ͡°) visit  https://radiodj.info

Testing RadioDJ v2.0.2.0 Beta

Re: RadioDJ v2.0.1.6 Beta Released!
« Reply #2 on: June 13, 2019, 11:37:47 AM »
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

Offline plauri

  • *****
  • 1407
    • Funky Corner Radio
Re: RadioDJ v2.0.1.6 Beta Released!
« Reply #3 on: June 13, 2019, 11:38:09 AM »
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!     
« Last Edit: June 13, 2019, 02:27:29 PM by plauri »
Funky Corner Radio
http://www.funkycorner.it
http://www.radiofunkycorner.com

Offline DJ Garybaldy

  • *****
  • 4270
  • Retired DJ who uses RadioDJ
    • DJ Garybaldy Blog
Re: RadioDJ v2.0.1.6 Beta Released!
« Reply #4 on: June 13, 2019, 12:10:00 PM »
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.

Retired DJ & Proud USER of RadioDJ since 2010

Computers: Windows 10 Pro 16GB & 32GB AMD10/Intel i5 processor

https://djgarybaldy.blogspot.com/

Repair the RadioDJ database: https://djgarybaldy.blogspot.com/2020/09/radiodj-database-maintenance-how-to.html

Offline Marius

  • *****
  • 5649
    • Radio DJ
Re: RadioDJ v2.0.1.6 Beta Released!
« Reply #5 on: June 13, 2019, 01:42:50 PM »
Gary, please check the windows logs. I suspect it has to do with skipping rotations, but i'm not sure at this time.
DOWNLOADS PAGE

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

Offline DJ Garybaldy

  • *****
  • 4270
  • Retired DJ who uses RadioDJ
    • DJ Garybaldy Blog
Re: RadioDJ v2.0.1.6 Beta Released!
« Reply #6 on: June 13, 2019, 02:56:01 PM »
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.
Retired DJ & Proud USER of RadioDJ since 2010

Computers: Windows 10 Pro 16GB & 32GB AMD10/Intel i5 processor

https://djgarybaldy.blogspot.com/

Repair the RadioDJ database: https://djgarybaldy.blogspot.com/2020/09/radiodj-database-maintenance-how-to.html

Re: RadioDJ v2.0.1.6 Beta Released!
« Reply #7 on: June 13, 2019, 03:24:50 PM »
Hi everyone, I have installed the new version with a new database with 1135 songs, for the moment everything works perfectly.   :cool:

Re: RadioDJ v2.0.1.6 Beta Released!
« Reply #8 on: June 13, 2019, 03:46:29 PM »

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

Offline DJ Garybaldy

  • *****
  • 4270
  • Retired DJ who uses RadioDJ
    • DJ Garybaldy Blog
Re: RadioDJ v2.0.1.6 Beta Released!
« Reply #9 on: June 13, 2019, 04:10:51 PM »
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
« Last Edit: June 13, 2019, 04:32:42 PM by DJ Garybaldy »
Retired DJ & Proud USER of RadioDJ since 2010

Computers: Windows 10 Pro 16GB & 32GB AMD10/Intel i5 processor

https://djgarybaldy.blogspot.com/

Repair the RadioDJ database: https://djgarybaldy.blogspot.com/2020/09/radiodj-database-maintenance-how-to.html

Offline DJ Garybaldy

  • *****
  • 4270
  • Retired DJ who uses RadioDJ
    • DJ Garybaldy Blog
Re: RadioDJ v2.0.1.6 Beta Released!
« Reply #10 on: June 13, 2019, 04:50:39 PM »
Quote
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
Retired DJ & Proud USER of RadioDJ since 2010

Computers: Windows 10 Pro 16GB & 32GB AMD10/Intel i5 processor

https://djgarybaldy.blogspot.com/

Repair the RadioDJ database: https://djgarybaldy.blogspot.com/2020/09/radiodj-database-maintenance-how-to.html

Offline Vanlen

  • *****
  • 1152
    • Music for your senses
Re: RadioDJ v2.0.1.6 Beta Released!
« Reply #11 on: June 13, 2019, 06:52:30 PM »
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 :cool:
Cheers
Forest Green - Music in Nature's Frequency
www.forestgreenradio.ca

Offline Marius

  • *****
  • 5649
    • Radio DJ
Re: RadioDJ v2.0.1.6 Beta Released!
« Reply #12 on: June 13, 2019, 08:30:00 PM »

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]
ALTER TABLE `queuelist`
ADD COLUMN `ETA` datetime DEFAULT '2002-01-01 00:00:01' AFTER `songID`;
DOWNLOADS PAGE

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

Offline DJ Garybaldy

  • *****
  • 4270
  • Retired DJ who uses RadioDJ
    • DJ Garybaldy Blog
Re: RadioDJ v2.0.1.6 Beta Released!
« Reply #13 on: June 14, 2019, 10:36:30 AM »
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.
« Last Edit: June 14, 2019, 10:52:30 AM by DJ Garybaldy »
Retired DJ & Proud USER of RadioDJ since 2010

Computers: Windows 10 Pro 16GB & 32GB AMD10/Intel i5 processor

https://djgarybaldy.blogspot.com/

Repair the RadioDJ database: https://djgarybaldy.blogspot.com/2020/09/radiodj-database-maintenance-how-to.html

Re: RadioDJ v2.0.1.6 Beta Released!
« Reply #14 on: June 14, 2019, 01:47:16 PM »
thanks for these updates to the events system!
i won't be able to test until next week