Author Topic: mythfilldatabase error  (Read 933 times)

ogodt

  • Newbie
  • *
  • Posts: 11
    • View Profile
mythfilldatabase error
« on: January 04, 2009, 01:46:03 pm »
hi all

I have a problem with mythtv, i live in denmark and therefor have downloaded an copied the danish "tv_grab_dk_tdc.py" into mythtv
i can see it in setup and i can download the channels, but when i try to run mythfilldatabase i dont get any data in the programguide  ???

here is how it goes:

"linuxmce@dcerouter:~$ mythfilldatabase --file 0 -1 tv_video.xmltv

### bypassing grabbers, reading directly from file
2009-01-04 12:59:33.890 Using runtime prefix = /usr
2009-01-04 12:59:33.901 New DB connection, total: 1
2009-01-04 12:59:33.905 Connected to database 'mythconverg' at host: localhost
2009-01-04 12:59:34.427 New DB connection, total: 2
2009-01-04 12:59:34.427 Connected to database 'mythconverg' at host: localhost
2009-01-04 12:59:34.984 New DB DataDirect connection
2009-01-04 12:59:34.984 Connected to database 'mythconverg' at host: localhost
2009-01-04 12:59:34.986 New DB connection, total: 3
2009-01-04 12:59:34.986 Connected to database 'mythconverg' at host: localhost
2009-01-04 12:59:35.024 Updating icons for sourceid: 0
Updated programs: 2238  Unchanged programs: 0
2009-01-04 12:59:48.263 New DB connection, total: 4
2009-01-04 12:59:48.264 Connected to database 'mythconverg' at host: localhost
2009-01-04 12:59:48.266 Adjusting program database end times.
2009-01-04 12:59:48.290     0 replacements made
2009-01-04 12:59:48.290 Marking generic episodes.
2009-01-04 12:59:48.338     Found 265
2009-01-04 12:59:48.338 Marking repeats.
2009-01-04 12:59:48.378     Found 0
2009-01-04 12:59:48.378 Unmarking new episode rebroadcast repeats.
2009-01-04 12:59:48.413     Found 0
2009-01-04 12:59:48.482 Marking episode first showings.
2009-01-04 12:59:49.429     Found 1146
2009-01-04 12:59:49.429 Marking episode last showings.
2009-01-04 12:59:50.401     Found 1146
2009-01-04 12:59:50.414
===============================================================
| Attempting to contact the master backend for rescheduling.  |
| If the master is not running, rescheduling will happen when |
| the master backend is restarted.                            |
===============================================================
2009-01-04 12:59:50.418 Connecting to backend server: 192.168.80.1:6543 (try 1 of 5)
2009-01-04 12:59:50.419 Using protocol version 31
2009-01-04 12:59:50.443 mythfilldatabase run complete.
2009-01-04 12:59:50.445 DataDirect: Deleting temporary files"

And when i then goes to mythweb it says in status:

"Last mythfilldatabase run started on 2009-01-04 12:59 and ended on 2009-01-04 12:59. mythfilldatabase ran, but did not insert any new data into the Guide for 1 of 1 sources. This can indicate a potential grabber failure.
There's guide data until 2009-01-10 01:35 (6 days)."

The file tv_video.xmltv is full, but there's no data at all  :-\

Ihope there's someone who can help.

Ole



ogodt

  • Newbie
  • *
  • Posts: 11
    • View Profile
Re: mythfilldatabase error
« Reply #1 on: January 05, 2009, 03:37:38 pm »
Hi,

nobody got any ideas or a link to a good mythtv forum, i have searched the net, wiki.lunxmce, forum.linuxmce and so on, but no luck.

plz advise.

Ole

bulek

  • Administrator
  • wants to work for LinuxMCE
  • *****
  • Posts: 884
  • Living with LMCE
    • View Profile
Re: mythfilldatabase error
« Reply #2 on: January 05, 2009, 05:25:10 pm »
Hi,

nobody got any ideas or a link to a good mythtv forum, i have searched the net, wiki.lunxmce, forum.linuxmce and so on, but no luck.

plz advise.

Ole
Hi,

try to look at mythtv.org and related forum archives... You'll find more info there...

Regards,

Bulek.
Thanks in advance,

regards,

Bulek.

indulis

  • Veteran
  • ***
  • Posts: 147
    • View Profile
Re: mythfilldatabase error
« Reply #3 on: January 06, 2009, 08:52:54 am »
This can be an issue with your Mythconverg database. There is more info in the Mythtv forums. http://www.mythtv.org/wiki/index.php/User_Manual:Periodic_Maintenance

All sorts of weird problems happen with Mythtv if the DB is stuffed up.

Go to Main KDE desktop Menu-settings, Mythtv backend setup, follow prompts to stop mythtv backend, go into Mythtv setup, exit without doing anything, then leave the panel "Do you want to run Mythfilldatabase" open, this stops mythtv running and stops LMCE from restarting it.  There is probabablu a more elegant way to do this but it works (and /etc/init.d/mythtvbackend stop does not).
Code: [Select]
sudo su - mythtv
cd /var/lib/mysql/mythconverg/
perl /usr/share/doc/mythtv-backend/contrib/optimize_mythdb.pl
cd <wherever your grabber stores its output.xmltv file>
mythfilldatabase --file 1 7 output.xmltv
Now go to panel asking you if you want to run mythfilldatabase, answer "no"

See if you can see something now in your program listing. I like to use Mythweb, open the LMCE admin website from the main LMCE launcher, then you can just access the URL http://localhost/mythweb/

Good luck!







ogodt

  • Newbie
  • *
  • Posts: 11
    • View Profile
Re: mythfilldatabase error
« Reply #4 on: January 06, 2009, 10:07:14 am »
i will try this as soon as possible, and give you my feedback.

thanks alot.

Ole