[mythtv-users] Just upgraded to latest git and now I get "Protocol version check failure."

[Ian Clark]

On 22 May 2011 06:04, Greg Grotsky <spikeygg.mythbox at gmail.com> wrote:
> On Fri, May 20, 2011 at 6:39 PM, R. G. Newbury <newbury at mandamus.org> wrote:
>>
>> Check your config.xml and mysql.txt files. Normally found in
>> /home/mythtv/.mythtv
>>
>> These tell mysql where to look for the mysql daemon.
>>
>> Geoff
>>
>
> Thanks Geoff, I tried running 'select * from settings order by value into
> outfile "junk";'.  I got 1273 rows out!  Then I realized that they are
> entries for each frontend that I have and I have three.  So I don't think I
> have any duplicates to get rid of - I tried doing a "sort -u junk |wc" and
> comparing it to "wc junk" and both were 1273.
>
Just fyi, If you run:

select count(*) from settings group by hostname,value,data having count(*) > 1;

it will return an empty set if there are no duplicates.

Cheers,

Ian