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

(Oracle) Adding Comments as anonymous generate a database error

    XMLWordPrintable

Details

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Medium Medium
    • None
    • 4.6.0
    • None
    • Operating System: RHEL 6.1
      PHP Version: 5.3.3
      Database and version: Oracle 11g
      Browser (and version):

    Description

      After giving access so that anonymous user's can create a comment, every time a add a comment the redirect debug is showing the following error:

      Error: eZOracleDB::query() 	Feb 06 2012 15:24:57
      
      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, 1328538297, 1328538297, 10, '', '192.168.2.117', 60, 0, 'Commenter 1', 'test@qa.ez', 'www.testqa.ez.no', 'This is my test comment', 1, 'My Comment')
      
      Start of error:
      '', '192.168.2.117', 60, 0, 'Commenter 1', 'test@qa.ez', 'www.testqa.ez.no', 'This is my test comment', 1, 'My Comment') 
      

      Related to tc-240

      Steps to reproduce

      1. Enable Debug Redirect
      2. Edit anonymous role adding permission to add/read comments
      3. Create an article with comments enabled
      4. On frontend add a comment as anonymous to this article
      5. Verify that the error is present in the debug (check attachment)

      Attachments

        Activity

          People

            unknown unknown
            jpingo jpingo
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated: