[WiP] Rework of SQLite wrapper (2 Viewers)

[SilentException]

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]

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]

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]

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]

AW: Rework of SQLite wrapper

Part 1:

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:

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]

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]

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]

AW: Rework of SQLite wrapper

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

 

[disaster123]

AW: Rework of SQLite wrapper

Any news on this?

 

[SilentException]

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.