[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