LinHES Forums
http://forums.linhes.org/

stupid myth.rebuilddatabase.pl question [solved]
http://forums.linhes.org/viewtopic.php?f=5&t=11669		 Page 1 of 1
Author:  dothedog [ Sun Sep 17, 2006 8:13 am ]
Post subject:  stupid myth.rebuilddatabase.pl question [solved]
Thanks for the replies:

I tried the --try_defaults and came up with the same thing. mythfrontend->setup says that the machine name is 'tv' btw.

manicmike, let me know when you post it. I would love to test it for you.



Rob

EDIT: I got it to work. I changed the command to this:
myth.rebuilddatabase.pl --user mythtv --pass mythtv --dir /mnt/video/TV --dbhost="localhost"
It is working now. What I have to do now is figure out how to research the program names...
Author:  tjc [ Sun Sep 17, 2006 9:30 am ]
Post subject: 
Is there anything in the pretty directory? (/myth/pretty)
Author:  dothedog [ Sun Sep 17, 2006 5:44 pm ]
Post subject: 
tjc,
I don't have a myth/pretty dir. There is a myth/nuv2disk/pretty dir however, it looks like it only has the restored files.
Author:  manicmike [ Mon Sep 18, 2006 9:42 am ]
Post subject:  Re: stupid myth.rebuilddatabase.pl question [solved]
dothedog wrote:
Thanks for the replies:

I tried the --try_defaults and came up with the same thing. mythfrontend->setup says that the machine name is 'tv' btw.

manicmike, let me know when you post it. I would love to test it for you.



Rob

EDIT: I got it to work. I changed the command to this:
myth.rebuilddatabase.pl --user mythtv --pass mythtv --dir /mnt/video/TV --dbhost="localhost"
It is working now. What I have to do now is figure out how to research the program names...


Hi Rob,

Nigel Pearson pointed out that it's already been updated. I nearly fixed it, though. Here is my patch (which is probably not a patch on the real fix, but I'll use it anyway because I made it and a bit of bloody mindedness). It doesn't quite work (inserts the wrong field order), and there's no point in fixing it now:
*** start patch***
66,67c66,67
< my $host = hostname;
< my $dbhost = $host;
---
> my $host = "localhost";
> my $dbhost = "localhost";
70a71
> my $dir = "/myth/tv";
131,133c132,133
< my ($starttime, $endtime, $title, $subtitle, $channel);
< my ($syear, $smonth, $sday, $shour, $sminute, $ssecond, $eyear, $emonth, $eday,
< $ehour, $eminute, $esecond);
---
> my ($starttime, $title, $subtitle, $channel);
> my ($syear, $smonth, $sday, $shour, $sminute, $ssecond);
156c156
< $q = "select title, subtitle, starttime, endtime, chanid from recorded order by starttime";
---
> $q = "select title, subtitle, starttime, chanid from recorded order by starttime";
166d165
< $endtime = $row[3];
175,179d173
< if ($endtime =~ m/$date_regx/) {
< ($eyear, $emonth, $eday, $ehour, $eminute, $esecond) =
< ($1, $2, $3, $4, $5, $6);
< }
<
183d176
< print "End time: $emonth/$eday/$eyear - $ehour:$eminute:$esecond\n";
190c183
< print "your database to see if the exist. If they do not, you will be prompted\n";
---
> print "your database to see if they exist. If they do not, you will be prompted\n";
193c186
< my @files = glob("$dir/*.nuv");
---
> my @files = glob("$dir/*.mpg");
197,198c190,191
< $eyear, $emonth, $eday, $ehour, $eminute, $esecond);
< my ($starttime, $endtime);
---
> );
> my ($starttime);
200c193
< if ($show =~ m/$channel_regx\_$date_regx\_$date_regx/) {
---
> if ($show =~ m/$channel_regx\_$date_regx/) {
206,208d198
< ($eyear, $emonth, $eday, $ehour, $eminute, $esecond) =
< ($8, $9, $10, $11, $12, $13);
<
210d199
< $endtime = "$eyear$emonth$eday$ehour$eminute$esecond";
216c205
< $q = "select title from recorded where chanid=(?) and starttime=(?) and endtime=(?)";
---
> $q = "select title from recorded where chanid=(?) and starttime=(?)";
218c207
< $sth->execute($channel, $starttime, $endtime)
---
> $sth->execute($channel, $starttime)
233c222
< my $guess = "select title, subtitle, description from oldrecorded where chanid=(?) and starttime=(?) and endtime=(?)";
---
> my $guess = "select title, subtitle, description from oldrecorded where chanid=(?) and starttime=(?)";
235c224
< $sth->execute($channel, $starttime, $endtime)
---
> $sth->execute($channel, $starttime)
251d239
< print "End time: $emonth/$eday/$eyear - $ehour:$eminute:$esecond\n";
277c265
< my $i = "insert into recorded (chanid, starttime, endtime, title, subtitle, description, hostname) values ((?), (?), (?), (?), (?), (?), (?))";
---
> my $i = "insert into recorded (chanid, starttime, title, subtitle, description, hostname) values ((?), (?), (?), (?), (?), (?))";
281c269
< $sth->execute($channel, $starttime, $endtime, $newtitle,
---
> $sth->execute($channel, $starttime, $newtitle,
287c275
< print(" Query params: '$channel', '$starttime', '$endtime',");
---
> print(" Query params: '$channel', '$starttime',");
***end patch***
Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/