[WiP] Rework of SQLite wrapper (1 Viewer)

SilentException

Retired Team Member
  • Premium Supporter
  • October 27, 2008
    2,617
    1,130
    Rijeka, Croatia
    Croatia Croatia
    Country flag
    • Thread starter
    • Moderator
    • #11
    Then I have no explanation yet. Strange that I don't get the error, so it must be something related to data. I will investigate further (will try to "break" my database somehow to get same error). When do you get the error (read: full logs would be cool to have)?
     

    disaster123

    MP Donator
  • Premium Supporter
  • May 14, 2008
    3,546
    432
    Germany Germany
    Country flag
    AW: Rework of SQLite wrapper

    OK now done a complete SQL .dump of the db and then recreated the DB. Still the same error.

    Complete Log attached.
     

    disaster123

    MP Donator
  • Premium Supporter
  • May 14, 2008
    3,546
    432
    Germany Germany
    Country flag
    AW: Rework of SQLite wrapper

    Anything i can do / help? Right now TvSeries seems to be the only plugin having problems. Although i can't find any wrong values in the DB.
     

    SilentException

    Retired Team Member
  • Premium Supporter
  • October 27, 2008
    2,617
    1,130
    Rijeka, Croatia
    Croatia Croatia
    Country flag
    • Thread starter
    • Moderator
    • #14
    Re: AW: Rework of SQLite wrapper

    Anything i can do / help? Right now TvSeries seems to be the only plugin having problems. Although i can't find any wrong values in the DB.
    I think output of these two commands on your DB might help me look further:

    SELECT sql FROM sqlite_master WHERE name='local_episodes'

    SELECT sql FROM sqlite_master WHERE name='online_episodes'
     

    disaster123

    MP Donator
  • Premium Supporter
  • May 14, 2008
    3,546
    432
    Germany Germany
    Country flag
    AW: Rework of SQLite wrapper

    Part 1:
    Code:
    sqlite> SELECT sql FROM sqlite_master WHERE name='local_episodes';
    CREATE TABLE local_episodes (EpisodeFilename String primary key, OriginalComposi
    te String, CompositeID String, SeriesID Int, SeasonIndex Int, EpisodeIndex Int,
    LocalEpisodeName String, LocalImportProcessed Int, CompositeUpdated Int, Availab
    leSubtitles String, OriginalComposite2 String, CompositeID2 String, EpisodeIndex
    2 Int, videoWidth Int, videoHeight Int, FileDateAdded String, FileDateCreated St
    ring, IsAvailable Int, ext String, Removable String, localPlaytime String, Video
    Codec String, VideoFormat String, VideoFormatProfile String, VideoBitrate String
    , VideoFrameRate String, VideoAspectRatio String, AudioCodec String, AudioFormat
     String, AudioFormatProfile String, AudioBitrate String, AudioChannels String, A
    udioTracks String, TextCount String, StopTime String, VolumeLabel String, DateWa
    tched String, FirstAired String)
    Part 2:
    Code:
    sqlite> SELECT sql FROM sqlite_master WHERE name='online_episodes';
    CREATE TABLE online_episodes (CompositeID String primary key, EpisodeID Int, Ser
    iesID Int, EpisodeIndex Int, SeasonIndex Int, EpisodeName String, Watched Int, S
    ummary String, FirstAired String, OnlineDataImported Int, GuestStars String, Dir
    ector String, Writer String, Hidden Int, lastupdated String, DownloadPending Int
    , DownloadExpectedName String, ThumbUrl String, thumbFilename String, Combined_e
    pisodenumber String, Combined_season String, DVD_chapter String, DVD_discid Stri
    ng, DVD_episodenumber String, DVD_season String, EpImgFlag String, IMDB_ID Strin
    g, Language String, ProductionCode String, Rating String, absolute_number String
    , seasonid String, airsafter_season String, airsbefore_episode String, airsbefor
    e_season String, RatingCount String, TraktSeen Int, TraktLibrary Int, follwit_id
     Int)

    Hope it helps!
     

    SilentException

    Retired Team Member
  • Premium Supporter
  • October 27, 2008
    2,617
    1,130
    Rijeka, Croatia
    Croatia Croatia
    Country flag
    • Thread starter
    • Moderator
    • #16
    Damn, everything looks alright there and I cannot see anything wrong in both MePo or TVS code :( Did you recompile TVSeries using new MediaPortal references? It shouldn't be needed but maybe, just maybe...

    Also I would appreciate TVSeries log in DebugSQL mode.
     

    disaster123

    MP Donator
  • Premium Supporter
  • May 14, 2008
    3,546
    432
    Germany Germany
    Country flag
    AW: Rework of SQLite wrapper

    No. TVSeries doesn't compile on my 64bit system. So i'm using the version which come along with Avalon Skin.
     

    disaster123

    MP Donator
  • Premium Supporter
  • May 14, 2008
    3,546
    432
    Germany Germany
    Country flag
    AW: Rework of SQLite wrapper

    I can send you my TVSeries.dll + my .sqlite file via PM if this helps.
     

    disaster123

    MP Donator
  • Premium Supporter
  • May 14, 2008
    3,546
    432
    Germany Germany
    Country flag
    AW: Rework of SQLite wrapper

    Any news on this?
     

    SilentException

    Retired Team Member
  • Premium Supporter
  • October 27, 2008
    2,617
    1,130
    Rijeka, Croatia
    Croatia Croatia
    Country flag
    • Thread starter
    • Moderator
    • #20
    Re: AW: Rework of SQLite wrapper

    Any news on this?
    Haven't had any time to do proper debugging. And the fact that the error doesn't happen to me, makes it even harder. You can send me FULL logs (all of them) + MPTVSeries.dll + DB so I have them ready if needed.
     

    Users Who Are Viewing This Thread (Users: 0, Guests: 1)

    OP Similar threads Forum Replies Date
    CyberSimian [Action Required] Rework TV/Radio recordings screen MediaPortal 1 23
    ajs Shared-Cache Mode for SQLite DBs... MediaPortal 1 2
    J Database schema General 0
    Similar threads



    Top Bottom