Posted by
augidog on
Nov 12, 2014; 5:09pm
URL: https://support.nabble.com/Error-500-help-please-user-can-only-view-their-own-topics-tp7592497p7592575.html
if I as admin go to "manage users and groups" and then click on my custom group "Who's In" I get the following Error Message:
NAML exception in customized site: org.postgresql.util.PSQLException: ERROR: syntax error at or near "s"
Position: 102
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:909) - <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(nabble:utilities.naml:19) - <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: NAML exception in customized site: org.postgresql.util.PSQLException: ERROR: syntax error at or near "s"
Position: 102
RequestURI: /template/NamlServlet.jtp
Server: n5.nabble.com
Caused by:
fschmidt.util.servlet.JtpContextServlet$JtpServletException: url=
http://motor-assisted-bicycling.1062526.n5.nabble.com/template/NamlServlet.jtp?macro=manage_users_and_groups&group=Who%27s+In user-agent=Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko method=GET referer=
http://motor-assisted-bicycling.1062526.n5.nabble.com/template/NamlServlet.jtp?macro=manage_users_and_groups at fschmidt.util.servlet.JtpContextServlet.handleException(JtpContextServlet.java:571)
at fschmidt.util.servlet.JtpContextServlet.service2(JtpContextServlet.java:465)
at fschmidt.util.servlet.JtpContextServlet.service(JtpContextServlet.java:332)
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:133)
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:745)
Caused by: javax.servlet.ServletException: NAML exception in customized site: org.postgresql.util.PSQLException: ERROR: syntax error at or near "s"
Position: 102
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:909) - <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(nabble:utilities.naml:19) - <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.view.web.template.NamlServlet.checkTweaked(NamlServlet.java:185)
at nabble.view.web.template.NamlServlet.service(NamlServlet.java:144)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at fschmidt.util.servlet.JtpContextServlet.service2(JtpContextServlet.java:461)
... 38 more
Caused by: nabble.naml.compiler.TemplateRuntimeException: org.postgresql.util.PSQLException: ERROR: syntax error at or near "s"
Position: 102
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:909) - <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(nabble:utilities.naml:19) - <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.GeneratedMethodAccessor254.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
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:132)
at sun.reflect.GeneratedMethodAccessor184.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
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.GeneratedMethodAccessor10.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
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.GeneratedMethodAccessor64.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
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:460)
at sun.reflect.GeneratedMethodAccessor493.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
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:30)
at nabble.view.web.template.ServletNamespace.nabble_html(ServletNamespace.java:237)
at sun.reflect.GeneratedMethodAccessor162.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
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:268)
at nabble.view.web.template.NamlServlet.service(NamlServlet.java:165)
at nabble.view.web.template.NamlServlet.service(NamlServlet.java:134)
... 40 more
Caused by: java.lang.RuntimeException: org.postgresql.util.PSQLException: ERROR: syntax error at or near "s"
Position: 102
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:789)
at sun.reflect.GeneratedMethodAccessor120.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
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: 102
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