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