Reply to thread

Message

<blockquote data-quote="toggsiii" data-source="post: 856550" data-attributes="member: 119696">Whilst waiting for MPExtended WebMediaPortal, i thought I'd take a look at Kev's webinterface. It is simple, functional and intuitive.Here's what I did to get Kev's webinterface working with MP 1.2 and MySQL. The SQL syntax should be the same for MS SQL users who have the advantage of a more inuitive SQL GUI (IMO).&nbsp;Install MySQL Workbench on the computer running the MP TV ServerRun MySQL Workbench and you are presented with the most complex SQL GUI I have ever come across!Don't be daunted. On the lefthand side click on &quot;Open Connection to Start Querying&quot;Select the (hidden) Stored Connection &quot;Local Instance MySQL&quot; in the top pulldown.Click on Password &quot;Store in Vault&quot; button and enter the default MP password MediaPortal (case sensitive) unless you've changed the default!Click on &quot;OK&quot; button&nbsp;You now see an SQL query window- delete whatever is there and add the two lines which are required to schedule recordings using the Web Interface:-ALTER TABLE mptvdb.schedule ALTER series SET DEFAULT FALSE;ALTER TABLE mptvdb.schedule ALTER directory varchar(1024) NULL;Both lines should have a green dot beside them. A red dot means a typo error.Hit the lighting bolt at the top of the query window to run the commands.The output window underneath should report no errors.&nbsp;- If you like to check to see changes have been made, clear the query window and use the following query which lists the attibutes of all the fields.You should see that the two fields &quot;series&quot; and &quot;directory&quot; have been changed.DESCRIBE mptvdb.schedule;&nbsp;- Someone suggested the following is required if using channel logos. It's not needed for scheduling and I don't see how to use logos anyway:-ALTER TABLE mptvdb.schedule ADD name varchar(50) NULL DEFAULT '';&nbsp;You are done, close the workbench. Changes should be immediate.</blockquote>

[QUOTE="toggsiii, post: 856550, member: 119696"] Whilst waiting for MPExtended WebMediaPortal, i thought I'd take a look at Kev's webinterface. It is simple, functional and intuitive. Here's what I did to get Kev's webinterface working with MP 1.2 and MySQL. The SQL syntax should be the same for MS SQL users who have the advantage of a more inuitive SQL GUI (IMO). Install MySQL Workbench on the computer running the MP TV Server Run MySQL Workbench and you are presented with the most complex SQL GUI I have ever come across! Don't be daunted. On the lefthand side click on "Open Connection to Start Querying" Select the (hidden) Stored Connection "Local Instance MySQL" in the top pulldown. Click on Password "Store in Vault" button and enter the default MP password MediaPortal (case sensitive) unless you've changed the default! Click on "OK" button You now see an SQL query window - delete whatever is there and add the two lines which are required to schedule recordings using the Web Interface:- ALTER TABLE mptvdb.schedule ALTER series SET DEFAULT FALSE; ALTER TABLE mptvdb.schedule ALTER directory varchar(1024) NULL; Both lines should have a green dot beside them. A red dot means a typo error. Hit the lighting bolt at the top of the query window to run the commands. The output window underneath should report no errors. - If you like to check to see changes have been made, clear the query window and use the following query which lists the attibutes of all the fields. You should see that the two fields "series" and "directory" have been changed. DESCRIBE mptvdb.schedule; - Someone suggested the following is required if using channel logos. It's not needed for scheduling and I don't see how to use logos anyway:- ALTER TABLE mptvdb.schedule ADD name varchar(50) NULL DEFAULT ''; You are done, close the workbench. Changes should be immediate. [/QUOTE]

Verification