Reply to thread

Message

<blockquote data-quote="tmacca" data-source="post: 928775" data-attributes="member: 77985">Started getting this problem today. Initially, I restored my database from backup, assuming it was corrupt, but still had the same issueSo, I upgraded to Moving Pictures 1.4, thinking this might solve it - but no. It's probably a full databse rebuild, but that would be a nightmare (1500+ titles, many custom, home video and foreign language films)&nbsp;Any ideas? And if not, whats the best way to rebuild the database while retaining as much of my custom info as possible&nbsp;04-Nov-2012 15:35:09 Error [&nbsp; &nbsp;&nbsp; DatabaseManager]: Could not commit to settings table. SQLite.NET.SQLiteException: SQLiteClient:&nbsp; 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:insert into settings (key, name, description, moreinfolink, grouping, value, type) values ('movie_manager_filter_menu_id', 'Movie Manager Filter Menu ID', 'The menu for the Movie Manager Filters functionality.', NULL, '|MediaPortal GUI|Filtering|', 'null', 'STRING')&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&amp; pVm)&nbsp;&nbsp; at SQLite.NET.SQLiteClient.Execute(String query)&nbsp;&nbsp; at Cornerstone.Database.DatabaseManager.insert(DatabaseTable dbObject)</blockquote>

[QUOTE="tmacca, post: 928775, member: 77985"] Started getting this problem today. Initially, I restored my database from backup, assuming it was corrupt, but still had the same issue So, I upgraded to Moving Pictures 1.4, thinking this might solve it - but no. It's probably a full databse rebuild, but that would be a nightmare (1500+ titles, many custom, home video and foreign language films) Any ideas? And if not, whats the best way to rebuild the database while retaining as much of my custom info as possible 04-Nov-2012 15:35:09 Error [ DatabaseManager]: Could not commit to settings table. SQLite.NET.SQLiteException: SQLiteClient: cmd:sqlite3_step err:ERROR detailed:SQL logic error or missing database query:insert into settings (key, name, description, moreinfolink, grouping, value, type) values ('movie_manager_filter_menu_id', 'Movie Manager Filter Menu ID', 'The menu for the Movie Manager Filters functionality.', NULL, '|MediaPortal GUI|Filtering|', 'null', 'STRING') 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 Cornerstone.Database.DatabaseManager.insert(DatabaseTable dbObject) [/QUOTE]

Verification