Forum OpenACS Q&A: How to Nuke user Manually?

Collapse
1: How to Nuke user Manually?
Posted by MaineBob OConnor on 08/01/00 02:23 AM

If I try to Nuke a user from admin pages and the final nuke-2.tcl I get a "Failed to Nuke" page: "Database operation "dml" failed" In the server Log I get a second line:

[31/Jul/2000:20:03:29][22045.140294][-conn65-] Error: Ns_PgExec: result status: 7 message: ERROR: control reaches end of trigger procedure without RETURN

I reported this as bug#668 in SDM but now I don't know how or where to fix this. How do I delete - NUKE - test users? Can I do it from psql? I assume I need some sort of cascade delete.

-Bob

Collapse
2: Response to How to Nuke user Manually? (response to 1)
Posted by Don Baccus on 08/01/00 02:31 AM
I just tried this on my test system and I could nuke a user OK.

So the trigger's on a table that the user you're trying to nuke has done something with.

It would help a lot if you could turn Verbose on for the main and subquery pools, restart AOLserver, try again, and post the relevant part of the log file so we can see exactly what "delete" is causing it to die.  Once we know that, we'll know which table is being deleted from, can look at the triggers on that table, and fix the problem PDQ.