[mythtv-users] cut points not saved

Fedor Pikus fpikus at gmail.com
Tue Jan 16 03:43:29 UTC 2007


On 1/5/07, john doe <viperman789 at hotmail.com> wrote:
> I found the problem and the solution.  The table "recorded" had "cutlist" as
> a "tinyint(1)".  In 0.19, it is supposed to be "text".  I did a dump to

Thanks! I was just looking for solution to this very same problem, and
I saw your post. I changed the field type in webmin without the
dump/restore (ran mysqlcheck, it was happy) and now cut points are
saved again!

> backup the database to a file, then edited the file to change "`cutlist`
> tinyint(1) NOT NULL default '0'" to "`cutlist` text default NULL" in the
> recoreded table.  I then droped the database, recreated it, and filled it
> with my edited backup file.  I can now insert cut points.  I don't know how
> my database got screwed up in the first place, but now it is fixed!
>
>
> >From: "Michael T. Dean" <mtdean at thirdcontact.com>
> >Reply-To: Discussion about mythtv <mythtv-users at mythtv.org>
> >To: Discussion about mythtv <mythtv-users at mythtv.org>
> >Subject: Re: [mythtv-users] cut points not saved
> >Date: Wed, 03 Jan 2007 13:36:58 -0500
> >
> >On 01/02/2007 01:02 PM, john doe wrote:
> > > Thanks for the suggestion, I tried that earlier, using the steps from:
> > > http://www.mythtv.org/docs/mythtv-HOWTO-23.html#ss23.7
> > >
> >
> >http://www.gossamer-threads.com/lists/mythtv/users/231664#231664
> >
> > > It gives me an error:  "ERROR 1054 (42S22) at line 1: Unknown column
> > > 'prefinput' in 'field list'".  Removing record table gets rid of that
> >error,
> > > but another appears.  Removing recorded gets rid of all errors, but then
> >I
> > > am not much better off.
> >
> >http://www.gossamer-threads.com/lists/mythtv/users/240029#240029
> >http://www.gossamer-threads.com/lists/mythtv/users/243909#243909
> >http://www.gossamer-threads.com/lists/mythtv/users/223625#223625
> >http://www.gossamer-threads.com/lists/mythtv/users/223928#223928
> >
> >Mike
> >_______________________________________________
> >mythtv-users mailing list
> >mythtv-users at mythtv.org
> >http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>


-- 
Fedor G Pikus (fpikus at gmail.com)
http://www.pikus.net
http://wild-light.com


More information about the mythtv-users mailing list