View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 4 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
PostPosted: Sun Sep 17, 2006 8:13 am 
Offline
Joined: Wed Apr 19, 2006 7:58 pm
Posts: 33
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...


Top
 Profile  
 
 Post subject:
PostPosted: Sun Sep 17, 2006 9:30 am 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
Is there anything in the pretty directory? (/myth/pretty)


Top
 Profile  
 
 Post subject:
PostPosted: Sun Sep 17, 2006 5:44 pm 
Offline
Joined: Wed Apr 19, 2006 7:58 pm
Posts: 33
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.


Top
 Profile  
 
PostPosted: Mon Sep 18, 2006 9:42 am 
Offline
Joined: Sun Aug 28, 2005 7:07 pm
Posts: 821
Location: Melbourne, Australia
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***

_________________
*********************
LinHES 7.4
Australian Dragon
*********************


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 9 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu