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

sarvin sarvinc at fastmail.fm
Wed Jan 24 22:12:48 UTC 2007


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"



More information about the mythtv-users mailing list