[mythtv-users] mythconverg.netflix table problem

[Mark Boyum]

On Fri, Sep 12, 2008 at 11:31 PM, Nick Morrott <knowledgejunkie at gmail.com>wrote:

>  On 11/09/2008, Mark Boyum <circushair at gmail.com> wrote:
> >
> > 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.
>
> You are probably missing the 'queue' field in the netflix table
> (
> http://cvs.mythtv.org/trac/browser/branches/release-0-21-fixes/mythplugins/mythflix/mythflix/dbcheck.cpp
> ),
> see you have 6 fields and are trying to insert 7 values.
>
> To update an old netflix table to the current version, you can try the
> following at the mysql command prompt (with mythconverg DB selected):
>
> mysql> ALTER TABLE netflix ADD queue VARCHAR(32) NOT NULL DEFAULT '';
> mysql> ALTER TABLE netflix DROP PRIMARY KEY, ADD PRIMARY KEY (name, queue);
>
> Take another backup before you do this, in case something goes wrong.
> Then retry the insert statements.
>
> --
> Nick Morrott
>
> MythTV Official wiki:
> http://mythtv.org/wiki/
> MythTV users list archive:
> http://www.gossamer-threads.com/lists/mythtv/users
>
> "An investment in knowledge always pays the best interest." - Benjamin
> Franklin
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>

Thank you Nick!  I have been away from my Myth box and was just able to try
that now.  It did the trick and now mythflix is working.

Thanks again.
-Mark
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20080917/7d022d18/attachment-0001.htm