TV Groups Database Error (3 Viewers)

robbo100

Retired Team Member
  • Premium Supporter
  • May 5, 2009
    1,290
    309
    UK
    Home Country
    United Kingdom United Kingdom
    Sorry to be asking so many questions at the moment. :sorry:

    I am trying to set up an HTPC for my father based upon an excellent MP working setup that I use, but I keep hitting little problems.

    I had configured groups on his HTPC previously such that there was "All Channels" and "Favorites" and set in MP-Config to hide "All Channesl", however I have just tried to add another channel to the "favorites" group and I can not find any Groups listed in the TV server setup. If I click on "TV Groups" the title changes on the user interface, but all of the screen below stays the same as from the previous menu item that I was using.

    If I look in the TV Server errror log file I can see the following error which seems to indicate that the database has an error and it looks like it relates to the "TV Group".

    Any ideas as to how to fix this? Strangely, the actual MP program is working fine and showing channels from the favorites group.


    2009-06-14 09:44:12.078125 [SetupTv]: Exception :Error: UnexpectedRowCountUnclassified
    Gentle.Common.GentleException: The number of returned rows 0 did not match the expected count of 1.
    If concurrency control is enabled this may indicate that the record was updated or deleted by another process.
    at Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg)
    at Gentle.Common.Check.Fail(Exception e, Error error, Object[] args)
    at Gentle.Common.Check.Verify(Boolean condition, Error error, Object[] args)
    at Gentle.Framework.ObjectFactory.GetInstance(Type type, SqlResult sr, Key key)
    at Gentle.Framework.PersistenceBroker.RetrieveInstance(Type type, Key key, IDbConnection conn, IDbTransaction tr)
    at Gentle.Framework.PersistenceBroker.RetrieveInstance[T](Key key)
    at Gentle.Framework.Broker.RetrieveInstance[T](Key key)
    at TvDatabase.Channel.Retrieve(Int32 id)
    at TvDatabase.GroupMap.ReferencedChannel()
    at SetupTv.Sections.TvGroups.mpComboBoxGroup_SelectedIndexChanged(Object sender, EventArgs e)
    at System.Windows.Forms.ComboBox.OnSelectedIndexChanged(EventArgs e)
    at System.Windows.Forms.ComboBox.set_SelectedIndex(Int32 value)
    at SetupTv.Sections.TvGroups.InitMapping()
    at SetupTv.Sections.TvGroups.OnSectionActivated()
    at SetupTv.SetupTvSettingsForm.ActivateSection(SectionSettings section)
     

    robbo100

    Retired Team Member
  • Premium Supporter
  • May 5, 2009
    1,290
    309
    UK
    Home Country
    United Kingdom United Kingdom
    Thanks,

    I just spotted that whilst I was continuing to check for solutions after my post.

    I installed SQL Studio Express and ran the Querie and it worked first time!

    Very simple really even for an idiot like me.

    Thanks for your help!:D
     

    Users who are viewing this thread

    Top Bottom