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

Need method to re-sync SQL/Myth after deleting mpg file.
http://forums.linhes.org/viewtopic.php?f=17&t=10349		 Page 1 of 1
Author:  calinb [ Sun Jun 04, 2006 2:57 am ]
Post subject:  Need method to re-sync SQL/Myth after deleting mpg file.
Before I migrated from Ubuntu to Knoppmyth, I dumped and archived my mythconverg SQL database containing all my QAM channel mappings. Unfortunately, I did not properly delete one recording I'd made, but rather deleted it directly from the subdirectory, and it does not exist on my new Knoppmyth system.

I deleted the installed Knoppmyth mythconverg database and re-initialized/imported my backup form Ubuntu. (Man, was that a pain). Now Myth won't delete the entry in the Recordings section. Actually, it looks like it deletes it but it just pops right back.

Any ideas (or step-by-step Wikki :)) would be much appreciated.

Thanks,

-Cal
Author:  tjc [ Sun Jun 04, 2006 8:07 am ]
Post subject: 
Touch the expected file into existance and then it will let you delete it.

http://mysettopbox.tv/phpBB2/viewtopic. ... +recording
http://mysettopbox.tv/phpBB2/viewtopic. ... touch+file
Author:  calinb [ Sun Jun 04, 2006 3:14 pm ]
Post subject: 
Thanks, but now I just get a baziilion entries like this:

Couldn't find backend for:
NW Newschannel 8 at Noon : ""

and the frontend keeps writing messages like:

2006-06-04 14:04:03.753 Error: File 'file not found' missing.

I think I'd better just delete the mythconverg database and start over :(. Yup--the SQL database sure is powerful...and very unforgiving!
Author:  tjc [ Sun Jun 04, 2006 4:21 pm ]
Post subject: 
I think you're doing something wrong. You have to look at the log file for what filename it's trying to delete and use the "touch" command to create a dummy for that in /myth/tv. I know this works because I've done it.

There is also another way to approach this if you've got webmin running. Use the DB browser there to go into the "recorded" tables (recorded, recordedprogram, recordedcredits, recordedmarkup, recordedrating) and remove the appropriate records manually. I've done that too.
Author:  marc.aronson [ Sun Jun 04, 2006 6:50 pm ]
Post subject: 
If you are on the R5A* series, I have a script you can run that will detect all inconsistancies between the database and the file system. It deals with the following condiitions:

1. Entry exists in data base, but no file in /myth/tv: Automatically creates a dummy file, as tjc suggests.

2. File exists in /myth/tv, but no corresponding entry in the data base exists: Moves the file to a directory named "/myth/tv/trash".

Has not been testing on the B or C series -- probably not a good idea to try it there. Let me know if you want a copy

Marc
Author:  calinb [ Mon Jun 05, 2006 12:57 am ]
Post subject: 
Thanks for all the help and I'll definitely need it if I ever delete a file again. Perhaps some of my problems stem from the fact that the subdirectory structure wasn't /myth/tv on my Ubuntu install of Myth. I thought about trying to recreate the structure but it seems easier at this point to just drop mythconverg from SQL and start over.

I've learned a lot about installing myth:

1. Ubuntu Breezy doesn't work with the Fusion 5 Lite.

2. Rebuilding a plain vanilla kernel in breezy and doing a custom build of 0.19 can work, but then there's so much more ahead (like finding and installing an Nvidia driver that won't crash the system under xvmc!)

3. Mythtv 0.18 doesn't support QAM very well. (apt-get in Breezy gives you 0.18.) Couldn't find non-extended ID channels and couldn't import dvb-aps atscscan data.

4. Knoppmyth is the fast path to success, but I wish it were more full-featured as a general purpose desktop distro Seems like an option to safely install a full desktop suite of aps would be nice, rather than risking apt-get (I got bit by it) or getting bogged down in tarballs!

my $0.02!

Thanks again,

-Cal
Author:  cesman [ Tue Jun 06, 2006 1:02 am ]
Post subject: 
calinb wrote:
4. Knoppmyth is the fast path to success,
That is the point. KnoppMyth is meant to be used on a set-top box. Yes, doing an apt-get maybe risky at this point. Frankly, if you keep 'set-top box' in mind, you should have no issues...
Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/