[mythtv-users] find_orphans and error?

[Stephen Worthington]

On Tue, 20 Jan 2015 15:54:49 +0000, you wrote:

>Hi.
>
>Seems I have an issue somewhere on my system in that find_orphans will 
>not run, but gives the follwoing error :-
>
>Traceback (most recent call last):
>   File "./Find_orphans.py", line 222, in <module>
>     BE = MythBE(db=DB)
>   File "/usr/lib/python2.7/dist-packages/MythTV/mythproto.py", line 93, 
>in __init__
>     self.port = int(self.db.settings[self.hostname].BackendServerPort)
>TypeError: int() argument must be a string or a number, not 'NoneType'
>
>Anyone have an idea why? Running Mythbuntu 14.04 with .27 Myth. 
>Everything else seems to work fine, wanted to have a cleanup after a 
>recent upgrade.
>
>Paul

That line in mythproto.py is trying to read the BackendServerPort
setting from your mythconverg.settings table, and instead of a valid
port number, it is finding a non-integer and non-string value in the
table, possibly a Null value.  This is what I have in my settings
table:

mysql> select * from settings where value='BackendServerPort';
+-------------------+------+----------+
| value             | data | hostname |
+-------------------+------+----------+
| BackendServerPort | 6543 | mypvr    |
| BackendServerPort | 6543 | mypvr    |
+-------------------+------+----------+
2 rows in set (0.00 sec)

That looks a bit strange as there are two identical rows in the table
- I have no idea why my database would have that.  But your database
probably needs to have one row like that with the appropriate hostname
for your system and the port number 6543 as in the data field.  I
think the server port is set somewhere in mythtv-settings, so you
might like to try running it and changing whatever value have there to
a valid port number other than 6543, saving and exiting mythtv-setup,
then running mythtv-setup again and setting it to the correct 6543
port number.  That might fix the value in the mythconverg.settings row
and make it work.