[mythtvnz] Screwed up Settings table in Myth Database

[Steve Holdoway]

No worries. Glad you're back up and running. Hope the gf's forgiven you, too (:

Steve

On Thu, 07 Feb 2008 22:04:20 +1300 (NZDT)
nhenwood at gmail.com wrote:

> 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>
> 


-- 
Steve Holdoway <steve at greengecko.co.nz>