Mailing List Archive: MythTV: Mythtvnz

0.19 / mythfilldatabase / time screwup

Index | Next | Previous | View Threaded

mythtvnz at hotblack

May 5, 2006, 11:27 PM

Post #1 of 7 (1605 views)
Permalink

0.19 / mythfilldatabase / time screwup

I've just upgraded to 0.19, and now my guide has gone kaboom. I'm
using a DVB-S card to grab the xml (using the guide at pvr.geek.nz)
then using

mythfilldatabase --no-delete --file 2 -1 /tmp/listings-latest.xml

to load the guide data. Has been working fine since xmas with 0.18.
I upgraded to 0.19 (using atrpms) yesterday, and today I noticed the
program guide was looking a little screwy. So I emptied the table
and ran the script to grab the xml and load it, so I now have a clean
set of data. Looking through the data it's all out by 12 hours.
Stuff that should be on 7pm sat, is appearing at 7am sun. Looking
at the raw xml I can see the original timestamp and it's correct, it
just what appears in the database that is wrong. I've checked my
time zone and it's set to Pacific/Auckland (NZST).

Anyone else running 0.19 hit this? Any ideas on things to check? The
missus is not pleased at the moment... 8(

- Wade

_______________________________________________
mythtvnz mailing list
mythtvnz [at] lists
http://lists.ourshack.com/mailman/listinfo/mythtvnz
Archives http://www.gossamer-threads.com/lists/mythtv/mythtvnz/

criggie at criggie

May 6, 2006, 12:25 AM

Post #2 of 7 (1569 views)
Permalink

Re: 0.19 / mythfilldatabase / time screwup [In reply to]

Wade Maxfield wrote:
> mythfilldatabase --no-delete --file 2 -1 /tmp/listings-latest.xml

Try this:
mythfilldatabase --no-delete --file /tmp/listings-latest.xml

I dunno what the -l and 2 used to do in 0.18 either.

--
Criggie

_______________________________________________
mythtvnz mailing list
mythtvnz [at] lists
http://lists.ourshack.com/mailman/listinfo/mythtvnz
Archives http://www.gossamer-threads.com/lists/mythtv/mythtvnz/

nick.read at engineer

May 6, 2006, 1:03 AM

Post #3 of 7 (1565 views)
Permalink

Re: 0.19 / mythfilldatabase / time screwup [In reply to]

This may help?

http://knoppmythwiki.org/index.php?page=ProgramGuideIsOff

Nick

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.5.4/332 - Release Date: 4/05/2006

_______________________________________________
mythtvnz mailing list
mythtvnz [at] lists
http://lists.ourshack.com/mailman/listinfo/mythtvnz
Archives http://www.gossamer-threads.com/lists/mythtv/mythtvnz/

mythtvnz at hotblack

May 6, 2006, 4:01 AM

Post #4 of 7 (1543 views)
Permalink

Re: 0.19 / mythfilldatabase / time screwup [In reply to]

>Wade Maxfield wrote:
>> mythfilldatabase --no-delete --file 2 -1 /tmp/listings-latest.xml
>
>Try this:
>mythfilldatabase --no-delete --file /tmp/listings-latest.xml
>
>I dunno what the -l and 2 used to do in 0.18 either.
>
>--
>Criggie
>

the 2 is for sourceid 2 and the -1 means to replace all the data.
Leaving them out gives an error:
missing or invalid parameters for --file option

So they're kind of needed. 8)

- Wade

_______________________________________________
mythtvnz mailing list
mythtvnz [at] lists
http://lists.ourshack.com/mailman/listinfo/mythtvnz
Archives http://www.gossamer-threads.com/lists/mythtv/mythtvnz/

criggie at criggie

May 6, 2006, 1:11 PM

Post #5 of 7 (1571 views)
Permalink

Re: 0.19 / mythfilldatabase / time screwup [In reply to]

Wade Maxfield wrote:
> the 2 is for sourceid 2 and the -1 means to replace all the data.
> Leaving them out gives an error:
> missing or invalid parameters for --file option
> So they're kind of needed. 8)

Strange - mine says

mythfilldatabase --file /home/mythtv/latest.xml --update

and does not complain. *shrug*

--
Criggie

_______________________________________________
mythtvnz mailing list
mythtvnz [at] lists
http://lists.ourshack.com/mailman/listinfo/mythtvnz
Archives http://www.gossamer-threads.com/lists/mythtv/mythtvnz/

mythtvnz at hotblack

May 6, 2006, 2:52 PM

Post #6 of 7 (1553 views)
Permalink

Re: 0.19 / mythfilldatabase / time screwup [In reply to]

>This may help?
>
>http://knoppmythwiki.org/index.php?page=ProgramGuideIsOff
>
>Nick
>
>

Thanks, but it didn't. 8( I don't have tzconfig for some reason
**shrug** but my timezone was correct.

After a bit of digging around I have found the issue though. In
mythtvsetup there is a XMLTV grabber offset. Mine was set to Auto,
when it should have been set to None. Auto tries to convert from UTC
to localtime using your timezone offset, while None assumes that the
datetime in the xml is in localtime already.

I don't remember seeing this option before, so I think it's new 0.19.
If anyone running 0.18.1 could check and see if they have this
option, then that would help me track down where/when things went
screwy.

-Wade

_______________________________________________
mythtvnz mailing list
mythtvnz [at] lists
http://lists.ourshack.com/mailman/listinfo/mythtvnz
Archives http://www.gossamer-threads.com/lists/mythtv/mythtvnz/

robert at fisher

May 6, 2006, 3:15 PM

Post #7 of 7 (1552 views)
Permalink

Re: 0.19 / mythfilldatabase / time screwup [In reply to]

On Saturday 06 May 2006 7:25 pm, Criggie wrote:
> Wade Maxfield wrote:
> > mythfilldatabase --no-delete --file 2 -1 /tmp/listings-latest.xml
>
> Try this:
> mythfilldatabase --no-delete --file /tmp/listings-latest.xml
>
> I dunno what the -l and 2 used to do in 0.18 either.

mythfilldatabase --help
would help answer that question.

In the example above I believe that the 2 is the
<sourceid> = cardinput

and the -1 is the
<offset> = days from today that xmlfile defines
(-1 means to replace all data, up to 10 days)

I use 1 -7

Rob

_______________________________________________
mythtvnz mailing list
mythtvnz [at] lists
http://lists.ourshack.com/mailman/listinfo/mythtvnz
Archives http://www.gossamer-threads.com/lists/mythtv/mythtvnz/

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads