Add/Remove Groups Error

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Add/Remove Groups Error

Spleen3
I'm an Admin on my friend's forum site http://doomforums.990887.n3.nabble.com/ . Whenever I try and edit the Groups settings, a HUGE error message comes up. It's been like this for a few weeks and I'm not exactly sure how to fix it and neither does my friend. Also, after that happened, my friend's account hasn't been working properly. She had to make a completely separate account because it wouldn't let her post or something crazy.

The error message is the following:

Oops... An error has occurred
Please contact Nabble Support and explain what you did to cause this error. Your feedback is very important to us.
More Details
Error 500
url=http://doomforums.990887.n3.nabble.com/template/NamlServlet.jtp?macro=change_user_groups&user=349471  bad agent Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; BLNGBAR)
RequestURI=/template/NamlServlet.jtp

Caused by:
fschmidt.util.servlet.JtpContextServlet$JtpServletException: url=http://doomforums.990887.n3.nabble.com/template/NamlServlet.jtp?macro=change_user_groups&user=349471  bad agent Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; BLNGBAR)
        at fschmidt.util.servlet.JtpContextServlet.handleException(JtpContextServlet.java:553)
        at fschmidt.util.servlet.JtpContextServlet.service2(JtpContextServlet.java:473)
        at fschmidt.util.servlet.JtpContextServlet.service(JtpContextServlet.java:325)
        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:156)
        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.headerComplete(HttpConnection.java:923)
        at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:547)
        at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
        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: nabble.naml.compiler.TemplateRuntimeException: sqlCondition = node_id is null and user_id=349471 and label='group:Dumbledore's Army'
        in is_in_group(nabble:change_user_groups.naml:62) - <n.page_user.is_in_group.current_group/> - public void nabble.view.web.template.UserNamespace.is_in_group(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.Interpreter)
        in page_user(nabble:change_user_groups.naml:62) - <n.page_user.is_in_group.current_group/> - public void nabble.view.web.template.UserPageNamespace.page_user(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.ScopedInterpreter)
        in checked(nabble:change_user_groups.naml:99) - <n.set_value.checked/>
        in set_value(nabble:change_user_groups.naml:99) - <n.set_value.checked/> - public void nabble.view.web.template.FieldNamespace.set_value(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.Interpreter)
        in do(nabble:change_user_groups.naml:111) - <n.do/>
        in field(nabble:change_user_groups.naml:111) - <n.field. name="group-[n.remove_spaces.group/]"> - public void nabble.view.web.template.ServletNamespace.field(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.ScopedInterpreter)
        in group_field(nabble:change_user_groups.naml:98) - <n.group_field. group="[n.group/]">
        in group_row(nabble:change_user_groups.naml:60) - <n.group_row>
        in do(nabble:utilities.naml:831) - <n.do/>
        in while(nabble:utilities.naml:829) - <n.while.next_element inc="[n.by/]"> - public void nabble.naml.namespaces.BasicNamespace._while(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.Interpreter)
        in loop(nabble:change_user_groups.naml:59) - <n.loop.>
        in do(nabble:change_user_groups.naml:140) - <n.do/>
        in user_groups(nabble:change_user_groups.naml:136) - <n.user_groups.> - public void nabble.view.web.template.NabbleNamespace.user_groups(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.ScopedInterpreter)
        in user_group_list(nabble:change_user_groups.naml:59) - <n.user_group_list.loop.>
        in if(nabble:change_user_groups.naml:57) - <n.if.page_user.is_authenticated> - public static void nabble.naml.namespaces.BasicNamespace._if(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.Interpreter)
        in content(nabble:utilities.naml:895) - <n.content/>
        in form(nabble:change_user_groups.naml:50) - <n.form.>
        in body(nabble:utilities.naml:9) - <n.body/>
        in body(nabble:utilities.naml:21) - <n.body/>
        in nabble_html(nabble:utilities.naml:17) - <n.nabble_html> - public void nabble.view.web.template.ServletNamespace.nabble_html(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.ScopedInterpreter)
        in html_impl(nabble:utilities.naml:4) - <n.html_impl>
        in html(nabble:change_user_groups.naml:30) - <n.html>
        in do(nabble:utilities.naml:920) - <n.get_user_from_parameter.as_user_page.do/>
        in as_user_page(nabble:utilities.naml:920) - <n.get_user_from_parameter.as_user_page.do/> - public void nabble.view.web.template.UserNamespace.as_user_page(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.ScopedInterpreter)
        in get_user_from_parameter(nabble:utilities.naml:920) - <n.get_user_from_parameter.as_user_page.do/> - public void nabble.view.web.template.ServletNamespace.get_user_from_parameter(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.ScopedInterpreter) throws java.io.IOException,javax.servlet.ServletException
        in user_page(nabble:change_user_groups.naml:2) - <n.user_page.>
        in (nabble:change_user_groups.naml:1) - <macro name="change_user_groups" requires="servlet">
        at nabble.naml.compiler.Compiler.interpFix(Compiler.java:1617)
        at nabble.naml.compiler.Compiler$Block.run(Compiler.java:1352)
        at nabble.naml.compiler.BlockWrapper.printTo(BlockWrapper.java:58)
        at nabble.naml.compiler.ScopedInterpreterImpl$1.printTo(ScopedInterpreterImpl.java:25)
        at nabble.naml.compiler.TemplatePrintWriter.print(TemplatePrintWriter.java:31)
        at nabble.naml.compiler.BlockWrapper$BlockWriter.print(BlockWrapper.java:29)
        at nabble.view.web.template.UserPageNamespace.page_user(UserPageNamespace.java:47)
        at sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at nabble.naml.compiler.JavaCall.invoke(JavaCall.java:20)
        at nabble.naml.compiler.Compiler$Block.invoke(Compiler.java:1273)
        at nabble.naml.compiler.Compiler$Block.run(Compiler.java:1341)
        at nabble.naml.compiler.BlockWrapper.printTo(BlockWrapper.java:58)
        at nabble.naml.compiler.BlockWrapper.toString(BlockWrapper.java:52)
        at nabble.naml.compiler.Template.stringValue(Template.java:128)
        at nabble.naml.compiler.InterpreterImpl.getAttrString(InterpreterImpl.java:33)
        at nabble.view.web.template.FieldNamespace.set_value(FieldNamespace.java:54)
        at sun.reflect.GeneratedMethodAccessor209.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at nabble.naml.compiler.JavaCall.invoke(JavaCall.java:20)
        at nabble.naml.compiler.Compiler$Block.invoke(Compiler.java:1273)
        at nabble.naml.compiler.Compiler$Block.run(Compiler.java:1347)
        at nabble.naml.compiler.Compiler$Chunks.run(Compiler.java:1038)
        at nabble.naml.compiler.BlockWrapper.printTo(BlockWrapper.java:58)
        at nabble.naml.compiler.ScopedInterpreterImpl$1.printTo(ScopedInterpreterImpl.java:25)
        at nabble.naml.compiler.TemplatePrintWriter.print(TemplatePrintWriter.java:31)
        at nabble.naml.compiler.BlockWrapper$BlockWriter.print(BlockWrapper.java:29)
        at nabble.view.web.template.ServletNamespace.field(ServletNamespace.java:122)
        at sun.reflect.GeneratedMethodAccessor70.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at nabble.naml.compiler.JavaCall.invoke(JavaCall.java:20)
        at nabble.naml.compiler.Compiler$Block.invoke(Compiler.java:1273)
        at nabble.naml.compiler.Compiler$Block.run(Compiler.java:1347)
        at nabble.naml.compiler.BlockWrapper.printTo(BlockWrapper.java:58)
        at nabble.naml.compiler.TemplatePrintWriter.print(TemplatePrintWriter.java:31)
        at nabble.naml.compiler.BlockWrapper$BlockWriter.print(BlockWrapper.java:29)
        at nabble.naml.namespaces.BasicNamespace._while(BasicNamespace.java:518)
        at sun.reflect.GeneratedMethodAccessor45.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at nabble.naml.compiler.JavaCall.invoke(JavaCall.java:20)
        at nabble.naml.compiler.Compiler$Block.invoke(Compiler.java:1273)
        at nabble.naml.compiler.Compiler$Block.run(Compiler.java:1347)
        at nabble.naml.compiler.Compiler$Chunks.run(Compiler.java:1038)
        at nabble.naml.compiler.BlockWrapper.printTo(BlockWrapper.java:58)
        at nabble.naml.compiler.ScopedInterpreterImpl$1.printTo(ScopedInterpreterImpl.java:25)
        at nabble.naml.compiler.TemplatePrintWriter.print(TemplatePrintWriter.java:31)
        at nabble.naml.compiler.BlockWrapper$BlockWriter.print(BlockWrapper.java:29)
        at nabble.view.web.template.NabbleNamespace.user_groups(NabbleNamespace.java:402)
        at sun.reflect.GeneratedMethodAccessor391.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at nabble.naml.compiler.JavaCall.invoke(JavaCall.java:20)
        at nabble.naml.compiler.Compiler$Block.invoke(Compiler.java:1273)
        at nabble.naml.compiler.Compiler$Block.run(Compiler.java:1341)
        at nabble.naml.compiler.Compiler$Chunks.run(Compiler.java:1038)
        at nabble.naml.compiler.BlockWrapper.printTo(BlockWrapper.java:58)
        at nabble.naml.compiler.TemplatePrintWriter.print(TemplatePrintWriter.java:31)
        at nabble.naml.compiler.BlockWrapper$BlockWriter.print(BlockWrapper.java:29)
        at nabble.naml.namespaces.BasicNamespace._if(BasicNamespace.java:121)
        at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at nabble.naml.compiler.JavaCall.invoke(JavaCall.java:20)
        at nabble.naml.compiler.Compiler$Block.invoke(Compiler.java:1273)
        at nabble.naml.compiler.Compiler$Block.run(Compiler.java:1347)
        at nabble.naml.compiler.Compiler$Chunks.run(Compiler.java:1038)
        at nabble.naml.compiler.Compiler$VarScope.run(Compiler.java:1082)
        at nabble.naml.compiler.Compiler$Chunks.run(Compiler.java:1038)
        at nabble.naml.compiler.BlockWrapper.printTo(BlockWrapper.java:58)
        at nabble.naml.compiler.ScopedInterpreterImpl$1.printTo(ScopedInterpreterImpl.java:25)
        at nabble.naml.compiler.BlockWrapper.toString(BlockWrapper.java:52)
        at nabble.naml.compiler.ScopedInterpreterImpl.getAttrString(ScopedInterpreterImpl.java:42)
        at nabble.view.web.template.HtmlNamespace.<init>(HtmlNamespace.java:32)
        at nabble.view.web.template.ServletNamespace.nabble_html(ServletNamespace.java:217)
        at sun.reflect.GeneratedMethodAccessor138.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at nabble.naml.compiler.JavaCall.invoke(JavaCall.java:20)
        at nabble.naml.compiler.Compiler$Block.invoke(Compiler.java:1273)
        at nabble.naml.compiler.Compiler$Block.run(Compiler.java:1341)
        at nabble.naml.compiler.Compiler$Chunks.run(Compiler.java:1038)
        at nabble.naml.compiler.BlockWrapper.printTo(BlockWrapper.java:58)
        at nabble.naml.compiler.ScopedInterpreterImpl$1.printTo(ScopedInterpreterImpl.java:25)
        at nabble.naml.compiler.TemplatePrintWriter.print(TemplatePrintWriter.java:31)
        at nabble.view.web.template.UserNamespace.as_user_page(UserNamespace.java:199)
        at sun.reflect.GeneratedMethodAccessor301.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at nabble.naml.compiler.JavaCall.invoke(JavaCall.java:20)
        at nabble.naml.compiler.Compiler$Block.invoke(Compiler.java:1273)
        at nabble.naml.compiler.Compiler$Block.run(Compiler.java:1341)
        at nabble.naml.compiler.BlockWrapper.printTo(BlockWrapper.java:58)
        at nabble.naml.compiler.ScopedInterpreterImpl$1.printTo(ScopedInterpreterImpl.java:25)
        at nabble.naml.compiler.TemplatePrintWriter.print(TemplatePrintWriter.java:31)
        at nabble.view.web.template.ServletNamespace.get_user_from_parameter(ServletNamespace.java:319)
        at sun.reflect.GeneratedMethodAccessor300.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at nabble.naml.compiler.JavaCall.invoke(JavaCall.java:20)
        at nabble.naml.compiler.Compiler$Block.invoke(Compiler.java:1273)
        at nabble.naml.compiler.Compiler$Block.run(Compiler.java:1341)
        at nabble.naml.compiler.Template.run(Template.java:88)
        at nabble.naml.compiler.Template.run(Template.java:61)
        at nabble.view.web.template.TemplateManager.run(TemplateManager.java:86)
        at nabble.view.web.template.NamlServlet.service(NamlServlet.java:127)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
        at fschmidt.util.servlet.JtpContextServlet.service2(JtpContextServlet.java:471)
        ... 25 more
Caused by: java.lang.RuntimeException: sqlCondition = node_id is null and user_id=349471 and label='group:Dumbledore's Army'
        at nabble.model.TagImpl.hasTags(TagImpl.java:63)
        at nabble.model.SiteImpl$5.compute(SiteImpl.java:596)
        at nabble.model.SiteImpl$5.compute(SiteImpl.java:594)
        at fschmidt.util.java.Memoizer$1.call(Memoizer.java:25)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
        at java.util.concurrent.FutureTask.run(FutureTask.java:138)
        at fschmidt.util.java.FastFuture.run(FastFuture.java:34)
        at fschmidt.util.java.Memoizer.get(Memoizer.java:32)
        at nabble.model.SiteImpl.hasTags(SiteImpl.java:601)
        at nabble.view.lib.Permissions.isInGroup(Permissions.java:27)
        at nabble.view.web.template.UserNamespace.is_in_group(UserNamespace.java:147)
        at sun.reflect.GeneratedMethodAccessor100.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at nabble.naml.compiler.JavaCall.invoke(JavaCall.java:20)
        at nabble.naml.compiler.Compiler$Block.invoke(Compiler.java:1273)
        at nabble.naml.compiler.Compiler$Block.run(Compiler.java:1347)
        ... 134 more
Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "s"
        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:336)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:235)
        at nabble.model.TagImpl.hasTags(TagImpl.java:52)
        ... 150 more



I'm not a very techical person, so I just want this fixed please.