Forum OpenACS Q&A: Re: Mailing List not working with Categories

Collapse
Posted by Walter Smith on
Thanks Timo.  I don't know if I was supposed to, but I tried to uninstall the package so I could reload it.  Was that the wrong thing to do?

So I ran into some errors with it not being able to drop all the tables.  I went in and dropped the tables manually, but I'm finally at an error that I can't resolve:

Deleting package instance 712
The database returned the following error message

    Database operation "0or1row" failed (exception NSDB, "Query was not a statement returning rows.") ERROR: update or delete on "acs_objects" violates foreign key constraint "acs_objects_context_id_fk" on "acs_objects" DETAIL: Key (object_id)=(712) is still referenced from table "acs_objects". SQL: select apm_package__delete('712');

Is there a way I can recover from this?  I restarted the server and the package still appears in the package manager, but if I try to delete it I get the same message above.