Quantcast

Error 500

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

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 	
Just a Volunteer Nabble Helper - because the nice folk at Nabble have helped me!
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Error 500

Hugo <Nabble>
Administrator
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.
Official Nabble Administrator - we never ask for passwords.
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

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.
Just a Volunteer Nabble Helper - because the nice folk at Nabble have helped me!
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Error 500

Hugo <Nabble>
Administrator
The fix has been released, so single quotes in a file name shouldn't create more issues.
Official Nabble Administrator - we never ask for passwords.
Loading...