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