Problem with DB (1 Viewer)

[bounguine]

Hi!

This Monday presented me with a new problem.
Everything went almost OK (“no audio/video” was, of course, my best friend depending on the SVN I installed), until I decided to upgrade TVserver again.
Thanks to Monday, but now I experience problems with the DB.
During the installation I got some message, that the new DB will be created.
I’m actually sick and tired of bugs in SVNs and I didn’t want to roll-back and use old SVN without losing the DB.
So I decided to install new SVN and to recreate my TV DB, losing the old one.
When I went to My TV in MP, I saw all the channels and favorites.
I saw only names, but I couldn’t watch TV.

I opened the error.log and saw:
* * *
04.09.2007 2:28:03 1 Exception :Error: DeveloperErrorUnclassified
Gentle.Common.GentleException: The columns pilot, rollOff in table TuningDetail do not exist.
at Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg)
at Gentle.Common.Check.Fail(Error error, Object[] args)
at Gentle.Framework.GentleAnalyzer.UpdateObjectMap(ObjectMap map)
at Gentle.Framework.ObjectFactory.ConstructMap(PersistenceBroker broker, Type type)
at Gentle.Framework.ObjectFactory.GetMap(PersistenceBroker broker, Type type)
at Gentle.Framework.SqlBuilder..ctor(IGentleProvider provider, StatementType stmtType, Type type, LogicalOperator logicalOperator)
at Gentle.Framework.SqlBuilder..ctor(StatementType stmtType, Type type)
at TvDatabase.Channel.ReferringTuningDetail()
at SetupTv.Sections.TvChannels.OnSectionActivated()
at SetupTv.SetupTvSettingsForm.ActivateSection(SectionSettings section)
04.09.2007 2:28:03 1 Exception :The columns pilot, rollOff in table TuningDetail do not exist.
04.09.2007 2:28:03 1 site :Void FailWith(Gentle.Common.Severity, Gentle.Common.Error, System.Exception, System.String)
04.09.2007 2:28:03 1 source :Gentle.Common
04.09.2007 2:28:03 1 stacktrace: at Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg)
at Gentle.Common.Check.Fail(Error error, Object[] args)
at Gentle.Framework.GentleAnalyzer.UpdateObjectMap(ObjectMap map)
at Gentle.Framework.ObjectFactory.ConstructMap(PersistenceBroker broker, Type type)
at Gentle.Framework.ObjectFactory.GetMap(PersistenceBroker broker, Type type)
at Gentle.Framework.SqlBuilder..ctor(IGentleProvider provider, StatementType stmtType, Type type, LogicalOperator logicalOperator)
at Gentle.Framework.SqlBuilder..ctor(StatementType stmtType, Type type)
at TvDatabase.Channel.ReferringTuningDetail()
at SetupTv.Sections.TvChannels.OnSectionActivated()
at SetupTv.SetupTvSettingsForm.ActivateSection(SectionSettings section)
04.09.2007 2:28:07 1 Exception :Error: DeveloperErrorUnclassified
Gentle.Common.GentleException: The columns pilot, rollOff in table TuningDetail do not exist.
at Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg)
at Gentle.Common.Check.Fail(Error error, Object[] args)
at Gentle.Framework.GentleAnalyzer.UpdateObjectMap(ObjectMap map)
at Gentle.Framework.ObjectFactory.ConstructMap(PersistenceBroker broker, Type type)
at Gentle.Framework.ObjectFactory.GetMap(PersistenceBroker broker, Type type)
at Gentle.Framework.SqlBuilder..ctor(IGentleProvider provider, StatementType stmtType, Type type, LogicalOperator logicalOperator)
at Gentle.Framework.SqlBuilder..ctor(StatementType stmtType, Type type)
at TvDatabase.Channel.ReferringTuningDetail()
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)
04.09.2007 2:28:07 1 Exception :The columns pilot, rollOff in table TuningDetail do not exist.
04.09.2007 2:28:07 1 site :Void FailWith(Gentle.Common.Severity, Gentle.Common.Error, System.Exception, System.String)
04.09.2007 2:28:07 1 source :Gentle.Common
04.09.2007 2:28:07 1 stacktrace: at Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg)
at Gentle.Common.Check.Fail(Error error, Object[] args)
at Gentle.Framework.GentleAnalyzer.UpdateObjectMap(ObjectMap map)
at Gentle.Framework.ObjectFactory.ConstructMap(PersistenceBroker broker, Type type)
at Gentle.Framework.ObjectFactory.GetMap(PersistenceBroker broker, Type type)
at Gentle.Framework.SqlBuilder..ctor(IGentleProvider provider, StatementType stmtType, Type type, LogicalOperator logicalOperator)
at Gentle.Framework.SqlBuilder..ctor(StatementType stmtType, Type type)
at TvDatabase.Channel.ReferringTuningDetail()
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)
* * *

Any suggestions?

 

[rtv]

Do you use an english windows?

 

[bounguine]

Do you use an english windows?

Russian version

 

[bounguine]

No answer

No one answers.

So what I did:
- I reinstall SQL-server,
- I reinstall TVserver (rev. 15780),
- I tested connection with DB - OK,
- I agreed to make TVserver run,
- I agreed to recreate DB,
- I got the message "unable to connect".

Now I don't have TVserver at all, TV console is absolutely blank.

Here are logs.
Sorry, some strings are in Russian.

 

[JackTramiel]

I had a similar problem with the db. Also got the message that the db needs to be upgraded but couldnt and therefore it must be deleted and recreated. Unfortunatly i deinstalled tvserver3 for now and have no more logs.
MS SQL, not mySQL.

 

[bounguine]

Usually TVserver upgrades in a normal way.
Only once or twice it advised to recreate DB.
Once I did it, but lost only channels and favourites.
I just rescanned the channels, but now I lost everything, even TV-cards

 

[rtv]

Drop the Database from the Management Console and re-install the tvserver. If that does not help try MySQL

 

[bounguine]

One more question:
https://forum.team-mediaportal.com/russian_dvb_epg_and_channels_iso_8895-t28309.html?t=28309