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

[Todd French]

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

On 1/23/07, sarvin <sarvinc at fastmail.fm> wrote:
>
>
> On Jan 23, 2007, at 7:49 PM, Todd French wrote:
> > Turned out it was just missing the field tc_param.  I created the
> > field as a varchar(128) default NULL, a complete guess as to those
> > values, but it looks like it's just a field for extra paramaters
> > for the transcoder.  Just started ripping again, seems to be
> > working fine again.  If anybody knows the correct values for that
> > field let me know.
> >
> > Todd
> >
> >
>
> I'm a complete idiot when it comes to SQL. Any chance I can get the
> actual commands you used?
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20070123/72eb2657/attachment.htm