Reply to thread

Message

<blockquote data-quote="pbb" data-source="post: 139191" data-attributes="member: 26308">Any ideas anyone? MediaPortal now even seems to crash when I open the TV Guide.From MediaPortal.log:[CODE]2007-03-28 23:40:09.593750 [Info.][MPMain]: window:MediaPortal.GUI.TV.GUITVGuide init2007-03-28 23:40:09.843750 [Info.][MPMain]: SQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database query:select * from channel,tblPrograms,genre where genre.idGenre=tblPrograms.idGenre and tblPrograms.idChannel=channel.idChannel and channel.strChannel like 'TV2 Zebra'&nbsp; and ( (tblPrograms.iEndTime&gt;='20070328233000' and tblPrograms.iEndTime &lt;='20070329012900')&nbsp; or (tblPrograms.iStartTime&gt;='20070328233000' and tblPrograms.iStartTime &lt;= '20070329012900' )&nbsp; or (tblPrograms.iStartTime&lt;='20070328233000' and tblPrograms.iEndTime &gt;= '20070329012900') ) order by iStartTime2007-03-28 23:40:09.843750 [Info.][MPMain]: TVDatabase exception err:SQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database query:select * from channel,tblPrograms,genre where genre.idGenre=tblPrograms.idGenre and tblPrograms.idChannel=channel.idChannel and channel.strChannel like 'TV2 Zebra'&nbsp; and ( (tblPrograms.iEndTime&gt;='20070328233000' and tblPrograms.iEndTime &lt;='20070329012900')&nbsp; or (tblPrograms.iStartTime&gt;='20070328233000' and tblPrograms.iStartTime &lt;= '20070329012900' )&nbsp; or (tblPrograms.iStartTime&lt;='20070328233000' and tblPrograms.iEndTime &gt;= '20070329012900') ) order by iStartTime stack:&nbsp;&nbsp; at SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)&nbsp;&nbsp; at SQLite.NET.SQLiteClient.ReadpVm(String query, SQLiteResultSet set1, IntPtr pVm)&nbsp;&nbsp; at SQLite.NET.SQLiteClient.Execute(String query)&nbsp;&nbsp; at MediaPortal.TV.Database.TVDatabase.GetProgramsPerChannel(String strChannel1, Int64 iStartTime, Int64 iEndTime, List`1&amp; progs) select * from channel,tblPrograms,genre where genre.idGenre=tblPrograms.idGenre and tblPrograms.idChannel=channel.idChannel and channel.strChannel like 'TV2 Zebra'&nbsp; and ( (tblPrograms.iEndTime&gt;='20070328233000' and tblPrograms.iEndTime &lt;='20070329012900')&nbsp; or (tblPrograms.iStartTime&gt;='20070328233000' and tblPrograms.iStartTime &lt;= '20070329012900' )&nbsp; or (tblPrograms.iStartTime&lt;='20070328233000' and tblPrograms.iEndTime &gt;= '20070329012900') ) order by iStartTime2007-03-28 23:40:09.843750 [Info.][MPMain]: opening tvdatabase2007-03-28 23:40:14.781250 [Info.][2]: dbs:close:TVDatabaseV21.db3[/CODE]</blockquote>

[QUOTE="pbb, post: 139191, member: 26308"] Any ideas anyone? MediaPortal now even seems to crash when I open the TV Guide. From MediaPortal.log: [CODE]2007-03-28 23:40:09.593750 [Info.][MPMain]: window:MediaPortal.GUI.TV.GUITVGuide init 2007-03-28 23:40:09.843750 [Info.][MPMain]: SQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database query:select * from channel,tblPrograms,genre where genre.idGenre=tblPrograms.idGenre and tblPrograms.idChannel=channel.idChannel and channel.strChannel like 'TV2 Zebra' and ( (tblPrograms.iEndTime>='20070328233000' and tblPrograms.iEndTime <='20070329012900') or (tblPrograms.iStartTime>='20070328233000' and tblPrograms.iStartTime <= '20070329012900' ) or (tblPrograms.iStartTime<='20070328233000' and tblPrograms.iEndTime >= '20070329012900') ) order by iStartTime 2007-03-28 23:40:09.843750 [Info.][MPMain]: TVDatabase exception err:SQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database query:select * from channel,tblPrograms,genre where genre.idGenre=tblPrograms.idGenre and tblPrograms.idChannel=channel.idChannel and channel.strChannel like 'TV2 Zebra' and ( (tblPrograms.iEndTime>='20070328233000' and tblPrograms.iEndTime <='20070329012900') or (tblPrograms.iStartTime>='20070328233000' and tblPrograms.iStartTime <= '20070329012900' ) or (tblPrograms.iStartTime<='20070328233000' and tblPrograms.iEndTime >= '20070329012900') ) order by iStartTime stack: at SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err) at SQLite.NET.SQLiteClient.ReadpVm(String query, SQLiteResultSet set1, IntPtr pVm) at SQLite.NET.SQLiteClient.Execute(String query) at MediaPortal.TV.Database.TVDatabase.GetProgramsPerChannel(String strChannel1, Int64 iStartTime, Int64 iEndTime, List`1& progs) select * from channel,tblPrograms,genre where genre.idGenre=tblPrograms.idGenre and tblPrograms.idChannel=channel.idChannel and channel.strChannel like 'TV2 Zebra' and ( (tblPrograms.iEndTime>='20070328233000' and tblPrograms.iEndTime <='20070329012900') or (tblPrograms.iStartTime>='20070328233000' and tblPrograms.iStartTime <= '20070329012900' ) or (tblPrograms.iStartTime<='20070328233000' and tblPrograms.iEndTime >= '20070329012900') ) order by iStartTime 2007-03-28 23:40:09.843750 [Info.][MPMain]: opening tvdatabase 2007-03-28 23:40:14.781250 [Info.][2]: dbs:close:TVDatabaseV21.db3[/CODE] [/QUOTE]

Verification