home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
Products
TV-Server
For The Record - The rule-based scheduling suite
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="GoldenEye" data-source="post: 197723" data-attributes="member: 15813"><p>I started testing your TvScheduler. In the manamgent console, I can see the channels but no shows.</p><p></p><p>The event log says:</p><p>[CODE]Error: StatementErrorUnclassified</p><p>Gentle.Common.GentleException: select ConfigurationId, Module, Key, Value, DefaultValue, LastModifiedTime, Version from Configuration where Module = ?Module and Key = ?Key; ---> MySql.Data.MySqlClient.MySqlException: #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Key, Value, DefaultValue, LastModifiedTime, Version from Configuration where Mod' at line 1</p><p> bei MySql.Data.MySqlClient.PacketReader.CheckForError()</p><p> bei MySql.Data.MySqlClient.PacketReader.ReadHeader()</p><p> bei MySql.Data.MySqlClient.PacketReader.OpenPacket()</p><p> bei MySql.Data.MySqlClient.NativeDriver.ReadResult(Int64& affectedRows, Int64& lastInsertId)</p><p> bei MySql.Data.MySqlClient.CommandResult.ReadNextResult(Boolean isFirst)</p><p> bei MySql.Data.MySqlClient.NativeDriver.SendQuery(Byte[] bytes, Int32 length, Boolean consume)</p><p> bei MySql.Data.MySqlClient.MySqlCommand.GetNextResultSet(MySqlDataReader reader)</p><p> bei MySql.Data.MySqlClient.MySqlDataReader.NextResult()</p><p> bei MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)</p><p> bei MySql.Data.MySqlClient.MySqlCommand.System.Data.IDbCommand.ExecuteReader()</p><p> bei Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)</p><p> --- Ende der internen Ausnahmestapelüberwachung ---</p><p> bei Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)</p><p> bei Gentle.Framework.PersistenceBroker.Execute(SqlStatement stmt, IDbConnection dbConnection, IDbTransaction dbTransaction)</p><p> bei Gentle.Framework.Broker.Execute(SqlStatement stmt)</p><p> bei TvScheduler.Business.Configuration.GetConfigurationByModuleAndKeyOperation.Execute(String module, String key)</p><p> bei TvScheduler.Business.Configuration.GetStringValueOperation.Execute(String module, String key, Boolean usedefault)</p><p> bei TvScheduler.Business.Guide.ImportProgramOperation.GetPreferredSource()</p><p> bei TvScheduler.Business.Guide.ImportProgramOperation.Execute(GuideProgram guideProgram, GuideSource source)</p><p> bei TvScheduler.Business.Guide.ImportXmlTvGuideOperation.Execute(String guidePath)</p><p> bei TvScheduler.Business.Guide.GuideFacade.ImportXmlTvGuide(String guidePath)</p><p> bei TvScheduler.ServiceImplementation.TvGuideService.ImportXmlTvGuide(String guidePath)MySql.Data.MySqlClient.MySqlException: #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Key, Value, DefaultValue, LastModifiedTime, Version from Configuration where Mod' at line 1</p><p> bei MySql.Data.MySqlClient.PacketReader.CheckForError()</p><p> bei MySql.Data.MySqlClient.PacketReader.ReadHeader()</p><p> bei MySql.Data.MySqlClient.PacketReader.OpenPacket()</p><p> bei MySql.Data.MySqlClient.NativeDriver.ReadResult(Int64& affectedRows, Int64& lastInsertId)</p><p> bei MySql.Data.MySqlClient.CommandResult.ReadNextResult(Boolean isFirst)</p><p> bei MySql.Data.MySqlClient.NativeDriver.SendQuery(Byte[] bytes, Int32 length, Boolean consume)</p><p> bei MySql.Data.MySqlClient.MySqlCommand.GetNextResultSet(MySqlDataReader reader)</p><p> bei MySql.Data.MySqlClient.MySqlDataReader.NextResult()</p><p> bei MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)</p><p> bei MySql.Data.MySqlClient.MySqlCommand.System.Data.IDbCommand.ExecuteReader()</p><p> bei Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr)</p><p>[/CODE]</p><p></p><p>I am using mysql, which works flawlessly with the TV engine 3.</p><p></p><p>G.</p></blockquote><p></p>
[QUOTE="GoldenEye, post: 197723, member: 15813"] I started testing your TvScheduler. In the manamgent console, I can see the channels but no shows. The event log says: [CODE]Error: StatementErrorUnclassified Gentle.Common.GentleException: select ConfigurationId, Module, Key, Value, DefaultValue, LastModifiedTime, Version from Configuration where Module = ?Module and Key = ?Key; ---> MySql.Data.MySqlClient.MySqlException: #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Key, Value, DefaultValue, LastModifiedTime, Version from Configuration where Mod' at line 1 bei MySql.Data.MySqlClient.PacketReader.CheckForError() bei MySql.Data.MySqlClient.PacketReader.ReadHeader() bei MySql.Data.MySqlClient.PacketReader.OpenPacket() bei MySql.Data.MySqlClient.NativeDriver.ReadResult(Int64& affectedRows, Int64& lastInsertId) bei MySql.Data.MySqlClient.CommandResult.ReadNextResult(Boolean isFirst) bei MySql.Data.MySqlClient.NativeDriver.SendQuery(Byte[] bytes, Int32 length, Boolean consume) bei MySql.Data.MySqlClient.MySqlCommand.GetNextResultSet(MySqlDataReader reader) bei MySql.Data.MySqlClient.MySqlDataReader.NextResult() bei MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) bei MySql.Data.MySqlClient.MySqlCommand.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.Broker.Execute(SqlStatement stmt) bei TvScheduler.Business.Configuration.GetConfigurationByModuleAndKeyOperation.Execute(String module, String key) bei TvScheduler.Business.Configuration.GetStringValueOperation.Execute(String module, String key, Boolean usedefault) bei TvScheduler.Business.Guide.ImportProgramOperation.GetPreferredSource() bei TvScheduler.Business.Guide.ImportProgramOperation.Execute(GuideProgram guideProgram, GuideSource source) bei TvScheduler.Business.Guide.ImportXmlTvGuideOperation.Execute(String guidePath) bei TvScheduler.Business.Guide.GuideFacade.ImportXmlTvGuide(String guidePath) bei TvScheduler.ServiceImplementation.TvGuideService.ImportXmlTvGuide(String guidePath)MySql.Data.MySqlClient.MySqlException: #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Key, Value, DefaultValue, LastModifiedTime, Version from Configuration where Mod' at line 1 bei MySql.Data.MySqlClient.PacketReader.CheckForError() bei MySql.Data.MySqlClient.PacketReader.ReadHeader() bei MySql.Data.MySqlClient.PacketReader.OpenPacket() bei MySql.Data.MySqlClient.NativeDriver.ReadResult(Int64& affectedRows, Int64& lastInsertId) bei MySql.Data.MySqlClient.CommandResult.ReadNextResult(Boolean isFirst) bei MySql.Data.MySqlClient.NativeDriver.SendQuery(Byte[] bytes, Int32 length, Boolean consume) bei MySql.Data.MySqlClient.MySqlCommand.GetNextResultSet(MySqlDataReader reader) bei MySql.Data.MySqlClient.MySqlDataReader.NextResult() bei MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) bei MySql.Data.MySqlClient.MySqlCommand.System.Data.IDbCommand.ExecuteReader() bei Gentle.Framework.SqlStatement.Execute(IDbConnection conn, IDbTransaction tr) [/CODE] I am using mysql, which works flawlessly with the TV engine 3. G. [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
Products
TV-Server
For The Record - The rule-based scheduling suite
Contact us
RSS
Top
Bottom
