Moving Pictures W/ Streamed MP - All Movies problem (1 Viewer)

[jvs]

Now, I'm confident that this is a Streamed MP issue, and not Moving Pictures, but I'm happy to be corrected

I've attached a screenshot of what I'm seeing here, and it looks like "All Movies" is the only category affected, because if I choose "Unwatched" I see >900 unwatched Movies.

Any thoughts on what could cause this?

StreamedMP: 1.4.11.2543
MP: 1.1.2.0
Moving Pictures: 1.1.2.1219


And for good measure, here's movingpictures.log
06-Mar-2011 13:52:07 Info [ DatabaseManager]: Successfully Opened Database: C:\Documents and Settings\All Users\Application Data\Team MediaPortal\MediaPortal\Database\movingpictures.db3
06-Mar-2011 13:52:07 Info [ SettingsManager]: SettingsManager Created
06-Mar-2011 13:52:09 Info [ MovingPicturesCore]: Moving Pictures (1.1.2:1219)
06-Mar-2011 13:52:09 Info [ MovingPicturesCore]: Plugin Launched
06-Mar-2011 13:52:09 Info [DatabaseMaintenanceM]: Checking for bad data source entries...
06-Mar-2011 13:52:12 Info [ DataProviderManager]: DataProviderManager Starting
06-Mar-2011 13:52:12 Info [ DataProviderManager]: Loading existing data sources...
06-Mar-2011 13:52:13 Info [ DataProviderManager]: Checking internal scripts for updates...
06-Mar-2011 13:52:13 Info [DatabaseMaintenanceM]: Updating Movie Information...
06-Mar-2011 13:52:13 Info [DatabaseMaintenanceM]: 'Echelon' was removed from the system because it had no local media.
06-Mar-2011 13:52:28 Error [ DatabaseManager]: Error deleting object from movie_info table. SQLite.NET.SQLiteException: SQLiteClient: cmd:sqlite3_finalize err:CORRUPT detailed:database disk image is malformed query:delete from movie_info where ID = 177
at SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
at SQLite.NET.SQLiteClient.Execute(String query)
at Cornerstone.Database.DatabaseManager.Delete(DatabaseTable dbObject)
06-Mar-2011 13:52:28 Info [DatabaseMaintenanceM]: '"Ghostbusters"' was removed from the system because it had no local media.
06-Mar-2011 13:52:43 Error [ DatabaseManager]: Error deleting object from movie_info table. SQLite.NET.SQLiteException: SQLiteClient: cmd:sqlite3_finalize err:CORRUPT detailed:database disk image is malformed query:delete from movie_info where ID = 236
at SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
at SQLite.NET.SQLiteClient.Execute(String query)
at Cornerstone.Database.DatabaseManager.Delete(DatabaseTable dbObject)
06-Mar-2011 13:52:43 Info [DatabaseMaintenanceM]: 'Gone with the West' was removed from the system because it had no local media.


Cheers guys

 

[mastyman]

looks like your moving pictures database is corrupted... there should be some backups of it in the database directory or you can create a new one.

 

[ltfearme]

Yes, this has nothing to do with the skin...why would you think that?

If you have nothing important that you need to keep in your database, just delete it and re-open movingpics configuration.

 

[jvs]

I assumed it was a skin problem because I'd seen this sort of thing before when an element can't be found, or the likes.
My bad, cheers guys, it must have gone at the same time my TV Series DB emptied itself. damn.... time to write a .bat file to regularly backup the databases methinks

(I know I'm officially in the wrong forum now, but any pro-tips on exporting watched flags and cover art?)

 

[ltfearme]

movingpics/tvseries re-uses your local artwork so just leave it in place. TVseries has an export watched setting in configuration, movingpics does not have a local setting but you can signup to follw.it and it will sync your watched flags from there.