Self Contained Web Server / Interface (1 Viewer)

[stoked]

Started to play around with the Query Management. I had to grant the Web user more access. Do all the fields require entries like duration, start after, start before, etc? I looked in the manual pdf but there was nothing explaining the Query Management feature.

I'm trying to record F1, so I set it to only record on Sunday's, and on the specific channel. I put "formula 1" as the query string and then save. My scheduled recordings show nothing for this upcoming Sunday though. When I edit this query, the "'s are stripped from it and I have to add it back in.

 

[Big_Kev]

Hi Guys.

After i installed and setup the Self contained Web server, everything looks fine, the only problem is when I try to schedule a recording this error message is shown in the IE7 window

------------------------------------------------------------------------------------------------------------------------------------
Error: [AnyDAC][Phys][ODBC][Microsoft][SQL Native Client][SQL Server]Cannot insert the value NULL into column 'directory', table 'MpTvDbRC2.dbo.Schedule'; column does not allow nulls. INSERT fails.
------------------------------------------------------------------------------------------------------------------------------------
Can anyone help me with this problem.

Thanks in advance.

Hi Brian,

Check your MediaPortal TV Server Configuration. I think you may not have set a Recording Folder for the Analog Card.

Regards
Kev

Started to play around with the Query Management. I had to grant the Web user more access. Do all the fields require entries like duration, start after, start before, etc? I looked in the manual pdf but there was nothing explaining the Query Management feature.

I'm trying to record F1, so I set it to only record on Sunday's, and on the specific channel. I put "formula 1" as the query string and then save. My scheduled recordings show nothing for this upcoming Sunday though. When I edit this query, the "'s are stripped from it and I have to add it back in.

Hi,

if you included quote marks in the search fields, this may account for the problem. The key words are built into SQL query strings internally in the web server, and any extra quote marks could be messing up the queries.

For the keywords, the scheduler is looking for '%KEYWORD%' in UPPER(title) or UPPER(description).

You dont need to fill in all fields. You can just have a name and 1 keyword if you like.

I am working hard on the remote control / playlist stuff you asked for - I can list / load / play playlists so far using a TCP helper plugin - all on .net 2.0... struggling on! (its amazing just how subtly different C# is to C++!)

Regards Kev

 

[stoked]

Hi,

if you included quote marks in the search fields, this may account for the problem. The key words are built into SQL query strings internally in the web server, and any extra quote marks could be messing up the queries.

For the keywords, the scheduler is looking for '%KEYWORD%' in UPPER(title) or UPPER(description).

You dont need to fill in all fields. You can just have a name and 1 keyword if you like.

I am working hard on the remote control / playlist stuff you asked for - I can list / load / play playlists so far using a TCP helper plugin - all on .net 2.0... struggling on! (its amazing just how subtly different C# is to C++!)

Regards Kev

Thanks Big_Kev,

Should a matching hit show up in scheduled recordings? If I just put formula for keyword and name of query, and Sunday and the single channel I want to record/suggest on, but nothing shows up.

Awesome to hear about the Music Remote Control! Thanks!

UPDATE: OK, What's happening is the channel filter was causing it to fail. If I choose All Channels I receive suggestions. Any reason why the channel filter doesn't work?

 

[vinch100]

Thanks a lot for your great job, it made me move to TV-Server and i'm really surprised how your interface works well (as far as I tested)

I only see a little problem : when a channel has many frequencies defined, it appears as many times as the number of frequencies

F. instance BBC 1 London on this picture has 3 "Details" columns, and by me such a configuration means that the Web Interface will display 3 columns (side-to-side) named "BBC 1 London" with the same guide :

Would it be possible to avoid that ?

 

[Furetto]

I only see a little problem : when a channel has many frequencies defined, it appears as many times as the number of frequencies

Confirmed. I did not have that with version 0.4.0.8
Having been on holiday, I skipped a few versions so I cannot say where exactly it started. And I had not figured out yet what the reason was that some channels appeared many time.

 

[Gixxer]

Gixxer,
you are using MS-SQL. Your default Master Database User is "sa" with password "Mediaportal".
And the database itself is called "MpTvDbRC2", if you have installed MP RC2.
Your screenshots showed that you have logged in successfully!
Re-read the documentation, ignore all MySQL stuff and you will have a clean good install of MP Webinterface.

If nothing helps, uninstall all components, and start from scratch. The default settings are good to go.

at lastttttt !!!

its working !!! thank u so much for paying attention to my questions and answering them.

ill have a look to find the translation file to work on it.

btw, i get this symbol in a lot of titles... 

 

[bhenriksen]

Hi Guys.

After i installed and setup the Self contained Web server, everything looks fine, the only problem is when I try to schedule a recording this error message is shown in the IE7 window

------------------------------------------------------------------------------------------------------------------------------------
Error: [AnyDAC][Phys][ODBC][Microsoft][SQL Native Client][SQL Server]Cannot insert the value NULL into column 'directory', table 'MpTvDbRC2.dbo.Schedule'; column does not allow nulls. INSERT fails.
------------------------------------------------------------------------------------------------------------------------------------
Can anyone help me with this problem.

Thanks in advance.

Hi Brian,

Check your MediaPortal TV Server Configuration. I think you may not have set a Recording Folder for the Analog Card.

Regards
Kev

Started to play around with the Query Management. I had to grant the Web user more access. Do all the fields require entries like duration, start after, start before, etc? I looked in the manual pdf but there was nothing explaining the Query Management feature.

I'm trying to record F1, so I set it to only record on Sunday's, and on the specific channel. I put "formula 1" as the query string and then save. My scheduled recordings show nothing for this upcoming Sunday though. When I edit this query, the "'s are stripped from it and I have to add it back in.

Hi,

if you included quote marks in the search fields, this may account for the problem. The key words are built into SQL query strings internally in the web server, and any extra quote marks could be messing up the queries.

For the keywords, the scheduler is looking for '%KEYWORD%' in UPPER(title) or UPPER(description).

You dont need to fill in all fields. You can just have a name and 1 keyword if you like.

I am working hard on the remote control / playlist stuff you asked for - I can list / load / play playlists so far using a TCP helper plugin - all on .net 2.0... struggling on! (its amazing just how subtly different C# is to C++!)

Regards Kev

Hi Big_Kev

A BIG thank you for the help.

I changed the recording folder to "C:\Recordings" instead of C:\Documents and Settings\...

And now it works like a charm.

Best regards
Brian Henriksen

 

[stoked]

Hi,

if you included quote marks in the search fields, this may account for the problem. The key words are built into SQL query strings internally in the web server, and any extra quote marks could be messing up the queries.

For the keywords, the scheduler is looking for '%KEYWORD%' in UPPER(title) or UPPER(description).

You dont need to fill in all fields. You can just have a name and 1 keyword if you like.

Regards Kev

Hi Big_Kev,

It seems that channel filter doesn't work. I set it to the channel I want to record on (HD version), and then the results show nothing. If I set it to Any channel, then I get results. Can anyone else confirm this problem?

 

[Gixxer]

btw, i get this symbol in a lot of titles... 

btw, can u see in your browsers the actual symbol?

looks like the one in the pic attached

 

[avrkris]

Big_Kev... is your website down ? I can't seem to open the link since yesterady

MediaPortal Web Interface

I've reinstalled my server box and now want to get the webinterface working with the newest version of your excellent intercace



Thanks
Kris