Details
-
Bug
-
Resolution: Fixed
-
Medium
-
5.0.0-dev, 5.0.0beta2
-
Operating System: RHEL 6.3
PHP Version: 5.3.3
Database and version: Oracle 11.2.0.1.0
Browser (and version): Firefox 16.0.1
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