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.
-
test post (will be deleted)
-
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.