Error 500

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Error 500

GregChapman
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.
Reply | Threaded
Open this post in threaded view
|

Re: Error 500

Hugo <Nabble>
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.
Reply | Threaded
Open this post in threaded view
|

Re: Error 500

GregChapman
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.
Reply | Threaded
Open this post in threaded view
|

Re: Error 500

Hugo <Nabble>
The fix has been released, so single quotes in a file name shouldn't create more issues.