** Also affects: mahara/19.10
Importance: Undecided
Status: New
** Also affects: mahara/19.04
Importance: Undecided
Status: New
** Changed in: mahara/19.10
Status: New => Confirmed
** Changed in: mahara/19.04
Status: New => Confirmed
** Changed in: mahara/19.10
Importance: Undecided => High
** Changed in: mahara/19.04
Importance: Undecided => High
** Changed in: mahara/19.10
Milestone: None => 19.10.0
** Changed in: mahara/19.04
Milestone: None => 19.04.1
--
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:
Confirmed
Status in Mahara 19.04 series:
Confirmed
Status in Mahara 19.10 series:
Confirmed
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
