Self Contained Web Server / Interface

[Big_Kev]

Originally Posted by Gixxer

i guess i have to install the app and find a file with all the languages,right?

There is a page for translations in the manager program. It has a lot of the strings that need translating, but as the program is always changing, it does not have all strings.

As the program comes across a string that has not been translated, it is added to the bottom of the translation table. You basically need to run the interface for a while and make sure you have accessed all screens. This will ensure that all strings have been loaded into the translation table.

After you save your changes, you need to send me the MPTranslate.ini file from the program directory.

Originally Posted by Gixxer

btw, can u tell me why im not finding the...

Adding a user to MySQL
Select “MySQL Administrator” from Start > All Programs > MySQL and log in.

it looks i have a program missing.

You need to install the MySQL GUI Tools package. You can find it here...

MySQL :: MySQL GUI Tools Downloads

Regards
Kev

[Gixxer]

Originally Posted by Big_Kev

There is a page for translations in the manager program. It has a lot of the strings that need translating, but as the program is always changing, it does not have all strings.

As the program comes across a string that has not been translated, it is added to the bottom of the translation table. You basically need to run the interface for a while and make sure you have accessed all screens. This will ensure that all strings have been loaded into the translation table.

After you save your changes, you need to send me the MPTranslate.ini file from the program directory.

You need to install the MySQL GUI Tools package. You can find it here...

MySQL :: MySQL GUI Tools Downloads

Regards
Kev

thanks, i think u should include in the pdf guide the fact that 2 additional programs must be installed.

nevertheless, i still cant connect using mysql administrator. i think there is something wrong in my database but have no clue on what as the only thing ive done is create the new user "Web". user "sa" was already there.

i have done ping and get answer. any help on this is very much appreciated.

about the translation, it looks that till i get it fixed maybe is better if u send me your .ini with all the strings and i can work on that.

hope u can help me, although i realize its hard as its not a web interface program problem

thanks

p.d. i was thinking... can it be a firewall issue? just wondering, although error message says "could not connecto to the specific instance. error number 1045. access denied for user "root@localhost"

[Mr.Montesa]

Sounds a little bit wired Gixxer,
Your user "sa" is te admin user for the DB. No need to try with user root, which is the default admin user on linux/Unix based systems.
I think you have logged in with SA to create user web.
Perhaps you need to grant more privileges on user web. And what is the exact problem?
You cant connect to the DB? Is it localhost? default port? etc.
If your DB is running on the local server (localhost) Firewalling cant be the problem.
Describe your problem little bit in detail.
greets

[Gixxer]

Originally Posted by Mr.Montesa

Sounds a little bit wired Gixxer,
Your user "sa" is te admin user for the DB. No need to try with user root, which is the default admin user on linux/Unix based systems.
I think you have logged in with SA to create user web.
Perhaps you need to grant more privileges on user web. And what is the exact problem?
You cant connect to the DB? Is it localhost? default port? etc.
If your DB is running on the local server (localhost) Firewalling cant be the problem.
Describe your problem little bit in detail.
greets

hi, thanks for your attention.

my steps were...

install mprc2 + setup everything...tv working (minor issues not related to this)
install mysql management express to proccede with the guide, step that says...

Adding a user to MSSQL Express.
Firstly, start up the “SQL Server Management Studio Express” that you installed with MSSQL Express, and connect to the server (remember that you have to add “\SQLEXPRESS” to the end of your computer name / ip address in the “Server” field on the login window. For Example, the computer “Kevin-laptop” should be entered as “Kevin-laptop\SQLEXPRESS” as the server name.

so i created the user.

install mysql gui tools, try to connect but i get this ... (see file attached)

password i am using is: MediaPortal
rest u can see in the pic.




files web2 and web3 are just in case they are relevant.

thanks for trying to help me.

[Mr.Montesa]

You've mixed up MySQL and MSSQL.
The screenshots look like you are using MSSQL, because you are connected successfully to the database in screenshot2.
You do not need "MySQL Administrator".
Proceed with the Howto for setting up MP webfrontend for MSSQL.
Good luck.
greets

[Gixxer]

Originally Posted by Mr.Montesa

You've mixed up MySQL and MSSQL.
The screenshots look like you are using MSSQL, because you are connected successfully to the database in screenshot2.
You do not need "MySQL Administrator".
Proceed with the Howto for setting up MP webfrontend for MSSQL.
Good luck.
greets

ok, i went to Mediaportal web interface manager, database.

but i cant do the "test login" correctly. ive tried

server name: htpc
user name: root
password: tv3 also tried MediaPortal
Database name: TvLibrary and also MpTvDbRC2
tried all checkbox options

any idea? i have skiped MySQL administration as u said.

thanks

[risu]

Originally Posted by regeszter

Hi Kev,

I am using the new interface and not the PDA screens. This problem is in IE6/7 and firefox too.

Here is a generated html after I removed a scheduling.

<html>

<head>
<meta http-equiv="Content-Language" content="en-au">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<META HTTP-EQUIV="Pragma" CONTENT="no-cache">
<META HTTP-EQUIV="Expires" CONTENT="-1">
<title>MP Web Interface - Program Removed Successfully!</title>

<link rel="stylesheet" type="text/css" href="custom.css">
<SCRIPT language="JavaScript">
<!--hide

function refresh(location)
{
window.opener.location.href = location;
window.setTimeout('window.close()',1000);
}

//-->
</SCRIPT>

</head>

<body onload="javascript:refresh('showrecording')">
<center><table width=100% height=100% bgcolor="#ECECFF"><tr><td valing=center align=center>
<center>
<table id="table1" cellpadding=4 cellspacing=1><tr><th>
<font size="2" color="#FFFFFF">&nbsp;<br><b>
&nbsp;&nbsp;&nbsp;Program Removed Successfully!&nbsp;&nbsp;&nbsp;<br>&nbsp;
</b></font>
</th></tr></table>

</center></td></tr></table></center>
</body>
<HEAD>
<META HTTP-EQUIV="Pragma" CONTENT="no-cache">
<META HTTP-EQUIV="Expires" CONTENT="-1">
</HEAD>

</html>


The IE7 says: the window.opener.location is NULL or not an object (translated from hungarian)

Hi, I don't know how html looks like on current release but that code indeed should report error like that. I posted fix a while ago:

Originally Posted by risu

Thanks, there's a little problem right now with my layout as removing scheduled show always changes tvguide to scheduled recordings page on the background.

It's because there wasn't option to view scheduled data from guide before, I'll see what I can do to fix this. Problem is that current javascript always reloads scheduled view on parent window after deleting scheduled show. I think it could be fixed by replacing following line on removeok.htm:

window.opener.location.href = "showrecording";

to

window.opener.location.href = window.opener.location;

I guess that window.opener. is missing from original html-file? I really haven't looked into later releases, I'm still using 3.0.0.7 myself. When I get time I'll check newest version and try see if I can fix some problems on interface. It seems like added features have had few conflicts with my original interface (yeah, some nasty tweaks there which worked just fine with older version).

Originally Posted by rroet

I've worked through the mptranslate file and I still found all headers to be showing in english, i.e.: the entire bar "Guide, Scheduled, Recorded, Manual Rec, Search, TV Service, Logout"

I found them in NewInterface\Guidemain

Can you fix them on your side, or should I supply a new file for the NewInterface skin? I'm currently working on the [New Strings] section and working out the grammar which got awefully lost during translation of the english text . I'll upload a new file a.s.a.p.


Jelle
-------------------------------------------
Extra edit for me. Been working through the translate and html files now.
I found most missing items and I've worked on them to translate them all and correct the html templates where the ~~~ were missing. The only location I couldn't find was the DELETE button on the showrecorded overview of the PDA skin.

Could you please point me to that?

Here's an updated set of files for the mp_translate.ini in dutch and the html files for both skins.

I'm just reading the original replys, and yes, by the time I did new interface, there was lots of text which isn't translated by ~~~, it wasn't simply possible without Kev making changes to the program. Now I could make a list of translatable content if Kev is willing to add parser entries for them (if he hasn't already done that).

[Mr.Montesa]

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.

@Kev,
while using the horizontal view of MP web interface, I have a small feature request.
In vertical view, the running show is highlighted. Havin this in horizontal view would be great.
Even better: Start the column on the left, with the running program.
Theres no need to display historical data in this view, or?
You know what I mean?
Any questions, or remarks, let me know.
greets

[rroet]

Originally Posted by risu

I'm just reading the original replys, and yes, by the time I did new interface, there was lots of text which isn't translated by ~~~, it wasn't simply possible without Kev making changes to the program. Now I could make a list of translatable content if Kev is willing to add parser entries for them (if he hasn't already done that).

Kev has already updated all entries. Thanks for the reply.

[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.

By the way, thanks for a splendid interface Big_Kev.

Best regards

Brian Henriksen