2006-06-25, 11:08 AM
Hi All
Is anyone providing support for the XSuite at the moment as I have a couple of bugs that I keep getting. I did an install at work as we have MS Visual Studio 2005 and i've done a couple of minor bug fixes already but I'm stuck on this one. It is on the line:
dbReader = dbCommand.ExecuteReader();
and only happens sometimes on entering XGuide.
The exception is:
System.Data.SQLite.SQLiteException was unhandled by user code
Message="SQLite error\r\nno such column: top"
Source="System.Data.SQLite"
StackTrace:
at System.Data.SQLite.SQLite3.Prepare(String strSql, SQLiteStatement previous, String& strRemain)
at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
at System.Data.SQLite.SQLiteDataReader.NextResult()
at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader()
at Guide2Plugin.GuideVertical.pCreateGuideChannelShows(XmlElement xelEPG, Int32 intRows, Int32 intStartChannel, DateTime dtmStartGuide, Boolean blnGreaterThan) in D:\C\XGuide\XGuide\GuideVertical.cs:line 349
at Guide2Plugin.GuideVertical.pCreateGuide(Int32 intRows, Int32 intStartChannel, DateTime dtmStartGuide, Boolean blnGreaterThan) in D:\C\XGuide\XGuide\GuideVertical.cs:line 299
at Guide2Plugin.GuideVertical.Activate() in D:\C\XGuide\XGuide\GuideVertical.cs:line 145
at Guide2Plugin.Guide.set_GuideExclude(String value) in D:\C\XGuide\XGuide\Guide.cs:line 617
at Guide2Plugin.GuideTask.Activate() in D:\C\XGuide\XGuide\GuideTask.cs:line 86
at GBPVR.x86396f56243de9fb.OnKeyDown(KeyEventArgs e)
at GBPVR.xbb1566157f5f8b1f.xdae9991ab918b397(Object xdf2e3583f942db7b, KeyEventArgs xc4f45905cb1fc7ba)
at System.Windows.Forms.Control.OnKeyDown(KeyEventArgs e)
at System.Windows.Forms.Control.ProcessKeyEventArgs(Message& m)
at System.Windows.Forms.Control.ProcessKeyMessage(Message& m)
at System.Windows.Forms.Control.WmKeyChar(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at GBPVR.xbb1566157f5f8b1f.WndProc(Message& m)
Is it just a matter of catching the exception and ignoring it or is it something more serious? I don't have any experience of SQLite as you may have already guessed!
Is anyone providing support for the XSuite at the moment as I have a couple of bugs that I keep getting. I did an install at work as we have MS Visual Studio 2005 and i've done a couple of minor bug fixes already but I'm stuck on this one. It is on the line:
dbReader = dbCommand.ExecuteReader();
and only happens sometimes on entering XGuide.
The exception is:
System.Data.SQLite.SQLiteException was unhandled by user code
Message="SQLite error\r\nno such column: top"
Source="System.Data.SQLite"
StackTrace:
at System.Data.SQLite.SQLite3.Prepare(String strSql, SQLiteStatement previous, String& strRemain)
at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
at System.Data.SQLite.SQLiteDataReader.NextResult()
at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader()
at Guide2Plugin.GuideVertical.pCreateGuideChannelShows(XmlElement xelEPG, Int32 intRows, Int32 intStartChannel, DateTime dtmStartGuide, Boolean blnGreaterThan) in D:\C\XGuide\XGuide\GuideVertical.cs:line 349
at Guide2Plugin.GuideVertical.pCreateGuide(Int32 intRows, Int32 intStartChannel, DateTime dtmStartGuide, Boolean blnGreaterThan) in D:\C\XGuide\XGuide\GuideVertical.cs:line 299
at Guide2Plugin.GuideVertical.Activate() in D:\C\XGuide\XGuide\GuideVertical.cs:line 145
at Guide2Plugin.Guide.set_GuideExclude(String value) in D:\C\XGuide\XGuide\Guide.cs:line 617
at Guide2Plugin.GuideTask.Activate() in D:\C\XGuide\XGuide\GuideTask.cs:line 86
at GBPVR.x86396f56243de9fb.OnKeyDown(KeyEventArgs e)
at GBPVR.xbb1566157f5f8b1f.xdae9991ab918b397(Object xdf2e3583f942db7b, KeyEventArgs xc4f45905cb1fc7ba)
at System.Windows.Forms.Control.OnKeyDown(KeyEventArgs e)
at System.Windows.Forms.Control.ProcessKeyEventArgs(Message& m)
at System.Windows.Forms.Control.ProcessKeyMessage(Message& m)
at System.Windows.Forms.Control.WmKeyChar(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at GBPVR.xbb1566157f5f8b1f.WndProc(Message& m)
Is it just a matter of catching the exception and ignoring it or is it something more serious? I don't have any experience of SQLite as you may have already guessed!