Reply to thread

Message

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

<blockquote data-quote="Callumgw" data-source="post: 975767" data-attributes="member: 76295">Ahh, thanks for that, yes I did that and the error disappeared then when I ran the query it said &quot;Error: 1060. Duplicate column name 'directory' &quot; .&nbsp; I rechecked the first error I got before and it actually says: &quot;syntax error. unexpected varchar. expecting drop or set&quot;I have since tried a few swaps for drop, set and varchar with no luck.I ran &quot; DESCRIBE mptvdb.schedule;&quot; and there is a varchar(1024) under &quot;null&quot; it lists &quot;no, but in the DEFAULT it has nullthought 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.&nbsp;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.&nbsp;Thanks&nbsp;C</blockquote>

[QUOTE="Callumgw, post: 975767, member: 76295"] 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 [/QUOTE]