LinuxMCE Forums

General => Users => Topic started by: ogodt on January 04, 2009, 01:46:03 pm

Title: mythfilldatabase error
Post by: ogodt 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


Title: Re: mythfilldatabase error
Post by: ogodt 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
Title: Re: mythfilldatabase error
Post by: bulek 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.
Title: Re: mythfilldatabase error
Post by: indulis 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 (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!






Title: Re: mythfilldatabase error
Post by: ogodt on January 06, 2009, 10:07:14 am
i will try this as soon as possible, and give you my feedback.

thanks alot.

Ole