[mythtv-users] find_orphans and error?

[Bill Meek]

On 01/20/2015 08:56 PM, Stephen Worthington wrote:
...
 > So I seem to somehow have acquired 20 rows with duplicate primary
> keys.  Fortunately, all the data values are also duplicated, so it
> should not be causing me any problems as long as I never have to
> change one of those settings.  Now I need to work out just how to fix
> this - my current thought is to dump the settings table, edit out all
> the duplicates from the SQL in the dump, then drop the table and
> restore it from the edited dump.  Are there any better ideas?
>
> And does anyone have any idea how this problem might have occurred?

I had the duplicates too. They're harmless. To see if the data has
non-printing characters something like this works:

      SELECT hostname,data,HEX(data) FROM settings WHERE value='BackendServerPort';

For the above, the hex is: 36353433.

-- 
Bill