Reply to thread

Message

<blockquote data-quote="pbb" data-source="post: 139894" data-attributes="member: 26308">Thanks for the suggestion, I hadn't thought about that option! However, it didn't help, the config program freezes when I try that. Over the course of 10 minutes, alternating the processor is being maxed out, the programs starts consuming up to 800 MB of memory, and the harddisk is maxed outcausing all other programs to also freeze...Here's a snippet from Configuration.log:[CODE]2007-03-31 16:21:21.875000 [Info.][Config Main]: SQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database query:delete frm tblPrograms2007-03-31 16:21:21.875000 [ERROR][Config Main]: SQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database query:delete frm tblPrograms2007-03-31 16:21:21.984375 [Info.][Config Main]: TVDatabase exception err:SQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database query:delete frm tblPrograms 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.RemovePrograms()2007-03-31 16:21:21.984375 [ERROR][Config Main]: TVDatabase exception err:SQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database query:delete frm tblPrograms 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.RemovePrograms()2007-03-31 16:21:21.984375 [Info.][Config Main]: opening tvdatabase2007-03-31 16:21:22.640625 [Info.][2]: dbs:close:TVDatabaseV21.db3[/CODE]Clearly something wrong with the database....Ah, and my program database is not only thing wrong I see -- this forum here gets an error 500 (Internal Server Error) whenever I write the words &quot;delete&quot; and &quot;from&quot; after eachother! Can you image that? That is why my log mentions the weird &quot;delete frm&quot;... That should be &quot;from&quot;...</blockquote>

[QUOTE="pbb, post: 139894, member: 26308"] Thanks for the suggestion, I hadn't thought about that option! However, it didn't help, the config program freezes when I try that. Over the course of 10 minutes, alternating the processor is being maxed out, the programs starts consuming up to 800 MB of memory, and the harddisk is maxed outcausing all other programs to also freeze... Here's a snippet from Configuration.log: [CODE]2007-03-31 16:21:21.875000 [Info.][Config Main]: SQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database query:delete frm tblPrograms 2007-03-31 16:21:21.875000 [ERROR][Config Main]: SQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database query:delete frm tblPrograms 2007-03-31 16:21:21.984375 [Info.][Config Main]: TVDatabase exception err:SQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database query:delete frm tblPrograms 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.RemovePrograms() 2007-03-31 16:21:21.984375 [ERROR][Config Main]: TVDatabase exception err:SQL:TVDatabaseV21.db3 cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database query:delete frm tblPrograms 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.RemovePrograms() 2007-03-31 16:21:21.984375 [Info.][Config Main]: opening tvdatabase 2007-03-31 16:21:22.640625 [Info.][2]: dbs:close:TVDatabaseV21.db3 [/CODE] Clearly something wrong with the database.... Ah, and my program database is not only thing wrong I see -- this forum here gets an error 500 (Internal Server Error) whenever I write the words "delete" and "from" after eachother! Can you image that? That is why my log mentions the weird "delete frm"... That should be "from"... [/QUOTE]

Verification