Dear All,
Recently I have tried to upgrade a DSpace 1.8 installation to 3.0;
Funny things happen here and there.
After completing all the requirements listed on the '1.8 to 3.0' guide, the
webpage works well and there is only log4j errors in the catalina output.
However, when I tried to browse any items or any collctions, the following
errors will be generated.
Notice that the SQL statement has a few problems:
javax.servlet.ServletException: 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 NULLS LAST LIMIT ?
communities2item.community_id = ?
mappings
NULLS
LIMIT ?
I have tried to do dspace index-init, update-discovery-index but no help.
Can any one shed me lights on this one?
Thanks,
Alexander Wong.
2014-01-10 17:23:49,917 WARN
org.dspace.app.webui.servlet.InternalErrorServlet @
:session_id=4DDF86F44C71459A348342325A63CE91:internal_error:-- URL Was:
http://158.132.160.6/jspui/handle/10397/11
-- Method: GET
-- Parameters were:
javax.servlet.ServletException: 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 NULLS LAST LIMIT ?
at
org.dspace.app.webui.servlet.HandleServlet.preProcessCommunityHome(HandleServlet.java:528)
at
org.dspace.app.webui.servlet.HandleServlet.communityHome(HandleServlet.java:472)
at
org.dspace.app.webui.servlet.HandleServlet.doDSGet(HandleServlet.java:254)
at
org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:119)
at
org.dspace.app.webui.servlet.DSpaceServlet.doGet(DSpaceServlet.java:67)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.dspace.utils.servlet.DSpaceWebappServletFilter.doFilter(DSpaceWebappServletFilter.java:78)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:662)
Caused by: 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 NULLS LAST LIMIT ?
at
org.dspace.app.webui.components.RecentCommunitySubmissions.process(RecentCommunitySubmissions.java:53)
at
org.dspace.app.webui.servlet.HandleServlet.preProcessCommunityHome(HandleServlet.java:522)
... 21 more
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 NULLS LAST LIMIT ?
at
org.dspace.app.webui.components.RecentSubmissionsManager.getRecentSubmissions(RecentSubmissionsManager.java:102)
at
org.dspace.app.webui.components.RecentCommunitySubmissions.process(RecentCommunitySubmissions.java:48)
... 22 more
Caused by: org.dspace.browse.BrowseException: problem with query: SELECT
bi_item.* FROM bi_item, (SELECT