Another thing you can do is check to see if there are any other broken
groups

SELECT id, name FROM `group` WHERE id NOT IN (SELECT `group` FROM view
WHERE `group` > 0 AND type = 'grouphomepage') AND deleted = 0;

It should return an empty set if all groups are fine.

-- 
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/1632717

Title:
  Bugs after updating Mahara

Status in Mahara:
  Incomplete

Bug description:
  Hello,

  After the update to the latest version of Mahara (16.04) I have
  problems with the display pages of the groups.

  Here is an example :

  [WAR] 1b (lib/group.php:2338) Trying to get property of non-object
  Call stack (most recent first):

      log_message(string(size 36), integer, true, true, string(size 53), 
integer) at /mypath/maha/lib/errors.php:513
      error(integer, string(size 36), string(size 53), integer, array(size 2)) 
at /mypath/maha/lib/group.php:2338
      group_get_homepage_view(string(size 2)) at /mypath/maha/lib/view.php:5734
      View->display_author() at /mypath/maha/view/view.php:362

  [WAR] 1b (lib/errors.php:820) Failed to get a recordset: mysqli error: [1452: 
Cannot add or update a child row: a foreign key constraint fails 
("mybdd"."view", CONSTRAINT "view_ibfk_7" FOREIGN KEY ("type") REFERENCES 
"view_type" ("type"))] in EXECUTE("INSERT INTO "view" ("ctime", "mtime", 
"atime", "copynewuser", "anonymise") VALUES ('2016-10-12 15:32:22', '2016-10-12 
15:32:22', '2016-10-12 15:32:22', 0, 0)")
  Command was: INSERT INTO "view" ("ctime", "mtime", "atime", "copynewuser", 
"anonymise") VALUES (?, ?, ?, ?, ?) and values was 
(ctime:2016-10-1215:32:22,mtime:2016-10-1215:32:22,atime:2016-10-1215:32:22,copynewuser:0,anonymise:0)
  Call stack (most recent first):

      log_message(string(size 618), integer, true, true) at 
/mypath/maha/lib/errors.php:95
      log_warn(string(size 618)) at /mypath/maha/lib/errors.php:820
      SQLException->__construct(string(size 618)) at 
/mypath/maha/lib/dml.php:1088
      insert_record(string(size 4), object(stdClass), string(size 2), true) at 
/mypath/maha/lib/view.php:728
      View->commit() at /mypath/maha/lib/view.php:702
      View->__destruct() at /mypath/maha/view/view.php:362
      View->display_author() at /mypath/maha/view/view.php:362

  [WAR] 1b (lib/dml.php:1088) Failed to get a recordset: mysqli error: [1452: 
Cannot add or update a child row: a foreign key constraint fails 
("mybdd"."view", CONSTRAINT "view_ibfk_7" FOREIGN KEY ("type") REFERENCES 
"view_type" ("type"))] in EXECUTE("INSERT INTO "view" ("ctime", "mtime", 
"atime", "copynewuser", "anonymise") VALUES ('2016-10-12 15:32:22', '2016-10-12 
15:32:22', '2016-10-12 15:32:22', 0, 0)")
  Command was: INSERT INTO "view" ("ctime", "mtime", "atime", "copynewuser", 
"anonymise") VALUES (?, ?, ?, ?, ?) and values was 
(ctime:2016-10-1215:32:22,mtime:2016-10-1215:32:22,atime:2016-10-1215:32:22,copynewuser:0,anonymise:0)
  Call stack (most recent first):

      insert_record(string(size 4), object(stdClass), string(size 2), true) at 
/mypath/maha/lib/view.php:728
      View->commit() at /mypath/maha/lib/view.php:702
      View->__destruct() at /mypath/maha/view/view.php:362
      View->display_author() at /mypath/maha/view/view.php:362

  Untitled
  Mywebsite Mahara : Site unavailable
  A nonrecoverable error occurred. This probably means you have encountered a 
bug in the system

  Thank you for your help.

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

_______________________________________________
Mailing list: https://launchpad.net/~mahara-contributors
Post to     : mahara-contributors@lists.launchpad.net
Unsubscribe : https://launchpad.net/~mahara-contributors
More help   : https://help.launchpad.net/ListHelp

Reply via email to