Can't edit access to profile after "Logged-in profile access" turned on
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Mahara |
Fix Released
|
Medium
|
Robert Lyon |
Bug Description
Steps to reproduce:
- Turn off "Logged-in profile access" in Administration -> Configure site -> Site options
- Remove "Logged-in users" from the access list on your profile page
- Turn "Logged-in profile access" back on
- Try to edit access to your profile page
This spews out various errors and prevents you from accessing the page:
[WAR] 25 (lib/adodb/
[WAR] 25 (lib/errors.
Command was: INSERT INTO "view_access" ("view", "accesstype", "allowcomments", "approvecomments") VALUES (?, ?, ?, ?) and values was (4,loggedin,0,1)
[WAR] 25 (lib/dml.php:1053) Failed to get a recordset: postgres7 error: [-1: ERROR: null value in column "ctime" violates not-null constraint] in adodb_throw(INSERT INTO "view_access" ("view", "accesstype", "allowcomments", "approvecomments") VALUES (?, ?, ?, ?), Array)
Command was: INSERT INTO "view_access" ("view", "accesstype", "allowcomments", "approvecomments") VALUES (?, ?, ?, ?) and values was (4,loggedin,0,1)
Affects latest master
Changed in mahara: | |
importance: | Undecided → Medium |
assignee: | nobody → Robert Lyon (robertl-9) |
milestone: | none → 1.9.0 |
status: | New → In Progress |
Changed in mahara: | |
status: | In Progress → Fix Committed |
Changed in mahara: | |
status: | Fix Committed → Fix Released |
Have made patch /reviews. mahara. org/#/c/ 2863/
https:/
The patch checks to see if a row already exists in the view_access table and if not add the ctime to the object used to ensure that row exists, allowing for proper insertion further down the process chain.