[mythtvnz] Screwed up Settings table in Myth Database

[nhenwood at gmail.com]

Hi Steve,

I figured out your frontend quite quickly (and myth added in mine when it started up), the issue was that the backed server IP addersses were set to 127.0.0.1, and not the IP of the host interface on that box. An SQL to update it and it all burst into life again.

Thanks again for your help.

Neil

Steve Holdoway wrote ..
> At a rough guess...
> 
> mysql> select count(*) from settings where hostname = 'pvr';
> +----------+
> | count(*) |
> +----------+
> |      341 | 
> +----------+
> 1 row in set (0.01 sec)
> 
> Now my pvr has a hostname of pvr.
> 
> Running the following query...
> 
> update settings set hostname = 'yourhostname' where hostname = 'pvr';
> 
> *should* fix this.
> 
> Well, you've got nothing to lose seeing as you've got a copy of the table
> already (:
> 
> hth,
> 
> Steve
<SNIP>