Forum OpenACS Q&A: How do I delete a contest?

Collapse
Posted by John Sturman on
I am running OpenACS 3.2.4 on a Sun box and ran into the following
problem.  I created a contest (badly) and now it is causing a core
dump of AOLServer when trying to do any maintenance on it.  I want to
delete the whole thing but cannot see how.  MarkD from AD wrote me to
remove it manually from the database, but I am a real novice in SQL
and don't want to screw anything up.  Any help?
Collapse
Posted by Don Baccus on
Who is core dumping, AOLserver???  PostgreSQL???

There are two tables that need deleting, contest_extra_columns and
contest_domains.  They need to be deleted in that order:

delete table contest_extra_columns;
delete table contest_domains;