MYSQL 5.6 won't start. Trouble started when playing with Dynamic Refresh Rate. (1 Viewer)

T^2

Portal Pro
December 9, 2013
133
10
53
United States of America United States of America
So played around with Dynamic Refresh Rate. Something I'm now regretting. Watched video and DRR reset refresh rate to 23.976.When video stopped, refresh rate went to NTSCHD. Everything good so far. Turned on TV and screen went black. Best I can tell is that MP set the graphics driver to a frame rate my TV doesn't support. I hooked up the computer to other monitors. No problem there. Only way I could get the computer to work again with the TV was to restore back to a previous restore point. Noted that I had to unistall/reinstall Norton IS. MSQL 5.6 seems to be broke and I don't know enough about it to get it to work. Need help!
2014-03-30 12_34_03-MediaPortal - Configuration.png
2014-03-30 13_08_59-Program Manager.png
 

mm1352000

Development Group
  • Team MediaPortal
  • September 1, 2008
    21,571
    8,218
    New Zealand New Zealand
    Country flag
    Only way I could get the computer to work again with the TV was to restore back to a previous restore point.
    Obviously too late now, but could you not have played a video with a frame rate that your TV does support?

    MSQL 5.6 seems to be broke and I don't know enough about it to get it to work. Need help!
    Unfortunately the info you've provided isn't enough for me to help you, and even were you to provide the full MySQL logs I don't know that I'd be able to help.
    We do use MySQL as a database option... but we're not MySQL experts.

    Putting that aside: what message do you get when you try to start the MySQL service?
     

    T^2

    Portal Pro
    December 9, 2013
    133
    10
    53
    United States of America United States of America
    Only way I could get the computer to work again with the TV was to restore back to a previous restore point.
    Obviously too late now, but could you not have played a video with a frame rate that your TV does support?

    MSQL 5.6 seems to be broke and I don't know enough about it to get it to work. Need help!
    Unfortunately the info you've provided isn't enough for me to help you, and even were you to provide the full MySQL logs I don't know that I'd be able to help.
    We do use MySQL as a database option... but we're not MySQL experts.

    Putting that aside: what message do you get when you try to start the MySQL service?
    I don't know how one would be able to play a video with a frame rate that the TV supports when the TV is blacked out making it impossible to navigate.[DOUBLEPOST=1396403212][/DOUBLEPOST]Anyway... Got things back up and running. Ugly, but I muddled my way through it.

    So my TV supports the following refresh rates: 23p Hz, 24p Hz, 59p Hz, 59i Hz, 60p Hz, 60i Hz. How do I set up Dynamic Refresh Rate so that no profile ever sets my system to a refresh rate that my TV doesn't support?
     

    mm1352000

    Development Group
  • Team MediaPortal
  • September 1, 2008
    21,571
    8,218
    New Zealand New Zealand
    Country flag
    I don't know how one would be able to play a video with a frame rate that the TV supports when the TV is blacked out making it impossible to navigate.
    Absolutely, fair point. Basically I made that comment because I would have thought that restoring from a restore point would have been a last resort, and I was a little surprised that was the only way you could resolve the issue.
    When you said...
    I hooked up the computer to other monitors. No problem there.
    ...I interpreted that to mean you were able to see the UI when you connected the PC to a regular PC monitor or different TV. Were that to be the case, my assumption was the access you had using whatever other screen you were testing with (or even RDP or similar) could have allowed you to fix the configuration that caused the TV to black out.
    Only a suggestion, and only trying to help. Please feel free to ignore. :)

    Did you have any luck with MySQL or grabbing the error message?






    .
     

    T^2

    Portal Pro
    December 9, 2013
    133
    10
    53
    United States of America United States of America
    I don't know how one would be able to play a video with a frame rate that the TV supports when the TV is blacked out making it impossible to navigate.
    Absolutely, fair point. Basically I made that comment because I would have thought that restoring from a restore point would have been a last resort, and I was a little surprised that was the only way you could resolve the issue.
    When you said...
    I hooked up the computer to other monitors. No problem there.
    ...I interpreted that to mean you were able to see the UI when you connected the PC to a regular PC monitor or different TV. Were that to be the case, my assumption was the access you had using whatever other screen you were testing with (or even RDP or similar) could have allowed you to fix the configuration that caused the TV to black out.
    Only a suggestion, and only trying to help. Please feel free to ignore. :)

    Did you have any luck with MySQL or grabbing the error message?
    I believe I tried that. If I remember correctly, it didn't matter what I did when I hooked up another monitor. When I hooked the TV back up, the TV was recognized, and the last known settings for that TV where reset - blanking out the screen. How to go about changing the settings that the graphics driver would be set to when the TV was connected was unknown to me and seemed like a nasty little homework assignment to figure out. Plus time was an issue. I needed to get this fixed before the "Boss" noticed (panic set in immediately). Being already irritated enough, I figured restoring to a previous good restore point might just get me where I needed to go and get me there quickly. For the most part it worked, but appeared to have a negative impact on MySQL 5.6. Had I known more about using MySQL 5.6, it probably wouldn't have been a big deal getting it back in operation. However, being MySQL ignorant, I used the sledgehammer approach with it too. It's broke - uninstall/reinstall. Long story short, after muddling through, I got MySQL working again and have managed to restore (without too much work) MP to operation. Of course, I wasn't quick enough and the "Boss" did take note - losing me a few WAF points in the process before it was all over I'm sure. I'm glad she's been mostly too busy the last few days to care too much about TV or the points lost could have been greater.
     

    T^2

    Portal Pro
    December 9, 2013
    133
    10
    53
    United States of America United States of America
    So my TV supports the following refresh rates: 23p Hz, 24p Hz, 59p Hz, 59i Hz, 60p Hz, 60i Hz. How do I set up Dynamic Refresh Rate so that no profile ever sets my system to a refresh rate that my TV doesn't support?
    I'd still like to get an answer on this...
     

    Users Who Are Viewing This Thread (Users: 0, Guests: 1)

    OP Similar threads Forum Replies Date
    I [solved] Connection to TV Server MySQL General Support 8
    vapourEyes Maria DB instead of MySQL MediaPortal 1 Talk 0
    azzuro [WiP] MP1-5019: Replace MySQL with MariaDB MediaPortal 1 40
    R Problems accessing MySQL database remotely MediaPortal 1 Talk 0
    W Setup data connection - mySQL connection failed Installation, configuration support 1
    doskabouter No guide info added due to a MYSQL deadlock Electronic Program Guide 1
    CyberSimian Is MySQL misconfigured? MediaPortal 1 5
    M FW configuration for MySQL Installation, configuration support 0
    D Getting Started General Support 30
    horned_reaper [Music] 5012: Start current music track from the beginning Improvement Suggestions 21
    T [solved] Green Button start MP not working....but box ticked in config. General Support 1
    W [solved] MP suddenly Crashes when starting live TV on most channels and on recordings from the same channels General Support 20
    W [solved] MP suddenly Crashes when starting live TV on some channels and on some recordings Television (MyTV frontend and TV-Server) 1
    vvulture UNKNOWN ERROR when starting live TV General Support 6
    ajs Trakt error when start with MP crash Trakt 1
    F Recording starts at second time only MediaPortal 1 Talk 6
    tano_grasa Movie cover not showing when starting a movie aMPed 0
    ajs [solved] 4982: Why this error hard stop when Mediaportal start? MediaPortal 1 3
    joecrow AMD Radeon Settings app. won't start after hibernation. General Support 0
    Icaro Close MP when the external player is started General Support 13
    M MP1 stops responding after Starting Plugins General Support 14
    joecool70 Fehlermeldung Error invoking action "Start Timeshift" Allgemeines Support- und Diskussionsforum 1
    P MP2 TV Server crashes when starting - throws error remoting exception General 2
    P [solved] MP2 fails to install: "Insufficient privileges to start services" General 11
    T MP bricht Videos und Serien beim Start ab. Allgemeines Supportforum 4
    Similar threads

























    Top Bottom