Calendar Home Widget replacement - Page 46 - maemo.org

Active Topics

The N900 is now 15 years old! (9)
to Nokia N900 by Arno_11 - 7 hrs, 56 mins ago
Sailfish OS for the Motorola Moto G7 Power (XT1955-5) - (ocean) (4)
to SailfishOS by Maemish - 5 days, 20 hrs ago
more...

Page 46 of 51

Thread Tools

Carlito	2011-04-17 , 10:19
Posts: 458 \| Thanked: 136 times \| Joined on Jul 2010 @ Holland	#451

Originally Posted by x-lette

Using version 1.3 I currently cannot see any errors in display of birthdays or recurring events. I set up an event of one hour duration repeating weekly and it's displayed correctly. Same for upcoming birthdays of which one is today and one tomorrow. Date and age are correct.

My settings are: UTC+2 (=UTC+1+DST) and display of upcoming three weeks with all recurrences and events only (no tasks).

same here..

Quote & Reply |

Carlito	2011-04-18 , 12:23
Posts: 458 \| Thanked: 136 times \| Joined on Jul 2010 @ Holland	#452

@Nicolai:

Could help you with the sql queries if you like. Or is it just about the timeset on the telephone? DST stuff ?

Quote & Reply |

	nicolai	2011-04-18 , 12:26
	Posts: 1,637 \| Thanked: 4,424 times \| Joined on Apr 2009 @ Germany	#453

Are the displayed events still wrong?
I thought the latest version solved all time shift related bugs.

Nicolai

Quote & Reply |

Carlito	2011-04-18 , 12:44
Posts: 458 \| Thanked: 136 times \| Joined on Jul 2010 @ Holland	#454

Nope . . . still displaying two hours earlier . . .

Quote & Reply |

stlpaul	2011-04-18 , 15:53
Posts: 1,141 \| Thanked: 781 times \| Joined on Dec 2009 @ Magical Unicorn Land	#455

Originally Posted by nicolai

what kind of entries? Events or Todos?

And what timezone settings do you have?

Nicolai

It seems that if I create an event on my N900 the time is correct. But if I synchronize an event from Exchange server (using MfE), the time is shown wrong. It shows 1 hour in the future, for example if my meeting is 9:00 it will show up as 10:00 instead.

My time zone is set to America/Chicago. The times show correctly in the nokia calendar widget, and the calendar itself, and my reminder alarms still ring at the correct time. So it seems like it's only displaying
wrong in this one place.

Let me know if there's any other info I can provide to help solve it! Thanks.

Quote & Reply |

The Following User Says Thank You to stlpaul For This Useful Post:
nicolai

	nicolai	2011-04-19 , 09:27
	Posts: 1,637 \| Thanked: 4,424 times \| Joined on Apr 2009 @ Germany	#456

Hi stlpaul,

can you use sqlite3 to export some of these calendar entries.
I don't use MFE, so for me it is difficult to reproduce it.

Thank you.

Nicolai

Quote & Reply |

The Following User Says Thank You to nicolai For This Useful Post:
stlpaul

stlpaul	2011-04-20 , 21:07
Posts: 1,141 \| Thanked: 781 times \| Joined on Dec 2009 @ Magical Unicorn Land	#457

Originally Posted by nicolai

can you use sqlite3 to export some of these calendar entries.
I don't use MFE, so for me it is difficult to reproduce it.

Hi, absolutely, thanks for your fine work.

Here is my time zone:

Code:

sqlite> select * from timezone where location='America/Chicago';
America/Chicago|/freeassociation.sourceforge.net/Tzfile/America/Chicago|26269200|6231600|-21600|-18000|FREQ=YEARLY;BYDAY=1SU;BYMONTH=11|FREQ=YEARLY;BYDAY=2SU;BYMONTH=3|CST|1

Here I created 2 events with the same start and end time; one on my N900 (shows up properly) and one from Exchange (created in Outlook), which shows time wrong by 1 hour in the widget:

Code:

sqlite> select * from components where id>793;
794|1|1|4|1303336800|1303338600|Test from N900|||-1||-1|0|1303332422|1303332738|:America/Chicago|-18000
795|1|1|4|1303336800|1303338600|Test from Exchange||

|0|040000008200E00074C5B7101A82E008000000008031F03C72FFCB01000000000000000010000000C7BDDF7F6675664DB1E7E27A75331E8E|-1|0|1303332470|1303332779|:America/Nassau|-14400

So we can see the UTC start and end timestamp are identical. The last columns are the interesting ones

Time Zone ID and Time Zone Offset to UTC.

Why does my Exchange event have America/Nassau and -14400? This difference of course is 3600 seconds, 1 hour, exactly the wrong difference in time on the widget.

But the strange part is that Nokia's widget, and in fact the rest of the calendar and alarm system, can properly interpret the date. Does this mean they only use UTC and compute TZ offset independently, ignoring the TZ and offset in this table? And that the calendar database contains the wrong values, apparently.

My company's Exchange server is located in US Eastern Time Zone, which happens to 1 hour ahead of mine. Maybe that's where the bad data comes from (if it's bad?).

Please let me know if you need any other data, thanks.

Quote & Reply |

The Following User Says Thank You to stlpaul For This Useful Post:
nicolai

	nicolai	2011-04-26 , 08:05
	Posts: 1,637 \| Thanked: 4,424 times \| Joined on Apr 2009 @ Germany	#458

Originally Posted by stlpaul

But the strange part is that Nokia's widget, and in fact the rest of the calendar and alarm system, can properly interpret the date. Does this mean they only use UTC and compute TZ offset independently, ignoring the TZ and offset in this table? And that the calendar database contains the wrong values, apparently.

That is really strange. I had so many bugs with wrong time offset, which
I got fixed only by using the TZ and TZ-offset.

I am afraid I can not simply remove this time offset from the timezone,
as in other cases the time offset may be wrong again.

Nicolai

Quote & Reply |

amok	2011-04-26 , 09:24
Posts: 10 \| Thanked: 2 times \| Joined on Jan 2010	#459

I am traveling quite often and I tend to set the timezone to every place I go. I have noticed that every time I edit any of my contacts while being abroad the birth date is set to the current timezone (I saw that using the sqlite3 command).

Due to that "behavior" the birth dates appeared with an offset for those contacts when I get back home.

In order to fix this, I have to edit the affected contacts again, when I am returning to my default time zone.

I though that this might help someone.