Self Contained Web Server / Interface (1 Viewer)

Oxan

Retired Team Member
  • Premium Supporter
  • August 29, 2009
    1,730
    1,124
    Netherlands Netherlands
    Are you aware that WebMediaPortal has already been released?
     

    Callumgw

    Portal Pro
    June 2, 2008
    134
    6
    Country flag
    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
     

    mmesh

    MP Donator
  • Premium Supporter
  • December 10, 2004
    65
    3
    Zagreb
    Croatia Croatia
    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?
    Try doing this SQL:
    Code:
    ALTER TABLE mptvdb.schedule ADD directory varchar(1024) NULL;
    just as the DB engine suggests.
     

    Callumgw

    Portal Pro
    June 2, 2008
    134
    6
    Country flag
    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
     

    Users Who Are Viewing This Thread (Users: 0, Guests: 1)

    Top Bottom