| LinHES Forums http://forum.linhes.org/ |
|
| Mythfilldatabase not updating database when complete http://forum.linhes.org/viewtopic.php?f=17&t=13539 |
Page 1 of 1 |
| Author: | AdamC [ Mon Jan 15, 2007 12:57 pm ] |
| Post subject: | Mythfilldatabase not updating database when complete |
I did a search and could not see a problem similar to this one. When my mythfilldatabase runs, it runs correctly and downloads the icons and the program data, but when it completes it doesnt seem to update MythTV correctly. When I view the status of the backend it has the following: Code: Last mythfilldatabase run started on 2007-01-15 18:18 and ended on 2007-01-15 18:22. mythfilldatabase ran, but did not insert any new data into the Guide. This can indicate a potential grabber failure. There's guide data until 2032-03-10 14:00 (9186 days). When mythfilldatabase runs it completes and the final messages are: Code: Updated programs: 8570 Unchanged programs: 0
2007-01-15 18:26:31.712 Data fetching complete. 2007-01-15 18:26:31.712 Adjusting program database end times. 2007-01-15 18:26:32.970 0 replacements made 2007-01-15 18:26:32.971 Marking generic episodes. 2007-01-15 18:26:33.480 Found 150 2007-01-15 18:26:33.481 Marking repeats. 2007-01-15 18:26:33.987 Found 0 2007-01-15 18:26:33.987 Unmarking new episode rebroadcast repeats. 2007-01-15 18:26:34.458 Found 0 2007-01-15 18:26:35.578 Marking episode first showings. 2007-01-15 18:26:59.792 Found 7756 2007-01-15 18:26:59.792 Marking episode last showings. 2007-01-15 18:27:23.172 Found 7756 2007-01-15 18:27:23.391 =============================================================== | Attempting to contact the master backend for rescheduling. | | If the master is not running, rescheduling will happen when | | the master backend is restarted. | =============================================================== 2007-01-15 18:27:23.420 Connecting to backend server: 127.0.0.1:6543 (try 1 of 5 ) 2007-01-15 18:27:23.423 Using protocol version 31 2007-01-15 18:27:23.639 Received a remote 'Clear Cache' request 2007-01-15 18:27:23.730 mythfilldatabase run complete. What should be updated and is there something I can set to ensure that this information is communicated to the backend server. |
|
| Author: | tjc [ Mon Jan 15, 2007 1:11 pm ] |
| Post subject: | |
You seem to have gotten some screwy listing data in the DB. You may want to purge it and retry. Don't forget to check that the system clock is rtight before doing this. These instructions may help: http://www.knoppmythwiki.org/index.php?page=ChannelLineupIsOff Even if your time is right, the information about purging an reloading the DB may be relevant. |
|
| Author: | AdamC [ Tue Jan 16, 2007 2:26 am ] |
| Post subject: | |
Thanks tjc, I had a look in the database and there was a stay line with a date in 2032!!! Not sure how it got there but I removed the line and then re-ran mythfilldatabase and the update was successfully. Thanks for the help. |
|
| Author: | Axxel [ Tue Jan 23, 2007 3:08 pm ] |
| Post subject: | |
I have a simular problem, mythfilldatabase runs but doesn't insert any data into the database. (But when I run 'mythfilldatabase --update' manually it works perfectly.) I've searched the forum repeatedly (trust me  ) but couldn't find any solution.
AdamC could you please tell me what you did exactly. |
|
| Author: | AdamC [ Tue Jan 30, 2007 3:29 pm ] |
| Post subject: | |
On my mythtv box I installed phpMyAdmin (using apt-get install) from this I had a look at the Programs table in the converg database. I ordered it by date and saw that I had a program that was suppose to end in 2030. I've no idea how it got there but by deleting it using phpMyAdmin it solved the problem the next time mythfilldatabase updated. |
|
| Author: | tjc [ Tue Jan 30, 2007 7:40 pm ] |
| Post subject: | |
You can also do this without having to install anything by using mythtv-setup following the directions linked above. |
|
| Author: | Axxel [ Thu Feb 01, 2007 7:01 am ] |
| Post subject: | |
I used Webmin to search the database, BUT I didn't find my problem. Quote: You may want to purge it and retry.
tjc: By purging, you mean dropping all the video sources? And what is purged by dropping the video sources? I mean which information/DB tables; program guide, oldprogram, but also recording schedules? |
|
| Author: | tjc [ Thu Feb 01, 2007 6:47 pm ] |
| Post subject: | |
Recording schedules are separate. I don't know about oldprograms but suspect that's not touched either. See the wiki page for the other details. |
|
| Page 1 of 1 | All times are UTC - 6 hours |
| Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |
|