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"