mahara-contributors team mailing list archive

[Ghada El-Zoghbi <ghada@xxxxxxxxxxxxxxx>]

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