Can't delete a forum

[Dr Shaun Hutchinson]

Hi I tried to delete a forum and got the following error message while trying to delete the following forum http://arbor-vitae-natural-health-forum.3006287.n2.nabble.com/:


Error 500

url=http://arbor-vitae-natural-health-forum.3006287.n2.nabble.com/forum/Delete.jtp?action=delete&node=3006287  method=POST user-agent=Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.8) Gecko/20100722 Firefox/3.6.8 referer=http://arbor-vitae-natural-health-forum.3006287.n2.nabble.com/forum/Delete.jtp?node=3006287 remote=196.30.31.182

RequestURI=/forum/Delete.jtp
Caused by:

fschmidt.util.servlet.JtpContextServlet$JtpRuntimeException: url=http://arbor-vitae-natural-health-forum.3006287.n2.nabble.com/forum/Delete.jtp?action=delete&node=3006287  method=POST user-agent=Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.8) Gecko/20100722 Firefox/3.6.8 referer=http://arbor-vitae-natural-health-forum.3006287.n2.nabble.com/forum/Delete.jtp?node=3006287 remote=196.30.31.182
        at fschmidt.util.servlet.JtpContextServlet.handleException(JtpContextServlet.java:559)
        at fschmidt.util.servlet.JtpContextServlet.service2(JtpContextServlet.java:469)
        at fschmidt.util.servlet.JtpContextServlet.service(JtpContextServlet.java:278)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
        at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
        at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1166)
        at org.mortbay.servlet.UserAgentFilter.doFilter(UserAgentFilter.java:81)
        at fschmidt.util.servlet.GzipFilter.doFilter(GzipFilter.java:137)
        at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
        at cachingfilter.CachingFilter.doFilter(CachingFilter.java:133)
        at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
        at fschmidt.util.servlet.BadBotFilter.doFilter(BadBotFilter.java:74)
        at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
        at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388)
        at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
        at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
        at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:230)
        at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
        at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
        at org.mortbay.jetty.Server.handle(Server.java:326)
        at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
        at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:938)
        at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:755)
        at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)
        at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
        at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409)
        at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
Caused by: fschmidt.db.SQLRuntimeException: key = 3006287
        at fschmidt.db.base.DbRecordImpl.delete(DbRecordImpl.java:300)
        at nabble.model.NodeImpl.deleteRecursively(NodeImpl.java:474)
        at nabble.model.NodeImpl.deleteRecursively(NodeImpl.java:466)
        at nabble.view.lib.Jtp.deleteRecursively(Jtp.java:1058)
        at nabble.view.web.forum.Delete.service(Delete.java:65)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
        at fschmidt.util.servlet.JtpContextServlet.service2(JtpContextServlet.java:467)
        ... 25 more
Caused by: org.postgresql.util.PSQLException: ERROR: update or delete on table "user_" violates foreign key constraint "member_new_user_id_fkey" on table "member"
  Detail: Key (user_id)=(132728) is still referenced from table "member".
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:304)
        at fschmidt.db.base.DbRecordImpl.delete(DbRecordImpl.java:288)
        ... 31 more

[Hugo <Nabble>]

Thanks for reporting this bug.
We are looking into it.

[Hugo <Nabble>]

We have fixed this bug (thanks for reporting it). Please try again and let me know if you still have issues.

[opie]

can you check for this sub-forum.. because I can't delete it..
TQ..

http://rofizzulhisyam.blogspot.com/p/forum.html

[Tutorial Moderator umum Baru]

[Hugo <Nabble>]

What happens when you try to delete the sub-forum?