RadioDJ v2.0.1.3 BETA Released!

[DJ Garybaldy]

If you have a running v2.0.0.6 (which wasn't updated to any newer version yet), you can update to the latest beta using the "2.0.0.6 TO 2.0.1.2.sql" database update file.

I've imported and upgraded my 2.0.0.6 database and applied the patch to upgrade it now I'm getting lots of this in the error logs

Code Select Expand

Database Insert Error: Unknown column 'ETA' in 'field list' (TRUNCATE `queuelist`;
INSERT INTO `queuelist` SET `songID` = '6106',ETA = NOW() + INTERVAL 161.601927437642 SECOND, duration = 226.369387755102, `artist` = 'Roy Orbison',`title` = 'That Lovin'' You Feelin'' Again',`album` = '';
INSERT INTO `queuelist` SET `songID` = '6785',ETA = NOW() + INTERVAL 387.971315192744 SECOND, duration = 118.284172335601, `artist` = 'The Everly Brothers',`title` = 'The Price of Love',`album` = '';
INSERT INTO `queuelist` SET `songID` = '6512',ETA = NOW() + INTERVAL 506.255487528345 SECOND, duration = 143.940680272108, `artist` = 'Del Shannon',`title` = 'Sea Of Love',`album` = '';
INSERT INTO `queuelist` SET `songID` = '14183',ETA = NOW() + INTERVAL 650.196167800454 SECOND, duration = 126.689455782313, `artist` = 'Sammy Davis Jr.',`title` = 'You Can Count On Me',`album` = '';
INSERT INTO `queuelist` SET `songID` = '19673',ETA = NOW() + INTERVAL 776.885623582767 SECOND, duration = 169.462947845805, `artist` = 'Strawbs',`title` = 'Part Of The Union',`album` = '';
INSERT INTO `queuelist` SET `songID` = '8473',ETA = NOW() + INTERVAL 946.348571428572 SECOND, duration = 136.912267573697, `artist` = 'Martha Reeves And The Vandellas',`title` = 'Come And Get These Memories',`album` = '';
INSERT INTO `queuelist` SET `songID` = '5659',ETA = NOW() + INTERVAL 1083.26083900227 SECOND, duration = 160.009569160998, `artist` = 'Dusty Springfield',`title` = 'How Can I Be Sure',`album` = '';
INSERT INTO `queuelist` SET `songID` = '6849',ETA = NOW() + INTERVAL 1243.27040816327 SECOND, duration = 176.636848072562, `artist` = 'The Shadows',`title` = 'Guitar Tango',`album` = '';
INSERT INTO `queuelist` SET `songID` = '14183',ETA = NOW() + INTERVAL 1419.90725623583 SECOND, duration = 126.689455782313, `artist` = 'Sammy Davis Jr.',`title` = 'You Can Count On Me',`album` = '';
INSERT INTO `queuelist` SET `songID` = '6716',ETA = NOW() + INTERVAL 1546.59671201814 SECOND, duration = 119.065804988662, `artist` = 'The Beach Boys',`title` = 'I Get Around',`album` = '';
INSERT INTO `queuelist` SET `songID` = '6521',ETA = NOW() + INTERVAL 1665.6625170068 SECOND, duration = 159.039886621315, `artist` = 'Dion',`title` = 'The Wanderer',`album` = '';
INSERT INTO `queuelist` SET `songID` = '14183',ETA = NOW() + INTERVAL 1824.70240362812 SECOND, duration = 126.689455782313, `artist` = 'Sammy Davis Jr.',`title` = 'You Can Count On Me',`album` = '';
INSERT INTO `queuelist` SET `songID` = '19713',ETA = NOW() + INTERVAL 1951.39185941043 SECOND, duration = 217.069297052154, `artist` = 'T.Rex',`title` = 'Telegram Sam',`album` = '';
INSERT INTO `queuelist` SET `songID` = '8536',ETA = NOW() + INTERVAL 2168.46115646259 SECOND, duration = 110.291247165533, `artist` = 'Marvin Gaye',`title` = 'How Can I Forget',`album` = '';
INSERT INTO `queuelist` SET `songID` = '6406',ETA = NOW() + INTERVAL 2278.75240362812 SECOND, duration = 141.258526077098, `artist` = 'Billy Fury',`title` = 'Since You''ve Been Gone',`album` = '';
INSERT INTO `queuelist` SET `songID` = '7667',ETA = NOW() + INTERVAL 2420.01092970522 SECOND, duration = 153.687278911564, `artist` = 'Brenda Lee',`title` = 'Break It To Me Gently',`album` = '';
INSERT INTO `queuelist` SET `songID` = '14183',ETA = NOW() + INTERVAL 2573.69820861678 SECOND, duration = 126.689455782313, `artist` = 'Sammy Davis Jr.',`title` = 'You Can Count On Me',`album` = '';
INSERT INTO `queuelist` SET `songID` = '13157',ETA = NOW() + INTERVAL 2700.38766439909 SECOND, duration = 185.982857142857, `artist` = 'Tom Jones',`title` = 'Daughter Of Darkness',`album` = '';
INSERT INTO `queuelist` SET `songID` = '6064',ETA = NOW() + INTERVAL 2886.37052154195 SECOND, duration = 123.762335600907, `artist` = 'Question Mark And The Mysterians',`title` = 'Need Somebody',`album` = '';
)

What have I done wrong? Its a fresh back up taken yesterday of the old database

[plauri]

@Garybaldy
I was thinking of doing the same, but now I will wait a little bit

[DJ Garybaldy]

Think I've found the culprit somehow when I had upgraded the database with the 2006>>2012 patch it didn't populate the updatetracks2 with any code.


I applied other patches from the other upgrades and I ended up with the magic code now I haven't got any errors posting themselves and I have my song database as it should be...

<<Quick Backup of the database>>

[absoluutfm]

In 2.0.0.6 the number is tracks in the queue equals the length of the rotation when you clear the playlist

Now the # of tracks is determined by the options set in AutoDJ options.

This messes up my rotations as I need them to start with certain categories and have a fixed lenghth.

Could you make the new behaviour optional and let us choose what to use?

[neutralhills]

Got it neutralhills. If you have a running v2.0.0.6 (which wasn't updated to any newer version yet), you can update to the latest beta using the "2.0.0.6 TO 2.0.1.2.sql" database update file.

Thanks Marius, I'll play with it some tomorrow and report any issues. I'm using a clean install of Windows 7 Pro to be safe.

[plauri]

I started v2.0.1.3 with a clean database (and tested for a while), then I imported all my tracks running on v1.8.2 on a local hd. I did an import of my db running in v1.8.2 into v2.0.1.3, then I used Database Utils making update from 1.8.2 TO 2.sql, 2.0.0.3 TO 2.0.0.4.sql, 2.0.0.6 TO 2.0.0.9.sql and finally 2.0.0.9 TO 2.0.1.2.sql. Of course I did a Relocate Tracks (and it took me a lot of time, because I have more than 50 folders with music and some of them I had to do twice). No errors running the first time v.2.0.1.3. After that rotations have become to have  repeating songs (sometimes the same song 3, 4 times one after the other. So I edited rotations and saved. Nothing changed. Reset playcounts and rotations started to run as they should. No problem in running news from a direct stream and with a bed. SayTime works (I had to rebuild the manual saytime with the new one) as before with a slight difference: the time starts a bit late, 1 second so it ends with no effect. Teaser works as before (I had to set them again in the Teaser Plugins). All the events works (Load by categories and load by rotations: even rotations that start with a specific jingle). At the moment everything is running smootly, crossfingers. I'm going on testing, Marius         

[zandgame17]

I started v2.0.1.3 with a clean database (and tested for a while), then I imported all my tracks running on v1.8.2 on a local hd. I did an import of my db running in v1.8.2 into v2.0.1.3, then I used Database Utils making update from 1.8.2 TO 2.sql, 2.0.0.3 TO 2.0.0.4.sql, 2.0.0.6 TO 2.0.0.9.sql and finally 2.0.0.9 TO 2.0.1.2.sql. Of course I did a Relocate Tracks (and it took me a lot of time, because I have more than 50 folders with music and some of them I had to do twice). No errors running the first time v.2.0.1.3. After that rotations have become to have  repeating songs (sometimes the same song 3, 4 times one after the other. So I edited rotations and saved. Nothing changed. Reset playcounts and rotations started to run as they should. No problem in running news from a direct stream and with a bed. SayTime works (I had to rebuild the manual saytime with the new one) ahttp://www.radiodj.ro/community/Smileys/LightB/005.gifs before with a slight difference: the time starts a bit late, 1 second so it ends with no effect. Teaser works as before (I had to set them again in the Teaser Plugins). All the events works (Load by categories and load by rotations: even rotations that start with a specific jingle). At the moment everything is running smootly, crossfingers. I'm going on testing, Marius         

Read this comment make me want to feel bout RDJv13beta! 

and theeeeen! Awesome, database from 12 running smoothly not lag anymore on RDJ13Beta. Great work brother 

[Calypso]

In 2.0.0.6 the number is tracks in the queue equals the length of the rotation when you clear the playlist

Now the # of tracks is determined by the options set in AutoDJ options.

This messes up my rotations as I need them to start with certain categories and have a fixed lenghth.

Could you make the new behaviour optional and let us choose what to use?

I've noted this a couple of times before in this forum, and after thinking of it, I think it can also be implemented differently and from a programmatically point of view easier: respect the rotation until it has been fully played. Most likely can be done in a few lines of code; just remember the rotation that is started, and look for a new rotation id when all tracks (added one by one like the "new" behaviour) have been added.

Doesn't have to be another option because if you don't experience problems with this behaviour, you won't notice the difference. Though if you experience it now, it makes a big difference.

[plauri]

It happens (see 2 posts above) that one of my rotation keeps repeating the same track sometimes 2 or 3 times in half an hour (the rotation lasts one hour and it's a 100 tracks (just one artist) to choose from. And yes I know that some of these artists have been played before this rotation, so it's less than 100 to choose from. But the rules are the same in v1.8.2 and this has never never happened in 2 years time. 

[zandgame17]

Hello everyone.. 

(Rdj13beta) are you guys already test the folder sync function?!
i try it today, but it won't work! There's no new song add from running the folder sync (i already add 10 song today). 

update : from track manager too (import folder or file)

[Vanlen]

Win10 / MariaDB 2.0.1.3 Beta

Running now well over a week 24/7.  Fired up the RadioDJ Reports and shows everything has been playing, playlists, rotations, manual & program events as created.   @zandgame17 - I just set up the Folder Sync. (Never used the feature before this morning) to check it out and it updated with new music & Genre etc with no errors on my end.

In the 7 days so far there has been No Errors reported in the Windows event log.

The Keep in Playlist feature is great but I agree there should be an option to toggle off/on for those with specific rotations.

Nice one Marius.
Cheers.

[DJ Garybaldy]

Been running as smooth as nut here too...Not had an error since I managed to upgrade my database.

[zandgame17]

Win10 / MariaDB 2.0.1.3 Beta

Running now well over a week 24/7.  Fired up the RadioDJ Reports and shows everything has been playing, playlists, rotations, manual & program events as created.   @zandgame17 - I just set up the Folder Sync. (Never used the feature before this morning) to check it out and it updated with new music & Genre etc with no errors on my end.

In the 7 days so far there has been No Errors reported in the Windows event log.

The Keep in Playlist feature is great but I agree there should be an option to toggle off/on for those with specific rotations.

Nice one Marius.
Cheers.

Fresh database setup or old database from v06?

[Vanlen]

@Zandgame17
Restored from Beta 2012 (didn't require a conversion to 2.0.1.3 Beta) in my case.
You might be on to something with issues from V6 to v13

Cheers

[plauri]

What do you think I can do to solve my problem about rotations which keep repeating either the same song or the same artist. Basically it doesn't respect the rule "do not play same track, artist, title and album" before 360 minutes and lowering this number is absurd (I have about 8k tracks in the db), and this doesn't happen in v.1.8.2.       

Apart from this the v2.0.1.3 is running rock solid, but I can't use it "on the air".