imorgan wrote:In MythTV settings, under General I believe, is where you set the program to be used to fill the database. I just changed it from mythfilldatabase to my script (which I called mythfillfromsd). I didn't change anything using mythtv-setup other than deleting all my channels and letting mythfilldatabase repoplulate the list.
There are many snippts of SQL scattered thoughout these forums and on Mythtv's trac site to fix the programid records. Mainly they fix just the programid's for the recorded and oldrecorded tables. I went a few steps further and applied the same logic to fix-up all programid's and seriesid's throughout the entire database, so as well as recorded and oldrecorded, I also fixed up record, and any other table that had a programid or seriesid.
Just keep in mind that your record table might have Power Searches saved where you make use of a programid within the stored SQL, and you'll have to updates those as well.
Now I just need to patch my mythweb, as it's cropping programids to 12 chars breaking the video streaming links.
Well I updated my last post to say that I got it. I didn't change anything with my mythconverg database however and it still worked. All my recording schedules are intact, meaning that it still will always record Scrubs on a certian day and time etc etc. Is there something else I should be worried about? You answered one of my questions regarding what command should be run by mythtv but I can't get into that at this current time. I am ssh'd in and then start an X11vnc session, than open tightvncviewer, but when I run the Mythtv frontend, and try to go to settings, it's just not working, I am guessing it's because I am using an OpenGL theme. ANyway, hopefully the place to change whether mythfilldatabase gets run is in there because it's definitely not in the backend setup.
So questions that you haven't answered yet:
-what do I do with the current zap2it source within mythtv-setup? delete it? change it to no grabber?
I didn't create the script or do it thru cron, I did it manually for now and per mythweb, the last mythfilldatabase was run at 11:13 today and finished at 11:14, this was immediately after I ran the commands above manually as root.
I do notice that thru mythweb, under settings, then under mythtv table settings, there's a place where it states, Mythfilldatabase location, then it says /usr/bin/mythfilldatabase. could I change that there? what does yours say within that place under mythweb mythtv table settings?
This is what it looks like: