RadioDJ - Free Radio Automation Software Forum
Beta Testings => Beta Versions Releases => Topic started by: Marius on January 19, 2020, 05:40:19 PM
-
The latest beta is available to download!
It uses the same database schema as the previous beta release, so to update it, just replace the files with the new ones.
I strongly recommend to test the version first and if everything is fine, to put it in production, because i may missed some bugs in my tests.
PS: Some antivirus may continue to alert you, but it's a false positive. Sorry for that. Soon the application will be digitally signed and hopefully this will be history.
PPS: The version jumped a bit for internal reasons... :D
-
Fandabidozi! Someone was only asking me about a new version earlier
-
Coffee is on and testing is about to commence. :cool:
Oops Error Log:
Description:
The program RadioDJ.exe version 2.0.2.0 stopped interacting with Windows and was closed. To see if more information about the problem is available, check the problem history in the Security and Maintenance control panel.
Process ID: 1b08
Start Time: 01d5cf061fc8fc4c
Termination Time: 4294967295
Application Path: C:\RadioDJv2020\RadioDJ.exe
Report Id: 44994476-d859-49b6-b9c3-1f3aafd22568
Faulting package full name:
Faulting package-relative application ID:
Hang type: Top level window is idle
Task Manager Pic attached with warning bit
Cheers Marius
-
Hi Vanlen, i suppose it's a new setup, the application showed up, or the error came at startup?
-
Yes it was Marius,
Installed as usual with setting up Data Base all good and then ran RadioDJ.exe and then what happened above.
-
I've installed the new version. It's working fine with no problems so far, the only thing I have noticed is it seems to be a bit sticky sometimes "I.E locks the application up with selecting the database searching for tracks etc". This is not interfering with playback just running a bit slower on my PC that previous beta.
-
@martyuk1 what database server are you using? MySQL or MariaDB?
-
Are there any special steps I should use to upgrade from v2.0.1.6beta?
I have tried to run v2.0.2.0 on my Win10 computer using MariaDB but after I set up the data base, the new version tries to start, but I get the RDJ start up screen on my computer and it doesn't go any further.
I've been running v.2.0.1.6 on the same computer with no problems.
Thanks, Marius! I'm looking forward to getting the new beta up and running! :cool:
-
Oh, i found the issue Chip. I forgot to disable the autodj at startup for the first start and behind the splash screen is displaying a warning that you don't have yet any rotation (since is a fresh install).
You can either try to press enter, or if it doesn't work, edit "settings_general.xml" and change this:
<Settings>
<Key>AutoDJStart</Key>
<Value>True</Value>
</Settings>
to this:
<Settings>
<Key>AutoDJStart</Key>
<Value>False</Value>
</Settings>
and restart the program.
PS: I updated the installer with the correct setting, so if you don't manage to change the setting manually, you can download and run again the installer. Just remove the old installation, because the installer is set to preserve your settings file, so it will not overwrite it.
-
I'm using MySQL.
Is the latest version more tuned "get it" to MariaDB then?
Martin.
@martyuk1 what database server are you using? MySQL or MariaDB?
-
Tnx Marius :cool:
The latest install works!! Now to Play. :cool:
I uninstalled, removed leftover Folder from C Drive and then did FRESH Install and good so far.
Windows 10/64bit Build 1909 and MariaDB
Cheers
-
Normally MySQL should be just fine, but there are plenty users saying that MariaDB is faster, especially after recent versions of MySQL.
I'm using MySQL.
Is the latest version more tuned "get it" to MariaDB then?
Martin.
-
Been running overnight with no errors, Everything appears to be working as it should.
No showstoppers that I can see.
Hurrah it let me post after the 4th attempt!
-
Running test box with just over 3000 elements events/rotations/jingles/IDs etc. So far so good.
Reset Play Count now working in Track Manager and from in a Manual event :cool:
Change log shows you were very busy. RadioDJ 2020 in 2020 Nice touch!
Thanks Marius ;)
-
Hi everyone, I'm testing the radiodj 2020 with windows 7 pro, maria db 10.2 (x64) and I found a problem with the TTS with Ivona's Brian voice. (Assuming that the settings are identical to version 2.0.0.6 where it sounds great). To hear the voice over a song I had to increase the volume to 200, which in version 2.0.0.6 is 10. Is there any new setting parameter? If so, can you tell me where it is?
Thank you.
-
Hi Marius!
I just deleted the installation and used the new one. It seems to be working really well. Thanks for your help (again)!
-
Hi Marius,
Just Started testing 2.0.2.0 but noticed the follow is still not working
https://www.radiodj.ro/community/index.php?topic=13210.msg74544#msg74544
(https://www.radiodj.ro/community/index.php?topic=13210.msg74544#msg74544)Thanks,
Wayne
-
Don't know about anyone else but the songs/artist repeating bug seems to have been fixed here.
I'm not seeing songs by the currently playing artist populating the bottom of the queue as I was in 2016
2020 is playing away nicely I'm loving the new audio settings being able to turn parts on or off is genius. I've emlinated the Equaliser and things still sound great.
-
Hi Marius,
I'm facing a little annoying bug, I don't know if it's the normal behaviour :
I open track edit window for a queued track (for example the next track to be played in pos #1) when this track is supposed to play, it is ignored and the track in #2 position is played.
As sometimes I correct track titles in the last minute....
Concerning what DJ Garybaldy said just before, I think the repeating track bug still exist:
I'm using essentially SQL requests (procedures) in my rotations , and autodj is set to always show 8 tracks queued , when rotation loads (or when clearing the playlist) the same track is loaded eight times but in my sql request i'm saying to not load a track already in "queue" table ;
the only way to correct that is to have only 1 track queued in autodj mode.
I have another little annoying things happen like this :
21 Jan 2020 08:52:49
Cannot find table 0. at System.Data.DataTableCollection.get_Item(Int32 index)
at rdjInterface.Playlist.AutoDJClass.?????????????????????????????????????????(DataTableCollection , Int32 )
at rdjInterface.Playlist.AutoDJClass.GeneratePlaylist(Int32 RotationID, Int32 ItemsCount, Double duration)
at ~\&v%7IY(HG("5N\[WS0>k^\[32!.?????????????????????????????????????????.?????????????????????????????????????????()
at System.Threading.Tasks.Task`1.InnerInvoke()
at System.Threading.Tasks.Task.Execute()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at ~\&v%7IY(HG("5N\[WS0>k^\[32!.LZ5YQ5\.CZKF')Ssu_8Rk3nu7.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.AsyncMethodBuilderCore.<>c.<ThrowAsync>b__6_0(Object state)
and radioDJ plays the last tracks in queue and stops...I have to reload RDJ
It seems a timeout problem with mariadb (in another server in my local network) but why RDJ does not retry to connect preventing the radio to become silent ...
Thanks Marius, I have some other little things to ask for but not very important, and as I'm coding a little too I know it's lots of work, explaining the long time between the last beta release...
:cool:
-
Now i am wondering about another thing and maybe Marius can shed some light on it. Can i test RadioDJ V2.02 beta on Windows XP on a P4? Just to push the limits or is it not working from the start?
-
Now i am wondering about another thing and maybe Marius can shed some light on it. Can i test RadioDJ V2.02 beta on Windows XP on a P4? Just to push the limits or is it not working from the start?
I doubt it as .NET 4.6 and above will not install on XP and Newer versions of RDJ require .NET 4.6
-
I doubt it as .NET 4.6 and above will not install on XP and Newer versions of RDJ require .NET 4.6
Sounds like a fail from start :hihi: Oke thanks, need to clear another PC for it than ;)
-
Questions about the audio output of 2.0.2.0beta...
1) The volume of the TTS is a lot less than in 2.0.1.6b. Using the same tracks, the TTS is buried in the music audio. I have the same settings in both versions but they don't seem to operating the same way.
2) The AGC is not as good in 2.0.2.0b as it is in 2.0.1.6b. I put the audio on my stream overnight and into this morning and several listeners noted that parts of the audio blasted out while other parts were quieter than in the v2.0.1.6b stream. The listeners were not aware that I was beta testing a new version.
3) I wonder if the problem comes from separation of the different actions of the audio processing. I set compression and AGC presets the same as I had them in v2.0.1.6b and still find that the volume output on the stream is different.
3) And again, I bring up for discussion the fact that any music file followed by an EVENT will play the music out to the end point, not the NEXT point, creating a short period of dead air.
For example,
MUSIC SONG #1
EVENT
Weather Jingle
Weather Forecast
Station Jingle
MUSIC SONG #2
Song #1 plays out to the END cue, not the NEXT cue, before moving into the EVENT. If I change the settings so that the EVENT is deleted and Song #1 goes straight into the Weather Jingle, Song #1 plays to the NEXT cue.
I use the EVENT because it's easier to set it up once and insert it every time I need the EVENT rather than having to write out the sequence each time it occurs in the flow of programming.
Any thoughts or discussion on this will be appreciated. I really want to use v2.0.2.0b but I don't want to put it on my stream again until these issues can be resolved.
Thanks, Marius. I do appreciate your hard work! :cool:
-
Don't know about anyone else but the songs/artist repeating bug seems to have been fixed here.
Here it isn't. I've thought of a way of reproducing it, and it's quite easy. Unless I'm making a fundamental thinking mistake, using the $ForceRepeatRules$ in an SQL rotation should respect the Repeat Rules.
When I make a rotation in 2.0.2.0 with a number of SQL queries in it like
SELECT ID FROM songs WHERE enabled=1 AND artist like '%beat%' AND $ForceRepeatRules$ ORDER BY `date_played` ASC, RAND() LIMIT 1;
SELECT ID FROM songs WHERE enabled=1 AND artist like '%beat%' AND $ForceRepeatRules$ ORDER BY `date_played` ASC, RAND() LIMIT 1;
SELECT ID FROM songs WHERE enabled=1 AND artist like '%beat%' AND $ForceRepeatRules$ ORDER BY `date_played` ASC, RAND() LIMIT 1;
SELECT ID FROM songs WHERE enabled=1 AND artist like '%beat%' AND $ForceRepeatRules$ ORDER BY `date_played` ASC, RAND() LIMIT 1;
SELECT ID FROM songs WHERE enabled=1 AND artist like '%beat%' AND $ForceRepeatRules$ ORDER BY `date_played` ASC, RAND() LIMIT 1;
I'd expect to only have 1 time "Beatles" in it, but instead I have them five times in my list of 10 tracks that the playlist is populated with, and from another band I even have the same song in there twice. Also, there are 24 artists available to be played with "Beat" in it - so it normally should be able to find a correct selection.
Now I think it can be "fixed (more or less)" with setting the number of songs to keep in the playlist to "1", but for my way of using Rotation Rules, it's important that it's always filled with at least one "full" sequence. And as said, I'd expect the $ForceRepeatRules$ to also consider the tracks already selected to be placed in the playlist.
-
I've been a bit busy these days... I noticed the new version two days later... I'm getting old :D Installed and working smootly in beta test with most of the events, intros, teasers etc. I have live. I tried tts too and, as somebody said, I had to rise girl's voice to 150 to hear something! Another great work, Marius! :ok:
-
Thanks for the feedback guys!
TTS: the volume is indeed lower and that's because when generating the output as a file, there is a volume setting in the Speech.Synthesis .net api, but that is ignored when generating the output to memory. Probably the volume is the default one.
Repeat rules: When using the sql rotation and regular rotation, the results are different, because the way it selects tracks is different. When using rotation from sql, the repeat rules uses the old method which was used in the older versions of RadioDJ (based purely by sql, which has some limitations), but on normal rotations the procedure is very different because the sql filtering only applies on enabled tracks, category, subcategory and genre and then a list is generated which is manipulated manually. While this can be a little slower, it gives me more control over the results.
-
NOW PLAYING INFO
Is the stream server working?
if so do we have to put our own codec in (a folder)?
-
NOW PLAYING INFO
Is the stream server working?
if so do we have to put our own codec in (a folder)?
If i'm reading the Plugin correctly I think its like the Song title Updater I have on my website.
It will update the now playing info to a server if that server is being fed by an encoder that doesn't support title streaming out of the box (e.g: SAMCast)
-
got confused by icecast and shoutcast setting.
thought it was the same as the stream plugin v1.1 of 182.
So my mistake
-
Repeat rules: When using the sql rotation and regular rotation, the results are different, because the way it selects tracks is different. When using rotation from sql, the repeat rules uses the old method which was used in the older versions of RadioDJ (based purely by sql, which has some limitations), but on normal rotations the procedure is very different because the sql filtering only applies on enabled tracks, category, subcategory and genre and then a list is generated which is manipulated manually. While this can be a little slower, it gives me more control over the results.
Basically this means that SQL Rotation is more or less useless; it doesn't respect repeat rules for tracks in the playlist (but not played yet), so you have the risk that tracks/artists/titles are put into the queue multiple times. Maybe I can change my SQL statements in such a way that they also look into the queue, but I'd expect that that piece of code is taken care of by $ForceRepeatRules$.
-
TTS: the volume is indeed lower and that's because when generating the output as a file, there is a volume setting in the Speech.Synthesis .net api, but that is ignored when generating the output to memory. Probably the volume is the default one.
A dumb guy here asking how you change the volume. ???
-
If you are able to create a better logic with pure sql, you are welcome to do so and if you will want to share it, i can implement it in the program.
The problem is that you must exclude all the tracks that has been played, artists (including associated artists), titles, albums and also the ones from the queue table by their played timestamp. So it will be a monstrous query.
Basically this means that SQL Rotation is more or less useless; it doesn't respect repeat rules for tracks in the playlist (but not played yet), so you have the risk that tracks/artists/titles are put into the queue multiple times. Maybe I can change my SQL statements in such a way that they also look into the queue, but I'd expect that that piece of code is taken care of by $ForceRepeatRules$.
-
If you are able to create a better logic with pure sql, you are welcome to do so and if you will want to share it, i can implement it in the program.
The problem is that you must exclude all the tracks that has been played, artists (including associated artists), titles, albums and also the ones from the queue table by their played timestamp. So it will be a monstrous query.
I Understand that, but one or more SQL queries in your query mean a risk for repeated artists/songs, so that's why I'm stating that SQL Queries in a Rotation become unwanted because of that risk.
A simpler solution (as extensive SQL queries) could be to add something like a "planned timestamp/because of track id" combination of fields in the songs that are filled whenever a track is added to the queue. The "because of track id" would be necessary to reset the planned timestamp in case of playlist clearance and/or track deletion from the queue. For now I'm gonne spend a couple of hours in the upcoming week or so to see if I can do it within SQL. Or maybe with the use of a procedure/function.
Leaving it as it is will (I think) lead to a number of questions of users who are not aware of the possibility for not respecting the repeat rules and wondering why they get tracks in the playlist when they don't expect it.
-
Been running 24/7 since the fixed beta release and reports show everything working as it should. Manual Triggered Events, Jingle Events, Rotations changing and all.
Reports feature shows what I wanted to happen happened.
The Audio processing option updates are a very welcome feature.
The only thing I notice is that in the Playlist Builder option (Load From Rotation) only loads 60 minutes no matter if I choose a greater number 90. 120 etc. Not a biggy.
I don't use Sql scripts so YMMV. I have set don't play same song/artist for 600 mins and keep playlist 0 etc and a very happy camper!
Thanks Marius:
RadioDJ 2020 Rocks :cool:
-
I've done a complete database and jingle re-install and re-installed the latest beta version and it's working perfectly with no lag and still on MySQL. Awesome job Marius. :cool: ;D
@martyuk1 what database server are you using? MySQL or MariaDB?
-
Playlist builder.Horiz and vrtic still wrong.Playlist from rotation not longer as 60 min.
-
Well in my tests I still cannot see any showstoppers...
The new audio plugin sounds amazing with just the compressor and stereo widening at 2.
Seriously nothad any issues. Its playing away as it should.
-
Playlist builder.Horiz and vrtic still wrong.Playlist from rotation not longer as 60 min.
That can be changed via language files. 60 minutes limitation is not a bug.
-
Marius,
How do I adjust the playback level for TTS? v2.0.2.0 plays back the TTS at a level where it is drowned out by music.
Thanks!
-
Marius,
How do I adjust the playback level for TTS? v2.0.2.0 plays back the TTS at a level where it is drowned out by music.
Thanks!
Put the volume number at 190! It works for me (my tracks are levelled at -3 db)
-
Any idea why i got this problem. happens in 2.0.2.0 but not 2.0.0.6
http://radiolanarkshire.co.uk/radiodjscreen.png (http://radiolanarkshire.co.uk/radiodjscreen.png)
-
Move Instant player into zone 3 and then the playlist won't look squashed.
-
Tried and changed screen resolution.
-
Go into options>plugin>Playlist Plugin>Show>Reduce the number of slots.
-
I only have 2 rows of 4 works fine in 2.0.0.6
-
Can u confirm minimum requirements
-
My long term test computer is a low end one by today standards: Zotac ZBOX ID83 with an old i3 2330M processor/8GBytes DDR3 @665MHz/Intel 545s series SSD.
-
What about software wise I got
Windows 7 Pro.
Mariadb 10.4
Netframe Work 4.6
-
My test are done on Windows 10 Home & Professional.
-
Anyone else tested on windows 7 pro
-
Have you tried restting your resolution? Just a hunch that that might be to blame for things looking squashed.
-
A bit worrying folks are still using Windows 7 with no support or security updates from now on.. Move to Windows 10 after 5 years it's now almost usable. Windows 10 still looks 1995 graphics but Microsoft took a major step back from windows 7 with 8 and 10.
I've been using RadioDJ v2.0.2.0 now for over a week, running fine :)
Currently uploaded to mixcloud as my old platform stopped working.
https://www.mixcloud.com/martyuk1/obr-playing-the-songs-you-know-jan-2020/ (https://www.mixcloud.com/martyuk1/obr-playing-the-songs-you-know-jan-2020/)
OBR Playing the songs you know!.
Thanks for this software I am thankful every day amazing work and website.
-
A bit worrying folks are still using Windows 7 with no support or security updates from now on.. Move to Windows 10 after 5 years it's now almost usable. Windows 10 still looks 1995 graphics but Microsoft took a major step back from windows 7 with 8 and 10.
Personally I understand your view (it's still a view, I know lots of people who very much dislike Windows 10 look and feel), but you're forgetting the "drivers" problem with Windows 10. There are quite a number of hardware devices out there (several popular soundcards for instance) that don't have Windows 10 drivers. If you, as a small radiostation, have a card that was expensive back in the days and you still want to use it, migrating to Windows 10 isn't an option.
Again, I don't want to stimulate older Windows versions, but Windows 7 with RadioDJ and no other usage/programs and in an controlled environment isn't the biggest risk. If I got $1 for every system out there in a critical environment with Windows XP, OS/2 or even DOS... I would give Marius a job to able to work on RDJ and still wouldn't need to work for the rest of my life... :hihi:
-
I suppose just don't connect it to the internet and Windows 95 will still be ok :D :D :D ;D :ok:
-
You wouldn't get it running on Windows 95/98 as it needs .NET
I know people who are still running with XP and i really don't understand why. It was at best a mediocre operating system that caused me no end of headaches.
OK So Windows 7 isn't supported by Microsoft but I'd imagine there are still Millions of computers running it that aren't connected to the internet.
I liked W7 but I'm a total W10 convert now OK so there are Driver issues but surely thats up to the manfacturers of that hardware to supply the latest drivers
P.S: RadioDJ v2.0.2.0 appears to be working fine here
-
Hello!
Several times I already have the same problem.
At least once a week, version 2.0.2.0 of the program suddenly stops working.
-
Milen please see my reply in the other topic you posted the same thing on.
-
OK, I sent the information from Logs folder
-
HUH? I've now got the same problem I had with 2016. The repeating artists are back.
Not sure what's happened Nothing in error logs to suggest an issue. I've ran a repair. Just now its playing Roxy Music and its slotted another record by them at the bottom of the queue. There are only 3 Items in the tracks rotation.
Couple of changes to Windows10 with updates yesterday one was a Cumulative Update for .NET yesterday I don't know if that's to blame. Its all a little strange it hasn't done it for a few days.
-
Just come across another weird issue it hasn't marked the currently playing track as played.
Don't if that's just me its happened to.
-
repeat tracks, for sure it's a net framework, I've done these tests, :ok:
-
I've come across a problem and I don't know if its happening to anyone else...
Played one rotation and I noticed the tracks weren't being marked as played, Yet when it switched to another rotation its marking the songs as played.
I've ran a repair/optimise I've also gone into the database and manually deleted the rotation that was causing the repeating artists I will rebuild that tomorrow and see what comes of it.
I'm wondering its it time to actually rebuild the database from Scratch again or not.
-
RDJ stop with playing on a artist played update. screen on black.
Database Insert Error: FUNCTION radiodj2020.REGEXP_INSTR does not exist (CALL UpdateTracks2(4498,'Charles Aznavour','Yesterday When I Was Young',0,0,30,0.1);
UPDATE `songs` SET `artist_played`=NOW() WHERE REGEXP_INSTR(songs.associated_artists, '\\b(Charles Aznavour)\\b');
)
-
Seems that REST server is still unable to load track to RadioDJ playlist. It returns an 400 error code if I try
-
I Saw this but not sure if it's due to version 2020 because it is the same as an earlier date of December 27 2019
1 Feb 2020 22:22:26
Object reference not set to an instance of an object. at Plugin_History.HistoryControl.?????????????????????????????????????????(String )
at Plugin_History.HistoryControl.?????????????????????????????????????????(Object , EventArgs )
at System.Windows.Forms.Timer.OnTick(EventArgs e)
at System.Windows.Forms.Timer.TimerNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
Updated from v2016 to v2020 on Win7 64bit system
-
wish i could sort the display issue out on the playlist.
-
@brodephat, can you please tell me your history plugin settings?
@djclews: please be more specific.
-
@marius
(http://radiolanarkshire.co.uk/radiodjscreen.png)
-
@marius
(http://radiolanarkshire.co.uk/radiodjscreen.png)
Just go to the settings > Plugins > double click Playlist > and then set "slots number" to 5-6 or whatever u want till the problem fixed
-
@marius
History plugins settings:
Zone: 3
Rows to display 100
Listener count checked pointing to a file that is updated from server.
-
The latest beta is available to download!
It uses the same database schema as the previous beta release, so to update it, just replace the files with the new ones.
I strongly recommend to test the version first and if everything is fine, to put it in production, because i may missed some bugs in my tests.
PS: Some antivirus may continue to alert you, but it's a false positive. Sorry for that. Soon the application will be digitally signed and hopefully this will be history.
PPS: The version jumped a bit for internal reasons... :D
hi marius, rdj 2020 is awesome.
i already set up my teaser, and it works perfectly. But lately, i found that we can set hook in and hook out directly from playlist, but when i press the shortcut to make teaser it didn't work (rdj 2020). i have set it up from search utility or track manager, and reload to playlist, and it works. previous rdj i can set it up from playlist,.. thx
-
Thanks for letting me know zandgame17, i will look into this.
-
Regarding your reply #31 where you asked for a SQL Track Rotation query, this is what I use:
/*
Select a random track from the top2000 category where:
1. the track is valid for the current date
2. the track has not yet been played today
3. the artist has not been played in the last 60 minutes
4. the artist is not already in the queuelist
5. with the lowest count_played
*/
SELECT * FROM songs
LEFT JOIN queuelist ON ( songs.artist = queuelist.artist)
WHERE songs.enabled = 1 /* enabled */
AND songs.song_type = 0 /* Music */
AND songs.id_subcat = 33 /* Top2000 */
AND ((`songs`.`start_date` <= Now()) AND (`songs`.`end_date` >= NOW() OR `songs`.`end_date` = '2002-01-01 00:00:01')) /* only tracks that are valid for the current date */
AND (TIMESTAMPDIFF(MINUTE, songs.date_played, NOW()) > 3600) /* don't play the same track twice a day */
AND (TIMESTAMPDIFF(MINUTE, songs.artist_played, NOW()) > 60) /* don't play the same artist twice an hour */
AND queuelist.artist IS NULL /* Artist not yet selected in queuelist */
AND count_played = (select min(count_played) from songs where id_subcat = 33) /* select the least played tracks */
ORDER BY RAND()
LIMIT 1
-
Regarding your reply #31 where you asked for a SQL Track Rotation query, this is what I use:
/*
Select a random track from the top2000 category where:
1. the track is valid for the current date
2. the track has not yet been played today
3. the artist has not been played in the last 60 minutes
4. the artist is not already in the queuelist
5. with the lowest count_played
*/
SELECT * FROM songs
LEFT JOIN queuelist ON ( songs.artist = queuelist.artist)
WHERE songs.enabled = 1 /* enabled */
AND songs.song_type = 0 /* Music */
AND songs.id_subcat = 33 /* Top2000 */
AND ((`songs`.`start_date` <= Now()) AND (`songs`.`end_date` >= NOW() OR `songs`.`end_date` = '2002-01-01 00:00:01')) /* only tracks that are valid for the current date */
AND (TIMESTAMPDIFF(MINUTE, songs.date_played, NOW()) > 3600) /* don't play the same track twice a day */
AND (TIMESTAMPDIFF(MINUTE, songs.artist_played, NOW()) > 60) /* don't play the same artist twice an hour */
AND queuelist.artist IS NULL /* Artist not yet selected in queuelist */
AND count_played = (select min(count_played) from songs where id_subcat = 33) /* select the least played tracks */
ORDER BY RAND()
LIMIT 1
This way you take the artist into consideration, but not the associated artists. In the current beta, the artist seperation is also put into the associated artist logic, so what basically happens is that you could get a song by "Paul Simon And Art Garfunkel" just after a song by "Art Garfunkel" and followed by a song by "Paul Simon". And this one is obvious, but the associated artists field makes it possible (and I use it extensively) to prevent a song by "Paul McCartney" following a song by "The Beatles". But currently I'm getting there, it's only not as neat as I was hoping. Have to put some stuff into a stored procedure to make it usable - why are there only 24 hours in a day.... :'(
-
Hi Calypso,
That is true, I don't take the associated artists into consideration. For that I would need to put all that information into the database, which is an enormous task. There are only 24 hours in a day here as well, so there is no time for that. I do make sure though that the artist names are as consequent as possible though, so no 'Simon and Garfunkel' and 'Simon & Garfunkel' and 'Paul Simon and Art Garfunkel' and whatever variation on this in my database: only one combination. That is doable. It works for me this way. Of course, it is still possible to have the Beatles. Wings and Paul McCartney back to back, but I really don't mind that. With around 30000 tracks that risk is rather small. My biggest concern was to select the tracks that were least played. Over time I tried several solutions in this query, this one (the last 'and' in the query) does the job the best. I'm always open for better options though...
Adrian
-
That is true, I don't take the associated artists into consideration. For that I would need to put all that information into the database, which is an enormous task.
Be aware that the recent beta versions don't use the artist seperation anymore when determining that "UB40 & Chrissie Hynde" are 2 artists, it uses the associated artist field which can be populated through the Utilities. So taking the associated artist field into consideration is (in my opinion) a "must".
Also, populating it can be a daunting task, yes, but in my database it's already done (50.000 items). And no, not by hand.
-
Hi Calypso,
Thank you for mentioning the utilities: I had not spotted the 'Associated artists' one! Will try it out this weekend and if it works okay (which I'm sure it will) I will alter my query!
Cheers,
Adrian
-
Hiya,
I used the 'Associated artists' utility and changed my query as below. Seems to work fine!
/*
Select a random track from the top2000 category where:
1. the track is valid for the current date
2. the track has not yet been played today
3. the artist has not been played in the last 60 minutes
4. the artist is not already in the queuelist
5. with the lowest count_played
*/
SELECT * FROM songs
WHERE songs.enabled = 1 /* enabled */
AND songs.song_type = 0 /* Music */
AND songs.id_subcat = 33 /* Top2000 */
AND ((`songs`.`start_date` <= Now()) AND (`songs`.`end_date` >= NOW() OR `songs`.`end_date` = '2002-01-01 00:00:01')) /* only tracks that are valid for the current date */
AND (TIMESTAMPDIFF(MINUTE, songs.date_played, NOW()) > 3600) /* don't play the same track twice a day */
AND (TIMESTAMPDIFF(MINUTE, songs.artist_played, NOW()) > 60) /* don't play the same artist twice an hour */
AND NOT songs.artist in (select queuelist.associated_artists from queuelist)
AND count_played = (select min(count_played) from songs where id_subcat = 33) /* select the least played tracks */
ORDER BY RAND()
LIMIT 1
-
Hi,
I noticed this error in my error-log:
Database Insert Error: FUNCTION radiodj2.REGEXP_INSTR does not exist (CALL UpdateTracks2(30826,'Katie Melua','Spider\'s Web',0,0,30,0);
UPDATE `songs` SET `artist_played`=NOW() WHERE REGEXP_INSTR(songs.associated_artists, '\\b(Katie Melua)\\b');
)
RadioDJ Version 2.0.2.0. MySQL Version 5.7.
Any idea what causes this??
-
Just a hunch but It could be MySQL 5.7 at fault I'd suggest you upgrade to something like MariaDB.
Backup any databases before changing over.
-
Hi Marius,
It was indeed MySQL 5.7 that caused the error. I upgraded to v8 and now the error no longer occurs.
Adrian
-
Thank you for the update. If however will return, please let me know.
-
Hiya,
I used the 'Associated artists' utility and changed my query as below. Seems to work fine!
/*
Select a random track from the top2000 category where:
1. the track is valid for the current date
2. the track has not yet been played today
3. the artist has not been played in the last 60 minutes
4. the artist is not already in the queuelist
5. with the lowest count_played
*/
SELECT * FROM songs
WHERE songs.enabled = 1 /* enabled */
AND songs.song_type = 0 /* Music */
AND songs.id_subcat = 33 /* Top2000 */
AND ((`songs`.`start_date` <= Now()) AND (`songs`.`end_date` >= NOW() OR `songs`.`end_date` = '2002-01-01 00:00:01')) /* only tracks that are valid for the current date */
AND (TIMESTAMPDIFF(MINUTE, songs.date_played, NOW()) > 3600) /* don't play the same track twice a day */
AND (TIMESTAMPDIFF(MINUTE, songs.artist_played, NOW()) > 60) /* don't play the same artist twice an hour */
AND NOT songs.artist in (select queuelist.associated_artists from queuelist)
AND count_played = (select min(count_played) from songs where id_subcat = 33) /* select the least played tracks */
ORDER BY RAND()
LIMIT 1
Yeah, getting there, but with the "in" statement you are looking for a exact match of the artist name compared to the contents of associated_artists, while "associated_artists" can be a set of artists. So what I've done is using the find_in_set function in MySQL, and that is nearly there.
However - it seems that there is still a risk for multiple entries. I'm using the setting that there must always be 2 full rotations in the queue. Somehow it looks like RadioDJ only writes the complete rotation in the queuelist at a time - so when you query the queuelist, the previous entries (from this rotation) aren't in it yet. @Marius: is this how it currently works?
BTW: I'd use the $ForceRepeatRules$ macro instead of hardcoding the repeat rules in the query - when you want to change the time artists (or titles or whatever) are not repeated, you have to change all the rules. With $ForceRepeatRules$ it's taken into account rightaway.
-
I'm wondering what's happening with these songs from the same artist in a very short time? (Jax Jones)
I'm testing on my machine, not on air. On the stable version this isn't happening.
-
Hi Calypso,
Thank you for your help, much appreciated!
I see what you mean: that subquery will never lead to a result. I changed my query as below:
SELECT * FROM songs
WHERE songs.enabled = 1 /* enabled */
AND songs.song_type = 0 /* Music */
AND songs.id_subcat = 33 /* Top2000 */
AND ((`songs`.`start_date` <= Now()) AND (`songs`.`end_date` >= NOW() OR `songs`.`end_date` = '2002-01-01 00:00:01')) /* only tracks that are valid for the current date */
AND (TIMESTAMPDIFF(MINUTE, songs.date_played, NOW()) > 3600) /* don't play the same track twice a day */
AND (TIMESTAMPDIFF(MINUTE, songs.artist_played, NOW()) > 120) /* don't play the same artist twice an hour */
AND (SELECT count(*) FROM queuelist WHERE FIND_IN_SET(songs.artist, queuelist.associated_artists) = 0) /* Associated artist not in queuelist */
AND count_played = (select min(count_played) from songs where id_subcat = 33) /* select the least played tracks */
ORDER BY RAND()
LIMIT 1
-
Andrei,
The slash is not in the sepator list:
,
;
f.
ft.
feat.
featuring,
&
and
and the
-
Hi Calypso,
There still is one issue though: when I copy the query in my previous post to the tracks rotation and run the query it returns an error and does not select a record. The problem is in the FIND_IN_SET part: when it's commented out the query is ok and returns a record. Could it be that this funxtion is not supported by RadioDJ.
Adrian
-
Ahhh, my own fault: got the brackets wrong:
AND (SELECT count(*) FROM queuelist WHERE FIND_IN_SET(songs.artist, queuelist.associated_artists)) = 0
-
Andrei,
The slash is not in the sepator list:
,
;
f.
ft.
feat.
featuring,
&
and
and the
I added the separtor in the slash list, and associated artists looks like in the screenshot. The problem is that it treats artists like this X / Y / Z as separate artists from X, Y, Z
I really don't know what i'm doing wrong :'( :'(
-
There was one other issue with my query... Artists like 'Hatfield & The North' are seperated as 'Hatfield' and 'The North' in the assiciated artist: 'hatfield, the north'. When you then check the artistname against the associated artists there is no match: 'Hatfield & The North' is not the same as 'hatfield' or 'the north'. So, instead of only checking the associated artists, you will have to check the artist name as well.
This is the final version of my query:
SELECT * FROM songs
WHERE songs.enabled = 1 /* the track is enabled */
AND songs.song_type = 0 /* Music */
AND songs.id_subcat = 33 /* Top2000 */
AND ((`songs`.`start_date` <= Now()) AND (`songs`.`end_date` >= NOW() OR `songs`.`end_date` = '2002-01-01 00:00:01')) /* only tracks that are valid for the current date */
AND (TIMESTAMPDIFF(MINUTE, songs.date_played, NOW()) > 3600) /* don't play the same track twice a day */
AND (TIMESTAMPDIFF(MINUTE, songs.artist_played, NOW()) > 120) /* don't play the same artist twice an hour */
AND NOT songs.artist IN (SELECT artist FROM queuelist) /* Artist not in queuelist */
AND (SELECT COUNT(*) FROM queuelist WHERE FIND_IN_SET(songs.artist, queuelist.associated_artists)) = 0 /* Associated artist not in queuelist */
AND count_played = (SELECT MIN(count_played) FROM songs WHERE id_subcat = 33) /* select the least played tracks */
ORDER BY RAND()
LIMIT 1
-
I changed the slash " / " with ", " and separation is not working in 'Search' (tracks aren't marked as 'played') and probably there are cases when two artists are played back to back.
I had three songs in a row from the same artists ::) ::)
-
Hi Calypso,
Thank you for your help, much appreciated!
Well we're helping eachother here - and most likely also Marius and the rest of the users - by trying to get the queries better. That's the whole idea of a community such as RDJ has ;)
-
Hi Marius,
I replicated the v2.0.1.5 database and then installed v2.0.2.0 and used the database update from 2.0.1.5 to 2.0.2.0
I checked usage and all seemed well.
However, I checked the procedures and found there were two procedures active.
UpdateTracks and UpdatTracks2.
I checked one against the other and then deleted the UpdateTracks procedure (I kept a text copy though just in case).
Everything still appears to work perfectly.
Have I done the right thing ?
Regards and thanks for all the wonderful things in v2.0.2.0 :)
Chris
-
I Understand that, but one or more SQL queries in your query mean a risk for repeated artists/songs, so that's why I'm stating that SQL Queries in a Rotation become unwanted because of that risk.
Hi Calypso,
I use SQL queries and my way to avoid repeats is to make the limit very high - enough to cover the time period I want to cover.
For instance:
I make the selection of tracks from whatever category with whatever filters I want using SQL and then use RAND(), LIMIT 80 for a 4 hour show.
That generates a random playlist from the desired criteria with 80 tracks in it and thanks to Marius's wizardry, it doesn't generate lag like it used to by having so many tracks in it.
After 4 hours, there are some tracks left - so I ensure that the next rotation clears the playlist (in an event) and generates a completely new playlist via a new or same rotation, thereby avoiding repeating a song that may have been in the playlist.
Does that make sense ??
Works here perfectly.
I hope this makes sense and works for you.
Regards,
Chris
-
I hope this makes sense and works for you.
Yes, it makes sense, but doesn't work for me :hihi: - the reason is that I use rotations to make a selection of different categories in a certain mix, so I almost always wanto to have a limit of 1. But that's the fun thing of something like RDJ; it has several ways of doing things to make almost unlimited possibilities.
-
Hi Marius,
I replicated the v2.0.1.5 database and then installed v2.0.2.0 and used the database update from 2.0.1.5 to 2.0.2.0
I checked usage and all seemed well.
However, I checked the procedures and found there were two procedures active.
UpdateTracks and UpdatTracks2.
I checked one against the other and then deleted the UpdateTracks procedure (I kept a text copy though just in case).
Everything still appears to work perfectly.
Have I done the right thing ?
What I remember is that UpdateTracks is there for historical reasons. AFAIK it isn't actively used in the latest versions.
-
Hiya,
After todays (28-02-2020) update of Windows Defender Antivirus, Radiodj 2.0.2.0 is now longer downloadable. Windows Defender says the file is infected with a virus (Program:Win32/Unwaders.A!ml) and quarantaines it right away. Radiodj 2.0.1.6 can be downloaded without any problems though...
Thought I would let you know. It's probably a false positive again but it blocks the download which is annoying...
Adrian
-
Hiya,
After todays (28-02-2020) update of Windows Defender Antivirus, Radiodj 2.0.2.0 is now longer downloadable. Windows Defender says the file is infected with a virus and quarantaines it right away. Radiodj 2.0.1.6 can be downloaded without any problems though...
Thought I would let you know. It's probably a false positive again but it blocks the download which is annoying...
Adrian
If you can try adding the RadioDJ folder and music files to the Exclude list in Windows defender or try disabling WD while you download and install.
-
Hey, just noticed that if RadioDJ plays a remote stream that is down, it freezes instead of kicking it out as in past times.
-
Hi everyone,
I’m having some problems with my Radiodj v2.0.2.0. It was working good all the time, now it freeze up or stop playing.
Is anyone also having the same problem? And how can I get this problem resolved?
-
Have you recently updated windows? what operating system are you on?
There are few windows updates causing issues.
-
Have you recently updated windows? what operating system are you on?
There are few windows updates causing issues.
Yes we have updated our windows 10
-
See Marius's post on this Topic [urll]https://www.radiodj.ro/community/index.php?topic=13906.0
-
Hi all,
Just downloaded the 2.0.2.0 beta version and I can't see all my music files in the Library Manager... Using Windows 10 and MySQL.
https://ibb.co/Dfn2VG7
-
When I clear the playlist manually & it reloads it doesn't automatically add requests to the queue it seems to ignore the request entry in the rotation.
Of which there are 3 in the current rotation. Don't know if this is a new issue or a recurring one.
-
I’m also having the issue when I clear the playlist manually & it reloads nothing comes up.
RadioDJ is working ok now because I have stopped all the Internet stream and Teaser from playing.
I realize that was causing the player to either freeze up or stop.
-
Extensive testing of the Run SQL Query Event action has shown that something has changed with it somewhere between RDJ 2.0.0.3 and RDJ 2.0.1.5.
I've downloaded RDJ 2.0.2.0 and was testing with this latest version.
I have a couple of SQL queries which check the database, calculate some values, then creates a playlist depending on what's been played and what's coming up. The next action in the event then loads the playlist to the top of the queue. This works flawlessly in RDJ 2.0.0.3.
When I run the queries in 2.0.2.0, RDJ doesn't log an error in it's log file. It does create an error in the windows event viewer.
Database Insert Error: Fatal error encountered during command execution. (SET @extrocat = 36; -- Sweeper Category ID for extro
SET @introcat = 14; -- Sweeper Category ID for intro
SET @seguecat = 35; -- Sweeper Category ID for Segues
SET @plid = 1; -- Segue Playlist ID
SET @GenSwp = 'Generic';
SET @lastsong = (SELECT trackID FROM history WHERE song_type=0 ORDER BY ID DESC LIMIT 1); -- Find ID of Last Song Played
SET @nextsong = (SELECT songID FROM queuelist WHERE ID=1); -- Find ID of Next Song to Play
SET @lastartist = (SELECT artist FROM songs WHERE ID = @lastsong); -- Last Artist Played
SET @lasttitle = (SELECT title FROM songs WHERE ID = @lastsong); -- Last Title Played
SET @nextartist = (SELECT artist FROM songs WHERE ID = @nextsong); -- Next Artist to Play
SET @nexttitle = (SELECT title FROM SONGS WHERE ID = @nextsong); -- Next Title to Play
SET @sID1 = (SELECT ID FROM songs
WHERE id_subcat=@extrocat
AND artist = @lastartist
AND (title IN (@lasttitle , @GenSwp))
AND ((start_date <= Now()) AND (end_date >= NOW() OR end_date = '2002-01-01 00:00:01'))
AND enabled=1
ORDER BY songs.date_played ASC LIMIT 1);
SET @sID2 = (SELECT ID FROM songs
WHERE id_subcat=@extrocat
AND artist = @GenSwp
AND ((songs.start_date <= Now()) AND (songs.end_date >= NOW() OR songs.end_date = '2002-01-01 00:00:01'))
AND enabled=1
ORDER BY songs.date_played ASC LIMIT 1);
SET @eID = COALESCE(@sID1 , @sID2);
SET @sID3 = (SELECT ID FROM songs
WHERE id_subcat=@introcat
AND artist = @nextartist
AND (title IN (@nexttitle , @GenSwp))
AND ((start_date <= Now()) AND (end_date >= NOW() OR end_date = '2002-01-01 00:00:01'))
AND enabled=1
ORDER BY songs.date_played ASC LIMIT 1);
SET @sID4 = (SELECT ID FROM songs
WHERE id_subcat=@introcat
AND artist = @GenSwp
AND ((songs.start_date <= Now()) AND (songs.end_date >= NOW() OR songs.end_date = '2002-01-01 00:00:01'))
AND enabled=1
ORDER BY songs.date_played ASC LIMIT 1);
SET @iID = COALESCE(@sID3 , @sID4);
SET @cuestr1 = (SELECT cue_times FROM songs WHERE ID = @eID);
SET @cstart1 = (SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(@cuestr1, '&sta=', -1), '&', 1));
SET @cend1 = (SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(@cuestr1, '&end=', -1), '&', 1));
SET @cfade1 = (SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(@cuestr1, '&fou=', -1), '&', 1));
SET @cnext1 = (@cend1 - @cfade1);
UPDATE `playlists_list`
SET `sID` = @eID, `cstart` = '0.0000' , `cnext` = @cend1, `cend` = @cend1 WHERE `pID` = @plid AND ord = 0;
SET @cuestr2 = (SELECT cue_times FROM songs WHERE ID = @iID);
SET @cstart2 = (SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(@cuestr2, '&sta=', -1), '&', 1));
SET @cend2 = (SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(@cuestr2, '&end=', -1), '&', 1));
SET @cfade2 = (SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(@cuestr2, '&fou=', -1), '&', 1));
SET @cnext2 = (@cend2 - @cfade2);
UPDATE `playlists_list`
SET `sID` = @iID, `cstart` = '0.0000' , `cnext` = @cend2, `cend` = @cend2 WHERE `pID` = @plid AND ord = 4;
SET @seg1 = (SELECT ID FROM songs
WHERE id_subcat=@seguecat
AND ((songs.start_date <= Now()) AND (songs.end_date >= NOW() OR songs.end_date = '2002-01-01 00:00:01'))
AND enabled=1
ORDER BY songs.date_played ASC LIMIT 1);
SET @seg = @seg1;
SET @cuestr3 = (SELECT cue_times FROM songs WHERE ID = @seg);
SET @cstart3 = (SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(@cuestr3, '&sta=', -1), '&', 1));
SET @cend3 = (SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(@cuestr3, '&end=', -1), '&', 1));
SET @cfade3 = (SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(@cuestr3, '&fou=', -1), '&', 1));
SET @cnext3 = (@cend3 - @cfade3);
UPDATE `playlists_list`
SET `sID` = @seg, `cstart` = '0.0000' , `cnext` = @cend3, `cend` = @cend3 WHERE `pID` = @plid AND ord = 2;
-- SELECT @eID , @iID , @sID1, @sID2 , @sID3, @sID4 , @seg , @seg1 , @lastartist , @lasttitle , @nextartist , @nexttitle
)
It turns out the only queries I can get to work are simple ones that basically do an update. I haven't tested a select query, as I can't see the results, but I'm guessing that they work too. As soon as I have a comment or variable in the query, it fails.
I would really like to run 2.0.2.0 to test it out, but if I can't run SQL Queries in events, I can't upgrade.
Marius, if you'd like any more info/screen shots, etc. let me know.
Thanks
-
Got this error for the first time.
I haven't done anything nor have I did any windows updates nor MariaDB updates:
Win7 64bit
MariaDB
RadioDJ v2.0.2.0 - updated from v2.0.1.6
The program is still running but it does have this in the log after about a week of the RDJ upgrade:
7 Mar 2020 21:03:38
Reading from the stream has failed. at MySql.Data.MySqlClient.MySqlStream.LoadPacket()
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.ReadOk(Boolean read)
at MySql.Data.MySqlClient.NativeDriver.SetDatabase(String dbName)
at MySql.Data.MySqlClient.Driver.SetDatabase(String dbName)
at MySql.Data.MySqlClient.MySqlConnection.ChangeDatabase(String databaseName)
at MySql.Data.MySqlClient.MySqlConnection.Open()
at rdjInterface.MysqlClass.MysqlQuery(String sql, DataSet& ds)
at `\,X^`"-yZ%Lvp2U$\\\&n!>(\*3#.MysqlQuery(String query, DataSet& ds)
at Plugin_Requests.UC_Requests.?????????????????????????????????????????()
at Plugin_Requests.UC_Requests.?????????????????????????????????????????(Object , EventArgs )
at System.Windows.Forms.Timer.OnTick(EventArgs e)
at System.Windows.Forms.Timer.TimerNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
8 Mar 2020 08:16:36
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at MySql.Data.Common.StreamCreator.GetTcpStream(MySqlConnectionStringBuilder settings)
at MySql.Data.Common.StreamCreator.GetStream(MySqlConnectionStringBuilder settings)
at MySql.Data.MySqlClient.NativeDriver.Open()
-
I'm using RadioDJ 2.0.2.0. For my rotations I am using a SQL querys. When I save the query the 'Sweepers' setting is set to 'Without'. How can I force this setting to 'Intro'? I noticed the $SweeperOnIntro& in the SQL window, but I have no clue on how to use it. At the moment, sweepers are not selected unless I do that manually in the queuelist.
Thanks in advance!
-
Setup, License Agreement
first line, 2009-2019, Broadcast Mediaware, LLC
date needs to be updated to 2020
-
Damn stevewa, already? :D
Thanks for pointing this out.
-
dUDE, I notice these thingz :)
I am a human compiler
-
Hi,
For this version, I had version 2.0.1.5
I updated the sql from version 2.0.1.5. To 2.0.2.0, but to installation of the program, it ran a rotation once, but it is now ready, but a new one is not executed. No matter which rotation I choose, the playlist remains empty.
Anton
-
Hey Anton, can you please check if the tracks are enabled, or if you have any errors on windows event logs?
-
Hi Marius,
Yes all the tracks are enabled. The solution from dj Johnny works. I made new rotations.
Tommorow I will look in the event log.
-
The solution was
Saving the rotations again in the rotation maker.
-
When I set a track rotation rule to Lowest Rating, it resets itself to Random. Highest Rating seems to be working fine. Any ideas?
-
Hi Marius,
I've been running v2.0.2.0 on and off for a while and used it on my shows in manual mode and not a problem.
Everything goes nicely and the new stuff is awesome.
Thanks and regards,
Chris M
-
Extensive testing of the Run SQL Query Event action has shown that something has changed with it somewhere between RDJ 2.0.0.3 and RDJ 2.0.1.5.
Further testing done on the Run SQL Event issue...
@Marius I downloaded V2.0.0.6 and the same issue is present. Previous to my last post, testing had been done on a completely brand spanking new database created for the testing. This time though, I created a new database for V2006, imported the data from V2003, then updated with the supplied SQL file, so all things are equal with the working V2003 program. I then copied everything over to my windows 10 pro laptop (test/backup machine is running windows 7 pro) and same results happen. (But for some reason, RadioDJ events do not show up in my events viewer -- maybe because I just copied the folder over and didn't install it?) Anyway, I now know it's not the backup machine. I don't think it's Maria DB, since RDJ V2.0.0.3 works fine.
I went through the release notes and noticed this for V2.0.0.4: - Updated the ADO.NET MySQL driver in order to support the new MySQL 8+ server [NEW];
Could this be the problem? If so, is there a way to roll back the ADO.NET driver?
My machine stats:
Test/Backup Machine: Win 7 Pro, Maria DB v10.4.11, RDJ versions 2.0.0.3, 2.0.0.6, 2.0.1.6, and 2.0.2.0.
Laptop: Win 10 Pro, Maria DB v10.3, RDJ Versions 2.0.0.3, and 2.0.0.6.
Thanks also to @Stinga who spent most of February helping me try and come up with a solution to this issue! Your help is very much appreciated.
-PROducer.
Edit: Yes, I know I'm talking about an older beta, but I have been working in reverse to see where this issue was introduced. The results are the same for v2.0.2.0.
-
Been running RadioDJ 2.0.2.0 for a few days on Tech Monkey's PC just to see how it handled being on that machine.
It had been running fine for 3 days until about half an hour ago when it just kept playing the same song over and over. Nothing in error logs.
I had to restart Radio DJ to get it to repopulate the playlist. Its certainly a strange one. Database setup said it was connected to the database when I clicked validate details.
I know I'm a fan of The shadows but not when they play 3 times before I noticed something was wrong.
-
I was busy to make a brand new installation with V2.0.2.0 and a compleet new Event and Rotations.
It's work perfect, after change some thinks in OPTION like, Audio Processing. RadioDJ does't start up anymore.
it's give some errors, after re-install and backup de database the same errors. See below.
___________________________________________________________________________
31 Mar 2020 17:40:55
The object reference is not set to a copy of an object. bij ~\&v%7IY(HG("5N\[WS0>k^\[32!.‫â€â€«â€â€‹â«â¬â¯â€â€â€ªâ€ªâ€®â¯â¬â€Žâ€¬â€Žâ€ââ«â€â¬â€¬â«â€®â¬â€â€‹â€â€®â¬â€®â€â€â®â€â¯â€â€¬â€®()
bij ~\&v%7IY(HG("5N\[WS0>k^\[32!.â¯âªâ€Žââ®â€Œâ€‹â€ªâ€â¬â¯â€â®â¬â«â€Œâ€âªâªâ€Žâ€Žâ€Žâ€â€â¯ââ¬â€Œâ€Œââ€â¯â¯â€Žâ€‹â€ªâ¯â«â€â€Žâ€®()
bij ~\&v%7IY(HG("5N\[WS0>k^\[32!.â¯â€Žâ€â€â€ªâ«â€‹â€Œâ«â¬â¯â¯âªâ€â€®â®â¯â€Œâ€â¬â€«â€«â€â€‹ââ€â€Žâªâ€«â€ªâ®â€‹âªâ®â€‹â€â‪‌â€â€®(Object , EventArgs )
bij System.EventHandler.Invoke(Object sender, EventArgs e)
bij System.Windows.Forms.Form.OnLoad(EventArgs e)
bij System.Windows.Forms.Form.OnCreateControl()
bij System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
bij System.Windows.Forms.Control.CreateControl()
bij System.Windows.Forms.Control.WmShowWindow(Message& m)
bij System.Windows.Forms.Control.WndProc(Message& m)
bij System.Windows.Forms.ScrollableControl.WndProc(Message& m)
bij System.Windows.Forms.Form.WmShowWindow(Message& m)
bij System.Windows.Forms.Form.WndProc(Message& m)
bij System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
bij System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
bij System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
-
Can you please upload somewhere the setting files?
I'm interested about "settings_general.xml" and "soundcardslist.xml".
-
This is the 3rd time I have seen this happening. (Song image being a red X)
(https://carterscripts.com/wp-content/uploads/2020/04/RadioDJ2020-Cover.png)
A restart of RadioDJ fixes it until it happens again.
Win7
4GB Ram
RadioDJ v2.0.2.0
Here an error in the logs:
31 Mar 2020 22:14:17
Parameter is not valid. at System.Drawing.Graphics.CheckErrorStatus(Int32 status)
at System.Drawing.Graphics.DrawImage(Image image, Int32 x, Int32 y, Int32 width, Int32 height)
at System.Drawing.Graphics.DrawImage(Image image, Rectangle rect)
at System.Windows.Forms.PictureBox.OnPaint(PaintEventArgs pe)
at System.Windows.Forms.Control.PaintWithErrorHandling(PaintEventArgs e, Int16 layer)
at System.Windows.Forms.Control.WmPaint(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
-
I did find a problem.
I was broadcasting and all of a sudden when I press for next song
then I hear a completely different song.
a little later I hear that song instead of something else.
i am using mysql
______________________________________________________
nederlands
ik heb wel een probleem gevonden.
ik was aan uitzenden en in eens als ik druk voor volgende liedje
dan hoor ik een heel ander liedje.
een beetje later hoor ik dat liedje in de plaats van iets anders.
ik gebruik mysql
-
@djbenbe: can you please check in tracks manager if you don't have any tracks that are not found?
@Brodephat: It is reproducible with the same track, or it's random?
-
@djbenbe: can you please check in tracks manager if you don't have any tracks that are not found?
I checked this and I was able to play them behind it.
I just played the same song. after my broadcast
______________________________________________
nederlands
ik heb dit gecontroleerd en ik heb ze er achter wel kunnen afspelen.
ik heb gewoon zelfde liedje afgespeeld. na mijn uitzending
-
@djbenbe: can you please check in tracks manager if you don't have any tracks that are not found?
@Brodephat: It is reproducible with the same track, or it's random?
When the cover image goes to showing the red x it will be for everything that plays until I restart it. So it's not a particular song. As for the rotations, I would have to wait until this happens again and cause the rotations to change and see what happens. This happens maybe once a few weeks.
-
It seems my WebExport is not always working but this article has some causes and remedies that appears must be done via the program.
https://support.microsoft.com/en-au/help/908573/a-post-or-put-request-may-fail-when-you-use-the-httpwebrequest-class-t (https://support.microsoft.com/en-au/help/908573/a-post-or-put-request-may-fail-when-you-use-the-httpwebrequest-class-t)
Tweeting (WebExport) is very unreliable in v2.0.2.0 than it was in v2.0.1.3
Playing Info Plugin [Web Export] Error: The operation has timed out
at System.Net.HttpWebRequest.GetRequestStream(TransportContext& context)
at System.Net.HttpWebRequest.GetRequestStream()
at Plugin_PlayingInfo.ClassUpdate.(ataDgnoS)
UPDATE: The funny thing is I have 4 stations all on the same PC and the other 3 have no issues with the web-export feature. This one station has stopped completely. SO it's something with this installation that suddenly just stopped posting.
-
Are requests supposed to disappear from the request list that haven't played when you use auto to add them to load bottom
Its just added a load of requests I just made and the request window is empty yet they haven't played yet. Is this normal behaviour or is it a bug?
-
@Brodephat
I think it must be something else.
You're not sending a ton of data in a tweet.
For the station with the issue, if you call the twitter api directly, bypassing, RDJ, does the tweet get accepted and posted on twtr, or does your api endpoint return an error? I would check there first.
-
@Brodephat
I think it must be something else.
You're not sending a ton of data in a tweet.
For the station with the issue, if you call the twitter api directly, bypassing, RDJ, does the tweet get accepted and posted on twtr, or does your api endpoint return an error? I would check there first.
Yes I can post via a browser but check this out:
Since the other stations worked fine I decided to point the web export of the troubled station to another hosted site I have and still got a no go.
So, I assumed that maybe the install itself was corrupt in some way. So I re-installed over the current installation. Same issue.
Then I decided to do a fresh install and import the database from the current install to the fresh install and WHOA it's working again! But only when pointing the web export to the other domain.
And within a few hours I got this and had to restart it to clear it up (the red x on pictures in RadioDJ):
9 Apr 2020 16:33:55
InvalidArgument=Value of '3' is not valid for 'SelectedIndex'.
Parameter name: SelectedIndex at System.Windows.Forms.ComboBox.set_SelectedIndex(Int32 value)
at Plugin_SoundProcessing.FormSetProcessing.(ComboBox , Int32 )
at Plugin_SoundProcessing.FormSetProcessing.?()
at Plugin_SoundProcessing.FormSetProcessing.(Object , EventArgs )
at System.Windows.Forms.Form.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
9 Apr 2020 22:21:43
Parameter is not valid. at System.Drawing.Graphics.CheckErrorStatus(Int32 status)
at System.Drawing.Graphics.DrawImage(Image image, Int32 x, Int32 y, Int32 width, Int32 height)
at System.Drawing.Graphics.DrawImage(Image image, Rectangle rect)
at System.Windows.Forms.PictureBox.OnPaint(PaintEventArgs pe)
at System.Windows.Forms.Control.PaintWithErrorHandling(PaintEventArgs e, Int16 layer)
at System.Windows.Forms.Control.WmPaint(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
Win7
4GB Ram
RadioDJ v2.0.2.0
-
Are requests supposed to disappear from the request list that haven't played when you use auto to add them to load bottom
Its just added a load of requests I just made and the request window is empty yet they haven't played yet. Is this normal behaviour or is it a bug?
OK its my mistake I had another copy of RadioDJ open (connected to same database) and that was set to stick requests at the bottom of the queue, I thought I'd clicked the only 1 instance box and hadn't.
It still shouldn't be registering the tracks as played when the request plugin is set to auto add them to the playlist surely?
-
Hi.
First of all, I'm sorry for my bad english, then I thank google for the translation.
I have been a user of RadioDJ since January 2020: Thanks Marius for the excellent work.
I installed version 2.0.0.6 with mySQL8+ and I found myself well except for some problems related to the replay of streams. I searched the forum and it seems that the version I use has a bug on the reproduction of event streams for which Marius has recommended to use an auxiliary player. I would like to update radiodj to version 2.0.2.0 and I am conducting some tests to check compatibility with the version 2.0.0.6 database after applying the sql query 2.0.0.6 to 2.0.2.0.
The tests seem to give positive results except for the rotations that must first be canceled and rewritten.
I noticed that if I double click on a track that is an audio file in the playlist, I can edit and save it, but if I double click on a track that is a streaming playback in the playlist, the edit window appears but the track disappears from the playlist. Is it a bug?
In addition to the rotations, do I have to fix anything else for the transition from 2.0.0.6 to 2.0.2.0?
I have 25451 song: can I have a query to overwrite the associated artist field with the artist field? thank you.
-
I noticed that if I double click on a track that is an audio file in the playlist, I can edit and save it, but if I double click on a track that is a streaming playback in the playlist, the edit window appears but the track disappears from the playlist. Is it a bug?
You cannot edit a streaming playback, I think it has never been possible neither today with V2.0.2.0 or with 1.8.2. No, it's not a bug.
-
You cannot edit a streaming playback, I think it has never been possible neither today with V2.0.2.0 or with 1.8.2. No, it's not a bug.
Maybe I did not say it clear enough:
If I want to import an audio track, I click on the track Manager, I click on the import File then the edit window appears where I enter the category (e.g. music) the type of track (music), Genre, Details, sweepers, Title, artists, image, comments, insert events at the start and stop of playback, select the audio file and many other things.
If I want to import a streaming track, I click on the track Manager, I click on the import File then the edit window appears where I enter the category (Radio streams) the type of track (internet stream), Genre, Details, sweepers, Title, artists, image, comments, insert events at the start of playback select the path on the network to connect to and many other things.
In version 2.0.0.6, by double clicking on the playlist, the edit window appears where I can edit the data or edit the sweepers, insert events at the start and in the case of an "internet stream" track, also change the address to connect to.
In version 2.0.2.0, by double clicking in the playlist, the edit window appears where, in the case of an audio file, I can edit data such as version 2.0.0.6 while in the case of an "internet stream" track, the edit window appears regularly but the track disappears from the playlist.
-
Hey REA, i can confirm this behaviour and is a bug. I'm working on this right now.
Thanks for reporting it.
-
@Marius.
A request is set as played while it is still in the list and has not yet been played
in the radio DJ request screen I have set that if there is a request it will put these automatically directly at the top of the playlist.
now I have discovered that once the request is in the play list, in the request table it is set as playing, while it still needs to be played.
On creating a php page in a new script, what is requested I saw this, and my page does not match what has or has not been played.
Hope you can fix this.
-
Best,
i have a problem with the shortcuts.
every time I restart my program I sometimes have to reset them or they won't work.
I use those shortcuts for my mapping of my mixer.
Kind regards,
Ben
-
Which mixer are you using?
-
beste,
i use d & r airlite.
with kind regards,
Ben
-
It's a familiar issue. Just read this post how to solve it.
https://www.radiodj.ro/community/index.php?topic=12440.msg70212#msg70212 (https://www.radiodj.ro/community/index.php?topic=12440.msg70212#msg70212)
-
It's a familiar issue. Just read this post how to solve it.
https://www.radiodj.ro/community/index.php?topic=12440.msg70212#msg70212 (https://www.radiodj.ro/community/index.php?topic=12440.msg70212#msg70212)
best,
Thanks for the info.
Kind regards,
Ben
-
Noticed here lately RadioDJ shuts down so I'm going through to test songs that were added recently to see if perhaps one is corrupt because this is new.
However I did see this in Windows error log around the time of one of the shut downs that could be related to it:
sound engine init error #2: BASS_ERROR_BUSY
Thought I'd share that.
-
Strange issue just started happening this past couple of days i have my rotation made up of 2 songs from a category followed by a jingle with 14 entries in the rotation
At some point the rotation is missing a song category out and pushing two jingles together I have enough music in the categories so that's not an issue.
Its like a car crash when the two jingle appear together. I may just go back to loading jingles via events see if that helps.
-
Hi I'm new to this so I hope I'm posting in the right place. We have been trialling radio dj for a couple of weeks. We have been testing the version 2.0.0.6 without any issues. Last weekend I installed the beta version 2.0.2.0. Everything seemed to go OK. However if we leave the new version playing on auto dj after about 10 hours it locks up. Windows says radiodj.exe has caused a problem. I looked in the event log and it says “The following fatal alert was received 20” We never got this error in the old version. I would appreciate any suggestions.
Many thanks
-
Hi I'm new to this so I hope I'm posting in the right place. We have been trialling radio dj for a couple of weeks. We have been testing the version 2.0.0.6 without any issues. Last weekend I installed the beta version 2.0.2.0. Everything seemed to go OK. However if we leave the new version playing on auto dj after about 10 hours it locks up. Windows says radiodj.exe has caused a problem. I looked in the event log and it says “The following fatal alert was received 20” We never got this error in the old version. I would appreciate any suggestions.
Many thanks
Is there anything RadioDJ related in the Windows error logs?
Start>Control Panel>Administrative tools>Event viewer>Windows Logs>Application
-
Hi
Thanks for the reply. I can't attach a photo it says the file is to big but this is what it says Event clr20r3 problem signature01 Radidj.exe problem signature 02 2.0.2.0 problem signature 03 5e247ae1 problem signature 04 system prob sig 05 4.8.4001.0 prob sig 06 5d37b3ae . Also I setup the old version again on the same PC and left it running. It ran all night without any issues. In the event log all it says is "The Following fatal alert was received 20". The computer I'm using is one of our playout pc's so I know its a reliable box.
Many thanks.
Rob
-
Hi,
This evening at 21:00, RadioDJ again crashed while loading the top of the hour event. This happens every now and then. The TOTH event schedules the TOTH jingle and a manual event which mentions the time. After that, the Play command id launched to start the TOTH jingle. The program crashes during this event. 99 times out of 100 the exact same event runs without any problems. The error message from the errorlog is below. Hope you can understand what it says....
Adrian
ERROR: System.ArgumentOutOfRangeException: De index valt buiten het bereik. Deze mag niet negatief zijn en moet kleiner zijn dan de grootte van de verzameling.
Parameternaam: index
bij System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource)
bij ~\&v%7IY(HG("5N\[WS0>k^\[32!.()
bij ~\&v%7IY(HG("5N\[WS0>k^\[32!.(Object )
bij System.Threading.ThreadHelper.ThreadStart_Context(Object state)
bij System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
bij System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
bij System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
bij System.Threading.ThreadHelper.ThreadStart(Object obj) bij System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource)
bij ~\&v%7IY(HG("5N\[WS0>k^\[32!.()
bij ~\&v%7IY(HG("5N\[WS0>k^\[32!.(Object )
bij System.Threading.ThreadHelper.ThreadStart_Context(Object state)
bij System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
bij System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
bij System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
bij System.Threading.ThreadHelper.ThreadStart(Object obj)
-
:-[
Hi,
another unexpected stop of radio dj. It happens at random times, in fact the software does not crash but stop AUTODJ, remaining tracks in the playlist are played and then it stays idle.
however when i click clear playlist to reload rotation nothing happen; I have to restart RDJ
and ,if when stopped, an event occurs : it works (for example play a news file or hourly bell) but it does not resume autodj rotation.
Here are the logs:
ExceptionLog :
27 Jun 2020 08:51:51
Cannot find table 0. at System.Data.DataTableCollection.get_Item(Int32 index)
at rdjInterface.Playlist.AutoDJClass.?????????????????????????????????????????(DataTableCollection , Int32 )
at rdjInterface.Playlist.AutoDJClass.GeneratePlaylist(Int32 RotationID, Int32 ItemsCount, Double duration)
at ~\&v%7IY(HG("5N\[WS0>k^\[32!.?????????????????????????????????????????.?????????????????????????????????????????()
at System.Threading.Tasks.Task`1.InnerInvoke()
at System.Threading.Tasks.Task.Execute()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at ~\&v%7IY(HG("5N\[WS0>k^\[32!.LZ5YQ5\.CZKF')Ssu_8Rk3nu7.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.AsyncMethodBuilderCore.<>c.<ThrowAsync>b__6_0(Object state)
WindowsLogs:
Database Query Error: Fatal error encountered during command execution. (SELECT
ID,
artist,
associated_artists,
title,
album,
duration,
date_added,
date_played,
artist_played,
title_played,
album_played,
id_subcat,
id_genre,
song_type,
weight,
start_type,
end_type,
mood,
gender,
lang,
rating,
year,
bpm,
count_played
FROM songs WHERE
enabled='1' AND
((start_date <= Now() AND (end_date >= NOW()) OR end_date = '2002-01-01 00:00:01'));)
just after:
Database Insert Error: Fatal error encountered during command execution. (CALL UpdateTracks2(65979,'france gall','hippie hippie',0,0,365,0);
)
and (same as exception)
ERROR: System.IndexOutOfRangeException: Cannot find table 0.
at System.Data.DataTableCollection.get_Item(Int32 index)
at rdjInterface.Playlist.AutoDJClass.?????????????????????????????????????????(DataTableCollection , Int32 )
at rdjInterface.Playlist.AutoDJClass.GeneratePlaylist(Int32 RotationID, Int32 ItemsCount, Double duration)
at ~\&v%7IY(HG("5N\[WS0>k^\[32!.?????????????????????????????????????????.?????????????????????????????????????????()
at System.Threading.Tasks.Task`1.InnerInvoke()
at System.Threading.Tasks.Task.Execute()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at ~\&v%7IY(HG("5N\[WS0>k^\[32!.LZ5YQ5\.CZKF')Ssu_8Rk3nu7.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.AsyncMethodBuilderCore.<>c.<ThrowAsync>b__6_0(Object state) at System.Data.DataTableCollection.get_Item(Int32 index)
at rdjInterface.Playlist.AutoDJClass.?????????????????????????????????????????(DataTableCollection , Int32 )
at rdjInterface.Playlist.AutoDJClass.GeneratePlaylist(Int32 RotationID, Int32 ItemsCount, Double duration)
at ~\&v%7IY(HG("5N\[WS0>k^\[32!.?????????????????????????????????????????.?????????????????????????????????????????()
at System.Threading.Tasks.Task`1.InnerInvoke()
at System.Threading.Tasks.Task.Execute()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at ~\&v%7IY(HG("5N\[WS0>k^\[32!.LZ5YQ5\.CZKF')Ssu_8Rk3nu7.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.AsyncMethodBuilderCore.<>c.<ThrowAsync>b__6_0(Object state)
I manually inserted the track which maybe caused the error, but it was played without issues...
Our mariaDb base is on a NAS in our local network
Is there a way in a next release to overcome sql timeouts and retry than just throw a exception that locks radiodj ?
like a big number of retries in the DataTableCollection class...
I raised timeout in mariadb config.
But it does not seems to be a timeout.
To overcome this problem, I started to make a watchdog program that checks if queuelist is empty for a too long time and then kill and restart rdj.
Thanks.
-
Cannot find table 0. usually means your database has crashed use Heidi SQL to repair.
-
thanks ,
I will try to, but why does it happens randomly and everything works well after restarting rdj?
.k.
-
why does it happens randomly and everything works well after restarting rdj?
Its a quirk of MySQL if the computer gets suddenly shut down (e.g: power cut) it can cause the tables to crash.
It happens to me occasionally
Like I say to everyone its easy enough to use Heidi SQL to repair it with.
-
ah I see,
In my case that's not a computer crashing but a docker in another server who generates the metadata for our player/website that I'm forcing to reboot 3 times a day. The hours when rdj crash match the forced restarts. At 99% of times nothing happens but sometimes not (I think when a sql request is not finished for example)
But rdj should handle these events a better way to not cause a broadcast blackout...
thanks for your feedback :ok:
-
Well apart from the already mentioned issues the 2020 beta seems really stable at least that's one thing Marius doesn't have to worry about.
-
Hi all, what are some of the changes/additions in 2020beta as opposed to 2.0.0.6 ? I installed it a few minutes ago.
-
Hi all, what are some of the changes/additions in 2020beta as opposed to 2.0.0.6 ? I installed it a few minutes ago.
If "it" is v2.0.2.0, then in the Docs subdirectory you'll find the file ChangesLog.txt.
-
If "it" is v2.0.2.0, then in the Docs subdirectory you'll find the file ChangesLog.txt.
Thanks....
I swear, I did not know about that text file...
-
Thanks....
I swear, I did not know about that text file...
Discovering something new every day :cool: - but no problem, that's what help is for.
-
Hi,
I mention this problem earlier. Quite often RadioDJ crashes while performing the Top Of The Hour event. When RadioDJ crashes, it always happens at 27 seconds to the hour. That is when my TOTH jingle is scheduled, followed by a manual event to say the time. I repaired the HeidiSQL database but that dit not solve the problem. The TOTH event is the same for every hour: most of the time there is no problem but once in two or three days the program crashes on the same event. The hour it occurs differs though....
The TOTH event has only three commands:
1. Load playlist|0|2|Time|Top
2. Load track from category|0|31|0|0|1|False|Top of the Hour|Any Genre|Least Recently Played|Top
3. Play!
Below is the info from the error-log.
ERROR: System.ArgumentOutOfRangeException: De index valt buiten het bereik. Deze mag niet negatief zijn en moet kleiner zijn dan de grootte van de verzameling.
Parameternaam: index
bij System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource)
bij ~\&v%7IY(HG("5N\[WS0>k^\[32!.()
bij ~\&v%7IY(HG("5N\[WS0>k^\[32!.(Object )
bij System.Threading.ThreadHelper.ThreadStart_Context(Object state)
bij System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
bij System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
bij System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
bij System.Threading.ThreadHelper.ThreadStart(Object obj) bij System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource)
bij ~\&v%7IY(HG("5N\[WS0>k^\[32!.()
bij ~\&v%7IY(HG("5N\[WS0>k^\[32!.(Object )
bij System.Threading.ThreadHelper.ThreadStart_Context(Object state)
bij System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
bij System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
bij System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
bij System.Threading.ThreadHelper.ThreadStart(Object obj)
Toepassing: RadioDJ.exe
Framework-versie: v4.0.30319
Beschrijving: het proces is beëindigd als gevolg van een onverwerkte uitzondering.
Uitzonderingsinformatie: System.ArgumentOutOfRangeException
bij System.ThrowHelper.ThrowArgumentOutOfRangeException(System.ExceptionArgument, System.ExceptionResource)
bij ~\&v%7IY(HG("5N\[WS0>k^\[32!.()
bij ~\&v%7IY(HG("5N\[WS0>k^\[32!.(System.Object)
bij System.Threading.ThreadHelper.ThreadStart_Context(System.Object)
bij System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
bij System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)
bij System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object)
bij System.Threading.ThreadHelper.ThreadStart(System.Object)
-
search the forums, for english "index out of range"
you will find many psotings & solutions
https://www.radiodj.ro/community/index.php?topic=14455.msg80126#msg80126
-
Thanks for your reply, I have read the link. I'm a programmer myself and know what an 'index out of range' means. But shouldn't it be handled in the software by means of a try-catch block? 'Index out of range' can of course happen but it should not lead to the crash of the application. Just trying to make the program even better!
-
I am a program er too but it is not my app and it is free so we must wait patiently for Marius to investigate it
-
Hmm just came across an anomaly. If you have Now Playing info open and try to open another window from the bottom panel RadioDJ locks up
I had to use the Task Manager to close it.
-
My long term test computer is a low end one by today standards: Zotac ZBOX ID83 with an old i3 2330M processor/8GBytes DDR3 @665MHz/Intel 545s series SSD.
Are these thin clients or small pc's just as good as a standard desktop pc or are they prone to over heating and freezing.
There meant be a lot cheaper to run electricity wise.
We got proper rack mount dell servers at the station for Radiodj
-
In my schedule there is a jingle at the top of the hour, followed by a one hour show. The size of the mp3 file of the show is between 80 and 120 Mb, depending on the bit rate the presenter has used. Every now and then, there is a 2 minute gap between the Toth and the start of the show. Most of the time the two files follow each other flawless. The show is added to the top of the schedule while the Toth is playing. In the logging I can see that the show is added at 6 seconds after the Toth, yet it only starts playing 2 minutes later. I don't have a clue what is causing this problem. Anyone have an idea? Radiodj v2. 0.2.0 running on a windows 2016 server with ssd harddisk, 6 cores and 16gb internal memory.
-
The files are stored locally? On Windows 10 with the newer updates, i often saw that external USB drives are entering on power saving (sleep), even if i disable that, case in which it takes some time to spin up the drive and start reading it.
-
Hi Marius,
I thought of that but his is an SSD drive so it has no spin delay.... It doesn't happen often though, a couple of times per week at random times.
Adrian
-
Any chance that something intensive (like updates, or virus scanning) is running in background? You can try to increase the RadioDJ priority in settings as a test.
-
Another thing you can try is to disable the "high precision cue points" in track editor, which requires to scan the whole file.
-
Hi Marius,
That is a very good tip, I'll try that. I will keep you informed!
Adrian
-
Hi again Marius,
Unfortunatelly, I cannot disable the 'high precision cue points'. The presented show is selected in an event by a datemask yyyy-MM-dd.HH.m3u (load m3u playlist by datemask) which points to an m3u file. That m3u file references the corresponding mp3 file. RadioDJ automatically adds the mp3 file to the playlist when the m3u file is selected, which happens while the TOTH is playing. So, there is no opportunity to change the cue points before the file starts playing....
Adrian
-
I'm not sure i understand how you do it, the files from the playlist are not imported yet in rdj? If so, the program will first import them and when playing it will read it again, this indeed can cause some delay, but i'm baffled about the 2 minutes delay. It's a lot.
If you have the chance the import the files first, you can disable the high precission cue point from the track editor. Then whenever you load the track, even when using playlists, the settings will apply.
-
Hi Marius,
Let me explain. We are running a radio station with presenters pre-recording 1 hour shows. They upload their shows to our server. While the shows are uploaded (via a custom built web application), the name of the show is changed to it's broadcast date and time (dd-mm-yyyy.hh.mp3). Because RadioDJ can only schedule M3U files based on date-format, a corresponding M3U is created automatically for each show (dd-mm-yyyy.hh.m3u).
Events are used to schedule the Top of the hour event as well as the shows. The TOTH is scheduled at precisely the top of the hour and lasts for 20 seconds. 6 seconds after the TOTH has started, the next show is loaded. I cannot load the show earlier because sometimes a show is missing in which case we broadcast non-stop music. The show is loaded by a 'Load M3U playlist by Date Mask' event so the right show is aired at the right time. The mp3 files have not been added to the RadioDJ playlist before, RadioDJ does that automatically when the M3U file is loaded. The M3U file references the MP3 file with the same name. So, the MP3 file is loaded and added to the RadioDJ playlist just before it is played.
A day later, all the shows that have been aired the previous day are deleted and an event removes th deteled tracks from the playlist using an 'Verify tracks' event.
-
Hi Marius,
Just an idea: would it be possible to create an event-type that imports files from a given directory? That way, I can import the files before they are broadcast.
Adrian
-
There is the Folder Sync plugin which syncs a folder to a custom defined subcategory. The sync operation can be done either manually, either by creating an event. You could give it a try.
-
Hi Marius,
You keep surprising me! I was not aware of that plugin: I'll give it a try, will keep you posted about the results!
Adrian
-
Don't know about anyone else but the songs/artist repeating bug seems to have been fixed here.
I'm not seeing songs by the currently playing artist populating the bottom of the queue as I was in 2016
Did that happen for you with a remote instance connected or with a single RadioDJ machine active? Currently I'm dealing with something that sounds similar, except it doesn't queue up the song but log it in the database despite the remote instance being set as passive.
-
Is there a chance for a beta update? :angel:
So Having some to do in the lock down time for testing. 8)
-
hei Marius and all of radiodj users, Happy New Year and Merry late Christmas to all of u.
Help. I found that, with mysql my playlist isn't running well when britney spears play, there is britney spears feat, not marked as play too. but when i'm using MariaDB, it marked as well. is it bugs? or?
Thx
-
I too am having new version withdrawal symptoms lol. They are always worth it but we always have to wait a seriously long time for a new version :D :huh: :hihi: ???
-
Unfortunatelly, the +/- 2 minute gap still occurs, also after I added an event to synchronize the folder on a daily basis at 23:30. I have no idea what causes this. I'm downloading tomorrows shows to my own PC and will run the same schedule locally as well....
Adrian
-
Hello, I installed version 2.0.2.0 and it does not respect the repetition rules at all (it seemed to be a new option in this version), neither those which are in the options, nor those that we can put in the rotations. 1 title can even pass 2 times in 1 hour!
I also have a problem when he has to broadcast a live stream. It crashes the software. Same if I want to edit the stream track. Help !
Thank you.
-
Its a known issue and I'm sure Marius is working hard on bringing us a new version.
-
Guys, how to minimized to tray with argument when i set event "run application" database backup? any clue. thx ;)
-
I may have a bug. I was running the latest release and decided to upgrade to the latest beta 2020. Everything seemed to be working correct except logging. I have it checked in the settings but nothing is ever logged in event viewer. RadioDJ doesn’t even show up as an application when setting up filters. I have tried reinstalling but that had no effect.
-
Dear Friends, Dear Marius
I have a problem with, and a suggestion for future versions of Now Playing Info plugin:
The problem I encountered after installing v2020 is as follows: A new track starts, the plugin correctly exports now plying data to a txt file, and simultaneously fails to export the correct data in the web export POST. It probably exports something, but the information is clearly uninterpretable for the web script, since the webpage is not updating. I coded my PHP script in such a way, that even if complete nonsense arrives as track info with the correct XPWD, the script will display a default track element, but it is not even doing that. This means when this happens, not even the XPWD is correct, or maybe it is the only incorrect variable in the POST, I have no idea.
This problem happens once about every 6-7 tracks played, distributed completely randomly. This issue is not caused by the info it has to send out, the exact same track's info is sometimes sent out, sometimes not, completely random. It is also not caused by the webserver, I never had this problem with the previous versions of RadioDJ.
My suggestion for future versions: A text encoding option for UTF8, without the BOM. BOM is mostly useless in UTF8, and many programs cannot interpret it, and they display it as a character in front of the text, and this is really annoying. Sometimes it can also cause crashes, a good example for this is the BUTT source client, which crashes when I try to feed it a txt file in UTF8 BOM (as the stream metadata). Unfortunately, the UTF8 encoding option in the plugin exports with a BOM, and there is no way to export without it in UTF8. If it is for some reason necessary to keep the UTF8 BOM in the plugin, please at least give us 2 options for it, like:
- UFT8 BOM
- UTF8
Thank you for your time and effort, keep up the excellent work!
David
-
Hey David!
The boom issue was fixed and it will be available in the next version, which hopefully will be released soon.
-
Hey David!
The boom issue was fixed and it will be available in the next version, which hopefully will be released soon.
Chomping at the Bit to test a new version...
-
Hey David!
The boom issue was fixed and it will be available in the next version, which hopefully will be released soon.
Thank you for the quick answer! I can't wait for the new version!!! ;)