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

[gemx]

Nope, it's always a "LIKE %" query.
So if you enter "pink", this would end up with "WHERE somedbfield LIKE '%' AND artist LIKE 'pink%' "
So the result would be correct.
The problem is, that somehow the artist info is always enclosed with by the pipe sign (|). So to search for any artist which name starts with "pink" you have to enter "| pink"

Don't know why but that's how it's stored in the db.

 

[pilehave]

Nope, it's always a "LIKE %" query.
So if you enter "pink", this would end up with "WHERE somedbfield LIKE '%' AND artist LIKE 'pink%' "
So the result would be correct.
The problem is, that somehow the artist info is always enclosed with by the pipe sign (|). So to search for any artist which name starts with "pink" you have to enter "| pink"

Don't know why but that's how it's stored in the db.

Thanks A bit weird to store it like that...sounds like bad database-design to me

 

[joz]

Nope, it's always a "LIKE %" query.
So if you enter "pink", this would end up with "WHERE somedbfield LIKE '%' AND artist LIKE 'pink%' "
So the result would be correct.
The problem is, that somehow the artist info is always enclosed with by the pipe sign (|). So to search for any artist which name starts with "pink" you have to enter "| pink"

Don't know why but that's how it's stored in the db.

Well couldn't you auto prepend the pipe sign then maybe for usabilites sake?

 

[gemx]

It's not a big deal to auto-prepend the pipe. I just wasn't sure if the pipe is there for everyone or if it depends on certain settings

 

[joz]

I do not know that, could check @ home on 3 systems if you would like me 2 (@ work atm).
Would appreciate it, also bumped into this and thought it was the query buildup.

Just complaining here but I think it's actually quite wrong that the pipe sign is in the DB. Presentation like that should not be in db fields but parts of the presentation (that is skin)... It's like that for a lot of things in MP.

 

[disaster123]

I hadn't the time to read the whole thread - so i'm sorry if the answer is already in here.

I'm searching for a solution which ables me to store some 20GB MKV's on a server and then livestream them to MP on a lower bitrate (better compression, ...). Is this possible?

 

[Seidelin]

I hadn't the time to read the whole thread - so i'm sorry if the answer is already in here.

I'm searching for a solution which ables me to store some 20GB MKV's on a server and then livestream them to MP on a lower bitrate (better compression, ...). Is this possible?

I think it is currently not possible. One would need a MP plugin to access the server, which I don't think exist yet. Now it is accessed by webpage.

 

[disaster123]

thanks for your answer - but except the client plugin may there be other problems?

 

[Swede]

Suggestion:

I dont' think it's so difficult to make this plugin work with smartphones too. Just add some .ram links that work with realplayer for a start.

 

[ravenrocks]

After installning the new svn I get the following message:

Server Error in '/' Application.
--------------------------------------------------------------------------------

The column notify in table Program does not exist.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: Gentle.Common.GentleException: The column notify in table Program does not exist.

Source Error:

Line 86: this.name = ch.DisplayName;
Line 87: this.isWebStream = ch.IsWebstream();
Line 88: epgNow = new WebShortProgram(ch.CurrentProgram);
Line 89: epgNext=new WebShortProgram(ch.NextProgram);
Line 90: }

Source File: f:\Program Files\Team MediaPortal\MediaPortal TV Server\Plugins\MPWebServices\htdocs\App_Code\Classes.cs Line: 88

Stack Trace:

[GentleException: The column notify in table Program does not exist.]
Gentle.Common.Check.FailWith(Severity severity, Error error, Exception e, String msg) +124
Gentle.Common.Check.Fail(Exception e, Error error, Object[] args) +42
Gentle.Common.Check.Fail(Error error, Object[] args) +10
Gentle.Framework.GentleAnalyzer.UpdateObjectMap(ObjectMap map) +1853
Gentle.Framework.ObjectFactory.ConstructMap(PersistenceBroker broker, Type type) +1519
Gentle.Framework.ObjectFactory.GetMap(PersistenceBroker broker, Type type) +114
Gentle.Framework.SqlBuilder..ctor(IGentleProvider provider, StatementType stmtType, Type type, LogicalOperator logicalOperator) +205
Gentle.Framework.SqlBuilder..ctor(StatementType stmtType, Type type) +14
TvDatabase.Channel.UpdateNowAndNext() +428
TvDatabase.Channel.get_CurrentProgram() +10
MediaPortal.TvServer.WebServices.Classes.WebMiniEPG..ctor(Channel ch) in f:\Program Files\Team MediaPortal\MediaPortal TV Server\Plugins\MPWebServices\htdocs\App_Code\Classes.cs:88
MediaPortal.TvServer.WebServices.ServiceInterface.GetTvMiniEPGForGroup(Int32 idGroup) in f:\Program Files\Team MediaPortal\MediaPortal TV Server\Plugins\MPWebServices\htdocs\App_Code\TvServiceWebServices.asmx.cs:230
Default.RefreshTv() in f:\Program Files\Team MediaPortal\MediaPortal TV Server\Plugins\MPWebServices\htdocs\Default.aspx.cs:154
Default.btnTv_Click(Object sender, EventArgs e) in f:\Program Files\Team MediaPortal\MediaPortal TV Server\Plugins\MPWebServices\htdocs\Default.aspx.cs:84
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