XMLTV import gives 2 hours offset (1 Viewer)

[milagroso]

Hello all,

after upgrading from svn 15142 to the recent svns of TVE3 I now observe that the XMLTV-Import gives me a 2 hours offset which I can't influence. With the old svn this part worked perfectly for long weeks.

I tried using the 'time zone compensation' with different values (on/off, -2h, 0, +2h), updated the file TVguide.xml slightly, waited until the importer was through and checked. I never got any different value than the 2 hours offset. I check into the TVguide.xml file itself for e.g. 'Tagesschau' and it correctly showed 20:00 starting time. Checking in the MP TV guide it shows 'Tagesschau' at 22:00. In the table 'program' of the MySQL-DB it (obviously) also shows 22:00.

I can't find any valuable debug information for this in the logs, so I would appreciate any hint where to look at.

regards from Germany

 

[Furetto]

Did you already try removing the time-zone compensation ? In my case that fixed it. Belgium is GMT+2 but so is the EPG I download... no extra compensation needed.

 

[milagroso]

Hello furetto,

in fact, I tried this option, too. It was my former default, but now the import behaves differently.

Thanks for Your suggestion.

edit:

I think I have found a solution now - however no explanation for the root cause.

I tried out the xmltv2 plugin. Among other nice features this plugin contains a checkbox 'delete program table before import'. I checked it, triggered the import and observed im MySQL that the program table was reduced from ~2MB to ~700kB. And I also found correct timestamps finally.

Comparing the new table with the previous one (wisely I made a backup...) I found that in the old table there were many, partially contradicting entries. In the example of my original post: I found as well one entry saying 22:00 and another saying 20:00. I assume that only the first of them 'won' and was displayed.

So, if anyone has a similar behaviour, he should try to empty (not delete) the table 'program' and then issue a reimport.

Have a nice day

 

[Spragleknas]

Hi milagroso.
I am having exact same problem, but I am afraid I don't understand how you solved this.
Could you please explain in "dummy language"

 

[milagroso]

Hello Sparkleknas,

I'll do my very best. I'll try to translate the german menu entries to english ones... If You have questions, just ask back.

1. I'll assume You use the MySQL database
2. Start the MySQl Administrator, login with the account You created during installation.
2a. If You know how and are as paranoid as me - make a backup of Your database...
3. Goto 'Catalogs', select the the scheme 'tvlibrary'. This will display all database tables which are used my TV Server (cuurently 28).
4. Right click on the table named 'program', select 'edit data'. A new window opens displaying all records of the table. Each record corresponds one tv program. This window also displays the SQL command which displays the data (SELECT * FROM...).
5. In the SQL field enter this command:

delete FROM `tvlibrary`.`program`

(Quite easy - just replace 'select *' by 'delete')
6. You now have deleted all records whithout deleting the table itself.
7. Trigger a reimport of the xmltv plugin. This should refill the table with fresh data.

As I said I have no real explanation why this helped. I assume that in the 'old' database there are double records for the same tv program. This resulted probably from a upgrade to a newer svn.

Hope it works for U2.

 

[Spragleknas]

Due to several other difficulties, I have dropped TVE3, and am now running RC2 w/o SNV and TVE2.

Thanks anyway! Will probably usefull next time I'll try TVE3.