<div dir="ltr">I'm running Myth 0.26 on Ubuntu 12.04. Over the years the migrations appear to have taken their toll on the database. So even though everything seems to be working well, mythweb gags when I select "Recorded Programs", saying:<br>
<br><div>Fatal Error !!NoTrans: SQL Error: Unknown column 'recordedmarkup.data' in 'field list' [#1054]!!<br><br>with the backtrace shown below. I'm looking for some advice on how to clean that up. The MythWeb "Repair Tables" function doesn't seem to do it.</div>
<div><br></div><div>Cheers,</div><div>Fred<br><br><div style>backtrace:</div><div><br></div><div><div> datetime: 2013-04-19 17:14:27 (PDT)</div><div> errornum: 256</div><div> error type: User Error</div><div>error string: !!NoTrans: SQL Error: Unknown column 'recordedmarkup.data' in 'field list' [#1054]!!</div>
<div> filename: /usr/share/mythtv/mythweb/classes/Database/Query/mysql.php</div><div> error line: 79</div><div><br></div><div>==========================================================================</div><div><br>
</div><div>Backtrace: </div><div><br></div><div> file: /usr/share/mythtv/mythweb/classes/Database/Query/mysql.php</div><div> line: 79</div><div> class: </div><div>function: trigger_error</div><div> type: </div>
<div> args: Array</div><div>(</div><div> [0] => SQL Error: Unknown column 'recordedmarkup.data' in 'field list' [#1054]</div><div> [1] => 256</div><div>)</div><div><br></div><div> file: /usr/share/mythtv/mythweb/classes/Database.php</div>
<div> line: 261</div><div> class: Database_Query_mysql</div><div>function: execute</div><div> type: -></div><div> args: Array</div><div>(</div><div> [0] => Array</div><div> (</div><div> [0] => 4709</div>
<div> [1] => 1366408800</div><div> )</div><div><br></div><div>)</div><div><br></div><div> file: /usr/share/mythtv/mythweb/modules/tv/classes/Program.php</div><div> line: 810</div><div> class: Database</div>
<div>function: query</div><div> type: -></div><div> args: Array</div><div>(</div><div> [0] => SELECT recordedmarkup.type,</div><div> recordedmarkup.data</div><div> FROM recordedmarkup</div>
<div> WHERE recordedmarkup.chanid = ?</div><div> AND recordedmarkup.starttime = FROM_UNIXTIME(?)</div><div> AND recordedmarkup.type IN (10, 11, 12, 13, 14)</div>
<div> GROUP BY recordedmarkup.type</div><div> ORDER BY SUM((SELECT IFNULL(rm.mark, recordedmarkup.mark)</div><div> FROM recordedmarkup AS rm</div>
<div> WHERE rm.chanid = recordedmarkup.chanid</div><div> AND rm.starttime = recordedmarkup.starttime</div><div> AND rm.type IN (10, 11, 12, 13, 14)</div>
<div> AND rm.mark > recordedmarkup.mark</div><div> ORDER BY rm.mark ASC LIMIT 1)- recordedmarkup.mark) DESC</div><div> LIMIT 1</div>
<div> [1] => 4709</div><div> [2] => 1366408800</div><div>)</div><div><br></div><div> file: /usr/share/mythtv/mythweb/modules/tv/tmpl/default/recorded.php</div><div> line: 144</div><div> class: Program</div>
<div>function: getAspect</div><div> type: -></div><div> args: Array ( )</div><div> file: /usr/share/mythtv/mythweb/modules/tv/recorded.php</div><div> line: 193</div><div> class: </div><div>function: require_once</div>
<div> type: </div><div> args: Array</div><div>(</div><div> [0] => /usr/share/mythtv/mythweb/modules/tv/tmpl/default/recorded.php</div><div>)</div><div><br></div><div> file: /usr/share/mythtv/mythweb/modules/tv/handler.php</div>
<div> line: 82</div><div> class: </div><div>function: require_once</div><div> type: </div><div> args: Array</div><div>(</div><div> [0] => /usr/share/mythtv/mythweb/modules/tv/recorded.php</div><div>
)</div>
<div><br></div><div> file: /usr/share/mythtv/mythweb/mythweb.php</div><div> line: 35</div><div> class: </div><div>function: require_once</div><div> type: </div><div> args: Array</div><div>(</div><div>
[0] => /usr/share/mythtv/mythweb/modules/tv/handler.php</div>
</div></div></div>