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".
I am new to DSpace and have no idea how/where to proceed. 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)
-->
David Marcinkowski
Associate Director
Academic Computing
Manhattan Campus
212-647-7761
_________________
my.pratt.edu <http://my.pratt.edu/> - Try it!
-------------------------------------------------------------------------
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
