[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