- August 29, 2009
- 1,730
- 1,124
- Home Country
- Netherlands
Since r25307, the query on line 948 of TVLibrary/TVDatabase/Program.cs is broken on MySQL: It states Update program instead of Update Program. This leads to crashes of MediaPortal. Please apply the patch, based on SVN r26092. (maybe you need to adjust the paths, checking out the whole SVN tree was way too slow, so I've only checked out the TVDatabase directory).
crash details in log:
crash details in log:
Code:
Gentle.Common.GentleException: Update program set state=0 where state<>0; ---> MySql.Data.MySqlClient.MySqlException: Table 'mediaportal.program' doesn't exist
at MySql.Data.MySqlClient.MySqlStream.OpenPacket()
at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId)
at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)
--- End of inner exception stack trace ---
at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)
at Gentle.Framework.PersistenceBroker.Execute(SqlStatement stmt, IDbConnection dbConnection, IDbTransaction dbTransaction)
at Gentle.Framework.SqlStatement.Execute()
at TvDatabase.Program.ResetAllStates()
at TvService.TVController.InitController()MySql.Data.MySqlClient.MySqlException: Table 'mediaportal.program' doesn't exist
at MySql.Data.MySqlClient.MySqlStream.OpenPacket()
at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId)
at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)
at Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)
at Gentle.Framework.PersistenceBroker.Execute(SqlStatement stmt, IDbConnection dbConnection, IDbTransaction dbTransaction)
at Gentle.Framework.SqlStatement.Execute()
at TvDatabase.Program.ResetAllStates()
at TvService.TVController.InitController()