Forum OpenACS Q&A: Response to Deleting categories in ecommerce
Posted by
Dave Bauer
on 12/18/00 01:47 AM
I think this is the relevant part. It is very long. It is everything between the "begin transacation" and "end transaction"
[17/Dec/2000:14:33:05][20999.5125][-conn1-] Notice: Querying 'begin transaction;'
[17/Dec/2000:14:33:05][20999.5125][-conn1-] Notice: Ns_PgExec: Entering transaction
[17/Dec/2000:14:33:05][20999.5125][-conn1-] Notice: dbinit: sql(localhost::nh): 'begin transaction'
[17/Dec/2000:14:33:05][20999.5125][-conn1-] Notice: Querying 'select subsubcategory_id from ec_subsubcategories where subcategory_id in (select subcategory_id from ec_subcategories where category_id=2);'
[17/Dec/2000:14:33:05][20999.5125][-conn1-] Notice: dbinit: sql(localhost::nh): 'select subsubcategory_id from ec_subsubcategories where subcategory_id in (select subcategory_id from ec_subcategories where category_id=2)'
[17/Dec/2000:14:33:05][20999.5125][-conn1-] Notice: Querying 'select subcategory_id from ec_subcategories where category_id=2;'
[17/Dec/2000:14:33:05][20999.5125][-conn1-] Notice: dbinit: sql(localhost::nh): 'select subcategory_id from ec_subcategories where category_id=2'
[17/Dec/2000:14:33:05][20999.5125][-conn1-] Notice: Querying 'delete from ec_subsubcategory_product_map
where subsubcategory_id in (select subsubcategory_id from ec_subsubcategories where subcategory_id in (select subcategory_id from ec_subcategories where category_id=2));'
[17/Dec/2000:14:33:05][20999.5125][-conn1-] Notice: dbinit: sql(localhost::nh): 'delete from ec_subsubcategory_product_map
where subsubcategory_id in (select subsubcategory_id from ec_subsubcategories where subcategory_id in (select subcategory_id from ec_subcategories where category_id=2))'
[17/Dec/2000:14:33:05][20999.5125][-conn1-] Notice: Querying 'delete from ec_subsubcategories where subcategory_id in (select subcategory_id from ec_subcategories where category_id=2);'
[17/Dec/2000:14:33:05][20999.5125][-conn1-] Notice: dbinit: sql(localhost::nh): 'delete from ec_subsubcategories where subcategory_id in (select subcategory_id from ec_subcategories where category_id=2)'
[17/Dec/2000:14:33:05][20999.5125][-conn1-] Notice: Querying 'delete from ec_subcategory_product_map
where subcategory_id in (select subcategory_id from ec_subcategories where category_id=2);'
[17/Dec/2000:14:33:05][20999.5125][-conn1-] Notice: dbinit: sql(localhost::nh): 'delete from ec_subcategory_product_map
where subcategory_id in (select subcategory_id from ec_subcategories where category_id=2)'
[17/Dec/2000:14:33:05][20999.5125][-conn1-] Notice: Querying 'insert into ec_subcat_prod_map_audit
(subcategory_id, last_modified,
last_modifying_user, modified_ip_address, delete_p)
values
(2, sysdate(),
'6', '216.254.100.170','t');'
[17/Dec/2000:14:33:05][20999.5125][-conn1-] Notice: dbinit: sql(localhost::nh): 'insert into ec_subcat_prod_map_audit
(subcategory_id, last_modified,
last_modifying_user, modified_ip_address, delete_p)
values
(2, sysdate(),
'6', '216.254.100.170','t')
'
[17/Dec/2000:14:33:05][20999.5125][-conn1-] Notice: Querying 'insert into ec_subcat_prod_map_audit
(subcategory_id, last_modified,
last_modifying_user, modified_ip_address, delete_p)
values
(1, sysdate(),
'6', '216.254.100.170','t');'
[17/Dec/2000:14:33:05][20999.5125][-conn1-] Notice: dbinit: sql(localhost::nh): 'insert into ec_subcat_prod_map_audit
(subcategory_id, last_modified,
last_modifying_user, modified_ip_address, delete_p)
values
(1, sysdate(),
'6', '216.254.100.170','t')
'
[17/Dec/2000:14:33:05][20999.5125][-conn1-] Notice: Querying 'delete from ec_subcategories where category_id=2;'
[17/Dec/2000:14:33:05][20999.5125][-conn1-] Notice: dbinit: sql(localhost::nh): 'delete from ec_subcategories where category_id=2'
[17/Dec/2000:14:33:05][20999.5125][-conn1-] Notice: Querying 'insert into ec_subcategories_audit
(subcategory_id, last_modified,
last_modifying_user, modified_ip_address, delete_p)
values
(2, sysdate(),
'6', '216.254.100.170','t');'
[17/Dec/2000:14:33:05][20999.5125][-conn1-] Notice: dbinit: sql(localhost::nh): 'insert into ec_subcategories_audit
(subcategory_id, last_modified,
last_modifying_user, modified_ip_address, delete_p)
values
(2, sysdate(),
'6', '216.254.100.170','t')
'
[17/Dec/2000:14:33:05][20999.5125][-conn1-] Notice: Querying 'insert into ec_subcategories_audit
(subcategory_id, last_modified,
last_modifying_user, modified_ip_address, delete_p)
values
(1, sysdate(),
'6', '216.254.100.170','t');'
[17/Dec/2000:14:33:05][20999.5125][-conn1-] Notice: dbinit: sql(localhost::nh): 'insert into ec_subcategories_audit
(subcategory_id, last_modified,
last_modifying_user, modified_ip_address, delete_p)
values
(1, sysdate(),
'6', '216.254.100.170','t')
'
[17/Dec/2000:14:33:05][20999.5125][-conn1-] Notice: Querying 'delete from ec_category_product_map where category_id=2;'
[17/Dec/2000:14:33:05][20999.5125][-conn1-] Notice: dbinit: sql(localhost::nh): 'delete from ec_category_product_map where category_id=2'
[17/Dec/2000:14:33:05][20999.5125][-conn1-] Notice: Querying 'insert into ec_category_product_map_audit
(category_id, last_modified,
last_modifying_user, modified_ip_address, delete_p)
values
(2, sysdate(),
'6', '216.254.100.170','t');'
[17/Dec/2000:14:33:05][20999.5125][-conn1-] Notice: dbinit: sql(localhost::nh): 'insert into ec_category_product_map_audit
(category_id, last_modified,
last_modifying_user, modified_ip_address, delete_p)
values
(2, sysdate(),
'6', '216.254.100.170','t')
'
[17/Dec/2000:14:33:05][20999.5125][-conn1-] Notice: Querying 'delete from ec_category_template_map where category_id=2;'
[17/Dec/2000:14:33:05][20999.5125][-conn1-] Notice: dbinit: sql(localhost::nh): 'delete from ec_category_template_map where category_id=2'
[17/Dec/2000:14:33:05][20999.5125][-conn1-] Notice: Querying 'delete from ec_categories where category_id=2;'
[17/Dec/2000:14:33:05][20999.5125][-conn1-] Notice: dbinit: sql(localhost::nh): 'delete from ec_categories where category_id=2'
[17/Dec/2000:14:33:05][20999.5125][-conn1-] Notice: Querying 'insert into ec_categories_audit
(category_id, last_modified,
last_modifying_user, modified_ip_address, delete_p)
values
(2, sysdate(),
'6', '216.254.100.170','t');'
[17/Dec/2000:14:33:05][20999.5125][-conn1-] Notice: dbinit: sql(localhost::nh): 'insert into ec_categories_audit
(category_id, last_modified,
last_modifying_user, modified_ip_address, delete_p)
values
(2, sysdate(),
'6', '216.254.100.170','t')
'
[17/Dec/2000:14:33:05][20999.5125][-conn1-] Notice: Querying 'end transaction;'
[17/Dec/2000:14:33:05][20999.5125][-conn1-] Notice: Ns_PgExec: Committing transaction
[17/Dec/2000:14:33:05][20999.5125][-conn1-] Notice: dbinit: sql(localhost::nh): 'end transaction'
Here is what came immediately after:
[17/Dec/2000:14:33:05][20999.5125][-conn1-] Notice: Querying 'select ad_group_member_p(6, system_administrator_group_id()) from dual;' [17/Dec/2000:14:33:05][20999.5125][-conn1-] Notice: dbinit: sql(localhost::nh): 'select ad_group_member_p(6, system_administrator_group_id()) from dual' [17/Dec/2000:14:33:05][20999.5125][-conn1-] Notice: Querying 'select category_id, sort_key, category_name from ec_categories order by sort_key;' [17/Dec/2000:14:33:05][20999.5125][-conn1-] Notice: dbinit: sql(localhost::nh): 'select category_id, sort_key, category_name from ec_categories order by sort_key'Thanks for any assistance.
