TV DB screwed - how to drop/recreate? (1 Viewer)

[Jimbawb]

TV-Server Version: v1.0.1
MediaPortal Version: v1.0.1
MediaPortal Skin: Black&White
Windows Version: XP Home 32bit + SP3
CPU Type: AMD Athlon 64 X2 4000+ (2.1GHz
HDD: 2x 500gb
Memory: 3x 1GB (1gb turned to ramdisk for .ts streams)
Motherboard: Gigabyte GA-MA69GM-S2H AMD 690G Socket AM2
Video Card: ATI HD 3650
Video Card Driver: latest
Sound Card: Onboard
Sound Card AC3: Optical out onboard
Sound Card Driver: 5.0.40001.9
1. TV Card: Hauppauge Nova-t 500
1. TV Card Type: DVB-T
1. TV Card Driver: 4.3.25080.0
2. TV Card: dvb-s (compro)
2. TV Card Type: dvb-s
2. TV Card Driver:
3. TV Card:
3. TV Card Type:
3. TV Card Driver:
4. TV Card:
4. TV Card Type:
4. TV Card Driver:
MPEG2 Video Codec: Cyberlink Video/SP Decoder (PDVD7)
MPEG2 Audio Codec: MPA Decoder
h.264 Video Codec: Cyberlink HD
Satelite/CableTV Provider:
HTPC Case: Antec Fusion
Cooling: fans
Power Supply:
Remote: Hauppauge 45 button
TV: Samsung 40"
TV - HTPC Connection: DVI->HDMI

Hi guys - I keep getting errors where the tv server config wont let me open the tab "tv groups" or "manual control" - both of these just dont load. Also when using MP the tv channels dont show up in the all channels group. I'm fairly confident its a database issue as i've done a reinstall of the database in the past which fixed it.

I'm using mysql server, whats the databases I need to delete/drop and how to re-create them so when i load the TV server config i get back to square one with the "connect to db" popup? Thanks!

 

[rekenaar]

Hi there

You can try running setuptv with startup argument of --delete-db

Example:
setuptv.exe --delete-db

Not sure if it is the problem though, but since you asked, you might as well try.

If it does not work, return here with full logs.

 

[Jimbawb]

Hmm, yep. Looks like it might be gentle.config ? Heres the error:

2009-08-10 22:20:13.265625 [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.TestService.comboBoxGroups_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.TestService.OnSectionActivated()
at SetupTv.SetupTvSettingsForm.ActivateSection(SectionSettings section)

2009-08-10 22:20:18.234375 [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)

2009-08-10 22:20:20.406250 [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.TestService.comboBoxGroups_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.TestService.OnSectionActivated()
at SetupTv.SetupTvSettingsForm.ActivateSection(SectionSettings section)

2009-08-10 22:20:34.046875 [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.TestService.comboBoxGroups_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.TestService.OnSectionActivated()
at SetupTv.SetupTvSettingsForm.ActivateSection(SectionSettings section)