[fixed] getting SQL Errors from EPG (1 Viewer)

[disaster123]

Hi!

My TV Server error.log Log is full of these SQL errors

2010-03-01 20:01:29.358800 [EPG Update thread(14)]: Exception   :Error: StatementErrorUnclassified
Gentle.Common.GentleException: select idProgram, idChannel, startTime, endTime, title, description, genre, state, originalAirDate, seriesNum, episodeNum, episodePart, episodeName, starRating, classification, parentalRating from Program where startTime >= ?startTime and idChannel = ?idChannel and EXTRACT(HOUR_SECOND FROM startTime) >= EXTRACT(HOUR_SECOND FROM ?pStartTime) and EXTRACT(HOUR_SECOND FROM endTime) <= EXTRACT(HOUR_SECOND FROM ?pEndTime) and EXTRACT(HOUR_SECOND FROM startTime) <= EXTRACT(HOUR_SECOND FROM ?endTime); ---> MySql.Data.MySqlClient.MySqlException: Parameter '?endTime' must be defined.
   bei MySql.Data.MySqlClient.Statement.SerializeParameter(MySqlParameterCollection parameters, MySqlStream stream, String parmName)
   bei MySql.Data.MySqlClient.Statement.BindParameters()
   bei MySql.Data.MySqlClient.PreparableStatement.Execute()
   bei MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   bei MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   bei System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
   bei Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)
   --- Ende der internen Ausnahmestapelüberwachung ---
   bei Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)
   bei Gentle.Framework.PersistenceBroker.Execute(SqlStatement stmt, IDbConnection dbConnection, IDbTransaction dbTransaction)
   bei Gentle.Framework.SqlStatement.Execute()
   bei TvDatabase.Program.RetrieveDaily(DateTime startTime, DateTime endTime, Int32 channelId)
   bei TvDatabase.Schedule.ApplyProgramStates(Int32 idSchedule, Boolean clear)MySql.Data.MySqlClient.MySqlException: Parameter '?endTime' must be defined.
   bei MySql.Data.MySqlClient.Statement.SerializeParameter(MySqlParameterCollection parameters, MySqlStream stream, String parmName)
   bei MySql.Data.MySqlClient.Statement.BindParameters()
   bei MySql.Data.MySqlClient.PreparableStatement.Execute()
   bei MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   bei MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   bei System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
   bei Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)

Stefan

 

[wouter1971]

Hi Stefan, i see this problem also. Are you allso experiencing problems with the guide? I see that schedules are there in the planner but not colored red in the guide until +/- half an hour before the schedule has to start.
Not good for WAF.

 

[disaster123]

AW: getting SQL Errors from EPG

yeah same for me

 

[wouter1971]

I have acronis backup running on that system. The problem with sql errors was not there before RC1 (did a restore and guideupdate). But the guide problem with red color was also in 24975. I will go back by restore to sort this out.

Hi Stefan, the color problem in the guide is gone when i restored svn 24964. Can you find updates after that which are guide and scheduling related in the changelogs?

 

[mortstar]

Some logs that are around this issue in this thread:

https://forum.team-mediaportal.com/...ing-series-not-reflected-correctly-epg-78310/

 

[arion_p]

Hi!

My TV Server error.log Log is full of these SQL errors

2010-03-01 20:01:29.358800 [EPG Update thread(14)]: Exception   :Error: StatementErrorUnclassified
Gentle.Common.GentleException: select idProgram, idChannel, startTime, endTime, title, description, genre, state, originalAirDate, seriesNum, episodeNum, episodePart, episodeName, starRating, classification, parentalRating from Program where startTime >= ?startTime and idChannel = ?idChannel and EXTRACT(HOUR_SECOND FROM startTime) >= EXTRACT(HOUR_SECOND FROM ?pStartTime) and EXTRACT(HOUR_SECOND FROM endTime) <= EXTRACT(HOUR_SECOND FROM ?pEndTime) and EXTRACT(HOUR_SECOND FROM startTime) <= EXTRACT(HOUR_SECOND FROM ?endTime); ---> MySql.Data.MySqlClient.MySqlException: Parameter '?endTime' must be defined.
   bei MySql.Data.MySqlClient.Statement.SerializeParameter(MySqlParameterCollection parameters, MySqlStream stream, String parmName)
   bei MySql.Data.MySqlClient.Statement.BindParameters()
   bei MySql.Data.MySqlClient.PreparableStatement.Execute()
   bei MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   bei MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   bei System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
   bei Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)
   --- Ende der internen Ausnahmestapelüberwachung ---
   bei Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)
   bei Gentle.Framework.PersistenceBroker.Execute(SqlStatement stmt, IDbConnection dbConnection, IDbTransaction dbTransaction)
   bei Gentle.Framework.SqlStatement.Execute()
   bei TvDatabase.Program.RetrieveDaily(DateTime startTime, DateTime endTime, Int32 channelId)
   bei TvDatabase.Schedule.ApplyProgramStates(Int32 idSchedule, Boolean clear)MySql.Data.MySqlClient.MySqlException: Parameter '?endTime' must be defined.
   bei MySql.Data.MySqlClient.Statement.SerializeParameter(MySqlParameterCollection parameters, MySqlStream stream, String parmName)
   bei MySql.Data.MySqlClient.Statement.BindParameters()
   bei MySql.Data.MySqlClient.PreparableStatement.Execute()
   bei MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   bei MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   bei System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
   bei Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)

Stefan

This is a known issue (happens only with MySQL). A fix is being tested internally and will go into SVN soon.

 

[disaster123]

AW: getting SQL Errors from EPG

hi arion - any news on this? still haven't seen any fix for this in svn.

Thanks! Stefan