Sarvin,<br><br>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 :-)
<br><br>I did something like this:<br><br>to dump the database:<br>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)<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 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)
<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 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 line)<br>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);
<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 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 was already logged in to the database.<br><br>Hope this helps,<br><br>Todd<br><br><div><span class="gmail_quote">On 1/23/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 7:49 PM, Todd French wrote:
<br>> Turned out it was just missing the field tc_param. I created the<br>> field as a varchar(128) default NULL, a complete guess as to those<br>> values, but it looks like it's just a field for extra paramaters
<br>> for the transcoder. Just started ripping again, seems to be<br>> working fine again. If anybody knows the correct values for that<br>> field let me know.<br>><br>> Todd<br>><br>><br><br>I'm a complete idiot when it comes to SQL. Any chance I can get the
<br>actual commands you used?<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>