[mythtv-users] Problem Recording

[Colin Armstrong]

Thanks for helping me with this problem but now I have another. My
problem now is that after I ran mc.sql, mythtv is now giving another
error. I ran the mythtvsetup program and had to set it up completely
again, which I guess is to be expected because I deleted everything in
the database. Now though when I set up mythtv's buffer location I
switched it from where I put it last time. I also switched the storage
location for files for mythtv if that matters. I do not know why
switching these two directories should matter but it appears as if it
does because when I try to watch tv, mythfrontend freezes and the
terminal where I ran the backend from gives an error and shows that
mythtv closed. Here is the error the backend gives:

ERROR opening file '/media/mythtv/cache/ringbuf1.nuv' in
ThreadedFileWriter.

Also, I tried using locate for this file and it turned up nothing. Any
ideas?
Thanks,
Colin
On Fri, 2003-08-22 at 11:25, Michael J. Sherman wrote:
> Okay, you ought to have at least a working knowledge of Linux and MySQL. 
>   But anyways, "drop database mythconverg" is a command that you run 
> inside the mysql program.  At a shell prompt, run the command "mysql". 
> You will then be at another prompt that will look like this: "mysql>". 
> At that point type in "drop database mythconverg;" and hit enter. Then 
> type in "quit" and hit enter.
> 
> 
> Colin Armstrong wrote:
> 
> > Sorry for this pathetic question but could you tell me the command to
> > run to the drop database command? when I type "drop database
> > mythconverg" it tells me that there is now command "drop" Sorry.
> > Thanks,
> > Colin
> > On Fri, 2003-08-22 at 10:17, Michael J. Sherman wrote:
> > 
> >>1) When you dumped the DB did you also drop it?  You have to remove the 
> >>database with the sql command "drop database mythconverg".
> >>
> >>2) Don't run "mysql > mc.sql".  I think you just blanked out your mc.sql 
> >>file.  You want to direct the contents of the file into the mysql 
> >>command, so run "myslq < mc.sql".
> >>
> >>
> >>Colin Armstrong wrote:
> >>
> >>
> >>>So, I did find the error on the mailing list and it did tell me what to
> >>>do, but now I am having trouble running the command. It told me to do a
> >>>database dump, which I did, and then to run mc.sql. After I did the
> >>>database dump, all of the files in mythconverg were still there and
> >>>mc.sql complained about there already being a database. Then, because of
> >>>this, I moved the bad file, recordmarkup.MYD to a different directory.
> >>>Then I ran "mysql > mc.sql" and it just sits there it does not give me
> >>>another terminal prompt but it goes done one line and the cursor just
> >>>blinks. It seems like it is doing something but I don't think it is,
> >>>because it has been going for 5 min and it has not stopped. One time I
> >>>stopped and checked to see if it had created recordmarkup.MYD and it had
> >>>not. Any ideas?
> >>>Thanks,
> >>>Colin
> >>>On Fri, 2003-08-22 at 07:18, Rob Minerick wrote:
> >>>
> >>>
> >>>>>DB Error (WriteRecordedToDB):
> >>>>>Query was:
> >>>>>INSERT INTO recorded
> >>>>>(chanid,starttime,endtime,title,subtitle,description,hostname,category)
> >>>>>VALUES(1004,"20030821160000","20030821163000","KRON 4 News at
> >>>>>4","","Sinkovitz, Liviakis.","conf-pc.ca.sandia.gov","News");
> >>>>>Driver error was [2/-1]:
> >>>>>QMYSQL3: Unable to execute query
> >>>>>Database error was:
> >>>>>Duplicate entry '1004-20030821160000' for key 1
> >>>>
> >>>>Colin,
> >>>>	You should probably try to search the mythTV archives @ 
> >>>>http://www.gossamer-threads.com/archive/MythTV_C2. Someone had an 
> >>>>identical (or very close) problem a few months back. Just search for 
> >>>>recordedmarkup.MYD in the user archives and I think you'll find your 
> >>>>answer.
> >>>>
> >>>>Cheers,
> >>
> >>
> >>_____
> 
> 
> ______________________________________________________________________
> 
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users