Forum .LRN Q&A: Re: notes on upgrading dotLRN to 2.2.0a1

Collapse
Posted by Nima Mazloumi on
I turned on ds and tried again with db on. here the db stack around the relevant part:

dbqd.acs-tcl.tcl.apm-procs.apm_package_registered_p.apm_package_registered_p: 0or1row nsdb0
select 1 from apm_package_types
where package_key = 'attachments'

2 ms 0or1row dbqd.dotlrn.tcl.community-procs.dotlrn_community::applet_active_p.select_active_applet_p: 0or1row nsdb0
select 1
from dotlrn_community_applets,
dotlrn_applets
where dotlrn_community_applets.community_id = '3355576'
and dotlrn_community_applets.applet_id = dotlrn_applets.applet_id
and dotlrn_applets.applet_key = 'dotlrn_fs'
and dotlrn_community_applets.active_p = 't'
and dotlrn_applets.active_p = 't'

2 ms 0or1row dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.package_select: 0or1row nsdb0

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

6 ms 0or1row dbqd.acs-subsite.tcl.package-procs.package_instantiate_object.create_object: 0or1row nsdb0

select site_node__new(NULL,'3355756',null,NULL,'t','t','27685','134.155.48.12')

2 ms select dbqd.acs-subsite.tcl.subsite-callback-procs.subsite_callback.select_callbacks: select nsdb0

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 = 'site_node')
and event_type = 'insert'

2 ms dml dbqd.acs-tcl.tcl.site-nodes-procs.site_node::mount.mount_object: dml nsdb0
update site_nodes
set object_id = '0'
where node_id = '3355765'

3 ms dml dbqd.acs-tcl.tcl.site-nodes-procs.site_node::mount.update_object_package_id: dml nsdb0
update acs_objects
set package_id = :object_id
where object_id = :node_id