Hi Hugo,
I keep getting this error on attempting to post a message at: http://band-forum.2320619.n4.nabble.com/template/NamlServlet.jtp?macro=new_topic&node=2 I can preview the message, but posting fails. Is it really my NAML changes that cause it? Error 500 NAML exception in customized site: org.postgresql.util.PSQLException: ERROR: syntax error at or near "ll_Be_Sorry" Position: 133 in create_child_of_page_node(nabble:reply.naml:33) - <n.create_child_of_page_node commit="[n.not.is_preview/]"> - public void nabble.view.web.template.NodePageNamespace.create_child_of_page_node(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.ScopedInterpreter) throws nabble.model.ModelException,javax.servlet.ServletException in catch_exception(nabble:reply.naml:29) - <n.catch_exception. id="save-block"> - public void nabble.naml.namespaces.BasicNamespace.catch_exception(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.Interpreter) in if(nabble:reply.naml:22) - <n.if.not.is_submitted_form> - public static void nabble.naml.namespaces.BasicNamespace._if(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.Interpreter) in comment(nabble:utilities.naml:50) - <n.comment.> in page_start(responsive:responsive.naml:7) - <n.page_start/> in current_permission_version(nabble:permissions.naml:6) - <n.current_permission_version/> in as_node_page(nabble:utilities.naml:986) - <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:991) - <n.get_node_from_request_parameter.do/> in get_node_from_request_parameter(nabble:utilities.naml:991) - <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:990) - <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:new_topic.naml:1) - <macro name="new_topic" requires="servlet"> Message: NAML exception in customized site: org.postgresql.util.PSQLException: ERROR: syntax error at or near "ll_Be_Sorry" Position: 133 RequestURI: /template/NamlServlet.jtp Server: n4.nabble.com Caused by: fschmidt.util.servlet.JtpContextServlet$JtpServletException: url=http://band-forum.2320619.n4.nabble.com/template/NamlServlet.jtp?macro=new_topic&node=2&s4=Post Message&poll_show_results_before_end=true&subject=Someday, After A While&new_topic=&poll_allow_vote_change=true&poll_max_choices=1&message=Here's three versions of the number we tried out this afternoon... The original, by <nabble_a href="Someday_After_A_While_-_Freddy_King.mp3">Freddy King</nabble_a> (Key F) The first version I heard, back in the 1960s, by <nabble_a href="13-Someday_After_A_While_(You'll_Be_Sorry).mp3">John Mayall</nabble_a> (Key F) And a more recent version by <nabble_a href="13-Someday_After_A_While.mp3">Eric Clapton</nabble_a> (Key D) And my <nabble_a href="Someday_After_A_While.pdf">Chord Sheet</nabble_a>. (Key A)&poll_question=&poll_days_left=&poll_show_results_before_vote=true user-agent=Mozilla/5.0 (Windows NT 6.1; rv:39.0) Gecko/20100101 Firefox/39.0 method=POST referer=http://band-forum.2320619.n4.nabble.com/template/NamlServlet.jtp?new_topic 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:126) 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.content(AbstractHttpConnection.java:925) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:857) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235) 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 "ll_Be_Sorry" Position: 133 in create_child_of_page_node(nabble:reply.naml:33) - <n.create_child_of_page_node commit="[n.not.is_preview/]"> - public void nabble.view.web.template.NodePageNamespace.create_child_of_page_node(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.ScopedInterpreter) throws nabble.model.ModelException,javax.servlet.ServletException in catch_exception(nabble:reply.naml:29) - <n.catch_exception. id="save-block"> - public void nabble.naml.namespaces.BasicNamespace.catch_exception(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.Interpreter) in if(nabble:reply.naml:22) - <n.if.not.is_submitted_form> - public static void nabble.naml.namespaces.BasicNamespace._if(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.Interpreter) in comment(nabble:utilities.naml:50) - <n.comment.> in page_start(responsive:responsive.naml:7) - <n.page_start/> in current_permission_version(nabble:permissions.naml:6) - <n.current_permission_version/> in as_node_page(nabble:utilities.naml:986) - <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:991) - <n.get_node_from_request_parameter.do/> in get_node_from_request_parameter(nabble:utilities.naml:991) - <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:990) - <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:new_topic.naml:1) - <macro name="new_topic" 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 "ll_Be_Sorry" Position: 133 in create_child_of_page_node(nabble:reply.naml:33) - <n.create_child_of_page_node commit="[n.not.is_preview/]"> - public void nabble.view.web.template.NodePageNamespace.create_child_of_page_node(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.ScopedInterpreter) throws nabble.model.ModelException,javax.servlet.ServletException in catch_exception(nabble:reply.naml:29) - <n.catch_exception. id="save-block"> - public void nabble.naml.namespaces.BasicNamespace.catch_exception(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.Interpreter) in if(nabble:reply.naml:22) - <n.if.not.is_submitted_form> - public static void nabble.naml.namespaces.BasicNamespace._if(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.Interpreter) in comment(nabble:utilities.naml:50) - <n.comment.> in page_start(responsive:responsive.naml:7) - <n.page_start/> in current_permission_version(nabble:permissions.naml:6) - <n.current_permission_version/> in as_node_page(nabble:utilities.naml:986) - <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:991) - <n.get_node_from_request_parameter.do/> in get_node_from_request_parameter(nabble:utilities.naml:991) - <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:990) - <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:new_topic.naml:1) - <macro name="new_topic" 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.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.namespaces.BasicNamespace.catch_exception(BasicNamespace.java:599) at sun.reflect.GeneratedMethodAccessor66.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) 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.namespaces.BasicNamespace._if(BasicNamespace.java:140) at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) 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.view.web.template.NodeNamespace.as_node_page(NodeNamespace.java:869) at sun.reflect.GeneratedMethodAccessor70.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) 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_node_from_request_parameter(ServletNamespace.java:382) at sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) 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.TemplatePrintWriter.print(TemplatePrintWriter.java:22) at nabble.naml.namespaces.BasicNamespace.catch_exception(BasicNamespace.java:599) at sun.reflect.GeneratedMethodAccessor66.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) 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.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 "ll_Be_Sorry" Position: 133 at nabble.model.FileUpload.deleteUnusedFiles(FileUpload.java:415) at nabble.model.FileUpload.access$100(FileUpload.java:37) at nabble.model.FileUpload$6.event(FileUpload.java:382) at nabble.model.FileUpload$6.event(FileUpload.java:376) at fschmidt.db.ListenerList.event(ListenerList.java:49) at fschmidt.db.ListenerList.event(ListenerList.java:49) at fschmidt.db.base.DbRecordImpl$2.run(DbRecordImpl.java:167) at fschmidt.db.pool.PooledConnection.commit(PooledConnection.java:155) at fschmidt.db.pool.PooledConnection.commitTransaction(PooledConnection.java:259) at fschmidt.db.pool.Pool.commitTransaction(Pool.java:70) at fschmidt.db.pool.DbDatabaseImpl.commitTransaction(DbDatabaseImpl.java:90) at fschmidt.db.extend.FilterDatabase.commitTransaction(FilterDatabase.java:99) at nabble.view.web.template.NodePageNamespace.create_child_of_page_node(NodePageNamespace.java:139) at sun.reflect.GeneratedMethodAccessor452.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) 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) ... 95 more Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "ll_Be_Sorry" Position: 133 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:388) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334) at nabble.model.FileUpload.deleteUnusedFiles(FileUpload.java:411) ... 113 more Powered by Nabble
Volunteer Helper - but recommending that users move off the platform!
Once the admin for GregHelp now deleted. |
Please remove the single quote from the file "13-Someday_After_A_While_(You'll_Be_Sorry).mp3". You can rename it to something else. We will release a fix for this issue soon, but you can just rename the file for now. Please let me know this works.
|
Yes, it works.
It would appear to be a bug introduced since 2013 as I was getting the same error message when trying to move some topics originally posted in 2012 and 2013 that included links to mp3's with apostrophes in the song title.
Volunteer Helper - but recommending that users move off the platform!
Once the admin for GregHelp now deleted. |
The fix has been released, so single quotes in a file name shouldn't create more issues.
|
Free forum by Nabble | Edit this page |