Reply to thread

Message

<blockquote data-quote="Andrew H" data-source="post: 1271207" data-attributes="member: 56239">I've been reading and see you are (unknowingly using) syntax is sloppy.&nbsp; You only need ONE of the SET episodeNum!= lines above as it is a repeated command every time after the first.&nbsp; Moreover, there is no ;&quot;&nbsp; (that's semicolon double-quote) following the end of the line to complete the phrase as you have properly included on the SET commands adjusting titles within your database (in an attempt for TheTVDB to properly identify the program).&nbsp; The blank lines do nothing other than provide for readability but are NOT necessary.&nbsp; BTW, this font makes it extremely difficult to identify two single-quotes from a single double-quote! It is critical they be used correctly though!cd C:\Program Files\MySQL\MySQL Server 5.1\binmysql.exe -uroot -pMediaPortal mptvdb -e &quot;UPDATE mptvdb.program SET episodeNum='' WHERE episodeNum!='' AND seriesNum='';&quot;mysql.exe -uroot -pMediaPortal mptvdb -e &quot;UPDATE mptvdb.program SET title='Bones' where title='Bones - Die Knochenjägerin';&quot;mysql.exe -uroot -pMediaPortal mptvdb -e &quot;UPDATE mptvdb.program SET title='CSI: Den Tätern auf der Spur' where title='CSI: Vegas';&quot;mysql.exe -uroot -pMediaPortal mptvdb -e &quot;UPDATE mptvdb.program SET title='Law and Order: SVU' where title='Law &amp; Order: Special Victims Unit';&quot;mysql.exe -uroot -pMediaPortal mptvdb -e &quot;UPDATE mptvdb.program SET title='CSI: Den Tätern auf der Spur' where title='CSI - Den Tätern auf der Spur';&quot;mysql.exe -uroot -pMediaPortal mptvdb -e &quot;UPDATE mptvdb.program SET title='CSI: New York' where title='CSI:NY';&quot;C:cd C:\Users\Annemarie\Downloads\episodescanner\episodescannerbin\episodescanner.exe</blockquote>

[QUOTE="Andrew H, post: 1271207, member: 56239"] I've been reading and see you are (unknowingly using) syntax is sloppy. You only need ONE of the SET episodeNum!= lines above as it is a repeated command every time after the first. Moreover, there is no ;" (that's semicolon double-quote) following the end of the line to complete the phrase as you have properly included on the SET commands adjusting titles within your database (in an attempt for TheTVDB to properly identify the program). The blank lines do nothing other than provide for readability but are NOT necessary. BTW, this font makes it extremely difficult to identify two single-quotes from a single double-quote! It is critical they be used correctly though! [FONT=courier new]cd C:\Program Files\MySQL\MySQL Server 5.1\bin mysql.exe -uroot -pMediaPortal mptvdb -e "UPDATE mptvdb.program SET episodeNum='' WHERE episodeNum!='' AND seriesNum='';" mysql.exe -uroot -pMediaPortal mptvdb -e "UPDATE mptvdb.program SET title='Bones' where title='Bones - Die Knochenjägerin';" mysql.exe -uroot -pMediaPortal mptvdb -e "UPDATE mptvdb.program SET title='CSI: Den Tätern auf der Spur' where title='CSI: Vegas';" mysql.exe -uroot -pMediaPortal mptvdb -e "UPDATE mptvdb.program SET title='Law and Order: SVU' where title='Law & Order: Special Victims Unit';" mysql.exe -uroot -pMediaPortal mptvdb -e "UPDATE mptvdb.program SET title='CSI: Den Tätern auf der Spur' where title='CSI - Den Tätern auf der Spur';" mysql.exe -uroot -pMediaPortal mptvdb -e "UPDATE mptvdb.program SET title='CSI: New York' where title='CSI:NY';" C: cd C:\Users\Annemarie\Downloads\episodescanner\episodescanner bin\episodescanner.exe[/FONT] [/QUOTE]

Verification