<br><br>
<div class="gmail_quote">On Tue, Jan 12, 2010 at 5:24 AM, Jeffrey J. Kosowsky <span dir="ltr"><<a href="mailto:mythtv@kosowsky.org">mythtv@kosowsky.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">I seem to get the following types of errors when watching LiveTV or<br>recording shows:<br><br>2010-01-12 04:55:39.561 DB Error (aspect ratio change insert):<br>
Query was:<br>INSERT INTO recordedmarkup (chanid, starttime, mark, type, data) VALUES ( ?, ?, ?, ?, ?);<br>Bindings were:<br>:CHANID=2071, :DATA=0, :MARK=15, :STARTTIME=2010-01-12T04:55:38, :TYPE=12<br>No error type from QSqlError? Strange...<br>
2010-01-12 04:55:39.595 Error preparing query: INSERT INTO recordedmarkup (chanid, starttime, mark, type, data) VALUES ( :CHANID, :STARTTIME, :MARK, :TYPE, :DATA);<br>2010-01-12 04:55:39.619 Driver error was [2/1054]:<br>
QMYSQL3: Unable to prepare statement<br>Database error was:<br>Unknown column 'data' in 'field list'<br><br>Originally, I feared that maybe they were caused by my recent editing<br>of the sql database to copy over frontend profiles or maybe due to<br>
incompatibilities between revisions on my Linux vs. Windows<br>frontends. But looking back in my logs, the error *precede* either of<br>those situations.<br><br>But they *all* seem to have occurred since upgrading from 0.21 to<br>
0.22. It makes me wonder whether the database was updated properly.<br><br>Looking back, I may have done the following:<br>- Sourced in new blank database:<br> mysql -u root -p < /usr/share/doc/mythtv-docs-0.22/database/mc.sql<br>
- Ran mythtv-setup and mythfrontend on that blank database to<br> customize my setup<br>- Sourced in my program data tables (record, recorded, oldrecorded,<br> recordedprogram, recordedrating, recordedmarkup, recordedseek) from<br>
my latest dump of the old Version 0.21<br> mysql -u mythtv -pmythtv mythconverg < myth-0.21-programdata.sql<br><br>Having learned a little sql over the past few days, I now realize that<br>the program-related tables may not have been compatible and that<br>
sourcing the old dump first erased the 0.22 version of the program<br>data tables and then replaced it with the 0.21 version of the tables.<br><br>- Is this likely to be the source of my problems?<br>- Whether or not that was the source of the problem, what can I do to<br>
fix things now?<br>- Will this lead to corruption, data loss, or issues down the road?<br>- Are there any other changed/added/deleted fields in the above tables<br> in moving from 0.21 to 0.22 that I need to fix?<br><br>
-------------------------------------------------------------------------<br>Here are some more of the errors...<br><br>2010-01-12 04:55:39.354 Error preparing query: INSERT INTO recordedmarkup (chanid, starttime, mark, type, data) VALUES ( :CHANID, :STARTTIME, :MARK, :TYPE, :DATA);<br>
2010-01-12 04:55:39.535 Driver error was [2/1054]:<br>QMYSQL3: Unable to prepare statement<br>Database error was:<br>Unknown column 'data' in 'field list'<br><br>2010-01-12 04:55:39.561 DB Error (aspect ratio change insert):<br>
Query was:<br>INSERT INTO recordedmarkup (chanid, starttime, mark, type, data) VALUES ( ?, ?, ?, ?, ?);<br>Bindings were:<br>:CHANID=2071, :DATA=0, :MARK=15, :STARTTIME=2010-01-12T04:55:38, :TYPE=12<br>No error type from QSqlError? Strange...<br>
2010-01-12 04:55:39.595 Error preparing query: INSERT INTO recordedmarkup (chanid, starttime, mark, type, data) VALUES ( :CHANID, :STARTTIME, :MARK, :TYPE, :DATA);<br>2010-01-12 04:55:39.619 Driver error was [2/1054]:<br>
QMYSQL3: Unable to prepare statement<br>Database error was:<br>Unknown column 'data' in 'field list'<br><br>2010-01-12 04:55:39.644 DB Error (Resolution insert):<br>Query was:<br>INSERT INTO recordedmarkup (chanid, starttime, mark, type, data) VALUES ( ?, ?, ?, ?, ?);<br>
Bindings were:<br>:CHANID=2071, :DATA=1920, :MARK=15, :STARTTIME=2010-01-12T04:55:38, :TYPE=30<br>No error type from QSqlError? Strange...<br>2010-01-12 04:55:39.686 Error preparing query: INSERT INTO recordedmarkup (chanid, starttime, mark, type, data) VALUES ( :CHANID, :STARTTIME, :MARK, :TYPE, :DATA);<br>
2010-01-12 04:55:39.712 Driver error was [2/1054]:<br>QMYSQL3: Unable to prepare statement<br>Database error was:<br>Unknown column 'data' in 'field list'<br><br>2010-01-12 04:55:39.737 DB Error (Resolution insert):<br>
Query was:<br>INSERT INTO recordedmarkup (chanid, starttime, mark, type, data) VALUES ( ?, ?, ?, ?, ?);<br>Bindings were:<br>:CHANID=2071, :DATA=1080, :MARK=15, :STARTTIME=2010-01-12T04:55:38, :TYPE=31<br>No error type from QSqlError? Strange...<br>
2010-01-12 04:55:41.850 RecBase(1:/dev/dvb/adapter0/frontend0): GetKeyframePositions(75,9223372036854775807,#1) out of 6<br>2010-01-12 04:55:41.893 RecBase(1:/dev/dvb/adapter0/frontend0): GetKeyframePositions(75,9223372036854775807,#1) out of 6<br>
2010-01-12 04:55:51.198 TVRec(1): Changing from Watching WatchingLiveTV to None<br>2010-01-12 04:55:51.426 Error preparing query: SELECT recordedmarkup.DATA FROM recordedmarkup WHERE recordedmarkup.chanid = :CHANID AND recordedmarkup.starttime = :STARTTIME AND recordedmarkup.type = 30 GROUP BY recordedmarkup.data ORDER BY SUM((SELECT IFNULL(rm.mark, recordedmarkup.mark) FROM recordedmarkup AS rm WHERE rm.chanid = recordedmarkup.chanid AND rm.starttime = recordedmarkup.starttime AND rm.type = recordedmarkup.type AND rm.mark > recordedmarkup.mark ORDER BY rm.mark ASC LIMIT 1) - recordedmarkup.mark) DESC LIMIT 1;<br>
2010-01-12 04:55:51.458 Driver error was [2/1054]:<br>QMYSQL3: Unable to prepare statement<br>Database error was:<br>Unknown column 'recordedmarkup.DATA' in 'field list'<br><br>2010-01-12 04:55:51.484 Unknown type, recording width was 0<br>
2010-01-12 04:55:52.013 Finished recording Early Today: channel 2071<br>_______________________________________________<br>mythtv-users mailing list<br><a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
<a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users" target="_blank">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br></blockquote>
<div> </div>
<div> </div>
<div>I think I got these errors when I dumped my 0.21 database and (improperly) loaded it over a 0.22 database. But, that was back in November.</div>
<div> </div>
<div> </div>
<div>Did you try doing a proper dump/restore with the correct versions?</div></div><br>