TV Server Configuration Issues (1 Viewer)

[ultimatejoe]

I upgraded to MP1.4 on Monday and ever since I've been having problems with the TV Server Configuration. I can't actually close the configuration screen properly; the "OK" button doesn't seem to work. Similarly, certain fields or values are not displaying correctly; for example, when I go the Recording screen there are no default value options for the custom path names, and it won't list any drives if I try to configure disk quotas.

Below is my log file:

[2013-06-29 09:47:03,775] [Log	] [SetupTv  ] [INFO ] - ---- SetupTv v1.4.0.0 is starting up on Windows 7 [6.1.7600.0]
[2013-06-29 09:47:03,790] [Log	] [SetupTv  ] [INFO ] - ---- check connection with database ----
[2013-06-29 09:47:03,993] [Log	] [SetupTv  ] [INFO ] - SetupDatabaseForm: Added dependency for TvService - MySQL
[2013-06-29 09:47:03,993] [Log	] [SetupTv  ] [INFO ] - ---- check if database needs to be updated/created ----
[2013-06-29 09:47:04,009] [Log	] [SetupTv  ] [INFO ] - ---- upgrade database schema ----
[2013-06-29 09:47:04,009] [Log	] [SetupTv  ] [INFO ] - ---- check if tvservice is running ----
[2013-06-29 09:47:04,165] [Log	] [SetupTv  ] [DEBUG] - RemoteControl: RegisterChannel first called in Domain SetupTv.exe for thread SetupTv with id 1
[2013-06-29 09:47:08,486] [Log	] [SetupTv  ] [INFO ] - Util: Version of installed Psisdecd.dll: 6.6.7600.16385 Path: C:\Windows\SysWOW64\PsisDecd.dll
[2013-06-29 09:47:08,486] [Log	] [SetupTv  ] [INFO ] - Util: Version of installed Psisdecd.dll: 6.6.7600.16385 Path: C:\Windows\SysWOW64\psisdecd.dll
[2013-06-29 09:47:09,094] [Log	] [SetupTv  ] [INFO ] - Exception in setuptv
[2013-06-29 09:47:09,094] [Log	] [SetupTv  ] [INFO ] - System.Threading.ThreadExceptionEventArgs
[2013-06-29 09:47:09,094] [Log	] [SetupTv  ] [ERROR] - Exception  :MySql.Data.MySqlClient.MySqlException: Table '.\mptvdb\program' is marked as crashed and should be repaired
  at MySql.Data.MySqlClient.MySqlStream.OpenPacket()
  at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId)
  at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()
  at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()
  at TvDatabase.TvBusinessLayer.GetProgramGenres()
  at SetupTv.Sections.EpgGenreMap.LoadSettings()
  at SetupTv.SetupTvSettingsForm.LoadSectionSettings(TreeNode currentNode)
  at SetupTv.SetupTvSettingsForm.LoadSectionSettings(TreeNode currentNode)
  at SetupTv.SetupTvSettingsForm.SettingsForm_Load(Object sender, EventArgs e)
  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.ContainerControl.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)
 
[2013-06-29 09:47:11,622] [Log	] [SetupTv  ] [ERROR] - Exception  :System.NullReferenceException: Object reference not set to an instance of an object.
  at TvDatabase.TvBusinessLayer.SaveMpGenres(List`1 mpGenres)
  at SetupTv.Sections.EpgGenreMap.SaveSettings()
  at SetupTv.SetupTvSettingsForm.SaveSectionSettings(TreeNode currentNode)
  at SetupTv.SetupTvSettingsForm.SaveSectionSettings(TreeNode currentNode)
  at SetupTv.SetupTvSettingsForm.SaveAllSettings()
  at SetupTv.SetupTvSettingsForm.applyButton_Click(Object sender, EventArgs e)
  at SetupTv.SetupTvSettingsForm.okButton_Click(Object sender, EventArgs e)
 
[2013-06-29 09:47:14,710] [Log	] [SetupTv  ] [ERROR] - Exception  :System.NullReferenceException: Object reference not set to an instance of an object.
  at TvDatabase.TvBusinessLayer.SaveMpGenres(List`1 mpGenres)
  at SetupTv.Sections.EpgGenreMap.SaveSettings()
  at SetupTv.SetupTvSettingsForm.SaveSectionSettings(TreeNode currentNode)
  at SetupTv.SetupTvSettingsForm.SaveSectionSettings(TreeNode currentNode)
  at SetupTv.SetupTvSettingsForm.SaveAllSettings()
  at SetupTv.SetupTvSettingsForm.applyButton_Click(Object sender, EventArgs e)
  at SetupTv.SetupTvSettingsForm.okButton_Click(Object sender, EventArgs e)
 
[2013-06-29 09:48:48,108] [Log	] [SetupTv  ] [ERROR] - Exception  :System.NullReferenceException: Object reference not set to an instance of an object.
  at TvDatabase.TvBusinessLayer.SaveMpGenres(List`1 mpGenres)
  at SetupTv.Sections.EpgGenreMap.SaveSettings()
  at SetupTv.SetupTvSettingsForm.SaveSectionSettings(TreeNode currentNode)
  at SetupTv.SetupTvSettingsForm.SaveSectionSettings(TreeNode currentNode)
  at SetupTv.SetupTvSettingsForm.SaveAllSettings()
  at SetupTv.SetupTvSettingsForm.applyButton_Click(Object sender, EventArgs e)
  at SetupTv.SetupTvSettingsForm.okButton_Click(Object sender, EventArgs e)
 
[2013-06-29 09:48:48,451] [Log	] [SetupTv  ] [ERROR] - Exception  :System.NullReferenceException: Object reference not set to an instance of an object.
  at TvDatabase.TvBusinessLayer.SaveMpGenres(List`1 mpGenres)
  at SetupTv.Sections.EpgGenreMap.SaveSettings()
  at SetupTv.SetupTvSettingsForm.SaveSectionSettings(TreeNode currentNode)
  at SetupTv.SetupTvSettingsForm.SaveSectionSettings(TreeNode currentNode)
  at SetupTv.SetupTvSettingsForm.SaveAllSettings()
  at SetupTv.SetupTvSettingsForm.applyButton_Click(Object sender, EventArgs e)
  at SetupTv.SetupTvSettingsForm.okButton_Click(Object sender, EventArgs e)

 

[mm1352000]

http://wiki.team-mediaportal.com/1_...Troubleshooting/TV/Repairing_database_(MySQL)

 

[ultimatejoe]

Sorry for the late reply, but thank you, that worked like a charm. For my own edification, how did you recognize the problem?

 

[Jay_UK]

Hi there,

The following line gives it away:

Exception :MySql.Data.MySqlClient.MySqlException: Table '.\mptvdb\program' is marked as crashed and should be repaired

Plus it is a known issue with MySQL - where corruption can happen.

J.