Simple Groupware / Patches / #19 synchronizing Birthdays before 1970-01-01

#19 synchronizing Birthdays before 1970-01-01

Status: closed

Owner: nobody

Labels: None

Priority: 5

Updated: 2012-02-11

Created: 2012-01-27

Creator: ben

Private: No

Birthdays before 1970-01-01 are not synchronized by funambol because of view fnbl_simple_contacts_exp
Workaround:
WHEN (`simple_contacts`.`birthday` < 0) THEN (_utf8\'1970-01-02\' + INTERVAL `simple_contacts`.`birthday` SECOND)

SQL script attached

Discussion

ben - 2012-01-27

create view

fnbl_simple_contacts_exp.sql

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

ben - 2012-01-27

Simple Groupware version: 0.740

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Thomas Bley - 2012-02-11

status: open --> closed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Thomas Bley - 2012-02-11

The fix is in the latest release, 0.743.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

synchronizing Birthdays before 1970-01-01

Group

Searches

Help

#19 synchronizing Birthdays before 1970-01-01

Discussion