Error 500 help please? user can only view their own topics.

[augidog]

 when logged out, my users, me too, can view stuff, but when logged in, we can only view our own stuff, we get this on all other threads and other view modes:

Error 500
sqlCondition = node_id is null and user_id is null and label='permission:View:Who\'s In'
        in has_permission(nabble:permissions.naml:257) - <n.has_permission node="[n.local_node/]" permission_node="[n.local_node.app_or_root/]" permission="[n.view_permission/]"/> - public void nabble.view.web.template.UserNamespace.has_permission(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.Interpreter)
        in do(nabble:utilities.naml:1142) - <n.do/>
        in get_user(nabble:utilities.naml:1142) - <n.get_user user="[n.uplevel_var name='local_user'/]" do="[n.do/]" /> - public void nabble.view.web.template.NabbleNamespace.get_user(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.ScopedInterpreter)
        in local_user(nabble:permissions.naml:257) - <condition1.local_user.has_permission node="[n.local_node/]" permission_node="[n.local_node.app_or_root/]" permission="[n.view_permission/]" />
        in uplevel_var(nabble:utilities.naml:1142) - <n.uplevel_var name='local_user'/> - public void nabble.naml.namespaces.BasicNamespace.uplevel_var(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.Interpreter)
        in either(nabble:permissions.naml:256) - <condition2.either> - public static void nabble.naml.namespaces.BasicNamespace.either(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.Interpreter)
        in either(nabble:permissions.naml:254) - <n.either> - public static void nabble.naml.namespaces.BasicNamespace.either(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.Interpreter)
        in block(nabble:permissions.naml:253) - <n.block.> - public void nabble.naml.namespaces.BasicNamespace.block(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.ScopedInterpreter)
        in (nabble:permissions.naml:250) - <macro name="can_view" requires="user" dot_parameter="node_attr">

Message: sqlCondition = node_id is null and user_id is null and label='permission:View:Who\'s In'

RequestURI: /Howdy-All-Just-registered-as-SoGAMaB-South-Ga-Motor-Assisited-Bicycle-tp5709160.html

Server: n5.nabble.com

Caused by:
fschmidt.util.servlet.JtpContextServlet$JtpServletException: url=http://motor-assisted-bicycling.1062526.n5.nabble.com/Howdy-All-Just-registered-as-SoGAMaB-South-Ga-Motor-Assisited-Bicycle-tp5709160.html  method=GET user-agent=Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko referer=http://motor-assisted-bicycling.1062526.n5.nabble.com/Introduce-Yourself-f4723622.html remote=71.11.71.112
        at fschmidt.util.servlet.JtpContextServlet.handleException(JtpContextServlet.java:558)
        at fschmidt.util.servlet.JtpContextServlet.service2(JtpContextServlet.java:463)
        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: nabble.naml.compiler.TemplateRuntimeException: sqlCondition = node_id is null and user_id is null and label='permission:View:Who\'s In'
        in has_permission(nabble:permissions.naml:257) - <n.has_permission node="[n.local_node/]" permission_node="[n.local_node.app_or_root/]" permission="[n.view_permission/]"/> - public void nabble.view.web.template.UserNamespace.has_permission(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.Interpreter)
        in do(nabble:utilities.naml:1142) - <n.do/>
        in get_user(nabble:utilities.naml:1142) - <n.get_user user="[n.uplevel_var name='local_user'/]" do="[n.do/]" /> - public void nabble.view.web.template.NabbleNamespace.get_user(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.ScopedInterpreter)
        in local_user(nabble:permissions.naml:257) - <condition1.local_user.has_permission node="[n.local_node/]" permission_node="[n.local_node.app_or_root/]" permission="[n.view_permission/]" />
        in uplevel_var(nabble:utilities.naml:1142) - <n.uplevel_var name='local_user'/> - public void nabble.naml.namespaces.BasicNamespace.uplevel_var(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.Interpreter)
        in either(nabble:permissions.naml:256) - <condition2.either> - public static void nabble.naml.namespaces.BasicNamespace.either(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.Interpreter)
        in either(nabble:permissions.naml:254) - <n.either> - public static void nabble.naml.namespaces.BasicNamespace.either(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.Interpreter)
        in block(nabble:permissions.naml:253) - <n.block.> - public void nabble.naml.namespaces.BasicNamespace.block(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.ScopedInterpreter)
        in (nabble:permissions.naml:250) - <macro name="can_view" requires="user" dot_parameter="node_attr">
        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.NabbleNamespace.get_user(NabbleNamespace.java:534)
        at sun.reflect.GeneratedMethodAccessor37.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.BlockWrapper.toString(BlockWrapper.java:62)
        at nabble.naml.compiler.Template.stringValue(Template.java:87)
        at nabble.naml.compiler.Template.booleanValue(Template.java:103)
        at nabble.naml.compiler.InterpreterImpl.getArgAsBoolean(InterpreterImpl.java:75)
        at nabble.naml.namespaces.BasicNamespace.either(BasicNamespace.java:108)
        at sun.reflect.GeneratedMethodAccessor36.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.BlockWrapper.toString(BlockWrapper.java:62)
        at nabble.naml.compiler.Template.stringValue(Template.java:87)
        at nabble.naml.compiler.Template.booleanValue(Template.java:103)
        at nabble.naml.compiler.InterpreterImpl.getArgAsBoolean(InterpreterImpl.java:75)
        at nabble.naml.namespaces.BasicNamespace.either(BasicNamespace.java:108)
        at sun.reflect.GeneratedMethodAccessor36.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.namespaces.BasicNamespace.block(BasicNamespace.java:952)
        at sun.reflect.GeneratedMethodAccessor150.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.Compiler$VarScope.run(Compiler.java:1259)
        at nabble.naml.compiler.Template.run(Template.java:61)
        at nabble.naml.compiler.Template.run(Template.java:33)
        at nabble.view.lib.Jtp.can(Jtp.java:927)
        at nabble.view.lib.Jtp.canBeViewedBy(Jtp.java:946)
        at nabble.view.web.forum.Permalink.service(Permalink.java:101)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
        at fschmidt.util.servlet.JtpContextServlet.service2(JtpContextServlet.java:461)
        ... 38 more
Caused by: java.lang.RuntimeException: sqlCondition = node_id is null and user_id is null and label='permission:View:Who\'s In'
        at nabble.model.TagImpl.countTags(TagImpl.java:60)
        at nabble.model.SiteImpl$2.get(SiteImpl.java:514)
        at nabble.model.SiteImpl$2.get(SiteImpl.java:512)
        at fschmidt.util.java.Memoizer$1.call(Memoizer.java:30)
        at java.util.concurrent.FutureTask.run(FutureTask.java:262)
        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.hasPermission(Permissions.java:242)
        at nabble.view.web.template.UserNamespace.has_permission(UserNamespace.java:193)
        at sun.reflect.GeneratedMethodAccessor67.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)
        ... 92 more
Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "s"
  Position: 105
        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)
        ... 107 more


I haven't changed anything, and this problem is about a day old as far as I can tell. thanks in advance for any pointers.

[augidog]

I can't view or change permissions or groups...and I cannot get into editor. someone, anyone, please help.

[GregChapman]

Has this problem righted itself?

I registered some time ago to test your site on a previous occasion (using an email address I no longer read).

Everything appears normal for me both before and after logging in at the moment. Perhaps that's because I have made no posts.

Do you have a test user that has made no posts to confirm this?

[augidog]

it appears to be connected to the usergroup "Who's In" of which I am a member. Note, it's not "Who\'s In" as expressed in the error message, if that matters. I never edited in that backward slash.

I'm stumped, except for this possible clue, did I get my java hacked or similar?

ERROR: syntax error at or near "s"

I can admin any group EXCEPT this one, I'd delete it, rename it, and rebuild it IF I could, but I CANNOT edit anyone who's in this group, and I cannot access permissions mode. Ergo, I can't really edit anything, I am locked out of helping myself in this case. I need staff help. If this is something I've done wrong, I'd pay for a single help ticket, but until staff has a look, I'm clueless AND I have a badly functioning forum.

[augidog]

Look, I am completely SERIOUS...READ the error message. I CANNOT help myself, because I am a member of the usergroup that seems to be the issue. I CANNOT as Admin go anywhere near anything that involves that usergroup, I can't display it, therefore I CANNOT delete it. ANYONE in that usergroup receives the same identical error message when trying to view content from anyone else in the group. Apparently, the group name has been edited or hacked, resulting in a syntax error. I myself haven't modified my code in ages, so I am clueless and NEED HELP.

HOW MUCH for a single Help Ticket if this is something I've done wrong?

[augidog]

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

[Pedro]

We have renamed that group: http://motor-assisted-bicycling.1062526.n5.nabble.com/template/NamlServlet.jtp?macro=manage_users_and_groups&group=Who-is-in .

[augidog]

THANK YOU VERY MUCH!!!

do you have any idea how this occurred? is there something I should be looking out for?

[augidog]

I guess what I'm asking is, since we used the group as named successfully for a long time, is it possible someone went in and inserted the syntax error, or did some of the core code recently change, making the apostrophe unusable?

inquiring minds want to know. again, thank you, Pedro...I was at a total loss.

[Pedro]

I don't know how someone could name that group using apostrophe.

[augidog]

huh...well, I don't know why it worked either, but it did. trust me, from now on, if I make changes, which I don't expect I will, I will definitely keep it simple.