[mythtv-users] mythweb fails when searching for "other showing of a program"

[Oz Dror]

> And there are no "BackendServerIP"?

There is Backup server IP it is the new IP

> What do you get when you do these?

> SELECT * FROM settings WHERE value = 'BackendServerIP';

> SELECT * FROM settings WHERE data = 'TYPE_YOUR_OLD_IP_HERE';

oldip 192.168.0.3 new ip 192.168.0.4

mysql> SELECT * FROM settings WHERE data = '192.168.0.3' ;
Empty set (0.00 sec)

> (Replace TYPE_YOUR_OLD_IP_HERE by the old IP...)

mysql> SELECT * FROM settings WHERE data = '192.168.0.4' ;
+-----------------+-------------+----------+
| value           | data        | hostname |
+-----------------+-------------+----------+
| MasterServerIP  | 192.168.0.4 | NULL     |
| BackendServerIP | 192.168.0.4 | NULL     |
+-----------------+-------------+----------+
2 rows in set (0.00 sec)


> What actually did you change in your config? It might give us a better
> idea of where the problem may lie...

Last September I upgraded my ubuntu+mythtv system from version 10.4 to 10.10.
mythweb did not work so I had to manualy assign hostname=null to
either the MasterServerIP or The BackendServerIP (I do not remeber to
which one)
mythweb then worked fine.

Last weekend I upgraded mythtv to the ppa version (from 0.23fixes to 0.24fixes)
In doing so mythweb failed with the error above. + other (probably
related issues)
my mythtv DB is since 2006 and was upgraded gradually over the years
(once or twice a year since version 0.21)

What should be the value of hostname for the data value 192.168.0.4
(newip) in the setting record. Anything but null causes a more serious
error in mythweb than the error above.