Hi I fixed all my triggers from before to after. I kept a log of the SQL results and there were no errors.
The problem I am having is if there is info in ec_user_sessions about product or category I get this error:
[10/Feb/2001:02:40:21][25652.1073157][-conn7-] Error: Ns_PgExec: result status: 7 message: ERROR: <unnamed> referential integrity violation - key in ec_categories still referenced from ec_user_session_info
[10/Feb/2001:02:40:21][25652.1073157][-conn7-] Error: dbinit: error(localhost::nh,ERROR: <unnamed> referential integrity violation - key in ec_categories still referenced from ec_user_session_info
): 'delete from ec_categories where category_id=1'
[10/Feb/2001:02:40:21][25652.1073157][-conn7-] Error: Database operation "dml" failed
Database operation "dml" failed
while executing
"ns_db dml $db "delete from ec_categories where category_id=$category_id""
(file "/web/nh/www/admin/ecommerce/cat/category-delete-2.tcl" line 94)
invoked from within
"source $script"
(procedure "ns_sourceproc" line 6)
invoked from within
"ns_sourceproc cns35 {}"
Any ideas? I understand why it fails, but shouldn't this be taken care of by OpenACS to not allow the deleting without causing a database error message?