[mythtv-users] Are these SQL errors something to worry about?

[Jeffrey J. Kosowsky]

I seem to get the following types of errors when watching LiveTV or
recording shows:

2010-01-12 04:55:39.561 DB Error (aspect ratio change insert):
Query was:
INSERT INTO recordedmarkup (chanid, starttime, mark, type, data) VALUES ( ?, ?, ?, ?, ?);
Bindings were:
:CHANID=2071, :DATA=0, :MARK=15, :STARTTIME=2010-01-12T04:55:38, :TYPE=12
No error type from QSqlError?  Strange...
2010-01-12 04:55:39.595 Error preparing query: INSERT INTO recordedmarkup    (chanid, starttime, mark, type, data)    VALUES ( :CHANID, :STARTTIME, :MARK, :TYPE, :DATA);
2010-01-12 04:55:39.619 Driver error was [2/1054]:
QMYSQL3: Unable to prepare statement
Database error was:
Unknown column 'data' in 'field list'

Originally, I feared that maybe they were caused by my recent editing
of the sql database to copy over frontend profiles or maybe due to
incompatibilities between revisions on my Linux vs. Windows
frontends. But looking back in my logs, the error *precede* either of
those situations.

But they *all* seem to have occurred since upgrading from 0.21 to
0.22. It makes me wonder whether the database was updated properly.

Looking back, I may have done the following:
- Sourced in new blank database:
    	mysql -u root -p < /usr/share/doc/mythtv-docs-0.22/database/mc.sql
- Ran mythtv-setup and mythfrontend on that blank database to
  customize my setup
- Sourced in my program data tables (record, recorded, oldrecorded,
  recordedprogram, recordedrating, recordedmarkup, recordedseek) from
  my latest dump of the old Version 0.21
  	    mysql -u mythtv -pmythtv mythconverg < myth-0.21-programdata.sql

Having learned a little sql over the past few days, I now realize that
the program-related tables may not have been compatible and that
sourcing the old dump first erased the 0.22 version of the program
data tables and then replaced it with the 0.21 version of the tables.

- Is this likely to be the source of my problems?
- Whether or not that was the source of the problem, what can I do to
  fix things now?
- Will this lead to corruption, data loss, or issues down the road?
- Are there any other changed/added/deleted fields in the above tables
  in moving from 0.21 to 0.22 that I need to fix?

-------------------------------------------------------------------------
Here are some more of the errors...

2010-01-12 04:55:39.354 Error preparing query: INSERT INTO recordedmarkup (chanid, starttime, mark, type, data) VALUES ( :CHANID, :STARTTIME, :MARK, :TYPE, :DATA);
2010-01-12 04:55:39.535 Driver error was [2/1054]:
QMYSQL3: Unable to prepare statement
Database error was:
Unknown column 'data' in 'field list'

2010-01-12 04:55:39.561 DB Error (aspect ratio change insert):
Query was:
INSERT INTO recordedmarkup (chanid, starttime, mark, type, data) VALUES ( ?, ?, ?, ?, ?);
Bindings were:
:CHANID=2071, :DATA=0, :MARK=15, :STARTTIME=2010-01-12T04:55:38, :TYPE=12
No error type from QSqlError?  Strange...
2010-01-12 04:55:39.595 Error preparing query: INSERT INTO recordedmarkup    (chanid, starttime, mark, type, data)    VALUES ( :CHANID, :STARTTIME, :MARK, :TYPE, :DATA);
2010-01-12 04:55:39.619 Driver error was [2/1054]:
QMYSQL3: Unable to prepare statement
Database error was:
Unknown column 'data' in 'field list'

2010-01-12 04:55:39.644 DB Error (Resolution insert):
Query was:
INSERT INTO recordedmarkup    (chanid, starttime, mark, type, data)    VALUES ( ?, ?, ?, ?, ?);
Bindings were:
:CHANID=2071, :DATA=1920, :MARK=15, :STARTTIME=2010-01-12T04:55:38, :TYPE=30
No error type from QSqlError?  Strange...
2010-01-12 04:55:39.686 Error preparing query: INSERT INTO recordedmarkup    (chanid, starttime, mark, type, data)    VALUES ( :CHANID, :STARTTIME, :MARK, :TYPE, :DATA);
2010-01-12 04:55:39.712 Driver error was [2/1054]:
QMYSQL3: Unable to prepare statement
Database error was:
Unknown column 'data' in 'field list'

2010-01-12 04:55:39.737 DB Error (Resolution insert):
Query was:
INSERT INTO recordedmarkup    (chanid, starttime, mark, type, data)    VALUES ( ?, ?, ?, ?, ?);
Bindings were:
:CHANID=2071, :DATA=1080, :MARK=15, :STARTTIME=2010-01-12T04:55:38, :TYPE=31
No error type from QSqlError?  Strange...
2010-01-12 04:55:41.850 RecBase(1:/dev/dvb/adapter0/frontend0): GetKeyframePositions(75,9223372036854775807,#1) out of 6
2010-01-12 04:55:41.893 RecBase(1:/dev/dvb/adapter0/frontend0): GetKeyframePositions(75,9223372036854775807,#1) out of 6
2010-01-12 04:55:51.198 TVRec(1): Changing from Watching WatchingLiveTV to None
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;
2010-01-12 04:55:51.458 Driver error was [2/1054]:
QMYSQL3: Unable to prepare statement
Database error was:
Unknown column 'recordedmarkup.DATA' in 'field list'

2010-01-12 04:55:51.484 Unknown type, recording width was 0
2010-01-12 04:55:52.013 Finished recording Early Today: channel 2071