<p>Are you sure your database properly upgraded when you went from 0.24 to 0.25?</p>
<div class="gmail_quote">On Sep 21, 2012 12:18 PM, &quot;Fred Hamilton&quot; &lt;<a href="mailto:fred@yonkitime.com">fred@yonkitime.com</a>&gt; wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Can anyone help me understand these database errors?  This is the<br>
Mythfrontend output when I try to watch a TV show via my HD-PVR (ATSC<br>
tuner works fine).<br>
<br>
Database error was: Unknown column &#39;recordedmarkup.data&#39; in &#39;field list&#39;<br>
<br>
Database error was: You have an error in your SQL syntax; check the<br>
manual that corresponds to your MySQL server version for the right<br>
syntax to use near &#39;:CHANID AND recordedmarkup.starttime = :STARTTIME<br>
AND recordedmar&#39; at line 1<br>
<br>
I recently upgraded from 10.10 / 0.24 to 12.04 / 0.25.  Everything<br>
worked fine under 10.10 / 0.24.<br>
<br>
Cheers,<br>
Fred<br>
<br>
Full output below:<br>
<br>
2012-09-17 22:53:42.204473 E  Error preparing query: SELECT<br>
recordedmarkup.data FROM recordedmarkup WHERE recordedmarkup.chanid<br>
= :CHANID    AND       recordedmarkup.starttime = :STARTTIME AND<br>
recordedmarkup.type      = 33 GROUP BY recordedmarkup.data ORDER BY<br>
SUM( ( SELECT IFNULL(rm.mark, recordedmarkup.mark)                FROM<br>
recordedmarkup AS rm                 WHERE rm.chanid    =<br>
recordedmarkup.chanid    AND                       rm.starttime =<br>
recordedmarkup.starttime AND                       rm.type      =<br>
recordedmarkup.type      AND                       rm.mark      &gt;<br>
recordedmarkup.mark                 ORDER BY rm.mark ASC LIMIT 1<br>
        ) - recordedmarkup.mark             ) DESC LIMIT 1<br>
2012-09-17 22:53:42.204487 E  Driver error was [2/1054]:<br>
QMYSQL3: Unable to prepare statement<br>
Database error was:<br>
Unknown column &#39;recordedmarkup.data&#39; in &#39;field list&#39;<br>
<br>
2012-09-17 22:53:42.204662 E  DB Error (load_markup_datum):<br>
Query was:<br>
SELECT recordedmarkup.data FROM recordedmarkup WHERE<br>
recordedmarkup.chanid    = :CHANID    AND<br>
recordedmarkup.starttime = :STARTTIME AND       recordedmarkup.type<br>
  = 33 GROUP BY recordedmarkup.data ORDER BY SUM( ( SELECT<br>
IFNULL(rm.mark, recordedmarkup.mark)                FROM<br>
recordedmarkup AS rm                 WHERE rm.chanid    =<br>
recordedmarkup.chanid    AND                       rm.starttime =<br>
recordedmarkup.starttime AND                       rm.type      =<br>
recordedmarkup.type      AND                       rm.mark      &gt;<br>
recordedmarkup.mark                 ORDER BY rm.mark ASC LIMIT 1<br>
        ) - recordedmarkup.mark             ) DESC LIMIT 1<br>
Bindings were:<br>
:CHANID=1221, :STARTTIME=2012-09-17T22:53:39<br>
Driver error was [2/1064]:<br>
QMYSQL: Unable to execute query<br>
Database error was:<br>
You have an error in your SQL syntax; check the manual that<br>
corresponds to your MySQL server version for the right syntax to use<br>
near &#39;:CHANID    AND       recordedmarkup.starttime = :STARTTIME AND<br>
    recordedmar&#39; at line 1<br>
<br>
2012-09-17 22:53:42.204834 E  Error preparing query: SELECT<br>
recordedmarkup.data FROM recordedmarkup WHERE recordedmarkup.chanid<br>
= :CHANID    AND       recordedmarkup.starttime = :STARTTIME AND<br>
recordedmarkup.type      = 34 GROUP BY recordedmarkup.data ORDER BY<br>
SUM( ( SELECT IFNULL(rm.mark, recordedmarkup.mark)                FROM<br>
recordedmarkup AS rm                 WHERE rm.chanid    =<br>
recordedmarkup.chanid    AND                       rm.starttime =<br>
recordedmarkup.starttime AND                       rm.type      =<br>
recordedmarkup.type      AND                       rm.mark      &gt;<br>
recordedmarkup.mark                 ORDER BY rm.mark ASC LIMIT 1<br>
        ) - recordedmarkup.mark             ) DESC LIMIT 1<br>
2012-09-17 22:53:42.204843 E  Driver error was [2/1054]:<br>
QMYSQL3: Unable to prepare statement<br>
Database error was:<br>
Unknown column &#39;recordedmarkup.data&#39; in &#39;field list&#39;<br>
<br>
2012-09-17 22:53:42.204965 E  DB Error (load_markup_datum):<br>
Query was:<br>
SELECT recordedmarkup.data FROM recordedmarkup WHERE<br>
recordedmarkup.chanid    = :CHANID    AND<br>
recordedmarkup.starttime = :STARTTIME AND       recordedmarkup.type<br>
  = 34 GROUP BY recordedmarkup.data ORDER BY SUM( ( SELECT<br>
IFNULL(rm.mark, recordedmarkup.mark)                FROM<br>
recordedmarkup AS rm                 WHERE rm.chanid    =<br>
recordedmarkup.chanid    AND                       rm.starttime =<br>
recordedmarkup.starttime AND                       rm.type      =<br>
recordedmarkup.type      AND                       rm.mark      &gt;<br>
recordedmarkup.mark                 ORDER BY rm.mark ASC LIMIT 1<br>
        ) - recordedmarkup.mark             ) DESC LIMIT 1<br>
Bindings were:<br>
:CHANID=1221, :STARTTIME=2012-09-17T22:53:39<br>
Driver error was [2/1064]:<br>
QMYSQL: Unable to execute query<br>
Database error was:<br>
You have an error in your SQL syntax; check the manual that<br>
corresponds to your MySQL server version for the right syntax to use<br>
near &#39;:CHANID    AND       recordedmarkup.starttime = :STARTTIME AND<br>
    recordedmar&#39; at line 1<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>
</blockquote></div>