View Issue Details

IDProjectCategoryView StatusLast Update
0004025SOGoWeb Generalpublic2017-02-10 15:38
Reportervdbroecj Assigned To 
PrioritynormalSeverityminorReproducibilityhave not tried
Status newResolutionopen 
Platform[Server] LinuxOSRHEL/CentOSOS Version6
Product Version2.3.19 
Summary0004025: old reccuring events reappear
Description

After [b]updating SOGo from 2.3.17-1 to 2.3.19-1[/b] (using the inverse repository [b]rhel6/CentOS6[/b]) some very old recurring events reappear (multiple time) for a few users

tables for one user affected by this problem:
[code]
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME like '%mylittleponey%'
and TABLE_SCHEMA = 'sogo'

+-------------------------------+
| sogomylittleponey0012c48149e |
| sogomylittleponey0012c48149e_acl |
| sogomylittleponey0012c48149e_quick |
| sogomylittleponey0015412fcc5 |
| sogomylittleponey0015412fcc5_acl |
| sogomylittleponey0015412fcc5_quick |
+-------------------------------+
[/code]

Id of one reappearing event: 31FF-56543600-5-151FFFA0

[code]
select * from sogomylittleponey0012c48149e where c_name like '%31FF-56543600-5-151FFFA0%'\G

1. row
c_name: 31FF-56543600-5-151FFFA0.ics
c_content: BEGIN:VCALENDAR
PRODID:-//Inverse inc./SOGo 2.3.2//EN
VERSION:2.0
BEGIN:VEVENT
UID:31FF-56543600-5-151FFFA0
SUMMARY:Temps partiel
LOCATION:Domicile
DESCRIPTION:Pas disponible
CLASS:PUBLIC
PRIORITY:5
CREATED:20151124T100520Z
DTSTAMP:20151124T100520Z
LAST-MODIFIED:20151124T100520Z
RRULE:FREQ=WEEKLY
DTSTART;VALUE=DATE:20151125
DTEND;VALUE=DATE:20161229
TRANSP:OPAQUE
END:VEVENT
END:VCALENDAR
c_creationdate: 1448359520
c_lastmodified: 1448359520
c_version: 0
c_deleted: NULL
[/code]

I tried to backup/restore all data of the user affected by this problem but it doesn't fix this issue! I don't know what information you need to debug or reproduce this.

Tagscalendar, cyclic events, upgrade

Activities

vdbroecj

vdbroecj

2017-02-09 09:54

reporter  

SOGo - Google Chrome_005.png (194,316 bytes)   
SOGo - Google Chrome_005.png (194,316 bytes)   
vdbroecj

vdbroecj

2017-02-09 10:35

reporter   ~0011284

The second screenshot shows the event in thunderbird, with some kind of conflicting information about the end of the event. Don't know if it's related to this issue

vdbroecj

vdbroecj

2017-02-09 10:35

reporter  

vdbroecj

vdbroecj

2017-02-09 10:41

reporter   ~0011285

setting an until date for the repeat period doesn't fix this problem, the event still appears in sogo and thunderbird

vdbroecj

vdbroecj

2017-02-09 11:26

reporter   ~0011286

the end date in this case should be the same as the start date! The user must customize the repeat time

Christian Mack

Christian Mack

2017-02-10 15:38

developer   ~0011299

Check if those events are more than a month long and repeat weekly.
We had some users with such repeating events.
They tried to stop the repeating, but ended up enlarging the event!

So you first have to set the ENDDATE to the same day the STARTDATE has, then set an until date for the repeating.

They show up, because Inverse fixed a bug, which preventet them showing up in the webinterface ;-)

Issue History

Date Modified Username Field Change
2017-02-09 09:54 vdbroecj New Issue
2017-02-09 09:54 vdbroecj File Added: SOGo - Google Chrome_005.png
2017-02-09 10:35 vdbroecj Note Added: 0011284
2017-02-09 10:35 vdbroecj File Added: Edit Event: Temps partiel_007.png
2017-02-09 10:41 vdbroecj Note Added: 0011285
2017-02-09 10:44 vdbroecj Tag Attached: calendar
2017-02-09 10:44 vdbroecj Tag Attached: cyclic events
2017-02-09 10:44 vdbroecj Tag Attached: upgrade
2017-02-09 11:26 vdbroecj Note Added: 0011286
2017-02-10 15:38 Christian Mack Note Added: 0011299