Error 500 when trying to download archive.

[Johann Petrak]

I just tried to use Options->Download Archives for the gate-users mailing list (http://gate-users-mailing-list-archive-read-only-no-new-topics-or-rep.1053641.n5.nabble.com/) and got the follogin error (together with a message telling me to contact support):


Error 500

org.postgresql.util.PSQLException: The column index is out of range: 1, number of columns: 0.

Message: org.postgresql.util.PSQLException: The column index is out of range: 1, number of columns: 0.

RequestURI: /forum/Archives.jtp

Server: n5.nabble.com
Caused by:

fschmidt.util.servlet.JtpContextServlet$JtpServletException: url=http://gate-users-mailing-list-archive-read-only-no-new-topics-or-rep.1053641.n5.nabble.com/forum/Archives.jtp  method=GET user-agent=Mozilla/5.0 (X11; Linux i686; rv:13.0) Gecko/20100101 Firefox/13.0 referer=http://gate-users-mailing-list-archive-read-only-no-new-topics-or-rep.1053641.n5.nabble.com/ remote=84.113.48.231
        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 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:662)
Caused by: java.lang.RuntimeException: org.postgresql.util.PSQLException: The column index is out of range: 1, number of columns: 0.
        at nabble.model.FileUpload.getFileDetails(FileUpload.java:166)
        at nabble.model.export.XMLBackupGenerator.getBackupFiles(XMLBackupGenerator.java:242)
        at nabble.view.web.forum.Archives.service(Archives.java:53)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
        at fschmidt.util.servlet.JtpContextServlet.service2(JtpContextServlet.java:461)
        ... 37 more
Caused by: org.postgresql.util.PSQLException: The column index is out of range: 1, number of columns: 0.
        at org.postgresql.core.v3.SimpleParameterList.bind(SimpleParameterList.java:53)
        at org.postgresql.core.v3.SimpleParameterList.setLiteralParameter(SimpleParameterList.java:114)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.bindLiteral(AbstractJdbc2Statement.java:2176)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.setLong(AbstractJdbc2Statement.java:1228)
        at nabble.model.FileUpload.setParams(FileUpload.java:71)
        at nabble.model.FileUpload.getFileDetails(FileUpload.java:154)
        ... 41 more

[Pedro]

Is it ok now?

[Johann Petrak]

I am sorry to say that the same error still occurs.

[Hugo <Nabble>]

We fixed this problem. Thanks for reporting it.

[Johann Petrak]

I am sorry that I have to tell you that a new error occurs now:
I can now start the generation of the archive (thank you for fixing this!!)
But after a short while I get an email with the text I posted below.
A small other suggestion: after pressing the button for generating the archive,
maybe it would be better to grey out the button or otherwise show that
the generation has been started? Otherwise one could get the impression
that nothing has happened and press the button again, stuffing your servers
with unnecessary generation jobs.

Dear user,

An error occurred during archive generation of the "gate-users mailing list archive (read-only, no new topics or replies allowed)" forum:

java.lang.UnsupportedOperationException
        nabble.modules.poll.PollImpl$1.getExportData(PollImpl.java:45)
        nabble.modules.poll.PollImpl$1.getExportData(PollImpl.java:21)
        nabble.model.NodeImpl.getData(NodeImpl.java:2118)
        nabble.model.export.Export.export(Export.java:173)
        nabble.model.export.Export.run(Export.java:112)
        nabble.model.Executors$1$1.run(Executors.java:27)
        fschmidt.util.executor.ThreadTimer$1.run(ThreadTimer.java:18)
        fschmidt.util.executor.AbstractThreadPool$1.run(AbstractThreadPool.java:29)
        java.lang.Thread.run(Thread.java:662)

You may post a message about this problem in the Nabble Support forum:
http://support.nabble.com/

[Pedro]

Hi,
please try again. I've just tested on my own forum and now it is woking fine.

[Johann Petrak]

Thank you -- this time everything worked just fine!