This post was updated on .
Hello - I added a group and it looks like the apostrophe in the name of the group might be causing a problem.
Now when I receive a new user registration request, I click and receive Error 500 messages. This is what happens when I try to manage the groups to remove the group with the apostrophe in its name: ------- This is what happens when i try to add someone from an email registration request link: Cult of TCAP 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 sqlCondition = node_id is null and user_id=18 and label='group:Lorne\'s Angel' in is_in_group(nabble:change_user_groups.naml:61) - <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:61) - <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:98) - <n.set_value.checked/> in set_value(nabble:change_user_groups.naml:98) - <n.set_value.checked/> - public void nabble.view.web.template.FieldNamespace.set_value(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.Interpreter) in field(nabble:change_user_groups.naml:110) - <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:97) - <n.group_field. group="[n.group/]"> in group_row(nabble:change_user_groups.naml:59) - <n.group_row> in do(nabble:utilities.naml:905) - <n.do/> in while(nabble:utilities.naml:903) - <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:58) - <n.loop.> in do(nabble:change_user_groups.naml:139) - <n.do/> in user_groups(nabble:change_user_groups.naml:135) - <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:58) - <n.user_group_list.loop.> in (nabble:change_user_groups.naml:119) - <t> in translation: remove(nabble:change_user_groups.naml:119) - <t> in if(nabble:change_user_groups.naml:56) - <n.if.page_user.is_authenticated> - public static void nabble.naml.namespaces.BasicNamespace._if(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.Interpreter) in nabble_html(responsive:responsive.naml:9) - <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:994) - <n.get_user_from_parameter.as_user_page.do/> in as_user_page(nabble:utilities.naml:994) - <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:994) - <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"> Message: sqlCondition = node_id is null and user_id=18 and label='group:Lorne\'s Angel' RequestURI: /template/NamlServlet.jtp Server: n8.nabble.com Caused by: nabble.view.lib.JtpContextServlet$JtpServletException: url=http://cult-of-tcap.82729.n8.nabble.com/template/NamlServlet.jtp?macro=change_user_groups&user=18 method=GET user-agent=Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/69.0.3497.100 Safari/537.36 referer=null remote=216.73.220.169 at nabble.view.lib.JtpContextServlet.handleException(JtpContextServlet.java:541) at nabble.view.lib.JtpContextServlet.service2(JtpContextServlet.java:442) at nabble.view.lib.JtpContextServlet.service(JtpContextServlet.java:311) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:565) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1360) at org.eclipse.jetty.servlets.UserAgentFilter.doFilter(UserAgentFilter.java:77) at org.eclipse.jetty.servlets.GzipFilter.doFilter(GzipFilter.java:144) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331) at cachingfilter.CachingFilter.doFilter(CachingFilter.java:135) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331) at fschmidt.util.servlet.BadBotFilter.doFilter(BadBotFilter.java:74) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331) at fschmidt.util.servlet.ConnectionLimitFilter.doFilter(ConnectionLimitFilter.java:94) at nabble.view.lib.NabbleConnectionLimitFilter.doFilter(NabbleConnectionLimitFilter.java:26) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331) at nabble.view.lib.NabbleErrorFilter.doFilter(NabbleErrorFilter.java:21) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:477) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:225) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1031) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:406) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:186) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:965) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117) at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:250) at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:149) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:111) at org.eclipse.jetty.server.Server.handle(Server.java:349) at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:449) at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:910) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:634) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:230) at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:76) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:609) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:45) at nabble.model.Executors$1$1.run(Executors.java:27) at fschmidt.util.executor.ThreadTimer$1.run(ThreadTimer.java:18) at fschmidt.util.executor.AbstractThreadPool$1.run(AbstractThreadPool.java:29) at java.lang.Thread.run(Thread.java:748) Caused by: nabble.naml.compiler.TemplateRuntimeException: sqlCondition = node_id is null and user_id=18 and label='group:Lorne\'s Angel' in is_in_group(nabble:change_user_groups.naml:61) - <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:61) - <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:98) - <n.set_value.checked/> in set_value(nabble:change_user_groups.naml:98) - <n.set_value.checked/> - public void nabble.view.web.template.FieldNamespace.set_value(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.Interpreter) in field(nabble:change_user_groups.naml:110) - <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:97) - <n.group_field. group="[n.group/]"> in group_row(nabble:change_user_groups.naml:59) - <n.group_row> in do(nabble:utilities.naml:905) - <n.do/> in while(nabble:utilities.naml:903) - <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:58) - <n.loop.> in do(nabble:change_user_groups.naml:139) - <n.do/> in user_groups(nabble:change_user_groups.naml:135) - <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:58) - <n.user_group_list.loop.> in (nabble:change_user_groups.naml:119) - <t> in translation: remove(nabble:change_user_groups.naml:119) - <t> in if(nabble:change_user_groups.naml:56) - <n.if.page_user.is_authenticated> - public static void nabble.naml.namespaces.BasicNamespace._if(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.Interpreter) in nabble_html(responsive:responsive.naml:9) - <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:994) - <n.get_user_from_parameter.as_user_page.do/> in as_user_page(nabble:utilities.naml:994) - <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:994) - <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:2007) at nabble.naml.compiler.Compiler$Block.run(Compiler.java:1636) at nabble.naml.compiler.BlockWrapper.printTo(BlockWrapper.java:68) at nabble.naml.compiler.ScopedInterpreterImpl$1.printTo(ScopedInterpreterImpl.java:25) at nabble.naml.compiler.TemplatePrintWriter.print(TemplatePrintWriter.java:22) at nabble.naml.compiler.BlockWrapper$BlockWriter.print(BlockWrapper.java:32) at nabble.view.web.template.UserPageNamespace.page_user(UserPageNamespace.java:43) at sun.reflect.GeneratedMethodAccessor335.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at nabble.naml.compiler.JavaCall.invoke(JavaCall.java:26) at nabble.naml.compiler.Compiler$Block.invoke(Compiler.java:1557) at nabble.naml.compiler.Compiler$Block.run(Compiler.java:1625) at nabble.naml.compiler.BlockWrapper.printTo(BlockWrapper.java:68) at nabble.naml.compiler.BlockWrapper.toString(BlockWrapper.java:62) at nabble.naml.compiler.Template.stringValue(Template.java:87) at nabble.naml.compiler.InterpreterImpl.getArgString(InterpreterImpl.java:31) at nabble.view.web.template.FieldNamespace.set_value(FieldNamespace.java:54) at sun.reflect.GeneratedMethodAccessor244.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at nabble.naml.compiler.JavaCall.invoke(JavaCall.java:26) at nabble.naml.compiler.Compiler$Block.invoke(Compiler.java:1557) at nabble.naml.compiler.Compiler$Block.run(Compiler.java:1631) at nabble.naml.compiler.Compiler$Chunks.run(Compiler.java:1121) at nabble.naml.compiler.BlockWrapper.printTo(BlockWrapper.java:68) at nabble.naml.compiler.ScopedInterpreterImpl$1.printTo(ScopedInterpreterImpl.java:25) at nabble.naml.compiler.TemplatePrintWriter.print(TemplatePrintWriter.java:22) at nabble.naml.compiler.BlockWrapper$BlockWriter.print(BlockWrapper.java:32) at nabble.view.web.template.ServletNamespace.field(ServletNamespace.java:135) at sun.reflect.GeneratedMethodAccessor118.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at nabble.naml.compiler.JavaCall.invoke(JavaCall.java:26) at nabble.naml.compiler.Compiler$Block.invoke(Compiler.java:1557) at nabble.naml.compiler.Compiler$Block.run(Compiler.java:1631) at nabble.naml.compiler.BlockWrapper.printTo(BlockWrapper.java:68) at nabble.naml.compiler.TemplatePrintWriter.print(TemplatePrintWriter.java:22) at nabble.naml.compiler.BlockWrapper$BlockWriter.print(BlockWrapper.java:32) at nabble.naml.namespaces.BasicNamespace._while(BasicNamespace.java:563) at sun.reflect.GeneratedMethodAccessor101.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at nabble.naml.compiler.JavaCall.invoke(JavaCall.java:26) at nabble.naml.compiler.Compiler$Block.invoke(Compiler.java:1557) at nabble.naml.compiler.Compiler$Block.run(Compiler.java:1631) at nabble.naml.compiler.Compiler$Chunks.run(Compiler.java:1121) at nabble.naml.compiler.BlockWrapper.printTo(BlockWrapper.java:68) at nabble.naml.compiler.ScopedInterpreterImpl$1.printTo(ScopedInterpreterImpl.java:25) at nabble.naml.compiler.TemplatePrintWriter.print(TemplatePrintWriter.java:22) at nabble.naml.compiler.BlockWrapper$BlockWriter.print(BlockWrapper.java:32) at nabble.view.web.template.NabbleNamespace.user_groups(NabbleNamespace.java:442) at sun.reflect.GeneratedMethodAccessor398.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at nabble.naml.compiler.JavaCall.invoke(JavaCall.java:26) at nabble.naml.compiler.Compiler$Block.invoke(Compiler.java:1557) at nabble.naml.compiler.Compiler$Block.run(Compiler.java:1625) at nabble.naml.compiler.Compiler$Chunks.run(Compiler.java:1121) at nabble.naml.compiler.BlockWrapper.printTo(BlockWrapper.java:68) at nabble.naml.compiler.TemplatePrintWriter.print(TemplatePrintWriter.java:22) at nabble.naml.compiler.BlockWrapper$BlockWriter.print(BlockWrapper.java:32) at nabble.naml.namespaces.BasicNamespace._if(BasicNamespace.java:140) at sun.reflect.GeneratedMethodAccessor20.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at nabble.naml.compiler.JavaCall.invoke(JavaCall.java:26) at nabble.naml.compiler.Compiler$Block.invoke(Compiler.java:1557) at nabble.naml.compiler.Compiler$Block.run(Compiler.java:1631) at nabble.naml.compiler.Compiler$Chunks.run(Compiler.java:1121) at nabble.naml.compiler.Compiler$VarScope.run(Compiler.java:1259) at nabble.naml.compiler.Compiler$Chunks.run(Compiler.java:1121) at nabble.naml.compiler.BlockWrapper.printTo(BlockWrapper.java:68) at nabble.naml.compiler.ScopedInterpreterImpl$1.printTo(ScopedInterpreterImpl.java:25) at nabble.naml.compiler.BlockWrapper.toString(BlockWrapper.java:62) at nabble.naml.compiler.ScopedInterpreterImpl.getArgString(ScopedInterpreterImpl.java:42) at nabble.view.web.template.HtmlNamespace.<init>(HtmlNamespace.java:31) at nabble.view.web.template.ServletNamespace.nabble_html(ServletNamespace.java:242) at sun.reflect.GeneratedMethodAccessor172.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at nabble.naml.compiler.JavaCall.invoke(JavaCall.java:26) at nabble.naml.compiler.Compiler$Block.invoke(Compiler.java:1557) at nabble.naml.compiler.Compiler$Block.run(Compiler.java:1625) at nabble.naml.compiler.Compiler$Chunks.run(Compiler.java:1121) at nabble.naml.compiler.BlockWrapper.printTo(BlockWrapper.java:68) at nabble.naml.compiler.ScopedInterpreterImpl$1.printTo(ScopedInterpreterImpl.java:25) at nabble.naml.compiler.TemplatePrintWriter.print(TemplatePrintWriter.java:22) at nabble.view.web.template.UserNamespace.as_user_page(UserNamespace.java:233) at sun.reflect.GeneratedMethodAccessor473.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at nabble.naml.compiler.JavaCall.invoke(JavaCall.java:26) at nabble.naml.compiler.Compiler$Block.invoke(Compiler.java:1557) at nabble.naml.compiler.Compiler$Block.run(Compiler.java:1625) at nabble.naml.compiler.BlockWrapper.printTo(BlockWrapper.java:68) at nabble.naml.compiler.ScopedInterpreterImpl$1.printTo(ScopedInterpreterImpl.java:25) at nabble.naml.compiler.TemplatePrintWriter.print(TemplatePrintWriter.java:22) at nabble.view.web.template.ServletNamespace.get_user_from_parameter(ServletNamespace.java:368) at sun.reflect.GeneratedMethodAccessor474.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at nabble.naml.compiler.JavaCall.invoke(JavaCall.java:26) at nabble.naml.compiler.Compiler$Block.invoke(Compiler.java:1557) at nabble.naml.compiler.Compiler$Block.run(Compiler.java:1625) at nabble.naml.compiler.Template.run(Template.java:61) at nabble.naml.compiler.Template.run(Template.java:33) at nabble.modules.ModuleManager.run(ModuleManager.java:269) at nabble.view.web.template.NamlServlet.service(NamlServlet.java:167) at nabble.view.web.template.NamlServlet.service(NamlServlet.java:135) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at nabble.view.lib.JtpContextServlet.service2(JtpContextServlet.java:440) ... 38 more Caused by: java.lang.RuntimeException: sqlCondition = node_id is null and user_id=18 and label='group:Lorne\'s Angel' at nabble.model.TagImpl.countTags(TagImpl.java:60) at nabble.model.UserImpl$8.get(UserImpl.java:1287) at nabble.model.UserImpl$8.get(UserImpl.java:1285) at fschmidt.util.java.Memoizer$1.call(Memoizer.java:30) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at fschmidt.util.java.FastFuture.run(FastFuture.java:21) at fschmidt.util.java.Memoizer.get(Memoizer.java:37) at nabble.model.SiteImpl.hasTags(SiteImpl.java:537) at nabble.view.lib.Permissions.isInGroup(Permissions.java:32) at nabble.view.web.template.UserNamespace.is_in_group(UserNamespace.java:181) at sun.reflect.GeneratedMethodAccessor148.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at nabble.naml.compiler.JavaCall.invoke(JavaCall.java:26) at nabble.naml.compiler.Compiler$Block.invoke(Compiler.java:1557) at nabble.naml.compiler.Compiler$Block.run(Compiler.java:1631) ... 148 more Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "s" Position: 92 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254) at nabble.model.TagImpl.countTags(TagImpl.java:48) ... 163 more URL = http://cult-of-tcap.82729.n8.nabble.com/template/NamlServlet.jtp?macro=change_user_groups&user=18 |
Hi, I would like to just delete the group, but is there a macro-workaround I can use since I cannot click on the group with the pesky apostrophe to delete it? I don't have any adjusted macros on my forum at all. I am unable to click the group to manage/delete it.
It produces the following error: Cult of TCAP 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 org.postgresql.util.PSQLException: ERROR: syntax error at or near "s" Position: 104 in users_in_group(nabble:manage_users_and_groups.naml:138) - <n.users_in_group. group="[n.group/]"> - public void nabble.view.web.template.NabbleNamespace.users_in_group(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.ScopedInterpreter) in set_value(nabble:manage_users_and_groups.naml:137) - <n.set_value.> - public void nabble.view.web.template.FieldNamespace.set_value(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.Interpreter) in do(nabble:manage_users_and_groups.naml:227) - <n.do/> in field(nabble:manage_users_and_groups.naml:227) - <n.field. name="users"> - public void nabble.view.web.template.ServletNamespace.field(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.ScopedInterpreter) in users_field(nabble:manage_users_and_groups.naml:137) - <n.users_field.set_value.> in if(nabble:ui_components.naml:72) - <n.if.selected> - public static void nabble.naml.namespaces.BasicNamespace._if(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.Interpreter) in while(nabble:utilities.naml:903) - <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:manage_users_and_groups.naml:46) - <n.loop.> in user_groups(nabble:manage_users_and_groups.naml:38) - <n.user_groups.> - public void nabble.view.web.template.NabbleNamespace.user_groups(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.ScopedInterpreter) in body(nabble:utilities.naml:10) - <n.body/> in nabble_html(responsive:responsive.naml:9) - <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:manage_users_and_groups.naml:12) - <n.html> in (nabble:manage_users_and_groups.naml:1) - <macro name="manage_users_and_groups" requires="servlet"> Message: org.postgresql.util.PSQLException: ERROR: syntax error at or near "s" Position: 104 RequestURI: /template/NamlServlet.jtp Server: n8.nabble.com Caused by: nabble.view.lib.JtpContextServlet$JtpServletException: url=http://cult-of-tcap.82729.n8.nabble.com/template/NamlServlet.jtp?macro=manage_users_and_groups&group=Lorne%27s+Angel method=GET user-agent=Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/69.0.3497.100 Safari/537.36 referer=http://cult-of-tcap.82729.n8.nabble.com/template/NamlServlet.jtp?macro=manage_users_and_groups remote=216.73.220.169 at nabble.view.lib.JtpContextServlet.handleException(JtpContextServlet.java:541) at nabble.view.lib.JtpContextServlet.service2(JtpContextServlet.java:442) at nabble.view.lib.JtpContextServlet.service(JtpContextServlet.java:311) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:565) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1360) at org.eclipse.jetty.servlets.UserAgentFilter.doFilter(UserAgentFilter.java:77) at org.eclipse.jetty.servlets.GzipFilter.doFilter(GzipFilter.java:144) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331) at cachingfilter.CachingFilter.doFilter(CachingFilter.java:135) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331) at fschmidt.util.servlet.BadBotFilter.doFilter(BadBotFilter.java:74) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331) at fschmidt.util.servlet.ConnectionLimitFilter.doFilter(ConnectionLimitFilter.java:94) at nabble.view.lib.NabbleConnectionLimitFilter.doFilter(NabbleConnectionLimitFilter.java:26) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331) at nabble.view.lib.NabbleErrorFilter.doFilter(NabbleErrorFilter.java:21) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:477) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:225) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1031) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:406) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:186) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:965) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117) at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:250) at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:149) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:111) at org.eclipse.jetty.server.Server.handle(Server.java:349) at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:449) at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:910) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:634) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:230) at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:76) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:609) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:45) at nabble.model.Executors$1$1.run(Executors.java:27) at fschmidt.util.executor.ThreadTimer$1.run(ThreadTimer.java:18) at fschmidt.util.executor.AbstractThreadPool$1.run(AbstractThreadPool.java:29) at java.lang.Thread.run(Thread.java:748) Caused by: nabble.naml.compiler.TemplateRuntimeException: org.postgresql.util.PSQLException: ERROR: syntax error at or near "s" Position: 104 in users_in_group(nabble:manage_users_and_groups.naml:138) - <n.users_in_group. group="[n.group/]"> - public void nabble.view.web.template.NabbleNamespace.users_in_group(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.ScopedInterpreter) in set_value(nabble:manage_users_and_groups.naml:137) - <n.set_value.> - public void nabble.view.web.template.FieldNamespace.set_value(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.Interpreter) in do(nabble:manage_users_and_groups.naml:227) - <n.do/> in field(nabble:manage_users_and_groups.naml:227) - <n.field. name="users"> - public void nabble.view.web.template.ServletNamespace.field(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.ScopedInterpreter) in users_field(nabble:manage_users_and_groups.naml:137) - <n.users_field.set_value.> in if(nabble:ui_components.naml:72) - <n.if.selected> - public static void nabble.naml.namespaces.BasicNamespace._if(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.Interpreter) in while(nabble:utilities.naml:903) - <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:manage_users_and_groups.naml:46) - <n.loop.> in user_groups(nabble:manage_users_and_groups.naml:38) - <n.user_groups.> - public void nabble.view.web.template.NabbleNamespace.user_groups(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.ScopedInterpreter) in body(nabble:utilities.naml:10) - <n.body/> in nabble_html(responsive:responsive.naml:9) - <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:manage_users_and_groups.naml:12) - <n.html> in (nabble:manage_users_and_groups.naml:1) - <macro name="manage_users_and_groups" requires="servlet"> at nabble.naml.compiler.Compiler.interpFix(Compiler.java:2007) at nabble.naml.compiler.Compiler$Block.run(Compiler.java:1636) at nabble.naml.compiler.BlockWrapper.printTo(BlockWrapper.java:68) at nabble.naml.compiler.BlockWrapper.toString(BlockWrapper.java:62) at nabble.naml.compiler.Template.stringValue(Template.java:87) at nabble.naml.compiler.InterpreterImpl.getArgString(InterpreterImpl.java:31) at nabble.view.web.template.FieldNamespace.set_value(FieldNamespace.java:54) at sun.reflect.GeneratedMethodAccessor244.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at nabble.naml.compiler.JavaCall.invoke(JavaCall.java:26) at nabble.naml.compiler.Compiler$Block.invoke(Compiler.java:1557) at nabble.naml.compiler.Compiler$Block.run(Compiler.java:1631) at nabble.naml.compiler.BlockWrapper.printTo(BlockWrapper.java:68) at nabble.naml.compiler.ScopedInterpreterImpl$1.printTo(ScopedInterpreterImpl.java:25) at nabble.naml.compiler.TemplatePrintWriter.print(TemplatePrintWriter.java:22) at nabble.naml.compiler.BlockWrapper$BlockWriter.print(BlockWrapper.java:32) at nabble.view.web.template.ServletNamespace.field(ServletNamespace.java:135) at sun.reflect.GeneratedMethodAccessor118.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at nabble.naml.compiler.JavaCall.invoke(JavaCall.java:26) at nabble.naml.compiler.Compiler$Block.invoke(Compiler.java:1557) at nabble.naml.compiler.Compiler$Block.run(Compiler.java:1625) at nabble.naml.compiler.Compiler$Chunks.run(Compiler.java:1121) at nabble.naml.compiler.BlockWrapper.printTo(BlockWrapper.java:68) at nabble.naml.compiler.TemplatePrintWriter.print(TemplatePrintWriter.java:22) at nabble.naml.compiler.BlockWrapper$BlockWriter.print(BlockWrapper.java:32) at nabble.naml.namespaces.BasicNamespace._if(BasicNamespace.java:140) at sun.reflect.GeneratedMethodAccessor20.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at nabble.naml.compiler.JavaCall.invoke(JavaCall.java:26) at nabble.naml.compiler.Compiler$Block.invoke(Compiler.java:1557) at nabble.naml.compiler.Compiler$Block.run(Compiler.java:1631) at nabble.naml.compiler.BlockWrapper.printTo(BlockWrapper.java:68) at nabble.naml.compiler.TemplatePrintWriter.print(TemplatePrintWriter.java:22) at nabble.naml.compiler.BlockWrapper$BlockWriter.print(BlockWrapper.java:32) at nabble.naml.namespaces.BasicNamespace._while(BasicNamespace.java:563) at sun.reflect.GeneratedMethodAccessor101.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at nabble.naml.compiler.JavaCall.invoke(JavaCall.java:26) at nabble.naml.compiler.Compiler$Block.invoke(Compiler.java:1557) at nabble.naml.compiler.Compiler$Block.run(Compiler.java:1631) at nabble.naml.compiler.Compiler$Chunks.run(Compiler.java:1121) at nabble.naml.compiler.BlockWrapper.printTo(BlockWrapper.java:68) at nabble.naml.compiler.ScopedInterpreterImpl$1.printTo(ScopedInterpreterImpl.java:25) at nabble.naml.compiler.TemplatePrintWriter.print(TemplatePrintWriter.java:22) at nabble.naml.compiler.BlockWrapper$BlockWriter.print(BlockWrapper.java:32) at nabble.view.web.template.NabbleNamespace.user_groups(NabbleNamespace.java:442) at sun.reflect.GeneratedMethodAccessor398.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at nabble.naml.compiler.JavaCall.invoke(JavaCall.java:26) at nabble.naml.compiler.Compiler$Block.invoke(Compiler.java:1557) at nabble.naml.compiler.Compiler$Block.run(Compiler.java:1625) at nabble.naml.compiler.Compiler$Chunks.run(Compiler.java:1121) at nabble.naml.compiler.BlockWrapper.printTo(BlockWrapper.java:68) at nabble.naml.compiler.ScopedInterpreterImpl$1.printTo(ScopedInterpreterImpl.java:25) at nabble.naml.compiler.BlockWrapper.toString(BlockWrapper.java:62) at nabble.naml.compiler.ScopedInterpreterImpl.getArgString(ScopedInterpreterImpl.java:42) at nabble.view.web.template.HtmlNamespace.<init>(HtmlNamespace.java:31) at nabble.view.web.template.ServletNamespace.nabble_html(ServletNamespace.java:242) at sun.reflect.GeneratedMethodAccessor172.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at nabble.naml.compiler.JavaCall.invoke(JavaCall.java:26) at nabble.naml.compiler.Compiler$Block.invoke(Compiler.java:1557) at nabble.naml.compiler.Compiler$Block.run(Compiler.java:1625) at nabble.naml.compiler.Compiler$Chunks.run(Compiler.java:1121) at nabble.naml.compiler.Template.run(Template.java:61) at nabble.naml.compiler.Template.run(Template.java:33) at nabble.modules.ModuleManager.run(ModuleManager.java:269) at nabble.view.web.template.NamlServlet.service(NamlServlet.java:167) at nabble.view.web.template.NamlServlet.service(NamlServlet.java:135) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at nabble.view.lib.JtpContextServlet.service2(JtpContextServlet.java:440) ... 38 more Caused by: java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: syntax error at or near "s" Position: 104 at nabble.model.TagImpl.findTagUserIds(TagImpl.java:100) at nabble.model.SiteImpl.findTagUsers(SiteImpl.java:549) at nabble.view.lib.Permissions.getUsersInGroup(Permissions.java:88) at nabble.view.web.template.NabbleNamespace.users_in_group(NabbleNamespace.java:771) at sun.reflect.GeneratedMethodAccessor366.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at nabble.naml.compiler.JavaCall.invoke(JavaCall.java:26) at nabble.naml.compiler.Compiler$Block.invoke(Compiler.java:1557) at nabble.naml.compiler.Compiler$Block.run(Compiler.java:1631) ... 114 more Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "s" Position: 104 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254) at nabble.model.TagImpl.findTagUserIds(TagImpl.java:89) ... 123 more URL = http://cult-of-tcap.82729.n8.nabble.com/template/NamlServlet.jtp?macro=manage_users_and_groups&group=Lorne%27s+Angel - |
In reply to this post by emberenfierno
Hello Moderators and Support Team - apologies if replying to my own thread with new information is discourteous forum behavior. I'm not a very experienced forum contributor.
When I click on "manage permissions," I receive a similar error pointing at the apostrophe in one of my groups as the problem again. The following is the error. Thanks again for your help! Error 500 sqlCondition = node_id=1 and user_id is null and label='permission:View:Lorne\'s Angel' in has_permission(nabble:change_permissions.naml:319) - <n.set_value.page_node.has_permission group="[n.group/]" permission="[n.permission/]" /> - public void nabble.view.web.template.NodeNamespace.has_permission(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.Interpreter) in page_node(nabble:change_permissions.naml:319) - <n.set_value.page_node.has_permission group="[n.group/]" permission="[n.permission/]" /> - public void nabble.view.web.template.NodePageNamespace.page_node(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.ScopedInterpreter) in set_value(nabble:change_permissions.naml:319) - <n.set_value.page_node.has_permission group="[n.group/]" permission="[n.permission/]" /> - public void nabble.view.web.template.FieldNamespace.set_value(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.Interpreter) in field(nabble:change_permissions.naml:373) - <n.field> - public void nabble.view.web.template.ServletNamespace.field(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.ScopedInterpreter) in permission_field(nabble:change_permissions.naml:318) - <n.permission_field. group="[n.group/]" permission="[n.permission/]" > in while(nabble:utilities.naml:903) - <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_permissions.naml:260) - <n.loop.> in do(nabble:change_permissions.naml:395) - <n.do/> in user_groups(nabble:change_permissions.naml:391) - <n.user_groups.> - public void nabble.view.web.template.NabbleNamespace.user_groups(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.ScopedInterpreter) in permission_group_list(nabble:change_permissions.naml:260) - <n.permission_group_list.loop.> in permission_row(nabble:change_permissions.naml:167) - <n.permission_row permission = "[n.view_permission/]" description="[t]Who can view this application and its contents[/t]" administrators_cell = "true" authors_cell = "true" /> in edit_app_permission(nabble:change_permissions.naml:174) - <n.edit_app_permission/> in permission(nabble:change_permissions.naml:244) - <n.permission/> in (nabble:change_permissions.naml:175) - <t> in translation: Who can edit applications (e.g., change name, description, etc.)(nabble:change_permissions.naml:175) - <t> in description(nabble:change_permissions.naml:245) - <n.description/> in edit_app_permission(nabble:change_permissions.naml:174) - <n.edit_app_permission/> in permission(nabble:change_permissions.naml:248) - <n.permission/> in permission(nabble:change_permissions.naml:385) - <n.permission/> in text(nabble:utilities.naml:1029) - <n.text/> in nabble_html(responsive:responsive.naml:9) - <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_permissions.naml:19) - <n.html> in do(nabble:utilities.naml:976) - <n.as_node_page.do/> in as_node_page(nabble:utilities.naml:976) - <n.as_node_page.do/> - public void nabble.view.web.template.NodeNamespace.as_node_page(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.ScopedInterpreter) in do(nabble:utilities.naml:981) - <n.get_node_from_request_parameter.do/> in get_node_from_request_parameter(nabble:utilities.naml:981) - <n.get_node_from_request_parameter.do/> - public void nabble.view.web.template.ServletNamespace.get_node_from_request_parameter(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.ScopedInterpreter) throws java.io.IOException,javax.servlet.ServletException,nabble.naml.namespaces.TemplateException in catch_exception(nabble:utilities.naml:980) - <n.catch_exception. id="get-node-block"> - public void nabble.naml.namespaces.BasicNamespace.catch_exception(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.Interpreter) in (nabble:change_permissions.naml:1) - <macro name="change_permissions" requires="servlet"> Message: sqlCondition = node_id=1 and user_id is null and label='permission:View:Lorne\'s Angel' RequestURI: /template/NamlServlet.jtp Server: n8.nabble.com |
Nabble support thread or admin - can you please delete the group giving me problems? I have not been able to add anyone to the forum. I'm unable to manage user permission
PLEASE HELP ME! I'M AN IDIOT! |
Looking into this
|
Fixed
|
Free forum by Nabble | Edit this page |