Self Contained Web Server / Interface (3 Viewers)

[Oxan]

Are you aware that WebMediaPortal has already been released?

 

[Callumgw]

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]

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:

ALTER TABLE mptvdb.schedule ADD directory varchar(1024) NULL;

just as the DB engine suggests.

 

[Callumgw]

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