[mythtv-users] Mythflix problem with mythconverg.netflix table

Mark Boyum mark at boyum.us
Thu Sep 11 15:07:04 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
-------------------------------------------------
A bit more information on my setup.  I am running Ubuntu 8.04 with the
Mythbuntu package installed ontop of it.  The system status screen reports
"Myth version: 0.21.20080304-1 16838".

I've also tried removing mythflix and re-installing, but that doesn't seem
to do it either.  I have also tried removing the table, but mythflix does
not recreate it as it did on its first run.  Is there someway to force
mythflix to recreate it?

-Mark
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20080911/c94775ca/attachment.htm 


More information about the mythtv-users mailing list