Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-68982

Message board email notifications do not have consistent Message-IDs when using MYSQL

Details

    Description

      Description:
      Message board email notifications do not have consistent Message-IDs.

      Steps to reproduce:

      1. Start portal with MySQL 5.5
      2. Configure an SMTP service configured to deliver message board notifications to an email account. I set it up with the following:
        Incoming POP Server: pop.gmail.com
        Incoming Port: 995
        Use a Secure Network Connection: Checked
        User Name: Your email address
        Password: The password to your email account
        
        Outgoing SMTP Server: smtp.gmail.com
        Outgoing Port: 465
        Use a Secure Network Connection: Checked
        User Name: Your email address
        Password: The password to your email account
        
      3. Add a message board portlet and Subscribe to the message board
      4. Create an initial post to the new message board thread.
      5. Control Panel --> Server Administration --> Clear content cached across the cluster
      6. On the Liferay portal, reply to the thread.
        1. Confirm that the message board portlet shows the postings as a tree structure with the reply as a child of the initial post.
      7. Check gmail inbox
      8. Open both Message board thread emails and view full headers
        1. How to view full headers on Gmail: https://support.google.com/mail/answer/29436?hl=en
      9. For the email received for the initial post:
        1. Look for the message-id
      10. For the email received for the reply to the initial post:
        1. Look for the in-reply-to and references

      Expected Behavior: The in-reply-to and references from the reply email headers should match the message-id of the initial post.

      Actual Behavior: The in-reply-to and references from the reply email headers do not match the message-id of the initial post.


      Example - Email Headers
      The initial posting has the email header:
      Message-ID: <[email protected]>

      The reply has the email header:
      Message-ID: <[email protected]>
      In-Reply-To: <[email protected]>
      References: <[email protected]>


      Extra Notes
      The message-id inconsistency also changes, based on the version of MYSQL being used.

      This is due to the changes introduced by MYSQL regarding the DateTime field:
      https://bugs.mysql.com/bug.php?id=68760

      Attachments

        Issue Links

          Activity

            People

              joyce.wang Joyce Wang
              eric.yan Eric Yan
              Kiyoshi Lee Kiyoshi Lee
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                6 years, 3 weeks, 4 days ago

                Packages

                  Version Package
                  6.2.X EE