To all,
I have been getting an internal server error whenever a user tries to enter their email address and click register, on dspace version 1.2.1. The system is not visible to the internet. Is that error generated because the machine has no external IP address and is not visible to internet or is it something else? The other features seam to be working.
Does anyone have any input on this?
Thanks,
Nigel Pegus
Systems
Unit
The Main Library,
The University of the West Indies,
St. Augustine
Campus,
St. Augustine,
Trinidad and Tobago,
West Indies.
Tel: 868-662-2002 ext 2263
Fax: 868-662-9238
<!--
org.dspace.app.webui.components.RecentSubmissionsException: org.dspace.browse.BrowseException: problem with query: SELECT bi_item.* FROM bi_item, (SELECT communities2item.item_id FROM communities2item WHERE communities2item.community_id=? ) mappings WHERE bi_item.item_id=mappings.item_id ORDER BY sort_3 DESC LIMIT ?
=============================================
org.dspace.plugin.PluginException: org.dspace.app.webui.components.RecentSubmissionsException: org.dspace.browse.BrowseException: problem with query: SELECT bi_item.* FROM bi_item, (SELECT communities2item.item_id FROM communities2item WHERE communities2item.community_id=? ) mappings WHERE bi_item.item_id=mappings.item_id ORDER BY sort_3 DESC LIMIT ?
at org.dspace.app.webui.components.RecentCommunitySubmissions.process(RecentCommunitySubmissions.java:85)
at org.dspace.app.webui.servlet.HandleServlet.preProcessCommunityHome(HandleServlet.java:455)
at org.dspace.app.webui.servlet.HandleServlet.communityHome(HandleServlet.java:413)
at org.dspace.app.webui.servlet.HandleServlet.doDSGet(HandleServlet.java:239)
at org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:151)
at org.dspace.app.webui.servlet.DSpaceServlet.doGet(DSpaceServlet.java:99)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:595)
Caused by: org.dspace.app.webui.components.RecentSubmissionsException: org.dspace.browse.BrowseException: problem with query: SELECT bi_item.* FROM bi_item, (SELECT communities2item.item_id FROM communities2item WHERE communities2item.community_id=? ) mappings WHERE bi_item.item_id=mappings.item_id ORDER BY sort_3 DESC LIMIT ?
at org.dspace.app.webui.components.RecentSubmissionsManager.getRecentSubmissions(RecentSubmissionsManager.java:132)
at org.dspace.app.webui.components.RecentCommunitySubmissions.process(RecentCommunitySubmissions.java:80)
... 21 more
Caused by: org.dspace.browse.BrowseException: problem with query: SELECT bi_item.* FROM bi_item, (SELECT communities2item.item_id FROM communities2item WHERE communities2item.community_id=? ) mappings WHERE bi_item.item_id=mappings.item_id ORDER BY sort_3 DESC LIMIT ?
at org.dspace.browse.BrowseDAOPostgres.doQuery(BrowseDAOPostgres.java:403)
at org.dspace.browse.BrowseEngine.browseMini(BrowseEngine.java:198)
at org.dspace.app.webui.components.RecentSubmissionsManager.getRecentSubmissions(RecentSubmissionsManager.java:116)
... 22 more
Caused by: org.postgresql.util.PSQLException: ERROR: column "sort_3" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at org.dspace.storage.rdbms.DatabaseManager.query(DatabaseManager.java:221)
at org.dspace.browse.BrowseDAOPostgres.doQuery(BrowseDAOPostgres.java:385)
... 24 more
org.dspace.browse.BrowseException: problem with query: SELECT bi_item.* FROM bi_item, (SELECT communities2item.item_id FROM communities2item WHERE communities2item.community_id=? ) mappings WHERE bi_item.item_id=mappings.item_id ORDER BY sort_3 DESC LIMIT ?
=============================================
org.dspace.app.webui.components.RecentSubmissionsException: org.dspace.browse.BrowseException: problem with query: SELECT bi_item.* FROM bi_item, (SELECT communities2item.item_id FROM communities2item WHERE communities2item.community_id=? ) mappings WHERE bi_item.item_id=mappings.item_id ORDER BY sort_3 DESC LIMIT ?
at org.dspace.app.webui.components.RecentSubmissionsManager.getRecentSubmissions(RecentSubmissionsManager.java:132)
at org.dspace.app.webui.components.RecentCommunitySubmissions.process(RecentCommunitySubmissions.java:80)
at org.dspace.app.webui.servlet.HandleServlet.preProcessCommunityHome(HandleServlet.java:455)
at org.dspace.app.webui.servlet.HandleServlet.communityHome(HandleServlet.java:413)
at org.dspace.app.webui.servlet.HandleServlet.doDSGet(HandleServlet.java:239)
at org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:151)
at org.dspace.app.webui.servlet.DSpaceServlet.doGet(DSpaceServlet.java:99)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:595)
Caused by: org.dspace.browse.BrowseException: problem with query: SELECT bi_item.* FROM bi_item, (SELECT communities2item.item_id FROM communities2item WHERE communities2item.community_id=? ) mappings WHERE bi_item.item_id=mappings.item_id ORDER BY sort_3 DESC LIMIT ?
at org.dspace.browse.BrowseDAOPostgres.doQuery(BrowseDAOPostgres.java:403)
at org.dspace.browse.BrowseEngine.browseMini(BrowseEngine.java:198)
at org.dspace.app.webui.components.RecentSubmissionsManager.getRecentSubmissions(RecentSubmissionsManager.java:116)
... 22 more
Caused by: org.postgresql.util.PSQLException: ERROR: column "sort_3" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at org.dspace.storage.rdbms.DatabaseManager.query(DatabaseManager.java:221)
at org.dspace.browse.BrowseDAOPostgres.doQuery(BrowseDAOPostgres.java:385)
... 24 more
problem with query: SELECT bi_item.* FROM bi_item, (SELECT communities2item.item_id FROM communities2item WHERE communities2item.community_id=? ) mappings WHERE bi_item.item_id=mappings.item_id ORDER BY sort_3 DESC LIMIT ?
=============================================
org.dspace.browse.BrowseException: problem with query: SELECT bi_item.* FROM bi_item, (SELECT communities2item.item_id FROM communities2item WHERE communities2item.community_id=? ) mappings WHERE bi_item.item_id=mappings.item_id ORDER BY sort_3 DESC LIMIT ?
at org.dspace.browse.BrowseDAOPostgres.doQuery(BrowseDAOPostgres.java:403)
at org.dspace.browse.BrowseEngine.browseMini(BrowseEngine.java:198)
at org.dspace.app.webui.components.RecentSubmissionsManager.getRecentSubmissions(RecentSubmissionsManager.java:116)
at org.dspace.app.webui.components.RecentCommunitySubmissions.process(RecentCommunitySubmissions.java:80)
at org.dspace.app.webui.servlet.HandleServlet.preProcessCommunityHome(HandleServlet.java:455)
at org.dspace.app.webui.servlet.HandleServlet.communityHome(HandleServlet.java:413)
at org.dspace.app.webui.servlet.HandleServlet.doDSGet(HandleServlet.java:239)
at org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:151)
at org.dspace.app.webui.servlet.DSpaceServlet.doGet(DSpaceServlet.java:99)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:595)
Caused by: org.postgresql.util.PSQLException: ERROR: column "sort_3" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at org.dspace.storage.rdbms.DatabaseManager.query(DatabaseManager.java:221)
at org.dspace.browse.BrowseDAOPostgres.doQuery(BrowseDAOPostgres.java:385)
... 24 more
ERROR: column "sort_3" does not exist
=============================================
org.postgresql.util.PSQLException: ERROR: column "sort_3" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1531)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1313)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at org.dspace.storage.rdbms.DatabaseManager.query(DatabaseManager.java:221)
at org.dspace.browse.BrowseDAOPostgres.doQuery(BrowseDAOPostgres.java:385)
at org.dspace.browse.BrowseEngine.browseMini(BrowseEngine.java:198)
at org.dspace.app.webui.components.RecentSubmissionsManager.getRecentSubmissions(RecentSubmissionsManager.java:116)
at org.dspace.app.webui.components.RecentCommunitySubmissions.process(RecentCommunitySubmissions.java:80)
at org.dspace.app.webui.servlet.HandleServlet.preProcessCommunityHome(HandleServlet.java:455)
at org.dspace.app.webui.servlet.HandleServlet.communityHome(HandleServlet.java:413)
at org.dspace.app.webui.servlet.HandleServlet.doDSGet(HandleServlet.java:239)
at org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:151)
at org.dspace.app.webui.servlet.DSpaceServlet.doGet(DSpaceServlet.java:99)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:595)
-->