Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-17250

TC-120 (eZ comments)(Oracle) Notifications on comments are not working

    Details

      Description

      Hi,
      In Oracle, when we create a comment, as anonymous, and check the "Notify me of new comments", the notifications are not being sent.

      Note: Subscription email is being sent. In this test, the subscription was confirmed.

      Steps to reproduce

      Setup - Give anonymous user access to post comments
       
         1. Log in as admin in ezwebin admin
         2. Click on "User accounts" in top menu
         3. Click "Roles and policy" in left menu
         4. Click edit icon next to "Anonymous"
         5. Click "New policy" button
            Module: comment
            Function: Add
         6. Click "Grant full access"
         7. Click "New policy" button
            Module: comment
            Function: Read
         8. Click "Grant full access"
         9. Click "New policy" button
            Module: comment
            Function: Activate
        10. Click "Grant full access"
        11. Click "Save" button
       
      Move test article to a folder
       
         1. Click "Content structure" in top menu
         2. Create new folder "News"
         3. Click "Comments system testing" link
         4. Click "Move" button
         5. Select radio button next to "News"
         6. Click "Select" button
       
      Post an anonymous comment
       
         1. Go to webin as anonymous
         2. Click "News" in top menu
         3. Go to plain site (don't login)
         4. Click on the "Comment system testing" article in the sub items list
         5. Fill in the comment form as follows:
            Title: Comment by an anonymous coward
            Name: Anonymous coward
            Website: leave blank
            Email: [ an email address the tester has access to ]
            Content: This is an anonymous comment
            Notification: check
         6. Click on "Add comment"
       
      Check that an email confirmation is required
       
         1. Validate that an email explaining that an email confirmation is required is sent to the email address provided above.
         2. Do NOT click the validation link in that email yet (will do this later inste.
       
      Create a administrator user
      1 . create a "testuser1" as administrator
       
      Post a comment as a registered user
       
         1. Log in as testuser1 in ezwebin
         2. Click "News" in top menu
         3. Click on the "Comment system testing" article in the sub items list
         4. Fill in the comment form:
                * Title: "Comment from testuser2"
                * Name: leave as is
                * Website: leave as is
                * Email: leave as is
                * Content: "A comment by test2"
         5. Click on "Add Comment"
         6. Log out from ezwebin
       
      Run the ezcomments cronjob
       
         1. Log in as admin in ezwebin
         2. Click "Selenium tests" in top menu
         3. Click "Cronjobs" in left menu
         4. Select SiteAccess ezwebin_site_admin
         5. Execute the "ezcomments" cronjob
         6. Log out from ezwebin admin
       
      Check that the anonymous user wasn't notified
       
         1. Check that no email notification about the new comment was sent to anonymous user
       
      Confirm the email address for the anoymous user
       
         1. In regards to the validation email explained in "Check that an email confirmation is required", click the validation link now
         2. Check that you in the browser get a message that confirms your notification subscription
       
      Run the ezcomments cronjob
       
         1. Log in as admin in ezwebin
         2. Click "Selenium tests" in top menu
         3. Click "Cronjobs" in left menu
         4. Select SiteAccess : ezwebin_plain_site
         5. Execute the "ezcomments" cronjob
         6. Log out from plain admin
       
      Check that the anonymous user was not notified
       
         1. Check that a notification email was not sent to the email address you specified earlier
       
       
       
      Post a comment as a registered user
       
         1. Log in as testuser1 in ezwebin
         2. Click "News" in top menu
         3. Click on the "Comment system testing" article in the sub items list
         4. Fill in the comment form:
                * Title: "Comment2 from testuser2"
                * Name: leave as is
                * Website: leave as is
                * Email: leave as is
                * Content: "A comment by test2"
         5. Click on "Add Comment"
         6. Log out from ezwebin
       
      Run the ezcomments cronjob
       
         1. Log in as admin in ezwebin
         2. Click "Selenium tests" in top menu
         3. Click "Cronjobs" in left menu
         4. Select SiteAccess : ezwebin_plain_site
         5. Execute the "ezcomments" cronjob
         6. Log out from plain admin
       
      Check that the anonymous user was notified
       
         1. Check that a notification email was sent (for the "Comment2 from testuser2" comment)  to the email address you specified earlier
      
      

        Activity

        Hide
        Gaetano Giunta added a comment -

        I think this is not a bug - closing. Feel free to reopen it if in disagreement.

        In short, it is normal that notifications are not sent to anon users until they have verified their email address by clicking on the verification link.
        In fact, that is the main reason for the email verification link: to make sure I cannot use your email and have the system spam you with emails from other's people's comments.

        As you said, after anon user conforms his email, he starts to receive notifications.

        The question is: what to do with the notifications generated by the system while anon did not yet confirm his email? Imho deleting them as we do is the right thing to do:
        1. we're not clobbering up db with notification emails that might never be sent
        2. user that activates a mail after 1 week does not want to receive 50 notifications all of a sudden anyway.

        A couple of nitpicks about this bug report:

        • I do not think it is oracle-related at all. Did you test it on mysql? If not, please remember to test things on mysql before flagging them as oracle bugs
        • in the steps-to-reproduce, it would be better if no selenium infrastructure was used, as I do not have it on my dev laptop, and have to figure out what you mean when you mention it
        Show
        Gaetano Giunta added a comment - I think this is not a bug - closing. Feel free to reopen it if in disagreement. In short, it is normal that notifications are not sent to anon users until they have verified their email address by clicking on the verification link. In fact, that is the main reason for the email verification link: to make sure I cannot use your email and have the system spam you with emails from other's people's comments. As you said, after anon user conforms his email, he starts to receive notifications. The question is: what to do with the notifications generated by the system while anon did not yet confirm his email? Imho deleting them as we do is the right thing to do: 1. we're not clobbering up db with notification emails that might never be sent 2. user that activates a mail after 1 week does not want to receive 50 notifications all of a sudden anyway. A couple of nitpicks about this bug report: I do not think it is oracle-related at all. Did you test it on mysql? If not, please remember to test things on mysql before flagging them as oracle bugs in the steps-to-reproduce, it would be better if no selenium infrastructure was used, as I do not have it on my dev laptop, and have to figure out what you mean when you mention it
        Hide
        Gaetano Giunta added a comment -

        it's a feature

        Show
        Gaetano Giunta added a comment - it's a feature
        Hide
        ezrobot added a comment -

        This issue has been automatically closed due to the lack of activity over a long period of time. It is very likely that it is obsolete, but if you think it is still valid, do not hesitate to reopen it and mention why.

        Show
        ezrobot added a comment - This issue has been automatically closed due to the lack of activity over a long period of time. It is very likely that it is obsolete, but if you think it is still valid, do not hesitate to reopen it and mention why.

          People

          • Assignee:
            unknown
            Reporter:
            Paulo Cardiga
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: