Reply to thread

Message

<blockquote data-quote="Tazman" data-source="post: 96948" data-attributes="member: 20566">Hi...Suddenly when i enter tvguide mp crashes and i get this in my mediaportal.log file:13-12-2006 22:50:30 detected new tvguide -&gt;import new tvguide13-12-2006 22:50:31 xmltv import C:\Program Files\Team MediaPortal\MediaPortal\XMLTV\tvguide.xml13-12-2006 22:50:31 SQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite5" alt=":confused:" title="Confused&nbsp; &nbsp; :confused:" loading="lazy" data-shortname=":confused:" />QL logic error or missing database query<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite8" alt=":D" title="Big Grin&nbsp; &nbsp; :D" loading="lazy" data-shortname=":D" />ELETE FROM tblPrograms WHERE iEndTime &lt; '20061212000000'13-12-2006 22:50:31 TVDatabase exception err<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite5" alt=":confused:" title="Confused&nbsp; &nbsp; :confused:" loading="lazy" data-shortname=":confused:" />QL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite5" alt=":confused:" title="Confused&nbsp; &nbsp; :confused:" loading="lazy" data-shortname=":confused:" />QL logic error or missing database query<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite8" alt=":D" title="Big Grin&nbsp; &nbsp; :D" loading="lazy" data-shortname=":D" />ELETE FROM tblPrograms WHERE iEndTime &lt; '20061212000000' 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.RemoveOldPrograms() DELETE FROM tblPrograms WHERE iEndTime &lt; '20061212000000'13-12-2006 22:50:31 opening tvdatabaseCan anynone tell whats happening?Tazman</blockquote>

[QUOTE="Tazman, post: 96948, member: 20566"] Hi... Suddenly when i enter tvguide mp crashes and i get this in my mediaportal.log file: 13-12-2006 22:50:30 detected new tvguide ->import new tvguide 13-12-2006 22:50:31 xmltv import C:\Program Files\Team MediaPortal\MediaPortal\XMLTV\tvguide.xml 13-12-2006 22:50:31 SQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database query:DELETE FROM tblPrograms WHERE iEndTime < '20061212000000' 13-12-2006 22:50:31 TVDatabase exception err:SQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database query:DELETE FROM tblPrograms WHERE iEndTime < '20061212000000' 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.RemoveOldPrograms() DELETE FROM tblPrograms WHERE iEndTime < '20061212000000' 13-12-2006 22:50:31 opening tvdatabase Can anynone tell whats happening? Tazman [/QUOTE]

Verification