Steps to reproduce: 1. Create an institution with xml-rpc integration with a Moodle. Allow submissions from Mahara to Moodle.
2. Add users to the new institution in Mahara. 3. In Moodle, create a course with an activity - Mahara submission. Make sure the Mahara user is enrolled in this course. 4. As a user of the institution, create a page in Mahara and submit the page to Moodle. 5. As an admin of Mahara, remove all users from the institution. This will enable the 'delete' button for the institution. 6. Try to delete the institution. You should receive the error above. -- 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 Instution Due to Foreign Key Constraint with View Table Status in Mahara: New 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
