Forum OpenACS Q&A: Error adding new users to translation server

There are 29 pending users on translate.openacs.org. I've tried to approve several but I get the error: Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.") ERROR: Cannot insert a duplicate key into unique index cr_items_unique_name The site has been upgraded to OpenACS 5.1 and .LRN 2.0.3. It would be very helpful if someone could take over debugging this or suggest a workaround, since it's apparently preventing a number of people from contributing translation work.
Collapse
Posted by Don Baccus on
Can you turn on SQL logging so we can see what the duplicate key is?
Collapse
Posted by Joel Aufrecht on
[24/Jun/2004:07:56:11][15077.1095707440][-conn:translate-51::0] Debug: NO FULLQUERY FOR dbqd.dotlrn.www.admin.user-new-2.select_user_info --> using default SQL
[24/Jun/2004:07:56:11][15077.1095707440][-conn:translate-51::0] Notice: Querying '
select email,
first_names,
last_name
from registered_users
where user_id = '43276';'
[24/Jun/2004:07:56:11][15077.1095707440][-conn:translate-51::0] Notice: dbinit: sql(localhost::translate-51): '
select email,
first_names,
last_name
from registered_users
where user_id = '43276'
'
[24/Jun/2004:07:56:11][15077.1095707440][-conn:translate-51::0] Notice: Querying '
select pretty_name,
type
from dotlrn_user_types
order by pretty_name;'
[24/Jun/2004:07:56:11][15077.1095707440][-conn:translate-51::0] Notice: dbinit: sql(localhost::translate-51): '
select pretty_name,
type
from dotlrn_user_types
order by pretty_name
'
[24/Jun/2004:07:56:11][15077.1095707440][-conn:translate-51::0] Notice: Querying '
select apm_parameter_values.attr_value
from apm_parameters, apm_parameter_values
where apm_parameter_values.package_id = '65'
and apm_parameter_values.parameter_id = apm_parameters.parameter_id
and apm_parameters.parameter_name = 'SystemOwner';'
[24/Jun/2004:07:56:11][15077.1095707440][-conn:translate-51::0] Notice: dbinit: sql(localhost::translate-51): '
select apm_parameter_values.attr_value
from apm_parameters, apm_parameter_values
where apm_parameter_values.package_id = '65'
and apm_parameter_values.parameter_id = apm_parameters.parameter_id
and apm_parameters.parameter_name = 'SystemOwner'
'
[24/Jun/2004:07:56:11][15077.1095707440][-conn:translate-51::0] Notice: Querying 'begin transaction;'
[24/Jun/2004:07:56:11][15077.1095707440][-conn:translate-51::0] Notice: Ns_PgExec: Entering transaction
[24/Jun/2004:07:56:11][15077.1095707440][-conn:translate-51::0] Notice: dbinit: sql(localhost::translate-51): 'begin transaction'
[24/Jun/2004:07:56:11][15077.1095707440][-conn:translate-51::0] Debug: NO FULLQUERY FOR dbqd.dotlrn.tcl.dotlrn-security-procs.dotlrn::user_p.select_count --> using default SQL
[24/Jun/2004:07:56:11][15077.1095707440][-conn:translate-51::0] Notice: Querying '
select count(*)
from dual
where exists (select 1
from dotlrn_users
where user_id = '43276');'
[24/Jun/2004:07:56:11][15077.1095707440][-conn:translate-51::0] Notice: dbinit: sql(localhost::translate-51): '
select count(*)
from dual
where exists (select 1
from dotlrn_users
where user_id = '43276')
'
[24/Jun/2004:07:56:11][15077.1095707440][-conn:translate-51::0] Notice: Querying '
select portal_id from dotlrn_portal_types_map where type = 'user';'
[24/Jun/2004:07:56:11][15077.1095707440][-conn:translate-51::0] Notice: dbinit: sql(localhost::translate-51): '
select portal_id from dotlrn_portal_types_map where type = 'user'
'
[24/Jun/2004:07:56:11][15077.1095707440][-conn:translate-51::0] Debug: PLPGSQL: bypassed anon function
[24/Jun/2004:07:56:11][15077.1095707440][-conn:translate-51::0] Notice: Querying '
select acs_permission__grant_permission(
'1383',
'43276',
'dotlrn_browse'
);'
[24/Jun/2004:07:56:11][15077.1095707440][-conn:translate-51::0] Notice: dbinit: sql(localhost::translate-51): '
select acs_permission__grant_permission(
'1383',
'43276',
'dotlrn_browse'
);
'
[24/Jun/2004:07:56:11][15077.1095707440][-conn:translate-51::0] Notice: Querying '
select layout_id
from portal_layouts
where name = '<span>#</span>new-portal.simple_2column_layout_name#';'
[24/Jun/2004:07:56:12][15077.1095707440][-conn:translate-51::0] Notice: dbinit: sql(localhost::translate-51): '
select layout_id
from portal_layouts
where name = '<span>#</span>new-portal.simple_2column_layout_name#'
'
[24/Jun/2004:07:56:12][15077.1095707440][-conn:translate-51::0] Notice: Querying '
select layout_id
from portal_layouts
where name = '<span>#</span>new-portal.simple_2column_layout_name#';'
[24/Jun/2004:07:56:12][15077.1095707440][-conn:translate-51::0] Notice: dbinit: sql(localhost::translate-51): '
select layout_id
from portal_layouts
where name = '<span>#</span>new-portal.simple_2column_layout_name#'
'
[24/Jun/2004:07:56:12][15077.1095707440][-conn:translate-51::0] Debug: NO FULLQUERY FOR dbqd..NULL --> using default SQL
[24/Jun/2004:07:56:12][15077.1095707440][-conn:translate-51::0] Notice: Querying '
select package_id from apm_packages where package_key = 'new-portal';'
[24/Jun/2004:07:56:12][15077.1095707440][-conn:translate-51::0] Notice: dbinit: sql(localhost::translate-51): '
select package_id from apm_packages where package_key = 'new-portal'
'
[24/Jun/2004:07:56:12][15077.1095707440][-conn:translate-51::0] Debug: NO FULLQUERY FOR dbqd..NULL --> using default SQL
[24/Jun/2004:07:56:12][15077.1095707440][-conn:translate-51::0] Notice: Querying '
select package_key from apm_packages where package_id = '489';'
[24/Jun/2004:07:56:12][15077.1095707440][-conn:translate-51::0] Notice: dbinit: sql(localhost::translate-51): '
select package_key from apm_packages where package_id = '489'
'
[24/Jun/2004:07:56:12][15077.1095707440][-conn:translate-51::0] Notice: Querying '
select apm_parameter_values.attr_value
from apm_parameters, apm_parameter_values
where apm_parameter_values.package_id = '489'
and apm_parameter_values.parameter_id = apm_parameters.parameter_id
and apm_parameters.parameter_name = 'default_theme_name';'
[24/Jun/2004:07:56:12][15077.1095707440][-conn:translate-51::0] Notice: dbinit: sql(localhost::translate-51): '
select apm_parameter_values.attr_value
from apm_parameters, apm_parameter_values
where apm_parameter_values.package_id = '489'
and apm_parameter_values.parameter_id = apm_parameters.parameter_id
and apm_parameters.parameter_name = 'default_theme_name'
'
[24/Jun/2004:07:56:12][15077.1095707440][-conn:translate-51::0] Notice: Querying '
select theme_id
from portal_element_themes
where name = '<span>#</span>new-portal.sloan_theme_name#';'
[24/Jun/2004:07:56:12][15077.1095707440][-conn:translate-51::0] Notice: dbinit: sql(localhost::translate-51): '
select theme_id
from portal_element_themes
where name = '<span>#</span>new-portal.sloan_theme_name#'
'
[24/Jun/2004:07:56:12][15077.1095707440][-conn:translate-51::0] Debug: PLPGSQL: bypassed anon function
[24/Jun/2004:07:56:12][15077.1095707440][-conn:translate-51::0] Notice: Querying '
select portal__new(
null,
'Your dotLRN Workspace',
'474',
'468',
'1467',
'Page 1',
'portal',
now(),
null,
null,
NULL
);'
NOTICE: Adding missing FROM-clause entry for table "acs_object_id_seq"
NOTICE: Adding missing FROM-clause entry for table "acs_object_id_seq"
NOTICE: Adding missing FROM-clause entry for table "acs_object_id_seq"
[24/Jun/2004:07:56:12][15077.1095707440][-conn:translate-51::0] Notice: dbinit: sql(localhost::translate-51): '
select portal__new(
null,
'Your dotLRN Workspace',
'474',
'468',
'1467',
'Page 1',
'portal',
now(),
null,
null,
NULL
);
'
[24/Jun/2004:07:56:12][15077.1095707440][-conn:translate-51::0] Debug: PLPGSQL: bypassed anon function
[24/Jun/2004:07:56:12][15077.1095707440][-conn:translate-51::0] Notice: Querying '
select acs_permission__grant_permission(
'44713',
'43276',
'portal_read_portal'
);'
[24/Jun/2004:07:56:12][15077.1095707440][-conn:translate-51::0] Notice: dbinit: sql(localhost::translate-51): '
select acs_permission__grant_permission(
'44713',
'43276',
'portal_read_portal'
);
'
[24/Jun/2004:07:56:12][15077.1095707440][-conn:translate-51::0] Debug: PLPGSQL: bypassed anon function
[24/Jun/2004:07:56:12][15077.1095707440][-conn:translate-51::0] Notice: Querying '
select acs_permission__grant_permission(
'44713',
'43276',
'portal_edit_portal'
);'
[24/Jun/2004:07:56:12][15077.1095707440][-conn:translate-51::0] Notice: dbinit: sql(localhost::translate-51): '
select acs_permission__grant_permission(
'44713',
'43276',
'portal_edit_portal'
);
'
[24/Jun/2004:07:56:12][15077.1095707440][-conn:translate-51::0] Debug: PLPGSQL: bypassed anon function
[24/Jun/2004:07:56:12][15077.1095707440][-conn:translate-51::0] Notice: Querying '
select acs_permission__grant_permission(
'44713',
'43276',
'portal_admin_portal'
);'
[24/Jun/2004:07:56:12][15077.1095707440][-conn:translate-51::0] Notice: dbinit: sql(localhost::translate-51): '
select acs_permission__grant_permission(
'44713',
'43276',
'portal_admin_portal'
);
'
[24/Jun/2004:07:56:12][15077.1095707440][-conn:translate-51::0] Debug: NO FULLQUERY FOR dbqd.acs-subsite.tcl.relation-procs.relation_add.rel_exists --> using default SQL
[24/Jun/2004:07:56:12][15077.1095707440][-conn:translate-51::0] Notice: Querying '
select rel_id
from acs_rels
where rel_type = 'dotlrn_professor_profile_rel'
and object_id_one = NULL
and object_id_two = '43276';'
[24/Jun/2004:07:56:12][15077.1095707440][-conn:translate-51::0] Notice: dbinit: sql(localhost::translate-51): '
select rel_id
from acs_rels
where rel_type = 'dotlrn_professor_profile_rel'
and object_id_one = NULL
and object_id_two = '43276'
'
[24/Jun/2004:07:56:12][15077.1095707440][-conn:translate-51::0] Notice: Querying '

select t.package_name
from acs_object_types t
where t.object_type = 'dotlrn_professor_profile_rel';'
[24/Jun/2004:07:56:12][15077.1095707440][-conn:translate-51::0] Notice: dbinit: sql(localhost::translate-51): '

select t.package_name
from acs_object_types t
where t.object_type = 'dotlrn_professor_profile_rel'

'
[24/Jun/2004:07:56:12][15077.1095707440][-conn:translate-51::0] Notice: Querying '
select args.arg_name
from acs_function_args args
where args.function = upper('dotlrn_professor_profile_rel') || '__' || upper('NEW');'
[24/Jun/2004:07:56:12][15077.1095707440][-conn:translate-51::0] Notice: dbinit: sql(localhost::translate-51): '
select args.arg_name
from acs_function_args args
where args.function = upper('dotlrn_professor_profile_rel') || '__' || upper('NEW')
'
[24/Jun/2004:07:56:12][15077.1095707440][-conn:translate-51::0] Debug: PLPGSQL: bypassed anon function
[24/Jun/2004:07:56:12][15077.1095707440][-conn:translate-51::0] Notice: Querying '
select arg_name, arg_default
from acs_function_args
where function = upper('dotlrn_professor_profile_rel__new')
order by arg_seq;'
[24/Jun/2004:07:56:12][15077.1095707440][-conn:translate-51::0] Notice: dbinit: sql(localhost::translate-51): '
select arg_name, arg_default
from acs_function_args
where function = upper('dotlrn_professor_profile_rel__new')
order by arg_seq
'
[24/Jun/2004:07:56:12][15077.1095707440][-conn:translate-51::0] Notice: Querying '

select dotlrn_professor_profile_rel__new(NULL,'43276','44713',NULL,'mailto:jpaguirre@ebstudio.com';,'dotlrn_professor_profile_rel',NULL,'14005','213.150.51.67');'
NOTICE: Adding missing FROM-clause entry for table "acs_object_id_seq"
[24/Jun/2004:07:56:13][15077.1095707440][-conn:translate-51::0] Notice: dbinit: sql(localhost::translate-51): '

select dotlrn_professor_profile_rel__new(NULL,'43276','44713',NULL,'mailto:jpaguirre@ebstudio.com';,'dotlrn_professor_profile_rel',NULL,'14005','213.150.51.67')

'
[24/Jun/2004:07:56:13][15077.1095707440][-conn:translate-51::0] Notice: Querying '

select distinct callback, callback_type
from subsite_callbacks
where object_type in (select t2.object_type
from acs_object_types t1, acs_object_types t2
where t2.tree_sortkey <= t1.tree_sortkey
and t1.tree_sortkey between t2.tree_sortkey and tree_right(t2.tree_sortkey)
and t1.object_type = 'dotlrn_professor_profile_rel')
and event_type = 'insert';'
[24/Jun/2004:07:56:13][15077.1095707440][-conn:translate-51::0] Notice: dbinit: sql(localhost::translate-51): '

select distinct callback, callback_type
from subsite_callbacks
where object_type in (select t2.object_type
from acs_object_types t1, acs_object_types t2
where t2.tree_sortkey <= t1.tree_sortkey
and t1.tree_sortkey between t2.tree_sortkey and tree_right(t2.tree_sortkey)
and t1.object_type = 'dotlrn_professor_profile_rel')
and event_type = 'insert'

'
[24/Jun/2004:07:56:13][15077.1095707440][-conn:translate-51::0] Notice: Querying '
select applet_key
from dotlrn_applets;'
[24/Jun/2004:07:56:13][15077.1095707440][-conn:translate-51::0] Notice: dbinit: sql(localhost::translate-51): '
select applet_key
from dotlrn_applets
'
[24/Jun/2004:07:56:13][15077.1095707440][-conn:translate-51::0] Debug: NO FULLQUERY FOR dbqd.dotlrn-fs.tcl.dotlrn-fs-procs.dotlrn_fs::add_user.select_user_name --> using default SQL
[24/Jun/2004:07:56:13][15077.1095707440][-conn:translate-51::0] Notice: Querying '
select first_names || ' ' || last_name
from persons
where person_id = '43276';'
[24/Jun/2004:07:56:13][15077.1095707440][-conn:translate-51::0] Notice: dbinit: sql(localhost::translate-51): '
select first_names || ' ' || last_name
from persons
where person_id = '43276'
'
[24/Jun/2004:07:56:13][15077.1095707440][-conn:translate-51::0] Notice: Querying '
select sn1.object_id
from site_nodes sn1,
apm_packages
where sn1.parent_id = (select sn2.node_id
from site_nodes sn2
where sn2.object_id = '1383')
and sn1.object_id = apm_packages.package_id
and apm_packages.package_key = 'file-storage';'
[24/Jun/2004:07:56:13][15077.1095707440][-conn:translate-51::0] Notice: dbinit: sql(localhost::translate-51): '
select sn1.object_id
from site_nodes sn1,
apm_packages
where sn1.parent_id = (select sn2.node_id
from site_nodes sn2
where sn2.object_id = '1383')
and sn1.object_id = apm_packages.package_id
and apm_packages.package_key = 'file-storage'
'
[24/Jun/2004:07:56:13][15077.1095707440][-conn:translate-51::0] Debug: PLPGSQL: bypassed anon function
[24/Jun/2004:07:56:13][15077.1095707440][-conn:translate-51::0] Notice: Querying '
select file_storage__get_root_folder('1432');'
WARNING: Error occurred while executing PL/pgSQL function content_item__new
WARNING: line 85 at SQL statement
[24/Jun/2004:07:56:13][15077.1095707440][-conn:translate-51::0] Error: Ns_PgExec: result status: 7 message: ERROR: Cannot insert a duplicate key into unique index cr_items_unique_name

[24/Jun/2004:07:56:13][15077.1095707440][-conn:translate-51::0] Error: dbinit: error(localhost::translate-51,ERROR: Cannot insert a duplicate key into unique index cr_items_unique_name
): '
select file_storage__get_root_folder('1432');
'
[24/Jun/2004:07:56:13][15077.1095707440][-conn:translate-51::0] Notice: Querying 'abort transaction;'
[24/Jun/2004:07:56:13][15077.1095707440][-conn:translate-51::0] Notice: Ns_PgExec: Rolling back transaction
[24/Jun/2004:07:56:13][15077.1095707440][-conn:translate-51::0] Notice: dbinit: sql(localhost::translate-51): 'abort transaction'
[24/Jun/2004:07:56:13][15077.1095707440][-conn:translate-51::0] Notice: Querying '
select apm_parameter_values.attr_value
from apm_parameters, apm_parameter_values
where apm_parameter_values.package_id = '65'
and apm_parameter_values.parameter_id = apm_parameters.parameter_id
and apm_parameters.parameter_name = 'RestrictErrorsToAdminsP';'
[24/Jun/2004:07:56:13][15077.1095707440][-conn:translate-51::0] Notice: dbinit: sql(localhost::translate-51): '
select apm_parameter_values.attr_value
from apm_parameters, apm_parameter_values
where apm_parameter_values.package_id = '65'
and apm_parameter_values.parameter_id = apm_parameters.parameter_id
and apm_parameters.parameter_name = 'RestrictErrorsToAdminsP'
'
[24/Jun/2004:07:56:13][15077.1095707440][-conn:translate-51::0] Notice: Querying '
select 1
where 't' = acs_permission__permission_p('1383', '14005', 'admin');'
[24/Jun/2004:07:56:13][15077.1095707440][-conn:translate-51::0] Notice: dbinit: sql(localhost::translate-51): '
select 1
where 't' = acs_permission__permission_p('1383', '14005', 'admin')
'
[24/Jun/2004:07:56:13][15077.1095707440][-conn:translate-51::0] Debug: Deprecated proc site_node_closest_ancestor_package used
[24/Jun/2004:07:56:13][15077.1095707440][-conn:translate-51::0] Debug: NO FULLQUERY FOR dbqd.dotlrn.tcl.dotlrn-security-procs.dotlrn::user_p.select_count --> using default SQL
[24/Jun/2004:07:56:13][15077.1095707440][-conn:translate-51::0] Notice: Querying '
select count(*)
from dual
where exists (select 1
from dotlrn_users
where user_id = '14005');'
[24/Jun/2004:07:56:14][15077.1095707440][-conn:translate-51::0] Notice: dbinit: sql(localhost::translate-51): '
select count(*)
from dual
where exists (select 1
from dotlrn_users
where user_id = '14005')
'
[24/Jun/2004:07:56:14][15077.1095707440][-conn:translate-51::0] Debug: Deprecated proc site_node_closest_ancestor_package used
[24/Jun/2004:07:56:14][15077.1095707440][-conn:translate-51::0] Debug: Deprecated proc site_node_closest_ancestor_package used
[24/Jun/2004:07:56:14][15077.1095707440][-conn:translate-51::0] Debug: NO FULLQUERY FOR dbqd.dotlrn.tcl.dotlrn-security-procs.dotlrn::user_p.select_count --> using default SQL
[24/Jun/2004:07:56:14][15077.1095707440][-conn:translate-51::0] Notice: Querying '
select count(*)
from dual
where exists (select 1
from dotlrn_users
where user_id = '14005');'
[24/Jun/2004:07:56:14][15077.1095707440][-conn:translate-51::0] Notice: dbinit: sql(localhost::translate-51): '
select count(*)
from dual
where exists (select 1
from dotlrn_users
where user_id = '14005')
'
[24/Jun/2004:07:56:14][15077.1095707440][-conn:translate-51::0] Notice: Querying '
select pretty_name,
sort_key as page_num
from portal_pages
where portal_id = '14007'
order by sort_key;'
[24/Jun/2004:07:56:14][15077.1095707440][-conn:translate-51::0] Notice: dbinit: sql(localhost::translate-51): '
select pretty_name,
sort_key as page_num
from portal_pages
where portal_id = '14007'
order by sort_key
'
[24/Jun/2004:07:56:14][15077.1095707440][-conn:translate-51::0] Notice: Querying '
select 1
where 't' = acs_permission__permission_p('336', '14005', 'admin');'
[24/Jun/2004:07:56:14][15077.1095707440][-conn:translate-51::0] Notice: dbinit: sql(localhost::translate-51): '
select 1
where 't' = acs_permission__permission_p('336', '14005', 'admin')
'
[24/Jun/2004:07:56:14][15077.1095707440][-conn:translate-51::0] Debug: Deprecated proc site_node_closest_ancestor_package used
[24/Jun/2004:07:56:14][15077.1095707440][-conn:translate-51::0] Debug: Deprecated proc site_node_closest_ancestor_package used
[24/Jun/2004:07:56:14][15077.1095707440][-conn:translate-51::0] Debug: Deprecated proc site_node_closest_ancestor_package used
[24/Jun/2004:07:56:14][15077.1095707440][-conn:translate-51::0] Debug: Deprecated proc site_node_closest_ancestor_package used
[24/Jun/2004:07:56:14][15077.1095707440][-conn:translate-51::0] Debug: Deprecated proc site_node_closest_ancestor_package used
[24/Jun/2004:07:56:14][15077.1095707440][-conn:translate-51::0] Debug: Deprecated proc site_node_closest_ancestor_package used
[24/Jun/2004:07:56:14][15077.1095707440][-conn:translate-51::0] Debug: Deprecated proc site_node_closest_ancestor_package used
[24/Jun/2004:07:56:14][15077.1095707440][-conn:translate-51::0] Error: POST http://translate.openacs.org/dotlrn/admin/user-new-2?
referred by "http://translate.openacs.org/dotlrn/admin/user-new-2?user_id=43276&referer=/dotlrn/admin/users?type=pending";
Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")

ERROR: Cannot insert a duplicate key into unique index cr_items_unique_name

SQL:
select file_storage__get_root_folder('1432');

while executing
"ns_pg_bind 0or1row nsdb0 {
select file_storage__get_root_folder(:package_id);
}"
("uplevel" body line 1)
invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql]"
("postgresql" arm line 2)
invoked from within
"switch $driverkey {
oracle {
return [uplevel $ulevel [list ns_ora $type $db $sql] $args]
}
..."
invoked from within
"db_exec 0or1row $db $full_statement_name $sql"
invoked from within
"if {[regexp -nocase -- {^\s*select} $test_sql match]} {
ns_log Debug "PLPGSQL: bypassed anon function"
set selection [..."
("uplevel" body line 6)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
# plsql calls that are simple selects bypass the plpgsql
# mechanism for creating anonymous fun..."
(procedure "db_exec_plsql" line 57)
invoked from within
"db_exec_plsql get_root_folder {}"
(procedure "fs::get_root_folder" line 7)
invoked from within
"fs::get_root_folder -package_id $package_id"
(procedure "dotlrn_fs::add_user" line 15)
invoked from within
"dotlrn_fs::add_user $user_id"
(procedure "AcsSc.dotlrn_applet.adduser.dotlrn_fs" line 1)
invoked from within
"AcsSc.dotlrn_applet.adduser.dotlrn_fs 43276"
("uplevel" body line 1)
invoked from within
"uplevel $func_and_args"
(procedure "apply" line 3)
invoked from within
"apply $proc_name $arguments"
(procedure "acs_sc_call" line 6)
invoked from within
"acs_sc_call dotlrn_applet $op $list_args $applet_key"
(procedure "applet_call" line 2)
invoked from within
"applet_call $applet $op $list_args"
(procedure "dotlrn_applet::dispatch" line 4)
invoked from within
"dotlrn_applet::dispatch -op AddUser -list_args [list $user_id]"
("uplevel" body line 12)
invoked from within
"uplevel 1 $transaction_code "
(procedure "db_transaction" line 1)
invoked from within
"db_transaction {
set_can_browse -user_id $user_id -can_browse\=$can_browse_p

set portal_id [portal::create -template_id $tem..."
(procedure "dotlrn::user_add" line 20)
invoked from within
"dotlrn::user_add -id $id -type $type -can_browse\=$can_browse_p -user_id $user_id"
("uplevel" body line 3)
invoked from within
"uplevel 1 $transaction_code "
(procedure "db_transaction" line 39)
invoked from within
"db_transaction {

dotlrn::user_add -id $id -type $type -can_browse\=$can_browse_p -user_id $user_id

dotlrn_privacy::set_user_gues..."
invoked from within
"if {[form is_valid add_user]} {

form get_values add_user user_id id type can_browse_p guest_p referer

set subject "Your [ad_system_name] me..."
("uplevel" body line 54)
invoked from within
"uplevel {
#
# Copyright (C) 2001, 2002 MIT
#
# This file is part of dotLRN.
#
# dotLRN is free software; you can redistribute it and/or modi..."
(procedure "code::tcl::/var/lib/aolserver/translate-51/packages/dotlrn/w..." line 2)
invoked from within
"code::tcl::$__adp_stub"
invoked from within
"if { [file exists $__adp_stub.tcl] } {

# ensure that data source preparation procedure exists and is up-to-date
adp_init tcl $__adp_stub
..."
("uplevel" body line 3)
invoked from within
"uplevel {

if { [file exists $__adp_stub.tcl] } {

# ensure that data source preparation procedure exists and is up-to-date
adp_init t..."
(procedure "adp_prepare" line 2)
invoked from within
"adp_prepare "
(procedure "template::adp_parse" line 30)
invoked from within
"template::adp_parse [file root [ad_conn file]] {}"
(procedure "adp_parse_ad_conn_file" line 5)
invoked from within
"$handler"
("uplevel" body line 2)
invoked from within
"uplevel $code"
invoked from within
"ad_try {
$handler
} ad_script_abort val {
# do nothing
}"
invoked from within
"rp_serve_concrete_file [ad_conn file]"
(procedure "rp_serve_abstract_file" line 60)
invoked from within
"rp_serve_abstract_file "$root/$path""
("uplevel" body line 2)
invoked from within
"uplevel $code"
invoked from within
"ad_try {
rp_serve_abstract_file "$root/$path"
set tcl_url2file([ad_conn url]) [ad_conn file]
set tcl_url2path_info..."

Collapse
Posted by Dave Bauer on
Joel,

This was a bug in file-storage on the 5.1 branch. I recreated the file_storage__get_root_folder function.

Collapse
Posted by Joel Aufrecht on
The site is very slow, so I thought I would install developer support to diagnose it.  However, when I try to install software, or do anything that uses list-builder, I get:

There was a server error processing your request. We apologize.

Here is a detailed dump of what took place at the time of the error, which may assist a programmer in tracking down the problem:

can't read "list_properties(bulk_action_method)": no such element in array
    while executing
"lang::util::localize $list_properties(bulk_action_method)"
    invoked from within
"if {! ([template::util::is_nil list_properties(bulk_actions)])} {

Any tips on debugging?  Could this be related to message keys?  To a botched upgrade?

Collapse
Posted by Joel Aufrecht on
Never mind the list_properties error - restarting the server made it go away.
Collapse
Posted by Jeff Davis on
bulk_action_method was something I added so bulk actions could be POSTs instead of GETs. I am not sure how you could get part of that change an not all of it since I think it was all in acs-templating. Here was the commit that added this.