Self Contained Web Server / Interface | Page 123

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

  1. Oxan
    • Team MediaPortal

    Oxan Retired Team Member

    Joined:
    August 29, 2009
    Messages:
    1,730
    Likes Received:
    1,024
    Gender:
    Male
    Ratings:
    +1,115 / 2
    Home Country:
    Netherlands Netherlands
    Are you aware that WebMediaPortal has already been released?


     
  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. Callumgw

    Callumgw Portal Pro

    Joined:
    June 2, 2008
    Messages:
    134
    Likes Received:
    4
    Ratings:
    +6 / 0
    Home Country:
    I tried this fix, but keep getting error on:
    ALTER TABLE mptvdb.schedule ALTER directory varchar(1024) NULL;

    It says it expects "add" or "set" before the "varchar(1024)" any suggestions?

    C
     
  4. mmesh
    • Premium Supporter

    mmesh MP Donator

    Joined:
    December 10, 2004
    Messages:
    65
    Likes Received:
    3
    Location:
    Zagreb
    Ratings:
    +3 / 1
    Home Country:
    Croatia Croatia
    Try doing this SQL:
    Code (Text):
    1. ALTER TABLE mptvdb.schedule ADD directory varchar(1024) NULL;
    just as the DB engine suggests.
     
  5. Callumgw

    Callumgw Portal Pro

    Joined:
    June 2, 2008
    Messages:
    134
    Likes Received:
    4
    Ratings:
    +6 / 0
    Home Country:
    Ahh, thanks for that, yes I did that and the error disappeared then when I ran the query it said "Error: 1060. Duplicate column name 'directory' " . I rechecked the first error I got before and it actually says: "syntax error. unexpected varchar. expecting drop or set"
    I have since tried a few swaps for drop, set and varchar with no luck.
    I ran " DESCRIBE mptvdb.schedule;" and there is a varchar(1024) under "null" it lists "no, but in the DEFAULT it has null
    thought it might not need this line so I ran the others and went tot the localhost page but it crashed!
    so I'm confused...
    think I'll give up.

    I just wanted a simple way to select and start recordings without turning on one of our media boxes. My server runs Apache and didn't want to use IIS, nor did I want all the bells and whistles of webmediaportal.
    So unless someone has a simple idea, I reckon I'll scrap this and just turn the boxes on to set recording and then turn them off again.

    Thanks

    C
     
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!