Self Contained Web Server / Interface | Page 122

Discussion in 'WebService and Mobile Access' started by Big_Kev, August 31, 2007.

  1. Spooky
    • Premium Supporter

    Spooky MP Donator

    Joined:
    February 14, 2005
    Messages:
    1,187
    Likes Received:
    45
    Location:
    void 4tl
    Ratings:
    +47 / 0
    Home Country:
    Austria Austria
    Show System Specs
    Hm, could it be that the MPWebInterface is not working with 1.2.x anymore? I updated my TV server to 1.2.1 and then wanted to update the TV logos in the MPWebInterface configuration. However, when I press the "Reset" button under "Logos" I get the following error: "ADQuery: field 'name' not found" and then no channels are displayed there anymore.


     
  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. dazzle
    • Premium Supporter

    dazzle MP Donator

    Joined:
    February 26, 2007
    Messages:
    54
    Likes Received:
    0
    Gender:
    Male
    Occupation:
    IT Systems Administrator
    Ratings:
    +0 / 0
    Home Country:
    Denmark Denmark
    Show System Specs
    Hi, I have the same issue with both 1.2.1 and 1.2.2 :-(

    Hope Big_Kev still would like to develop this nice program.

    -dazzle
     
  4. asboe

    asboe Portal Member

    Joined:
    March 5, 2008
    Messages:
    47
    Likes Received:
    3
    Ratings:
    +3 / 0
    Some clean-up in DB was done in the MP update to version 1.2. MP WEbinterface expext a Coloumn Name: 'name'.
    I fixed it remaking the column name in db.
     
  5. dazzle
    • Premium Supporter

    dazzle MP Donator

    Joined:
    February 26, 2007
    Messages:
    54
    Likes Received:
    0
    Gender:
    Male
    Occupation:
    IT Systems Administrator
    Ratings:
    +0 / 0
    Home Country:
    Denmark Denmark
    Show System Specs
    Hi,

    I thought it was something like that, but I am not good at MySQL. Can you post a "howto" please?

    Regards
     
  6. Spooky
    • Premium Supporter

    Spooky MP Donator

    Joined:
    February 14, 2005
    Messages:
    1,187
    Likes Received:
    45
    Location:
    void 4tl
    Ratings:
    +47 / 0
    Home Country:
    Austria Austria
    Show System Specs
    He wanted to completely redo the whole thing in C#. But now it's probably better to use the MPExtended WebMediaPortal, that is currently under development. It's better to have one unified plugin instead of running multiple web services for your TV service. Though I don't like the current design layout of MPExtended WebMediaPortal.
     
  7. dazzle
    • Premium Supporter

    dazzle MP Donator

    Joined:
    February 26, 2007
    Messages:
    54
    Likes Received:
    0
    Gender:
    Male
    Occupation:
    IT Systems Administrator
    Ratings:
    +0 / 0
    Home Country:
    Denmark Denmark
    Show System Specs
    Interesting info. I will keep an eye on the MPExtended WebMediaPortal.

    Thank you for info.
     
  8. asboe

    asboe Portal Member

    Joined:
    March 5, 2008
    Messages:
    47
    Likes Received:
    3
    Ratings:
    +3 / 0
    Some time ago i did these changes. by using the guide from Big_Kev, where he explain how to add a db for queries. Using Microsoft SQL Server Management Studio
    I saved the settings in a screendump.

    Hope it helps
     

    Attached Files:

    • db-clip.png
      db-clip.png
      File size:
      184.7 KB
      Uploaded:
      January 13, 2012
      Views:
      167
  9. Elof
    • Premium Supporter

    Elof MP Donator

    Joined:
    December 18, 2005
    Messages:
    94
    Likes Received:
    11
    Ratings:
    +16 / 1
    Home Country:
    Sweden Sweden
    I agree that one web interface to rule them all is the best but I mainly use the query function for scheduling shows and series I want to watch. Any suggestions on a replacement for that part?
     
  10. Spooky
    • Premium Supporter

    Spooky MP Donator

    Joined:
    February 14, 2005
    Messages:
    1,187
    Likes Received:
    45
    Location:
    void 4tl
    Ratings:
    +47 / 0
    Home Country:
    Austria Austria
    Show System Specs
    I still use Kev's webinterface. I currently don't mind having no TV logos. However, WebMediaPortal should be able to do that as well, but I haven't tried the preview version yet.
     
  11. toggsiii

    toggsiii New Member

    Joined:
    February 24, 2012
    Messages:
    1
    Likes Received:
    0
    Gender:
    Male
    Ratings:
    +0 / 0
    Home Country:
    United Kingdom United Kingdom
    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.
     
Loading...

Users Viewing Thread (Users: 0, Guests: 0)

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice
  • About The Project

    The vision of the MediaPortal project is to create a free open source media centre application, which supports all advanced media centre functions, and is accessible to all Windows users.

    In reaching this goal we are working every day to make sure our software is one of the best.

             

  • Support MediaPortal!

    The team works very hard to make sure the community is running the best HTPC-software. We give away MediaPortal for free but hosting and software is not for us.

    Care to support our work with a few bucks? We'd really appreciate it!