Forum OpenACS Q&A: Intranet / Deleting customer
permission problems. I have now various customer groups with
identical names, but different id's:
Subgroups
Foo (0 members)
Foo (1 member)
Internal (0 members)
Klutz Corp (1 member)
Semandex (0 members)
The Whole Wide World (0 members)
The Whole Wide World (0 members)
If I know try to delete on of the customers (id=18) I get the
following:
-----
For url: /admin/ug/group-delete-2.tcl?group_id=18
Deleting the user-group mappings for groups of this type... 0 rows
deleted.
Deleting group type specific fields...
Deleting group specific member fields... 0 rows deleted.
Deleting group permissions... 0 rows deleted.
Deleting permission mappings... 0 rows deleted.
Deleting group actions... 0 rows deleted.
Deleting The Whole Wide World content section links... 0 rows
deleted.
Deleting The Whole Wide World content section files... 0 rows
deleted.
Deleting The Whole Wide World content sections... 0 rows deleted.
Deleting The Whole Wide World faqs... 0 rows deleted.
Deleting The Whole Wide World logo... 0 rows deleted.
Deleting The Whole Wide World css... 0 rows deleted.
Deleting The Whole Wide World downloads ... 0 rows deleted.
Deleting this group... HTTP/1.0 500 Internal Server Error MIME-
Version: 1.0 Date: Mon, 30 Jul 2001 17:16:50 GMT Server:
AOLserver/3.4 Content-Type: text/html Content-Length: 540 Connection:
close
Server Error
The requested URL cannot be accessed due to a system error on this
server.
-----
[30/Jul/2001:13:59:21][23680.19462][-conn3-] Notice: Querying 'select
ad_group_mem
ber_p(1, system_administrator_group_id()) from dual;'
[30/Jul/2001:13:59:21][23680.19462][-conn3-] Notice: dbinit: sql
(localhost::semand
ex): 'select ad_group_member_p(1, system_administrator_group_id())
from dual'
[30/Jul/2001:13:59:21][23680.19462][-conn3-] Error: Ns_PgExec: result
status: 7 me
ssage: ERROR: <unnamed> referential integrity violation - key in
user_groups stil
l referenced from im_customers
[30/Jul/2001:13:59:21][23680.19462][-conn3-] Error: dbinit: error
(localhost::seman
dex,ERROR: <unnamed> referential integrity violation - key in
user_groups still r
eferenced from im_customers
): 'delete from user_groups where group_id = 18'
[30/Jul/2001:13:59:21][23680.19462][-conn3-] Error: Database
operation "dml" faile
d
Database operation "dml" failed
while executing
"ns_db dml $db "delete from user_groups where group_id = $group_id""
(file "/usr/local/etc/web/servers/acs/www/admin/ug/group-delete-
2.tcl" line 15
2)
invoked from within
"source $script"
(procedure "ns_sourceproc" line 6)
invoked from within
"ns_sourceproc cns58 {}"
------
If I go in as common user I don't see any customers and if I create a
project it shows up multiple times, appearingly (?) once for every
existing customer - however, following the link does show the same
customer.
I'm not sure if I corrupted the database.
Any help would be greatly appriciated,
Thanks,
-max
p.s. Using openacs-3.2.5.
