[mythtv-users] Problem Recording
Michael J. Sherman
msherman at dsbox.com
Fri Aug 22 16:30:11 EDT 2003
Does the /media/mythtv/cache/ directory exist? If so, does it have
permissions set such that the user account from which you are running
mythtv has write access?
Colin Armstrong wrote:
> 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,
>>>>
More information about the mythtv-users
mailing list