Reviewed: https://reviews.mahara.org/10581 Committed: https://git.mahara.org/mahara/mahara/commit/46ded34bc7ba35725ba628c0b01dd7b5405bccdf Submitter: Robert Lyon (robe...@catalyst.net.nz) Branch: 19.04_STABLE
commit 46ded34bc7ba35725ba628c0b01dd7b5405bccdf Author: Cecilia Vela Gurovic <cecili...@catalyst.net.nz> Date: Fri Oct 11 15:05:54 2019 +1300 Bug 1829943: Release submitted portfolios when deleting an institution behatnotneeded Change-Id: I70e3c27b91bb3b6ec5afd749f3a441e23ce5afc0 (cherry picked from commit 7ba35ae895750ff3215e883cdbd18c473a7a2337) -- 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/1829943 Title: Error deleting institution due to foreign key constraint with view table Status in Mahara: Fix Committed Status in Mahara 19.04 series: Fix Committed Status in Mahara 19.10 series: Fix Committed Status in Mahara 20.04 series: Fix Committed Bug description: Mahara: 19.04.0 OS: Linux DB: Postgres Browser: FF We have an institution which no longer has any users. When trying to delete it, it fails due to the foreign key constraint with the view table - which now has the institution field. Call stack (most recent first): log_message("Array to string conversion", 8, true, true, "/var/www/mahara/htdocs/lib/adodb/adodb...", 45) at /var/www/mahara/htdocs/lib/errors.php:520 error(8, "Array to string conversion", "/var/www/mahara/htdocs/lib/adodb/adodb...", 45, array(size 7)) at /var/www/mahara/htdocs/lib/adodb/adodb-exceptions.inc.php:45 ADODB_Exception->__construct("postgres8", "adodb_throw", -1, "ERROR: update or delete on table "host" violates ...", "DELETE FROM "host" WHERE "institution" = ? ", array(size 1), object(ADODB_postgres8)) at /var/www/mahara/htdocs/lib/adodb/adodb-exceptions.inc.php:80 adodb_throw("postgres8", "adodb_throw", -1, "ERROR: update or delete on table "host" violates ...", "DELETE FROM "host" WHERE "institution" = ? ", array(size 1), object(ADODB_postgres8)) at /var/www/mahara/htdocs/lib/adodb/adodb.inc.php:310 ADODB_TransMonitor("postgres8", "adodb_throw", -1, "ERROR: update or delete on table "host" violates ...", "DELETE FROM "host" WHERE "institution" = ? ", array(size 1), object(ADODB_postgres8)) at /var/www/mahara/htdocs/lib/adodb/adodb.inc.php:1281 ADOConnection->_Execute("DELETE FROM "host" WHERE "institution" = ? ", array(size 1)) at /var/www/mahara/htdocs/lib/adodb/adodb.inc.php:1241 ADOConnection->Execute("DELETE FROM "host" WHERE "institution" = ? ", array(size 1)) at /var/www/mahara/htdocs/lib/dml.php:981 delete_records("host", "institution", "mytest") at /var/www/mahara/htdocs/admin/users/institutions.php:175 delete_submit(object(Pieform), array(size 4)) at /var/www/mahara/htdocs/lib/pieforms/pieform.php:544 Pieform->__construct(array(size 2)) at /var/www/clients/htdocs/lib/pieforms/pieform.php:166 Pieform::process(array(size 2)) at /var/www/clients/htdocs/lib/mahara.php:5379 pieform(array(size 2)) at /var/www/mahara/htdocs/admin/users/institutions.php:217 [WAR] 55 (lib/errors.php:858) Failed to get a recordset: postgres8 error: [-1: ERROR: update or delete on table "host" violates foreign key constraint "view_sub2_fk" on table "view" DETAIL: Key (wwwroot)=(https://mytest.com.au) is still referenced from table "view".] in adodb_throw(DELETE FROM "host" WHERE "institution" = ? , Array)Command was: DELETE FROM "host" WHERE "institution" = ? and values was (0:mytest) There are records in the view table that have submitted pages to this institution. It's setup with XML-RPC with a Moodle. To manage notifications about this bug go to: https://bugs.launchpad.net/mahara/+bug/1829943/+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