Reply to thread

Message

<blockquote data-quote="RichardT" data-source="post: 957434" data-attributes="member: 136099">Hello out there.&nbsp;I'm trying to get the analog side of an HVR-900 card to work with MP.&nbsp; I believe that the thing standing in my way is the lack of a video encoder. I came across the posts above and felt that it was the last thing to try before giving up. I've extracted the encoders from a WINTV CD and registered them, but they are not as shown in the DB list so the don't appear as installed.&nbsp;So putting my typing skills to use I tried to enter one myself via MySQL copying verbatim what appeared above.&nbsp;When I hit &lt;CR&gt;&nbsp;&nbsp; a password was requested..........looking good here I thought.........until I got the following error message:-&nbsp;&nbsp;C:\Program Files\MySQL\MySQL Server 5.1\bin&gt;mysql -u root -p MpTvDb -e &quot;INSERT INTO SoftwareEncoder (idEncoder,priority,name,type,reusable) VALUES ((SELECT MAX(idEncoder) + 1 FROM SoftwareEncoder),(SELECT MAX(priority) + 1 FROM SoftwareEncoder WHERE type = 0), 'MainConcept MPEG Encoder', 0, 1);&quot;Enter password: ***********ERROR 1093 (HY000) at line 1: You can't specify target table 'SoftwareEncoder' for update in FROM clause&nbsp;Not knowing anything about DB's I am now totally lost as to what to do now!&nbsp;Anyone able to put me back on track please?&nbsp;TIA&nbsp; &nbsp; Richard.</blockquote>

[QUOTE="RichardT, post: 957434, member: 136099"] Hello out there. I'm trying to get the analog side of an HVR-900 card to work with MP. I believe that the thing standing in my way is the lack of a video encoder. I came across the posts above and felt that it was the last thing to try before giving up. I've extracted the encoders from a WINTV CD and registered them, but they are not as shown in the DB list so the don't appear as installed. So putting my typing skills to use I tried to enter one myself via MySQL copying verbatim what appeared above. When I hit <CR> a password was requested..........looking good here I thought.........until I got the following error message:- C:\Program Files\MySQL\MySQL Server 5.1\bin>mysql -u root -p MpTvDb -e "INSERT I NTO SoftwareEncoder (idEncoder,priority,name,type,reusable) VALUES ((SELECT MAX( idEncoder) + 1 FROM SoftwareEncoder),(SELECT MAX(priority) + 1 FROM SoftwareEnco der WHERE type = 0), 'MainConcept MPEG Encoder', 0, 1);" Enter password: *********** ERROR 1093 (HY000) at line 1: You can't specify target table 'SoftwareEncoder' for update in FROM clause Not knowing anything about DB's I am now totally lost as to what to do now! Anyone able to put me back on track please? TIA Richard. [/QUOTE]

Verification