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

Unable to add a comment as anonymous user with Oracle

    Details

      Description

      Description

      If I try to add a comment, with an anonymous user, I get the following error

      "
      Error: eZOracleDB::query()
      Error (1400): ORA-01400: kan ikke sette inn NULL i ("EZP"."EZCOMMENT"."SESSION_KEY")
      Failed query at offset 195:
      INSERT INTO ezcomment (language_id, created, modified, user_id, session_key, ip, contentobject_id, parent_comment_id, name, email, url, text, status, title) VALUES(2, 1350677490, 1350677490, 10, '', '192.168.2.204', 60, 0, 'fsd', 'fds@ez.no', 'fds', 'fds', 1, 'fds')

      Start of error:
      '', '192.168.2.204', 60, 0, 'fsd', 'fds@ez.no', 'fds', 'fds', 1, 'fds')
      "

      Steps

      Setup

      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: security

      8. Click "Grant full access"
      9. Click "New policy" button
      Module: comment
      Function: Read

      10. Click "Grant full access"
      11. Click "Save" button

      Create a test article to a folder

      1. Click "Content structure" in top menu
      2. Create new folder "News"
      3. Click on "Create new" button
      4. Choose "Article with comments" from the drop down list
      5. Fill in the fields:
      Title (required): Test
      Summary (required): Summary of the test

      6. Click on "Send for publishing" button

      Add a new comment

      1. Access the frontend
      2. Click on "News" folder
      3. Click on "Test" article
      4. Fill in the comment fields:
      Title: test
      Name: Testes
      Website: http://ez.no
      Email: ez@ez.no
      Content: Simple test

      5. Check the "Remember me" checkbox
      6. Click on "Add comment" button
      7. Verify the error in the redirect

        Activity

        Pedro Resende (Inactive) created issue -
        Vidar Langseid made changes -
        Field Original Value New Value
        Affects Version/s 5.0 Certification [ 11013 ]
        Vidar Langseid made changes -
        Fix Version/s QA tracked issues [ 11072 ]
        Fix Version/s 5.0 Certification [ 11013 ]
        Vidar Langseid made changes -
        Priority High [ 3 ] Medium [ 4 ]
        Vidar Langseid made changes -
        Status Open [ 1 ] Backlog [ 10000 ]
        Vidar Langseid made changes -
        Status Backlog [ 10000 ] InputQ [ 10001 ]
        Vidar Langseid made changes -
        Rank Ranked higher
        André Rømcke made changes -
        Summary Unable to add a comment with and anonymous user: eZ Oracle eZ Oracle: Unable to add a comment with and anonymous user
        Damien Pobel (Inactive) made changes -
        Assignee Damien Pobel [ damien.pobel@ez.no ]
        Damien Pobel (Inactive) made changes -
        Status InputQ [ 10001 ] Development [ 3 ]
        Damien Pobel (Inactive) made changes -
        Summary eZ Oracle: Unable to add a comment with and anonymous user Unable to add a comment as anonymous user with Oracle
        Damien Pobel (Inactive) logged work - 31/Oct/12 3:48 PM - edited
        Hide
        Damien Pobel (Inactive) added a comment -
        Show
        Damien Pobel (Inactive) added a comment - Fixed in ezcomments: master: http://github.com/ezsystems/ezcomments/commit/e172bc42b025122a424d033debb754f5170ae729 stable-5.0: https://github.com/ezsystems/ezcomments/commit/1065c174b218aff120db65889774cefc12f29d8f by the way, this bug had been there since the 4.4 release...
        Damien Pobel (Inactive) made changes -
        Remaining Estimate 0 minutes [ 0 ]
        Time Spent 7 hours [ 25200 ]
        Worklog Id 22431 [ 22431 ]
        Damien Pobel (Inactive) made changes -
        Status Development [ 3 ] Devlopment done [ 5 ]
        André Rømcke made changes -
        Status Devlopment done [ 5 ] Documentation done [ 10011 ]
        Hide
        Damien Pobel (Inactive) added a comment -

        Documentation: to upgrade to eZ Publish 5.0, the extension/ezcomments/update/database/<database>/5.0/dbupdate-1.4.0-to-5.0.0.sql has to be imported in the used database.

        Show
        Damien Pobel (Inactive) added a comment - Documentation: to upgrade to eZ Publish 5.0, the extension/ezcomments/update/database/<database>/5.0/dbupdate-1.4.0-to-5.0.0.sql has to be imported in the used database.
        Damien Pobel (Inactive) made changes -
        Time Spent 7 hours [ 25200 ] 1 day [ 28800 ]
        Worklog Id 22431 [ 22431 ]
        Joao Pingo (Inactive) logged work - 05/Nov/12 9:52 AM - edited
        • Time Spent:
          2 hours
           

          Restested and closed

        Joao Pingo (Inactive) made changes -
        Status Documentation done [ 10011 ] QA [ 10008 ]
        Assignee Damien Pobel [ damien.pobel@ez.no ] Joao Pingo [ joao.pingo@ez.no ]
        Hide
        Joao Pingo (Inactive) added a comment -

        Re-Testes using tc-112
        Test Passed ... Approved by QA

        Show
        Joao Pingo (Inactive) added a comment - Re-Testes using tc-112 Test Passed ... Approved by QA
        Joao Pingo (Inactive) made changes -
        Status QA [ 10008 ] QA done [ 10007 ]
        Joao Pingo (Inactive) made changes -
        Time Spent 1 day [ 28800 ] 1 day, 2 hours [ 36000 ]
        Worklog Id 22693 [ 22693 ]
        Joao Pingo (Inactive) made changes -
        Worklog Id 22693 [ 22693 ]
        André Rømcke made changes -
        Assignee Joao Pingo [ joao.pingo@ez.no ]
        Status QA done [ 10007 ] Closed [ 6 ]
        Fix Version/s 5.0.0rc1 [ 11080 ]
        Fix Version/s 5.0 Certification [ 11013 ]
        Fix Version/s QA tracked issues [ 11072 ]
        Resolution Fixed [ 1 ]
        André Rømcke made changes -
        Resolution Fixed [ 1 ]
        Status Closed [ 6 ] Reopened [ 4 ]
        André Rømcke made changes -
        Fix Version/s QA tracked issues [ 11072 ]
        Fix Version/s 5.0 Certification [ 11013 ]
        André Rømcke made changes -
        Status Reopened [ 4 ] Closed [ 6 ]
        Resolution Fixed [ 1 ]
        André Rømcke made changes -
        Workflow eZ Community Workflow [ 34182 ] eZ Engineering Scrumban Workflow [ 48689 ]
        André Rømcke made changes -
        Workflow eZ Engineering Scrumban Workflow [ 48689 ] EZ* Development Workflow [ 83160 ]
        Alex Schuster made changes -
        Workflow EZ* Development Workflow [ 83160 ] EZEE Development Workflow [ 121740 ]
        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open Backlog Backlog
        7d 4h 8m 1 Vidar Langseid 29/Oct/12 4:20 PM
        Backlog Backlog InputQ InputQ
        3s 1 Vidar Langseid 29/Oct/12 4:20 PM
        InputQ InputQ Development Development
        1d 17h 5m 1 damien.pobel@ez.no 31/Oct/12 9:26 AM
        Development Development Development Done Development Done
        6h 22m 1 damien.pobel@ez.no 31/Oct/12 3:49 PM
        Development Done Development Done Documentation Review done Documentation Review done
        1m 30s 1 André Rømcke 31/Oct/12 3:50 PM
        Documentation Review done Documentation Review done QA QA
        4d 19h 24m 1 Joao Pingo (Inactive) 05/Nov/12 11:15 AM
        QA QA QA Done QA Done
        2h 5m 1 Joao Pingo (Inactive) 05/Nov/12 1:20 PM
        QA Done QA Done Closed Closed
        20h 43m 1 André Rømcke 06/Nov/12 10:03 AM
        Closed Closed Reopened Reopened
        2d 5h 26m 1 André Rømcke 08/Nov/12 3:30 PM
        Reopened Reopened Closed Closed
        5m 7s 1 André Rømcke 08/Nov/12 3:35 PM

          People

          • Assignee:
            Unassigned
            Reporter:
            Pedro Resende (Inactive)
          • Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Time Tracking

              Estimated:
              Original Estimate - Not Specified
              Not Specified
              Remaining:
              Remaining Estimate - 0 minutes
              0m
              Logged:
              Time Spent - 1 day, 2 hours
              1d 2h