mahara-contributors team mailing list archive

[Robert Lyon <robertl@xxxxxxxxxxxxxxx>]

Have made patch
https://reviews.mahara.org/#/c/2863/

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.

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it!
https://bugs.launchpad.net/bugs/1265696

Title:
  Can't edit access to profile after "Logged-in profile access" turned
  on

Status in Mahara ePortfolio:
  In Progress

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/adodb-exceptions.inc.php:43) Array to string conversion
  [WAR] 25 (lib/errors.php:736) 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)
  [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

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1265696/+subscriptions