Miss channel group (1 Viewer)

[siva]

Hi,

I setup fresh system Win 7 x64 SP1, SQL Express 2008 SP2 MP 1.2.0a.
I scan channel for 2 tuners and IPTV, place them in some groups.
Start MP (1.2.0a) and don't see any group by TV\Channel. At TV\TV Guide I can see channel group.
After that I uninstall MP 1.2.0a, drop database MpTvDb and install MP 1.1.3.
Repeat steps and again don't see channel group.
At error log I see message "Invalid column name 'sortOrder'".
In fact table GroupMap has column 'SortOrder'. I change 'SortOrder' to 'sortOrder'. But it dos'nt help me.

In previos installation Win 7 x64 (without SP1) SQL Express 2008 MP 1.2.0a everything was ok.

Error log:
2011-03-31 21:05:08.330148 [ERROR][MPMain(1)]: OnMessage exception:Error: StatementErrorUnclassified
Gentle.Common.GentleException: select c.* from Channel c join GroupMap g on c.idChannel=g.idChannel where visibleInGuide = 1 and isTv = 1 and idGroup = '3' order by g.idGroup, g.sortOrder ---> System.Data.SqlClient.SqlException: Invalid column name 'sortOrder'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)
--- End of inner exception stack trace ---



MediaPortal Version: MediaPortal 1.2.0 A / 1.1.3
MediaPortal Skin: Blue3 Wide
Windows Version: Windows 7 64 bit SP1 SQLExpress 2008 SP2
CPU Type: Intel i5
HDD: 3TB
Memory: 8Gb
Motherboard: Asus P7H57D-V EVO
Video Card: Intel HD Graphics
Sound Card: Asus Xonar HDAV 1.3
Sound Card Driver: 7.12.8.1792
1. TV Card: SkyStar 2
1. TV Card Type: DVB-S
3. TV Card: Pinnacle 7010i
3. TV Card Type: analog*2, DVB-T*2, DVB-S*2