[mythtv-users] mtd dvd rips failing after .20 upgrade, solution

Todd French toddfrench1 at gmail.com
Thu Jan 25 07:36:16 UTC 2007


Sarvin,

Looks different than what I was seeing.

Todd

On 1/24/07, sarvin <sarvinc at fastmail.fm> wrote:
>
>
> On Jan 23, 2007, at 8:25 PM, Todd French wrote:
>
> > Sarvin,
> >
> > I'm no SQL guy either, in fact it took me a while messing around
> > with things to figure this out and how to fix it.  There probably
> > is a better way to do this than I did, but so far it's working. I'm
> > sure there must be a way to just add a field to the table with
> > deleting and recreating, but I knew how to do that so I didn't
> > bother to find it.  So you're milage may vary, be careful as if you
> > hose your database you've hosed your setup, I would only do this if
> > you're getting exactly the same error, or if you know what you're
> > doing.  Basically I used a dump of the database that I had made,
> > found the relevant section, added the field as needed, and put back
> > into mysql.  Out of curiousity are you having the same exact
> > problem?  I searched around and couldn't find anything about it.  I
> > was almost ready to post on the list and ask for help, but decided
> > it would be more fun to mess with stuff I didn't understand :-)
> >
> > I did something like this:
> >
> > to dump the database:
> > mysqldump -p mythconverg > backup.sql   ( you need to provide a
> > password, should be mythtv or something like that, mine was same as
> > my root password)
> >
> > to find the right section and put it into a file
> > cat backup.sql | grep -B 10 -A 30 dvdtranscode > transcode.sql
> >
> > The above command gives you a bit before and after the seach term
> > so you have to trim off the I then hand edited the file to add the
> > tc_param field, and add NULL data in to fill the fields ( this will
> > all be in the sql commands below)
> >
> > then log in to the database
> >
> > mysql -p mythconverg
> >
> > once you're logged in, I basically cut and pasted in my modified
> > commands:
> >
> > DROP TABLE IF EXISTS `dvdtranscode`;
> >
> > CREATE TABLE `dvdtranscode` (
> >   `intid` int(11) NOT NULL auto_increment,
> >   `input` int(10) unsigned default NULL,
> >   `name` varchar(128) NOT NULL,
> >   `sync_mode` int(10) unsigned default NULL,
> >   `use_yv12` tinyint(1) default NULL,
> >   `cliptop` int(11) default NULL,
> >   `clipbottom` int(11) default NULL,
> >   `clipleft` int(11) default NULL,
> >   `clipright` int(11) default NULL,
> >   `f_resize_h` int(11) default NULL,
> >   `f_resize_w` int(11) default NULL,
> >   `hq_resize_h` int(11) default NULL,
> >   `hq_resize_w` int(11) default NULL,
> >   `grow_h` int(11) default NULL,
> >   `grow_w` int(11) default NULL,
> >   `clip2top` int(11) default NULL,
> >   `clip2bottom` int(11) default NULL,
> >   `clip2left` int(11) default NULL,
> >   `clip2right` int(11) default NULL,
> >   `codec` varchar(128) NOT NULL,
> >   `codec_param` varchar(128) default NULL,
> >   `bitrate` int(11) default NULL,
> >   `a_sample_r` int(11) default NULL,
> >   `a_bitrate` int(11) default NULL,
> >   `two_pass` tinyint(1) default NULL,
> >   `tc_param` varchar(128) default NULL,
> >   PRIMARY KEY  (`intid`)
> > ) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
> >
> > LOCK TABLES `dvdtranscode` WRITE;
> >
> > /*!40000 ALTER TABLE `dvdtranscode` DISABLE KEYS */;
> >
> > (I don't know how the below will wrap, but it is actually all one
> > line)
> > INSERT INTO `dvdtranscode` VALUES (1,1,'Good',
> > 2,1,16,16,0,0,2,0,0,0,0,0,32,32,8,8,'divx5',NULL,1618,NULL,NULL,
> > 0,NULL),(2,2,'Excellent',
> > 2,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'divx5',NULL,0,NULL,NULL,1,NULL),
> > (3,2,'Good',2,1,0,0,8,8,0,0,0,0,0,0,0,0,0,0,'divx5',NULL,
> > 1618,NULL,NULL,0,NULL),(4,2,'Medium',
> > 2,1,0,0,8,8,5,5,0,0,0,0,0,0,0,0,'divx5',NULL,1200,NULL,NULL,0,NULL),
> > (5,3,'Good',2,1,0,0,0,0,0,0,0,0,2,0,80,80,8,8,'divx5',NULL,
> > 0,NULL,NULL,0,NULL),(6,4,'Excellent',
> > 2,1,0,0,0,0,0,0,0,0,2,0,0,0,0,0,'divx5',NULL,0,NULL,NULL,1,NULL),
> > (7,4,'Good',2,1,0,0,8,8,0,2,0,0,0,0,0,0,0,0,'divx5',NULL,
> > 1618,NULL,NULL,0,NULL),(8,5,'Good',
> > 1,1,16,16,0,0,5,0,0,0,0,0,40,40,8,8,'divx5',NULL,1618,NULL,NULL,
> > 0,NULL),(9,6,'Good',1,1,0,0,16,16,5,0,0,0,0,0,0,0,0,0,'divx5',NULL,
> > 1618,NULL,NULL,0,NULL),(10,7,'Good',
> > 1,1,0,0,0,0,1,0,0,0,0,0,76,76,8,8,'divx5',NULL,1618,NULL,NULL,
> > 0,NULL),(11,8,'Good',1,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,'divx5',NULL,
> > 1618,NULL,NULL,0,NULL);
> >
> > /*!40000 ALTER TABLE `dvdtranscode` ENABLE KEYS */;
> >
> > UNLOCK TABLES;
> >
> > If you have your file transcode.sql or whatever edited all clean I
> > think you can also do a mysql -p mythconverg < transcode.sql
> > I wanted to do it manually so I could see any error output, and  I
> > was already logged in to the database.
> >
> > Hope this helps,
> >
> > Todd
> >
>
> This is a lot of help.
>
> I don't know if we're having the same problem. Mine was posted here:
> "http://www.gossamer-threads.com/lists/mythtv/users/245872?
> search_string=not%20able%20to%20rip%20DVDs;#245872"
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20070124/989b467e/attachment.htm 


More information about the mythtv-users mailing list