home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 1
Support
Installation, configuration support
SQL Table Crash - Any Recovery Option?
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="Chuckyy" data-source="post: 520149" data-attributes="member: 87385"><p>Hi,</p><p></p><p>I'm using MP 1.1.0 Beta as Single-Seat-Installation. Today MyTV didn't work (UnknownError). I looked up my error.log and it told me, that it couldn't access 'program' table in MySQL 5.1. So I installed MySQL Administrator. Found out that 'program' is marked as 'crashed'. I didn't know what to do. Tried to repair the table, but with little success. So I deleted the table and hoped that it would magically reappear by pushing the right buttons in the config menu of tv-server. It didn't.</p><p></p><p>I just reinstalled TV-Server, but the table is still missing. </p><p></p><p></p><p>Last Error report says: </p><p>[CODE]2009-10-09 21:09:01.000872 [17]: Exception :Error: UnknownTableUnclassified</p><p>Gentle.Common.GentleException: The table Program to which type TvDatabase.Program maps does not exist.</p><p> bei Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg)</p><p> bei Gentle.Common.Check.Fail(Exception e, Error error, Object[] args)</p><p> bei Gentle.Common.Check.VerifyNotNull(Object obj1, Error error, Object[] args)</p><p> bei Gentle.Framework.GentleAnalyzer.UpdateObjectMap(ObjectMap map)</p><p> bei Gentle.Framework.ObjectFactory.ConstructMap(PersistenceBroker broker, Type type)</p><p> bei Gentle.Framework.ObjectFactory.GetMap(PersistenceBroker broker, Type type)</p><p> bei Gentle.Framework.SqlBuilder..ctor(IGentleProvider provider, StatementType stmtType, Type type, LogicalOperator logicalOperator)</p><p> bei Gentle.Framework.SqlBuilder..ctor(StatementType stmtType, Type type)</p><p> bei TvDatabase.Channel.UpdateNowAndNext()</p><p> bei TvDatabase.Channel.get_CurrentProgram()</p><p> bei TvService.TvCardContext.OnZap(User user)</p><p> bei TvService.TimeShifter.Start(User& user, String& fileName)</p><p></p><p>2009-10-09 21:10:24.249634 [SetupTv]: Exception :System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.</p><p> bei SetupTv.Sections.WebEPGSetup.LoadWebepgConfigFile()</p><p> bei SetupTv.Sections.WebEPGSetup.LoadSettings()</p><p> bei SetupTv.SetupTvSettingsForm.LoadSectionSettings(TreeNode currentNode)</p><p> bei SetupTv.SetupTvSettingsForm.LoadSectionSettings(TreeNode currentNode)</p><p> bei SetupTv.SetupTvSettingsForm.SettingsForm_Load(Object sender, EventArgs e)</p><p> bei System.Windows.Forms.Form.OnLoad(EventArgs e)</p><p> bei System.Windows.Forms.Form.OnCreateControl()</p><p> bei System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)</p><p> bei System.Windows.Forms.Control.CreateControl()</p><p> bei System.Windows.Forms.Control.WmShowWindow(Message& m)</p><p> bei System.Windows.Forms.Control.WndProc(Message& m)</p><p> bei System.Windows.Forms.ScrollableControl.WndProc(Message& m)</p><p> bei System.Windows.Forms.ContainerControl.WndProc(Message& m)</p><p> bei System.Windows.Forms.Form.WmShowWindow(Message& m)</p><p> bei System.Windows.Forms.Form.WndProc(Message& m)</p><p> bei System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)</p><p> bei System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)</p><p> bei System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)</p><p></p><p>2009-10-09 21:10:37.517393 [15]: Exception :Error: UnknownTableUnclassified</p><p>Gentle.Common.GentleException: The table Program to which type TvDatabase.Program maps does not exist.</p><p> bei Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg)</p><p> bei Gentle.Common.Check.Fail(Exception e, Error error, Object[] args)</p><p> bei Gentle.Common.Check.VerifyNotNull(Object obj1, Error error, Object[] args)</p><p> bei Gentle.Framework.GentleAnalyzer.UpdateObjectMap(ObjectMap map)</p><p> bei Gentle.Framework.ObjectFactory.ConstructMap(PersistenceBroker broker, Type type)</p><p> bei Gentle.Framework.ObjectFactory.GetMap(PersistenceBroker broker, Type type)</p><p> bei Gentle.Framework.SqlBuilder..ctor(IGentleProvider provider, StatementType stmtType, Type type, LogicalOperator logicalOperator)</p><p> bei Gentle.Framework.SqlBuilder..ctor(StatementType stmtType, Type type)</p><p> bei TvDatabase.Channel.UpdateNowAndNext()</p><p> bei TvDatabase.Channel.get_CurrentProgram()</p><p> bei TvService.TvCardContext.OnZap(User user)</p><p> bei TvService.TimeShifter.Start(User& user, String& fileName)</p><p></p><p>2009-10-09 21:11:53.083715 [EPG Update thread]: Exception :Error: UnknownTableUnclassified</p><p>Gentle.Common.GentleException: The table Program to which type TvDatabase.Program maps does not exist.</p><p> bei Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg)</p><p> bei Gentle.Common.Check.Fail(Exception e, Error error, Object[] args)</p><p> bei Gentle.Common.Check.VerifyNotNull(Object obj1, Error error, Object[] args)</p><p> bei Gentle.Framework.GentleAnalyzer.UpdateObjectMap(ObjectMap map)</p><p> bei Gentle.Framework.ObjectFactory.ConstructMap(PersistenceBroker broker, Type type)</p><p> bei Gentle.Framework.ObjectFactory.GetMap(PersistenceBroker broker, Type type)</p><p> bei Gentle.Framework.SqlBuilder..ctor(IGentleProvider provider, StatementType stmtType, Type type, LogicalOperator logicalOperator)</p><p> bei Gentle.Framework.SqlBuilder..ctor(StatementType stmtType, Type type)</p><p> bei TvDatabase.TvBusinessLayer.RemoveOldPrograms(Int32 idChannel)</p><p> bei TvDatabase.EpgDBUpdater.ImportPrograms(Channel dbChannel, IList`1 epgPrograms)</p><p> bei TvDatabase.EpgDBUpdater.UpdateEpgForChannel(EpgChannel epgChannel)</p><p> bei TvService.EpgCard.UpdateDatabaseThread()</p><p></p><p>[/CODE]</p><p></p><p>So, what do I have to do to get the table back in place?</p></blockquote><p></p>
[QUOTE="Chuckyy, post: 520149, member: 87385"] Hi, I'm using MP 1.1.0 Beta as Single-Seat-Installation. Today MyTV didn't work (UnknownError). I looked up my error.log and it told me, that it couldn't access 'program' table in MySQL 5.1. So I installed MySQL Administrator. Found out that 'program' is marked as 'crashed'. I didn't know what to do. Tried to repair the table, but with little success. So I deleted the table and hoped that it would magically reappear by pushing the right buttons in the config menu of tv-server. It didn't. I just reinstalled TV-Server, but the table is still missing. Last Error report says: [CODE]2009-10-09 21:09:01.000872 [17]: Exception :Error: UnknownTableUnclassified Gentle.Common.GentleException: The table Program to which type TvDatabase.Program maps does not exist. bei Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg) bei Gentle.Common.Check.Fail(Exception e, Error error, Object[] args) bei Gentle.Common.Check.VerifyNotNull(Object obj1, Error error, Object[] args) bei Gentle.Framework.GentleAnalyzer.UpdateObjectMap(ObjectMap map) bei Gentle.Framework.ObjectFactory.ConstructMap(PersistenceBroker broker, Type type) bei Gentle.Framework.ObjectFactory.GetMap(PersistenceBroker broker, Type type) bei Gentle.Framework.SqlBuilder..ctor(IGentleProvider provider, StatementType stmtType, Type type, LogicalOperator logicalOperator) bei Gentle.Framework.SqlBuilder..ctor(StatementType stmtType, Type type) bei TvDatabase.Channel.UpdateNowAndNext() bei TvDatabase.Channel.get_CurrentProgram() bei TvService.TvCardContext.OnZap(User user) bei TvService.TimeShifter.Start(User& user, String& fileName) 2009-10-09 21:10:24.249634 [SetupTv]: Exception :System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt. bei SetupTv.Sections.WebEPGSetup.LoadWebepgConfigFile() bei SetupTv.Sections.WebEPGSetup.LoadSettings() bei SetupTv.SetupTvSettingsForm.LoadSectionSettings(TreeNode currentNode) bei SetupTv.SetupTvSettingsForm.LoadSectionSettings(TreeNode currentNode) bei SetupTv.SetupTvSettingsForm.SettingsForm_Load(Object sender, EventArgs e) bei System.Windows.Forms.Form.OnLoad(EventArgs e) bei System.Windows.Forms.Form.OnCreateControl() bei System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible) bei System.Windows.Forms.Control.CreateControl() bei System.Windows.Forms.Control.WmShowWindow(Message& m) bei System.Windows.Forms.Control.WndProc(Message& m) bei System.Windows.Forms.ScrollableControl.WndProc(Message& m) bei System.Windows.Forms.ContainerControl.WndProc(Message& m) bei System.Windows.Forms.Form.WmShowWindow(Message& m) bei System.Windows.Forms.Form.WndProc(Message& m) bei System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) bei System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) bei System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) 2009-10-09 21:10:37.517393 [15]: Exception :Error: UnknownTableUnclassified Gentle.Common.GentleException: The table Program to which type TvDatabase.Program maps does not exist. bei Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg) bei Gentle.Common.Check.Fail(Exception e, Error error, Object[] args) bei Gentle.Common.Check.VerifyNotNull(Object obj1, Error error, Object[] args) bei Gentle.Framework.GentleAnalyzer.UpdateObjectMap(ObjectMap map) bei Gentle.Framework.ObjectFactory.ConstructMap(PersistenceBroker broker, Type type) bei Gentle.Framework.ObjectFactory.GetMap(PersistenceBroker broker, Type type) bei Gentle.Framework.SqlBuilder..ctor(IGentleProvider provider, StatementType stmtType, Type type, LogicalOperator logicalOperator) bei Gentle.Framework.SqlBuilder..ctor(StatementType stmtType, Type type) bei TvDatabase.Channel.UpdateNowAndNext() bei TvDatabase.Channel.get_CurrentProgram() bei TvService.TvCardContext.OnZap(User user) bei TvService.TimeShifter.Start(User& user, String& fileName) 2009-10-09 21:11:53.083715 [EPG Update thread]: Exception :Error: UnknownTableUnclassified Gentle.Common.GentleException: The table Program to which type TvDatabase.Program maps does not exist. bei Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg) bei Gentle.Common.Check.Fail(Exception e, Error error, Object[] args) bei Gentle.Common.Check.VerifyNotNull(Object obj1, Error error, Object[] args) bei Gentle.Framework.GentleAnalyzer.UpdateObjectMap(ObjectMap map) bei Gentle.Framework.ObjectFactory.ConstructMap(PersistenceBroker broker, Type type) bei Gentle.Framework.ObjectFactory.GetMap(PersistenceBroker broker, Type type) bei Gentle.Framework.SqlBuilder..ctor(IGentleProvider provider, StatementType stmtType, Type type, LogicalOperator logicalOperator) bei Gentle.Framework.SqlBuilder..ctor(StatementType stmtType, Type type) bei TvDatabase.TvBusinessLayer.RemoveOldPrograms(Int32 idChannel) bei TvDatabase.EpgDBUpdater.ImportPrograms(Channel dbChannel, IList`1 epgPrograms) bei TvDatabase.EpgDBUpdater.UpdateEpgForChannel(EpgChannel epgChannel) bei TvService.EpgCard.UpdateDatabaseThread() [/CODE] So, what do I have to do to get the table back in place? [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Support
Installation, configuration support
SQL Table Crash - Any Recovery Option?
Contact us
RSS
Top
Bottom
