*** This bug is a duplicate of bug 1034268 ***
https://bugs.launchpad.net/bugs/1034268
Looks like bug #1034268 that has been fixed. Though i may of been wrong
with mysql, may of been postgres xD
** This bug has been marked a duplicate of bug 1034268
Can't delete an institution on mysql
--
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
https://bugs.launchpad.net/bugs/1036664
Title:
Deleting institution brings warning
Status in Mahara ePortfolio:
Invalid
Bug description:
I want to delete 1 institution from my instance (master). That
institution had 1 user which I removed from the institution. The user
does not have any auth method from the institution to be deleted
anymore. When I attempt the deletion process, the following warnings
are displayed and a generic "Site unavailable" message displayed.
Might this be similar to what was already be fixed in Bug #548166?
[WAR] fb (lib/errors.php:749) Failed to get a recordset: postgres7 error:
[-1: ERROR: update or delete on table "institution" violates foreign key
constraint "instdata_ins_fk" on table "institution_data"
DETAIL: Key (name)=(test) is still referenced from table
"institution_data".] in adodb_throw(DELETE FROM "institution" WHERE "name" = ?
, Array)
Command was: DELETE FROM "institution" WHERE "name" = ? and values was
(test)
Call stack (most recent first):
log_message("Failed to get a recordset: postgres7 error: [-1: E...", 8,
true, true) at /home/kristina/code/mahara/htdocs/lib/errors.php:109
log_warn("Failed to get a recordset: postgres7 error: [-1: E...") at
/home/kristina/code/mahara/htdocs/lib/errors.php:749
SQLException->__construct("Failed to get a recordset: postgres7 error:
[-1: E...") at /home/kristina/code/mahara/htdocs/lib/dml.php:932
delete_records("institution", "name", "test") at
/home/kristina/code/mahara/htdocs/admin/users/institutions.php:168
delete_submit(object(Pieform), array(size 4)) at Unknown:0
call_user_func_array("delete_submit", array(size 2)) at
/home/kristina/code/mahara/htdocs/lib/pieforms/pieform.php:514
Pieform->__construct(array(size 2)) at
/home/kristina/code/mahara/htdocs/lib/pieforms/pieform.php:161
Pieform::process(array(size 2)) at
/home/kristina/code/mahara/htdocs/lib/pieforms/pieform.php:71
pieform(array(size 2)) at
/home/kristina/code/mahara/htdocs/admin/users/institutions.php:191
[WAR] fb (lib/dml.php:932) Failed to get a recordset: postgres7 error: [-1:
ERROR: update or delete on table "institution" violates foreign key constraint
"instdata_ins_fk" on table "institution_data"
DETAIL: Key (name)=(test) is still referenced from table
"institution_data".] in adodb_throw(DELETE FROM "institution" WHERE "name" = ?
, Array)
Command was: DELETE FROM "institution" WHERE "name" = ? and values was
(test)
Call stack (most recent first):
delete_records("institution", "name", "test") at
/home/kristina/code/mahara/htdocs/admin/users/institutions.php:168
delete_submit(object(Pieform), array(size 4)) at Unknown:0
call_user_func_array("delete_submit", array(size 2)) at
/home/kristina/code/mahara/htdocs/lib/pieforms/pieform.php:514
Pieform->__construct(array(size 2)) at
/home/kristina/code/mahara/htdocs/lib/pieforms/pieform.php:161
Pieform::process(array(size 2)) at
/home/kristina/code/mahara/htdocs/lib/pieforms/pieform.php:71
pieform(array(size 2)) at
/home/kristina/code/mahara/htdocs/admin/users/institutions.php:191
To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1036664/+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
