[mythtv-users] mythconverg.netflix table problem

Mark Boyum circushair at gmail.com
Thu Sep 11 06:47:31 UTC 2008


Hello MythTVers,

I don't really want to go into the details of how I ended up in this
situation, but I've messed up my netflix table in mythconverg.  At this
point I've now got an old table from my .20 database running in my .21
system.

I've deduced this from having restored the table from an old DB, only to
realize my backup was very old.  And based on Internet postings for errors
similar to mine.

mysql> insert into mythconverg.netflix values ('Queue','NetFlix',
'[MYQUEUERSSFEED]','http://cdn.nflximg.com/us/icons/nficon.ico', null, 1,
'');
ERROR 1136 (21S01): Column count doesn't match value count at row 1
Is there anyway to force Myth to upgrade this table back to the correct
version?  I have tried optimize_mythdb.pl to no avail.

Just in case you are wondering, yes I have learned my lesson and will backup
the DB before future tinkering.
-Mark
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20080911/fe688e88/attachment.htm 


More information about the mythtv-users mailing list