[mythtv-users] My mythweb shows me only new, mythfrontend only old recordings :-(

[Michael T. Dean]

On 04/12/2011 03:47 PM, Christoph Paul wrote:
> With a median cut approach I managed to find a line:
> Here it is:
> INSERT INTO `recorded` (`chanid`, `starttime`, `endtime`, `title`, `subtitle`, `description`, `category`, `hostname`, `bookmark`, `editing`, `cutlist`, `autoexpire`, `commflagged`, `recgroup`, `recordid`, `seriesid`, `programid`, `lastmodified`, `filesize`, `stars`, `previouslyshown`, `originalairdate`, `preserve`, `findid`, `deletepending`, `transcoder`, `timestretch`, `recpriority`, `basename`, `progstart`, `progend`, `playgroup`, `profile`, `duplicate`, `transcoded`, `watched`, `storagegroup`, `bookmarkupdate`) VALUES(13040, '2011-04-08 20:15:00', '2011-04-08 22:00:00', 'Asterix - Operation Hinkelstein', '', 'Miraculix wird ausgerechnet von Obelix niedergeschlagen - versehentlich, versteht sich. Doch fortan kann der Druide keinen Zaubertrank mehr brauen. Was nun? Ein Betrüger namens Lügfix kommt dahinter, dass die Gallier keine Kräfte mehr haben und verrät sie an die Römer. Jetzt ist guter Rat teuer!', 'Kids', 'vmyth22', 127, 0, 0, 1, 0, 'Default', 154, '', '', '2011-04-09 13:39:17', 3524029732, 0, 0, '0000-00-00', 0, 0, 0, 0, 1, 0, '13040_20110408201500.mpg', '2011-04-08 20:15:00', '2011-04-08 22:00:00', 'Default', 'Default', 0, 0, 0, 'Default', '2011-04-09 13:39:17');
> Do you see something special?
>

You have a broken Qt, and something inserted invalid garbage into your 
recorded table /after/ you upgraded to 0.24.  The data couldn't be from 
the one period of time (during development between MythTV 0.19 and 
0.20--in unstable code between Mar 6 and Sep 2, 2006) where MythTV was 
inserting invalid data into the database, since there's a database 
update in the switch from 0.23 to 0.24 schema that will correct any 
invalid data.  So, either some program or script or ... modified your 
database data directly, or your database upgrade didn't complete 
properly and someone used manual modification of the database to ignore 
the problem, or you imported garbage from a different-schema-version 
MythTV installation or backup (which, is always extremely likely to 
cause problems) after you let MythTV upgrade your database.  TTBOMK, 
there is no place in our code that would write the invalid data you 
have, so if you can think of anything special about this recording (or 
how it got into your database), please let me know.

FWIW, Qt 4.6.3 fixed the issue.  In the meantime, you can fix your 
broken data.

mysql -umythtv -p -e "UPDATE recorded SET bookmark = 1 WHERE bookmark != 0;"

Mike