View Issue Details

IDProjectCategoryView StatusLast Update
0003183SOGoWeb Generalpublic2015-06-03 14:07
Reporterabantiuc Assigned Tofrancis  
PrioritynormalSeverityminorReproducibilityhave not tried
Status resolvedResolutionno change required 
PlatformDebian 7 
Product Version2.2.17 
Summary0003183: Dates that appear in calendar doesn't match dates from database
Description

Dates that appear in calendar doesn't match dates from database.
Usually they appears the day before the event.
Also, events can't be edited receiving error:
Warning
The end date that you entered occurs before the start date.

Desirable: the dates from db to match the dates that appear in calendar

--
Check attachments to understand situation.

Steps To Reproduce

In Holidays calendar:

  1. dates in database:
    Christmas - 2015.12.25
    Christmas 2nd Day - 2014.12.26

  2. Dates viewed:
    Christmas - 2014.12.24
    Christmas 2nd Day - 2014.12.25

Tagscalendar, dates, match, view

Activities

abantiuc

abantiuc

2015-04-24 14:59

reporter  

bug-sogo.png (61,321 bytes)   
bug-sogo.png (61,321 bytes)   
francis

francis

2015-04-24 15:24

administrator   ~0008429

Are your events coming from a public Web calendar? If so, can you share the URL?

Otherwise, please add the event's raw source (vCalendar) to the ticket.

abantiuc

abantiuc

2015-04-24 15:35

reporter   ~0008430

No, they are from db.

mysql> SELECT * FROM holiday WHERE holiday_date = '2014-12-25';
+------------+------------+---------------------------------+--------------+
| id_holiday | id_country | holiday_translation_placeholder | holiday_date |
+------------+------------+---------------------------------+--------------+
| 109 | 1 | Christmas | 2014-12-25 |
| 121 | 5 | Christmas | 2014-12-25 |
| 155 | 7 | Christmas | 2014-12-25 |
| 166 | 11 | Christmas Day | 2014-12-25 |
| 280 | 6 | Christmas (new style) | 2014-12-25 |
+------------+------------+---------------------------------+--------------+
5 rows in set (0.00 sec)

This events are inserted manually in database and I can't get Raw Source.

abantiuc

abantiuc

2015-06-03 14:04

reporter   ~0008569

So, issue caused by wrong time-stamps. Fixed by adding default_time_zone='+00:00'
in my.cnf

Please mark this task as resolved.

Issue History

Date Modified Username Field Change
2015-04-24 14:59 abantiuc New Issue
2015-04-24 14:59 abantiuc File Added: bug-sogo.png
2015-04-24 15:03 abantiuc Tag Attached: calendar
2015-04-24 15:03 abantiuc Tag Attached: dates
2015-04-24 15:03 abantiuc Tag Attached: match
2015-04-24 15:03 abantiuc Tag Attached: view
2015-04-24 15:24 francis Note Added: 0008429
2015-04-24 15:35 abantiuc Note Added: 0008430
2015-06-03 14:04 abantiuc Note Added: 0008569
2015-06-03 14:07 francis Status new => resolved
2015-06-03 14:07 francis Resolution open => no change required
2015-06-03 14:07 francis Assigned To => francis