<div dir="ltr"><div class="gmail_quote">On Fri, Sep 12, 2008 at 11:31 PM, Nick Morrott <span dir="ltr"><<a href="mailto:knowledgejunkie@gmail.com">knowledgejunkie@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div>
<div></div>
<div class="Wj3C7c">On 11/09/2008, Mark Boyum <<a href="mailto:circushair@gmail.com">circushair@gmail.com</a>> wrote:<br>><br>> Hello MythTVers,<br>><br>> I don't really want to go into the details of how I ended up in this<br>
> situation, but I've messed up my netflix table in mythconverg. At this<br>> point I've now got an old table from my .20 database running in my .21<br>> system.<br>><br>> I've deduced this from having restored the table from an old DB, only to<br>
> realize my backup was very old. And based on Internet postings for errors<br>> similar to mine.<br>><br>> mysql> insert into mythconverg.netflix values ('Queue','NetFlix',<br>> '[MYQUEUERSSFEED]','<a href="http://cdn.nflximg.com/us/icons/nficon.ico" target="_blank">http://cdn.nflximg.com/us/icons/nficon.ico</a>',<br>
> null, 1, '');<br>> ERROR 1136 (21S01): Column count doesn't match value count at row 1<br>><br>> Is there anyway to force Myth to upgrade this table back to the correct<br>> version? I have tried optimize_mythdb.pl to no avail.<br>
><br>> Just in case you are wondering, yes I have learned my lesson and will backup<br>> the DB before future tinkering.<br><br></div></div>You are probably missing the 'queue' field in the netflix table<br>
(<a href="http://cvs.mythtv.org/trac/browser/branches/release-0-21-fixes/mythplugins/mythflix/mythflix/dbcheck.cpp" target="_blank">http://cvs.mythtv.org/trac/browser/branches/release-0-21-fixes/mythplugins/mythflix/mythflix/dbcheck.cpp</a>),<br>
see you have 6 fields and are trying to insert 7 values.<br><br>To update an old netflix table to the current version, you can try the<br>following at the mysql command prompt (with mythconverg DB selected):<br><br>mysql> ALTER TABLE netflix ADD queue VARCHAR(32) NOT NULL DEFAULT '';<br>
mysql> ALTER TABLE netflix DROP PRIMARY KEY, ADD PRIMARY KEY (name, queue);<br><br>Take another backup before you do this, in case something goes wrong.<br>Then retry the insert statements.<br><br>--<br>Nick Morrott<br>
<br>MythTV Official wiki:<br><a href="http://mythtv.org/wiki/" target="_blank">http://mythtv.org/wiki/</a><br>MythTV users list archive:<br><a href="http://www.gossamer-threads.com/lists/mythtv/users" target="_blank">http://www.gossamer-threads.com/lists/mythtv/users</a><br>
<br>"An investment in knowledge always pays the best interest." - Benjamin Franklin<br>_______________________________________________<br>mythtv-users mailing list<br><a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
<a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users" target="_blank">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br></blockquote></div>
<div><br>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.</div>
<div> </div>
<div>Thanks again.</div>
<div>-Mark</div></div>