Forum .LRN Q&A: Error deleting an user
I´ve trying to install dotlrn into Centos 5, aolserver 4.0.10 and postgres sql 8.2
thanks in advance
"Database update failed with the following error:
Transaction aborted: Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.")
ERROR: current transaction is aborted, commands ignored until end of transaction block
select 1 from dual
( select 1
from acs_object_party_privilege_map ppm
where ppm.object_id = '-1' and ppm.party_id = '568' and ppm.privilege = 'admin' )"
1.- login into dotlrn with a user with permission of superadministrator.
2.- I click on option "users" on dotlrn toolbar
3.- Select the user that I want to delete (ban access to the dotlrn system)
4.- I click on "delete"
5.- Appears the error
also if you're using a newer postgres driver, the error messages can be made to be more informative if you go into the service config file and set the var debug to true; this should be well documented. (If you look at the database pool definitiions, you should see ns_param verbose $debug)