Author Topic: Reports  (Read 345 times)

danny.oranim

  • Jr. Member

  • Offline
  • **
  • 50
Re: Reports
« Reply #15 on: September 10, 2019, 06:59:58 AM »
for that you would need to use a database tool like HeidiSQL to directly query data tables, and find tracks that have events assigned to them, and using that same tool you could read the history data table and see what the last song that was played before there was a long gap with no music (the crash).
The rdj not crashing,I have a manual event that making a pause for the events.It`s possible that 1 of the radio operators put in the end of the song that manual event by mistake,cause of that the stop button is on the events not changing.
And how I using  HeidiSQL to find the song?

stevewa

  • Hero Member

  • Offline
  • *****
  • 509
Re: Reports
« Reply #16 on: September 10, 2019, 12:31:09 PM »
I’m sorry I don’t have time to teach you Heidi sql, you’re needing to learn it from YouTube

danny.oranim

  • Jr. Member

  • Offline
  • **
  • 50
Re: Reports
« Reply #17 on: September 10, 2019, 02:23:03 PM »
I’m sorry I don’t have time to teach you Heidi sql, you’re needing to learn it from YouTube
In which table I can see that according the screenshot I attached?
https://oranimlive-my.sharepoint.com/:i:/g/personal/danny_tveria_oranim_ac_il/EdYUFaNVTKFOv6pMTA1shsYBMfMWxycSxmEmOsYt8NBMeQ?e=DVQa5l

stevewa

  • Hero Member

  • Offline
  • *****
  • 509
Re: Reports
« Reply #18 on: September 10, 2019, 02:37:18 PM »
edit your post so it is a link that we can click on,

stevewa

  • Hero Member

  • Offline
  • *****
  • 509
Re: Reports
« Reply #19 on: September 10, 2019, 02:41:12 PM »
lol, you are smart enough to use vnc, AND launch MySQL Workbench, BUT you can't browse thru the data tables to find which one has the playback history in it?
OR which table has song data in it, and which column has event codes?

shake my head. i'm trying to embarrass you so you don't make these silly mistakes next time. apes gave you a brain. use it.

DJ Garybaldy

  • Global Moderator
  • Hero Member

  • Offline
  • *****
  • 3725
  • Personal Text
    Just an ordinary RadioDJ user!
    • DJ Garybaldy
Re: Reports
« Reply #20 on: September 10, 2019, 02:44:37 PM »
OK can we try being a little less rude when replying to someone's problem we want the user to feel they're part of a community try not to belittle people. We all had to start somewhere.
Proud USER of RadioDJ since 2010

https://djgarybaldy.co.uk/maria-db-radiodj/
https://djgarybaldy.co.uk/help-cant-install-radiodj
https://djgarybaldy.co.uk/running-a-database-neednt-be-scary/
https://djgarybaldy.co.uk/using-a-stand-alone-encoder-with-radiodj-neednt-be-difficult

Jhonny

  • Hero Member

  • Offline
  • *****
  • 3522
  • Personal Text
    Peace, enjoy life.it's over before you've lived it
    • Jhonny's RadioDJ tutorials.
Re: Reports
« Reply #21 on: September 10, 2019, 03:06:11 PM »
edit your post so it is a link that we can click on,
There is a search button in the top bar of Heidi .
R.T.F.M. means to me, Read The Fantastic Messages.
Make things simple, but don't make simple things simpler!
I don't do drugs, I do tuts. ( ͡° ͜ʖ ͡°) visit https://radiodj.info

Testing RadioDJ v2.0.1.6 Beta

bnickles1961

  • Jr. Member

  • Offline
  • **
  • 83
  • Personal Text
    "Michigan Sucks"
    • All Oldies 247
Re: Reports
« Reply #22 on: September 10, 2019, 03:13:16 PM »
I agree Gary, people should feel confident when asking for help and should not have to be subject to people being rude.  This is a help and support forum.
Playing All Your Favorite Oldies celebrating 5 years! Check Us Out Here: https://www.alloldies247.com

Jhonny

  • Hero Member

  • Offline
  • *****
  • 3522
  • Personal Text
    Peace, enjoy life.it's over before you've lived it
    • Jhonny's RadioDJ tutorials.
Re: Reports
« Reply #23 on: September 10, 2019, 03:26:18 PM »
Ok select the table history and look in the column date_played for a big divers in time zo you can find the track .
R.T.F.M. means to me, Read The Fantastic Messages.
Make things simple, but don't make simple things simpler!
I don't do drugs, I do tuts. ( ͡° ͜ʖ ͡°) visit https://radiodj.info

Testing RadioDJ v2.0.1.6 Beta

stevewa

  • Hero Member

  • Offline
  • *****
  • 509
Re: Reports
« Reply #24 on: September 11, 2019, 01:38:51 PM »
Yeah I’ll chill out

danny.oranim

  • Jr. Member

  • Offline
  • **
  • 50
Re: Reports
« Reply #25 on: September 11, 2019, 08:56:20 PM »
Ok select the table history and look in the column date_played for a big divers in time zo you can find the track .
I trying to find the date 24-25/08/19 but the history table showing me only from 01/09/19 until 04/09/19
There a way to change the database to show more dates?
I attached a screenshot
https://oranimlive-my.sharepoint.com/:i:/g/personal/danny_tveria_oranim_ac_il/Ebskb1QIwrhDmIMU70SnXy8BbFN18ZRf7av2FyMmplMuqw?e=wVtJpF