Can You have a look in Your dspace.log and post the lines belonging to Your error?
Greetings Robert David Marcinkowski schrieb: > Hello, > After installing and setting up our installation of DSpace, I tried to > create a top level community and when I do so I get a "Internal Server > Error". > > Bellow is the "stack trace" returned from the page. Please help if you > can...much appreciated. > > David Marcinkowski > Associate Director > Academic Computing > Pratt Institute > > stack trace bellow > ___________________________________________________ > > <!-- > > 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(Recen > tCommunitySubmissions.java:85) > > at > org.dspace.app.webui.servlet.HandleServlet.preProcessCommunityHome(Handl > eServlet.java:455) > > at > org.dspace.app.webui.servlet.HandleServlet.communityHome(HandleServlet.j > ava:413) > > at > org.dspace.app.webui.servlet.HandleServlet.doDSGet(HandleServlet.java:23 > 9) > > 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(Applica > tionFilterChain.java:269) > > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt > erChain.java:188) > > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv > e.java:213) > > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv > e.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:1 > 74) > > at > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:87 > 4) > > at > org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.proc > essConnection(Http11BaseProtocol.java:665) > > at > org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint > .java:528) > > at > org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow > erWorkerThread.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.getRecentSubmis > sions(RecentSubmissionsManager.java:132) > > at > org.dspace.app.webui.components.RecentCommunitySubmissions.process(Recen > tCommunitySubmissions.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.getRecentSubmis > sions(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(QueryExecu > torImpl.java:1531) > > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImp > l.java:1313) > > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java: > 188) > > at > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme > nt.java:452) > > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdb > c2Statement.java:354) > > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2St > atement.java:258) > > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegat > ingPreparedStatement.java:93) > > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegat > ingPreparedStatement.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.getRecentSubmis > sions(RecentSubmissionsManager.java:132) > > at > org.dspace.app.webui.components.RecentCommunitySubmissions.process(Recen > tCommunitySubmissions.java:80) > > at > org.dspace.app.webui.servlet.HandleServlet.preProcessCommunityHome(Handl > eServlet.java:455) > > at > org.dspace.app.webui.servlet.HandleServlet.communityHome(HandleServlet.j > ava:413) > > at > org.dspace.app.webui.servlet.HandleServlet.doDSGet(HandleServlet.java:23 > 9) > > 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(Applica > tionFilterChain.java:269) > > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt > erChain.java:188) > > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv > e.java:213) > > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv > e.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:1 > 74) > > at > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:87 > 4) > > at > org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.proc > essConnection(Http11BaseProtocol.java:665) > > at > org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint > .java:528) > > at > org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow > erWorkerThread.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.getRecentSubmis > sions(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(QueryExecu > torImpl.java:1531) > > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImp > l.java:1313) > > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java: > 188) > > at > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme > nt.java:452) > > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdb > c2Statement.java:354) > > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2St > atement.java:258) > > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegat > ingPreparedStatement.java:93) > > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegat > ingPreparedStatement.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.getRecentSubmis > sions(RecentSubmissionsManager.java:116) > > at > org.dspace.app.webui.components.RecentCommunitySubmissions.process(Recen > tCommunitySubmissions.java:80) > > at > org.dspace.app.webui.servlet.HandleServlet.preProcessCommunityHome(Handl > eServlet.java:455) > > at > org.dspace.app.webui.servlet.HandleServlet.communityHome(HandleServlet.j > ava:413) > > at > org.dspace.app.webui.servlet.HandleServlet.doDSGet(HandleServlet.java:23 > 9) > > 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(Applica > tionFilterChain.java:269) > > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt > erChain.java:188) > > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv > e.java:213) > > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv > e.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:1 > 74) > > at > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:87 > 4) > > at > org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.proc > essConnection(Http11BaseProtocol.java:665) > > at > org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint > .java:528) > > at > org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow > erWorkerThread.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(QueryExecu > torImpl.java:1531) > > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImp > l.java:1313) > > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java: > 188) > > at > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme > nt.java:452) > > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdb > c2Statement.java:354) > > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2St > atement.java:258) > > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegat > ingPreparedStatement.java:93) > > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegat > ingPreparedStatement.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(QueryExecu > torImpl.java:1531) > > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImp > l.java:1313) > > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java: > 188) > > at > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme > nt.java:452) > > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdb > c2Statement.java:354) > > at > org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2St > atement.java:258) > > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegat > ingPreparedStatement.java:93) > > at > org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegat > ingPreparedStatement.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.getRecentSubmis > sions(RecentSubmissionsManager.java:116) > > at > org.dspace.app.webui.components.RecentCommunitySubmissions.process(Recen > tCommunitySubmissions.java:80) > > at > org.dspace.app.webui.servlet.HandleServlet.preProcessCommunityHome(Handl > eServlet.java:455) > > at > org.dspace.app.webui.servlet.HandleServlet.communityHome(HandleServlet.j > ava:413) > > at > org.dspace.app.webui.servlet.HandleServlet.doDSGet(HandleServlet.java:23 > 9) > > 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(Applica > tionFilterChain.java:269) > > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt > erChain.java:188) > > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv > e.java:213) > > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv > e.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:1 > 74) > > at > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:87 > 4) > > at > org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.proc > essConnection(Http11BaseProtocol.java:665) > > at > org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint > .java:528) > > at > org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow > erWorkerThread.java:81) > > at > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool > .java:689) > > at java.lang.Thread.run(Thread.java:595) > > > > > > > > > > > > --> > > > > > > > > > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's challenge > Build the coolest Linux based applications with Moblin SDK & win great prizes > Grand prize is a trip for two to an Open Source event anywhere in the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > > > ------------------------------------------------------------------------ > > _______________________________________________ > DSpace-tech mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/dspace-tech -- =================================== Robert Roggenbuck Universitaetsbibliothek Osnabrueck Alte Muenze 16 D-49074 Osnabrueck Germany Tel ++49/541/969-4344 Fax -4482 [EMAIL PROTECTED] Postbox: Postfach 4496 D-49034 Osnabrueck =================================== ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
