Reply to thread

Message

<blockquote data-quote="Taipan" data-source="post: 180088" data-attributes="member: 11681">There are many, many error messages in your MediaPortal.log file like this:-[CODE]2007-09-09 20:05:07.000000 [Info.][MPMain]: SQL:FolderDatabase3.db3 cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database query:select * from tblSetting where idPath=4 and tagName like 'VideoFiles'2007-09-09 20:05:07.000000 [Info.][MPMain]: Exception&nbsp;&nbsp; :SQLite.NET.SQLiteException: SQL:FolderDatabase3.db3 cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database query:select * from tblSetting where idPath=4 and tagName like 'VideoFiles'&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 Databases.Folders.FolderSettingsSqlLite.GetFolderSetting(String strPath, String Key, Type type, Object&amp; Value)2007-09-09 20:05:07.000000 [Info.][MPMain]: Exception&nbsp;&nbsp; :SQL:FolderDatabase3.db3 cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database query:select * from tblSetting where idPath=4 and tagName like 'VideoFiles'2007-09-09 20:05:07.000000 [Info.][MPMain]:&nbsp;&nbsp; site&nbsp; &nbsp; &nbsp; :Void ThrowError(System.String, System.String, SqliteError)2007-09-09 20:05:07.000000 [Info.][MPMain]:&nbsp;&nbsp; source&nbsp; &nbsp; :Databases2007-09-09 20:05:07.000000 [Info.][MPMain]:&nbsp;&nbsp; stacktrace:&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 Databases.Folders.FolderSettingsSqlLite.GetFolderSetting(String strPath, String Key, Type type, Object&amp; Value)[/CODE]Which I suggest is the cause - and I am guessing that your FolderDatabase3.db3 file is corrupt.Try renaming your FolderDatabase3.db3 to FolderDatabase3.db3.old (just in case you need to restore it later) and then run Configuration again to setup all your folders, and see if that resolves the issue?HTH ....</blockquote>

[QUOTE="Taipan, post: 180088, member: 11681"] There are many, many error messages in your MediaPortal.log file like this:- [CODE]2007-09-09 20:05:07.000000 [Info.][MPMain]: SQL:FolderDatabase3.db3 cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database query:select * from tblSetting where idPath=4 and tagName like 'VideoFiles' 2007-09-09 20:05:07.000000 [Info.][MPMain]: Exception :SQLite.NET.SQLiteException: SQL:FolderDatabase3.db3 cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database query:select * from tblSetting where idPath=4 and tagName like 'VideoFiles' 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 Databases.Folders.FolderSettingsSqlLite.GetFolderSetting(String strPath, String Key, Type type, Object& Value) 2007-09-09 20:05:07.000000 [Info.][MPMain]: Exception :SQL:FolderDatabase3.db3 cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database query:select * from tblSetting where idPath=4 and tagName like 'VideoFiles' 2007-09-09 20:05:07.000000 [Info.][MPMain]: site :Void ThrowError(System.String, System.String, SqliteError) 2007-09-09 20:05:07.000000 [Info.][MPMain]: source :Databases 2007-09-09 20:05:07.000000 [Info.][MPMain]: stacktrace: 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 Databases.Folders.FolderSettingsSqlLite.GetFolderSetting(String strPath, String Key, Type type, Object& Value)[/CODE] Which I suggest is the cause - and I am guessing that your FolderDatabase3.db3 file is corrupt. Try renaming your FolderDatabase3.db3 to FolderDatabase3.db3.old (just in case you need to restore it later) and then run Configuration again to setup all your folders, and see if that resolves the issue? HTH .... [/QUOTE]

Verification