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

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

Posted by augidog on Nov 10, 2014; 2:40am
URL: https://support.nabble.com/Error-500-help-please-user-can-only-view-their-own-topics-tp7592497.html

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.

http://motor-assisted-bicycling.1062526.n5.nabble.com/