[fixed] Unintended saving of resume position for empty MediaItemID (1 Viewer)

Holzi

Super Moderator
  • Team MediaPortal
  • April 21, 2010
    7,934
    2,235
    Ba-Wü
    Home Country
    Germany Germany
    I think I found a problem with SQLite and Resume? Or lies the problem somewhere else?
    Code:
    [2013-10-02 16:14:48,360] [24055734] [37      ] [ERROR] - UserProfileDataManagement: Error setting media item data 'PlayerContext: ResumeState' for media item '00000000-0000-0000-0000-000000000000' in profile 'df6fe492-7979-498a-b9c9-1f2a3d3f6a2d'
    System.Data.SQLite.SQLiteException (0x80004005): constraint failed
    foreign key constraint failed
      bei System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
      bei System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
      bei System.Data.SQLite.SQLiteDataReader.NextResult()
      bei System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
      bei System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
      bei System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
      bei MediaPortal.Backend.Services.Database.LoggingDbCommandWrapper.ExecuteNonQuery()
      bei MediaPortal.Backend.Services.UserProfileDataManagement.UserProfileDataManagement.SetUserMediaItemData(Guid profileId, Guid mediaItemId, String key, String data)

    Thanks!
     

    morpheus_xx

    Retired Team Member
  • Team MediaPortal
  • March 24, 2007
    12,073
    7,459
    Home Country
    Germany Germany
    Oh... this is not related to SQLite, but more to the feature to save mediaitem's restore position. This method should not be called with "Guid.Empty", as there is a foreign key to mediaitem (which doesn't exists with this ID).

    What did you do to make this happen?

    I will move your post and my answer to a new bug report.
     

    Holzi

    Super Moderator
  • Team MediaPortal
  • April 21, 2010
    7,934
    2,235
    Ba-Wü
    Home Country
    Germany Germany
    • Thread starter
    • Moderator
    • #3
    I don't know what I did. I didn't notice any strange behaviour in MP itself. When I checked the log I saw this error by accident. WIll have a look.
    Thanks :)
     

    Users who are viewing this thread

    Top Bottom