Using the gc module, when you enter a domain and then are asked
to "Choose a Member to Add as an Administrator", clicking on the
desired administrator's e-mail kicks up a "Server Error" page
(OpenACS 3.2.5).
Here's what the log says...
[01/Sep/2001:17:02:09][6554.67591][-conn13-] Notice: Querying 'select
ad_group_member_p(3, system_administrator_group_id()) from dual;'
[01/Sep/2001:17:02:09][6554.67591][-conn13-] Notice: dbinit: sql
(localhost::buxs): 'select ad_group_member_p(3,
system_administrator_group_id()) from dual'
[01/Sep/2001:17:02:09][6554.67591][-conn13-] Error: Ns_PgExec: result
status: 7 message: ERROR: ExecAppend: Fail to add null value in not
null attribute creation_user
[01/Sep/2001:17:02:09][6554.67591][-conn13-] Error: dbinit: error
(localhost::buxs,ERROR: ExecAppend: Fail to add null value in not
null attribute creation_user
): 'select administration_group_add('Admin group for the misc
classifieds', short_name_from_group_name('Admin group for the misc
classifieds'), 'gc', 'misc', 'f', '/gc/admin/domain-top.tcl?
domain=misc')'
[01/Sep/2001:17:02:09][6554.67591][-conn13-] Error: Database
operation "select" failed (exception NSDB, "Query was not a statement
returning rows.")
Database operation "select" failed (exception NSDB, "Query was not a
statement returning rows.")
while executing
"ns_db select $db "select administration_group_add('Admin group for
the $QQdomain classifieds', short_name_from_group_name('Admin group
for the $QQdoma..."
(file "/web/buxs/www/admin/gc/domain-add-2.tcl" line 45)
invoked from within
"source $script"
(procedure "ns_sourceproc" line 6)
invoked from within
"ns_sourceproc cns121 {}"
[01/Sep/2001:17:02:09][6554.67591][-conn13-] Notice: Querying 'select
* from referer_log_glob_patterns;'
[01/Sep/2001:17:02:09][6554.67591][-conn13-] Notice: dbinit: sql
(localhost::buxs): 'select * from referer_log_glob_patterns'
[01/Sep/2001:17:02:09][6554.67591][-conn13-] Notice: Querying 'update
referer_log set click_count = click_count + 1
where local_url = '/admin/gc/domain-add-2.tcl'
and foreign_url = 'http://buxs.net/user-search.tcl'
and trunc(entry_date) = trunc(sysdate());'
[01/Sep/2001:17:02:09][6554.67591][-conn13-] Notice: dbinit: sql
(localhost::buxs): 'update referer_log set click_count = click_count
+ 1
where local_url = '/admin/gc/domain-add-2.tcl'
and foreign_url = 'http://buxs.net/user-search.tcl'
and trunc(entry_date) = trunc(sysdate())'