<font color='black' size='2' face='Arial, Helvetica, sans-serif'><font size="2"><font face="Arial, Helvetica, sans-serif">Further to Josu's mail, r</font></font>un<font color="black" face="Arial, Helvetica, sans-serif" size="2"> my edited version in my earlier post. The query below was the first query in my post that uses temporary tables (i.e. sched_temp_record) and you'll get errors about it not being found. My last query can run stand alone. The result should be a list of programs that are scheduled to be recorded next. If you put the keyword 'explain' before select it will give you the explain plan in my earlier mail.
<div> </div>
<div> <br>
</div>
<div> <br>
</div>
<div style="font-family: arial,helvetica; font-size: 10pt; color: black;">-----Original Message-----<br>
From: Josu Lazkano <josu.lazkano@gmail.com><br>
To: Discussion about MythTV <mythtv-users@mythtv.org><br>
Sent: Tue, Mar 8, 2011 3:20 pm<br>
Subject: Re: [mythtv-users] Mythtv 0.24 Acer Revo ALSA WriteAudio buffer underruns<br>
<br>
<div id="AOLMsgPart_0_e1fb3845-f18d-44ee-9e06-693728c08d9e" style="margin: 0px; font-family: Tahoma,Verdana,Arial,Sans-Serif; font-size: 12px; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
<pre style="font-size: 9pt;"><tt>Hello again, I try to execute the SQL command this way:<br>
<br>
$ mysql -u mythtv -pPASS mythconverg<br>
<br>
SELECT c.chanid, c.sourceid, p.starttime, p.endtime, p.title,<br>
p.subtitle, p.description, c.channum, c.callsign, c.name,<br>
oldrecduplicate, p.category, sched_temp_record.recpriority,<br>
sched_temp_record.dupin, recduplicate, findduplicate,<br>
sched_temp_record.type, sched_temp_record.recordid, p.starttime -<br>
INTERVAL sched_temp_record.startoffset minute AS recstartts, p.endtime<br>
+ INTERVAL sched_temp_record.endoffset minute AS recendts,<br>
p.previouslyshown, sched_temp_record.recgroup,<br>
sched_temp_record.dupmethod, c.commmethod, capturecard.cardid,<br>
cardinput.cardinputid,p.seriesid, p.programid, p.category_type,<br>
p.airdate, p.stars, p.originalairdate, sched_temp_record.inactive,<br>
sched_temp_record.parentid, (CASE sched_temp_record.type WHEN 6 THEN<br>
sched_temp_record.findid WHEN 9 THEN to_days(date_sub(p.starttime,<br>
interval time_format(sched_temp_record.findtime, '%H:%i')<br>
hour_minute)) WHEN 10 THEN floor((to_days(date_sub(p.starttime,<br>
interval time_format(sched_temp_record.findtime, '%H:%i')<br>
hour_minute)) - sched_temp_record.findday)/7) * 7 +<br>
sched_temp_record.findday WHEN 7 THEN sched_temp_record.findid ELSE 0<br>
END) , sched_temp_record.playgroup, oldrecstatus.recstatus,<br>
oldrecstatus.reactivate, p.videoprop+0, p.subtitletypes+0,<br>
p.audioprop+0, sched_temp_record.storagegroup, capturecard.hostname,<br>
recordmatch.oldrecstatus, sched_temp_record.avg_delay,<br>
c.recp0.24.0+fixes.20110206.1a69c92riority + cardinput.recpriority +<br>
(cardinput.cardinputid = sched_temp_record.prefinput) * 2 AS<br>
powerpriority FROM recordmatch INNER JOIN sched_temp_record ON<br>
(recordmatch.recordid = sched_temp_record.recordid) INNER JOIN program<br>
AS p ON ( recordmatch.chanid = p.chanid AND recordmatch.starttime =<br>
p.starttime AND recordmatch.manualid = p.manualid ) INNER JOIN channel<br>
AS c ON ( c.chanid = p.chanid ) INNER JOIN cardinput ON (c.sourceid =<br>
cardinput.sourceid) INNER JOIN capturecard ON (capturecard.cardid =<br>
cardinput.cardid) LEFT JOIN oldrecorded as oldrecstatus ON (<br>
oldrecstatus.station = c.callsign AND oldrecstatus.starttime =<br>
p.starttime AND oldrecstatus.title = p.title ) WHERE p.endtime >=<br>
NOW() - INTERVAL 1 DAY ORDER BY sched_temp_record.recordid DESC;<br>
<br>
But I have no any output and there is no buffer stop on the frontend,<br>
how can I test it?<br>
<br>
Sorry for my stupid questions, but I want to test to help fixing this<br>
problem. I have FE/BE on a Nvidia ION 330 board.<br>
<br>
Kind regards.<br>
<br>
-- <br>
Josu Lazkano<br>
_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
<a href="http://www.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://www.mythtv.org/mailman/listinfo/mythtv-users</a><br>
</tt></pre>
</div>
<!-- end of AOLMsgPart_0_e1fb3845-f18d-44ee-9e06-693728c08d9e -->
</div>
</font></font>