[New Plugin] WebServices + Transcoded streaming + Web Interface for TvServer and MP (3 Viewers)

[joz]

Same version (latest public tv series build) mine is also named "TvSeriesDatabase4.db3"

A couple days back my tvseries db got corrupted because I had a crash when undervolting, I already restored the DB so that should not be the problem.
When it was corrupted it showed in error.log as well, now it doesn't so I guess it's fine (I had restored it from a backup)

 

[nikos1671]

can someone give a good parameters for watching tv via internet???not lan
my upload line is 1024kb.
with the defults parameters its playing just for some seconds.

 

[gemx]

It must be something with the database.

You could try to open your tvseries db with this tool SQLite Database Browser | Get SQLite Database Browser at SourceForge.net
It just a small download (single zipped exe file).

Please execute the following query (you can just copy and paste):

SELECT online_episodes.SeasonIndex,online_episodes.EpisodeIndex,online_series.pretty_name,online_episodes.EpisodeName,online_episodes.Summary,local_episodes.EpisodeFilename,local_episodes.CompositeID FROM online_series,online_episodes,local_episodes WHERE online_series.ID=online_episodes.SeriesID AND online_episodes.CompositeID=local_episodes.CompositeID ORDER BY online_series.pretty_name,online_episodes.SeasonIndex,online_episodes.EpisodeIndex

and post a screenshot of about 2 lines of the results.
That would help much

 

[nicx]

hey the new version is great so far with 2 problems for me: both the music and the pictures are not working with following error:

<!-- Web.Config Configuration File -->

<configuration>
<system.web>
<customErrors mode="Off"/>
</system.web>
</configuration>


Hinweise: Die aktuelle Seite kann durch eine benutzerdefinierte Fehlerseite ersetzt werden, indem Sie das defaultRedirect-Attribut des <customErrors>-Konfigurationstags dieser Anwendung so setzen, das es auf einen benutzerdefinierten Fehlerseiten-URL zeigt.


<!-- Web.Config Configuration File -->

<configuration>
<system.web>
<customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/>
</system.web>
</configuration>

 

[joz]

The query runs just fine, see the screenshot.
Hmm this is weird, I saw a reference of invalid cast exception in logs do you think it's because casting a null reff instance of an sqllite object or something to that extent? Wouldn't a try, catch block be appropriate here? It could provide some info. I do not want to tell you how to do things cause you probably know better than me.

p.s.

I do not really get the where block you have posted, wouldn't a join make more sense? Ah well, just for test purposes

 

[gemx]

nicx:

Please replace the attached web.config in your htdocs dir, try again and then post error message

 

[gemx]

joz

Please copy the attached TvServiceWebServices.asmx to your ...htdocs\App_Data dir and replace the existing file.
Then try again

 

[joz]

Here goes
[collapse]
Serverfout in toepassing /.
De opgegeven conversie is ongeldig.
Beschrijving: Er is een onverwerkte uitzondering opgetreden tijdens het uitvoeren van de huidige webaanvraag. Raadpleeg de stacktracering voor meer informatie over deze fout en de oorsprong ervan in de code.

Details van uitzondering: System.InvalidCastException: De opgegeven conversie is ongeldig.

Fout in bron:

Regel 109: return "";
Regel 110: else
Regel 111: return reader.GetString(idx);
Regel 112: }
Regel 113: private Int32 SafeInt32(SQLiteDataReader reader, int idx)


Bronbestand: c:\Program Files\MediaPortal\TV Server\Plugins\MPWebServices\htdocs\App_Code\TvServiceWebServices.asmx.cs Regel: 111

Stacktracering:

[InvalidCastException: De opgegeven conversie is ongeldig.]
System.Data.SQLite.SQLiteDataReader.VerifyType(Int32 i, DbType typ) +295
System.Data.SQLite.SQLiteDataReader.GetString(Int32 i) +70
MediaPortal.TvServer.WebServices.ServiceInterface.SafeStr(SQLiteDataReader reader, Int32 idx) in c:\Program Files\MediaPortal\TV Server\Plugins\MPWebServices\htdocs\App_Code\TvServiceWebServices.asmx.cs:111
MediaPortal.TvServer.WebServices.ServiceInterface.GetAllTvSeries() in c:\Program Files\MediaPortal\TV Server\Plugins\MPWebServices\htdocs\App_Code\TvServiceWebServices.asmx.cs:777
Default.RefreshTvSeries() in c:\Program Files\MediaPortal\TV Server\Plugins\MPWebServices\htdocs\Default.aspx.cs:451
Default.btnTvSeries_Click(Object sender, EventArgs e) in c:\Program Files\MediaPortal\TV Server\Plugins\MPWebServices\htdocs\Default.aspx.cs:116
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +78
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +100
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2863
[/collapse]

---EDIT---

Didn't see last message, trying now

---EDIT2---

This is getting weirder and weirder At least to me, I know some C# so I dug around a bit just now. With the updated files of last post I get an invalid cast exception on return "", the method should return a string so not sure where the casting happens.
[collapse]
Serverfout in toepassing /.
De opgegeven conversie is ongeldig.
Beschrijving: Er is een onverwerkte uitzondering opgetreden tijdens het uitvoeren van de huidige webaanvraag. Raadpleeg de stacktracering voor meer informatie over deze fout en de oorsprong ervan in de code.

Details van uitzondering: System.InvalidCastException: De opgegeven conversie is ongeldig.

Fout in bron:

Regel 109: {
Regel 110: if (reader.IsDBNull(idx))
Regel 111: return "";
Regel 112: else
Regel 113: return reader.GetString(idx);


Bronbestand: c:\Program Files\MediaPortal\TV Server\Plugins\MPWebServices\htdocs\App_Code\TvServiceWebServices.asmx.cs Regel: 111

Stacktracering:

[InvalidCastException: De opgegeven conversie is ongeldig.]
System.Data.SQLite.SQLiteDataReader.VerifyType(Int32 i, DbType typ) +295
System.Data.SQLite.SQLiteDataReader.GetString(Int32 i) +70
MediaPortal.TvServer.WebServices.ServiceInterface.SafeStr(SQLiteDataReader reader, Int32 idx) in c:\Program Files\MediaPortal\TV Server\Plugins\MPWebServices\htdocs\App_Code\TvServiceWebServices.asmx.cs:111
MediaPortal.TvServer.WebServices.ServiceInterface.GetAllTvSeries() in c:\Program Files\MediaPortal\TV Server\Plugins\MPWebServices\htdocs\App_Code\TvServiceWebServices.asmx.cs:777
Default.RefreshTvSeries() in c:\Program Files\MediaPortal\TV Server\Plugins\MPWebServices\htdocs\Default.aspx.cs:451
Default.btnTvSeries_Click(Object sender, EventArgs e) in c:\Program Files\MediaPortal\TV Server\Plugins\MPWebServices\htdocs\Default.aspx.cs:116
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +78
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +100
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2863
[/collapse]

 

[ravenrocks]

I get no connection after installing the Beta 2 plugin. I restarted tv-server and the log says its started. Do I need to open some firewall-port or something, tvserver.exe is already added.
It works locally though.

 

[gemx]

Erm, sorry, but that stacktrace is not with the attached ..asmx.cs file from the previous post or is it?