[mythtv-users] Myth Recording Extender (MRE) database query issue
Andrew Casper
andrew at andrewcasper.com
Sun Jan 21 06:36:02 UTC 2007
John -
On a whim, I decided to try MRE again tonight and ran into exactly
the same problem and errors you are having. Any chance you are on a
64 bit system? It's a long shot, but I've seen thing like this
because apps were not happy with 64 bit or the paths involved.
- Andrew
On Jan 21, 2007, at 12:01 AM, John wrote:
> 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
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2429 bytes
Desc: not available
Url : http://mythtv.org/pipermail/mythtv-users/attachments/20070121/65ead2a2/attachment.bin
More information about the mythtv-users
mailing list