Quickly adding social activities results in a duplicate key exception

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 5.1 EE SP2 (5.1.5), 5.2 EE (5.2.4)
• Fix Version/s: 5.1 EE SP3 (5.1.6), 5.2 EE SP1 (5.2.5)
• Component/s: Environments > Databases, Legacy Components > API, Social Networking > Activities
• Labels:
  • 5.2_release_notes
• Environment: MySQL

Since MySQL's DateTime column type does not support milliseconds, adding social activities in quick succession may cause the database to throw a duplicate key exception.

As part of this bug fix, all Date properties in SocialActivity, SocialRelation, and SocialRequest have been changed to a long.