[mythtv-users] Myth Recording Extender (MRE) database query issue
John
jharitos at yahoo.com
Sun Jan 21 05:01:18 UTC 2007
I did a php --modules and it said pnctl was compiled
but for some reason this was giving me the issue. I
turned it off in the mre.conf file and just added
nohup mre.php to my rc.local. It bombed on an NCAA
game but worked on a NHL Game.
--- John <jharitos at yahoo.com> wrote:
>
> --- John <jharitos at yahoo.com> wrote:
>
> > Does your system meet all requirements listed in
> the
> > README file?
> > Sounds like you may need the PEAR DB package.
> >
> > #> pear list
> > Installed packages, channel pear.php.net:
> > =========================================
> > Package Version State
> > Archive_Tar 1.3.1 stable
> > Console_Getopt 1.2 stable
> > DB 1.7.6 stable
> > PEAR 1.4.9 stable
> >
> > If you don't have DB listed try this:
> > >>>>>>>>>>>>>>>>>>>>>>>>>
> >
> > Thanks for the help. I did a pear list and this is
> > what the output displayed.
> >
> > Installed packages, channel pear.php.net:
> > =========================================
> > Package Version State
> > Archive_Tar 1.3.1 stable
> > Console_Getopt 1.2 stable
> > DB 1.7.7 stable
> > Log 1.9.9 stable
> > PEAR 1.4.6 stable
> > XML_RPC 1.4.4 stable
> >
> > Am I missing something?
> >
> >
> >>>>>>>
>
> I ran MRE in debug mode and it gives me the
> following.
>
> SELECT * FROM recorded
> WHERE
> endtime > NOW() AND recordid <> 0 AND
> recgroup
> <> 'LiveTV' AND
> DATE_ADD(starttime, INTERVAL 15 MINUTE) >= NOW()
> [nativecode=2006 ** MySQL server has gone
> away]SELECT
> * FROM recorded
> WHERE
> endtime > NOW() AND recordid <> 0 AND
> recgroup <> 'LiveTV' AND
> DATE_ADD(NOW(), INTERVAL 30
> MINUTE)
> >= endtime [nativecode=2006 ** MySQL server has gone
> away]Sleeping for 5 minutes.
>
> I suspect the issue is the Mysql has gone away but
> I'm
> not sure how to fix it.
>
>
>
>
____________________________________________________________________________________
> Sucker-punch spam with award-winning protection.
> Try the free Yahoo! Mail Beta.
>
http://advision.webevents.yahoo.com/mailbeta/features_spam.html
>
____________________________________________________________________________________
Don't get soaked. Take a quick peak at the forecast
with the Yahoo! Search weather shortcut.
http://tools.search.yahoo.com/shortcuts/#loc_weather
More information about the mythtv-users
mailing list