Database: Refactor MP1 database for multi seat usage (1 Viewer)

[ajs]

I try test Refactor MP1 from first post ... But:

[2021-11-24 18:43:09,275] [Config ] [Config Main] [DEBUG] - VideoDatabase: ProcessVideoUpgrade: pDatabaseName: C:\ProgramData\Team MediaPortal\MediaPortal\Database\VideoDatabaseV6.db3
[2021-11-24 18:43:09,553] [Config ] [Config Main] [WARN ] - Failed to locate assembly 'EntityFramework.SqlServer, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.
[2021-11-24 18:43:09,553] [Config ] [Config Main] [WARN ] - Failed to locate assembly 'EntityFramework.SqlServer, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.
[2021-11-24 18:43:37,250] [Config ] [Config Main] [ERROR] - UpgradeActors: exception err:An error occurred while updating the entries. See the inner exception for details. stack:   в System.Data.Entity.Internal.InternalContext.SaveChanges()
   в System.Data.Entity.Internal.LazyInternalContext.SaveChanges()
   в System.Data.Entity.DbContext.SaveChanges()
   в MediaPortal.Video.Database.VideoDatabase.UpgradeActors()
[2021-11-24 18:44:28,376] [Config ] [Config Main] [DEBUG] - VideoDatabase: BuildDatabase: end

[2021-11-24 18:44:29,104] [Config ] [Config Main] [DEBUG] - MusicDatabase: ProcessMusicUpgrade: start pDatabaseName: C:\ProgramData\Team MediaPortal\MediaPortal\Database\MusicDatabaseV15.db3
[2021-11-24 18:45:18,977] [Config ] [Config Main] [ERROR] - UpgradeAlbumInfo: exception err:The 'idGenre' property on 'albuminfo' could not be set to a 'null' value. You must set this property to a non-null value of type 'System.Int64'.  stack:   в System.Data.Entity.Core.Common.Internal.Materialization.Shaper.ErrorHandlingValueReader`1.GetValue(DbDataReader reader, Int32 ordinal)
   в lambda_method(Closure , Shaper )
   в System.Data.Entity.Core.Common.Internal.Materialization.Shaper.HandleEntityAppendOnly[TEntity](Func`2 constructEntityDelegate, EntityKey entityKey, EntitySet entitySet)
   в lambda_method(Closure , Shaper )
   в System.Data.Entity.Core.Common.Internal.Materialization.Coordinator`1.ReadNextElement(Shaper shaper)
   в System.Data.Entity.Core.Common.Internal.Materialization.Shaper`1.SimpleEnumerator.MoveNext()
   в System.Data.Entity.Internal.LazyEnumerator`1.MoveNext()
   в System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   в System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   в MediaPortal.Music.Database.MusicDatabase.UpgradeAlbumInfo()
[2021-11-24 18:45:19,908] [Config ] [Config Main] [DEBUG] - MusicDatabase: ProcessMusicUpgrade: upgrade finished

[2021-11-24 18:45:23,219] [Config ] [Config Main] [ERROR] - GetPictureDataList: error: The 'HDR' property on 'picturedata' could not be set to a 'null' value. You must set this property to a non-null value of type 'System.Boolean'.  - inner:

[2021-11-24 18:45:39,055] [Config ] [Config Main] [ERROR] - SetMovieDetails: exception err:Ссылка на объект не указывает на экземпляр объекта. inner exception:  stack:    в MediaPortal.Video.Database.VideoDatabase.GetPathMovie(Int64 pMovieId)
   в MediaPortal.Video.Database.VideoDatabase.SetMovieDetails(movieinfo pMovieInfo)
[2021-11-24 18:45:39,088] [Config ] [Config Main] [ERROR] - SetMovieDetails: exception err:Ссылка на объект не указывает на экземпляр объекта. inner exception:  stack:    в MediaPortal.Video.Database.VideoDatabase.GetPathMovie(Int64 pMovieId)
   в MediaPortal.Video.Database.VideoDatabase.SetMovieDetails(movieinfo pMovieInfo)
[2021-11-24 18:45:39,092] [Config ] [Config Main] [ERROR] - SetMovieDetails: exception err:Ссылка на объект не указывает на экземпляр объекта. inner exception:  stack:    в MediaPortal.Video.Database.VideoDatabase.GetPathMovie(Int64 pMovieId)
   в MediaPortal.Video.Database.VideoDatabase.SetMovieDetails(movieinfo pMovieInfo)
[2021-11-24 18:45:39,348] [Config ] [Config Main] [ERROR] - SetMovieDetails: exception err:Ссылка на объект не указывает на экземпляр объекта. inner exception:  stack:    в MediaPortal.Video.Database.VideoDatabase.GetPathMovie(Int64 pMovieId)
   в MediaPortal.Video.Database.VideoDatabase.SetMovieDetails(movieinfo pMovieInfo)
[2021-11-24 18:45:39,561] [Config ] [Config Main] [ERROR] - SetMovieDetails: exception err:Ссылка на объект не указывает на экземпляр объекта. inner exception:  stack:    в MediaPortal.Video.Database.VideoDatabase.GetPathMovie(Int64 pMovieId)
   в MediaPortal.Video.Database.VideoDatabase.SetMovieDetails(movieinfo pMovieInfo)
[2021-11-24 18:45:47,832] [Config ] [Config Main] [DEBUG] - GetPathMovie: start pMovieId: 4860
[2021-11-24 18:45:47,833] [Config ] [Config Main] [ERROR] - SetMovieDetails: exception err:Ссылка на объект не указывает на экземпляр объекта. inner exception:  stack:    в MediaPortal.Video.Database.VideoDatabase.GetPathMovie(Int64 pMovieId)
   в MediaPortal.Video.Database.VideoDatabase.SetMovieDetails(movieinfo pMovieInfo)

After i try start MP1 (Mediaportal.exe) after long long long long long start ... In log i see a lot of:

[2021-11-24 18:54:45,229] [Log    ] [MPMain   ] [DEBUG] - DeleteTrack: start pTrackId: 23175
[2021-11-24 18:54:45,229] [Log    ] [MPMain   ] [DEBUG] - DatabaseQueue: EnQueueData: start
[2021-11-24 18:54:45,230] [Log    ] [MPMain   ] [DEBUG] - DeleteTrack: start pTrackId: 23176
[2021-11-24 18:54:45,231] [Log    ] [MPMain   ] [DEBUG] - DatabaseQueue: EnQueueData: start
[2021-11-24 18:54:45,232] [Log    ] [MPMain   ] [DEBUG] - DeleteTrack: start pTrackId: 23177
[2021-11-24 18:54:45,233] [Log    ] [MPMain   ] [DEBUG] - DatabaseQueue: EnQueueData: start
[2021-11-24 18:54:45,234] [Log    ] [MPMain   ] [DEBUG] - DeleteTrack: start pTrackId: 23178
[2021-11-24 18:54:45,234] [Log    ] [MPMain   ] [DEBUG] - DatabaseQueue: EnQueueData: start
[2021-11-24 18:54:45,235] [Log    ] [MPMain   ] [DEBUG] - DeleteTrack: start pTrackId: 23179
[2021-11-24 18:54:45,236] [Log    ] [MPMain   ] [DEBUG] - DatabaseQueue: EnQueueData: start
[2021-11-24 18:54:45,237] [Log    ] [MPMain   ] [DEBUG] - DeleteTrack: start pTrackId: 23180
[2021-11-24 18:54:45,238] [Log    ] [MPMain   ] [DEBUG] - DatabaseQueue: EnQueueData: start
[2021-11-24 18:54:45,239] [Log    ] [MPMain   ] [DEBUG] - DeleteTrack: start pTrackId: 23181
[2021-11-24 18:54:45,239] [Log    ] [MPMain   ] [DEBUG] - DatabaseQueue: EnQueueData: start
[2021-11-24 18:54:45,240] [Log    ] [MPMain   ] [DEBUG] - DeleteTrack: start pTrackId: 23182
[2021-11-24 18:54:45,241] [Log    ] [MPMain   ] [DEBUG] - DatabaseQueue: EnQueueData: start
[2021-11-24 18:54:45,281] [Log    ] [MPMain   ] [DEBUG] - DeleteTrack: start pTrackId: 23149
[2021-11-24 18:54:45,282] [Log    ] [MPMain   ] [DEBUG] - DatabaseQueue: EnQueueData: start
[2021-11-24 18:54:45,283] [Log    ] [MPMain   ] [DEBUG] - DeleteTrack: start pTrackId: 23150
[2021-11-24 18:54:45,283] [Log    ] [MPMain   ] [DEBUG] - DatabaseQueue: EnQueueData: start
[2021-11-24 18:54:45,285] [Log    ] [MPMain   ] [DEBUG] - DeleteTrack: start pTrackId: 23151
[2021-11-24 18:54:45,285] [Log    ] [MPMain   ] [DEBUG] - DatabaseQueue: EnQueueData: start

After MP start i try goto MyVideo plugin and Mediaportal crash ...

 

[ajs]

The series is not in my database, but for some reason they are in the part table, also there is no movie that I marked.

 

[framug]

The worst is that "No time to die" is not in the DB.
OFC, joke inside

 

[Anthony Vaughan]

Thank you for letting me know about this. When I modified the code to handle stacked movies properly, I forgot to change the upgrade code .

I would expect, when the database is not loaded correctly, for the rest of the app to become unstable - so a crash wold be expected. This got me thinking about what to do when an upgrade fails. Maybe the answer, so users can keep using the system, is to load the default version of the database when something goes wrong so users can at least do something; maybe putting a log entry in to say that the upgrade process failed and to contact MP.

Of course, this shouldn't happen once I've fixed the bug.

 

[Anthony Vaughan]

Can you check which version of the MediaPortalRefactor1.29.010.zip you were using? You'll see here that the latest version is 010 and I checked the upgrade processing and it does process stacked files properly (for me anyway). A bit of a mystery.

 

[ajs]

Can you check which version of the MediaPortalRefactor1.29.010.zip you were using?

Mediaportalrefactor1.29.010.zip

 

[Anthony Vaughan]

Mediaportalrefactor1.29.010.zip

Okay. I'll check it out.

 

[Anthony Vaughan]

Can you provide me with a copy of the video database? I need to understand where there may be differences between what I do and what you do. Hopefully, the data will reveal that.

 

[Anthony Vaughan]

I notice you are using a script file I have not seen before - KTI_MDB.csscript.

We are now using entity framework so we need to declare that in the script files.

//css_reference "core.dll";
//css_reference "Databases.dll";
//css_reference "EntityFramework.dll";
//css_reference "utils.dll";

using System;
using System.Text;
using System.IO;
using System.Net;
using System.Collections;
using System.Data;
using System.Data.Entity;
using System.Web;
using System.Text.RegularExpressions;
using MediaPortal.Util;
using MediaPortal.Video.Database;
using System.Windows.Forms;

Notice entity framework and the system.data references.

 

[ajs]

Can you provide me with a copy of the video database?

Original? Or refactor?