Ok Robert....I have done as you suggest....bellow is the log
generated.....
The strange thing is that the xmlui seems to work OK...strange....
David
___________________________________________________________________
2008-10-06 10:34:43,033 ERROR
org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/dspace].
[handle] @ Servlet.service() for servlet handle threw exception
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)
2008-10-06 10:34:43,033 WARN
org.dspace.app.webui.servlet.InternalErrorServlet @
:session_id=2C6A9F3BE90EC7C242C8719E0842F8AF:internal_error:-- URL Was:
http://pmc.pratt.edu:8180/dspace/handle/123456789/7
-- Method: GET
-- Parameters were:
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
David Marcinkowski
Associate Director
Academic Computing
Manhattan Campus
212-647-7761
_________________
my.pratt.edu - Try it!
-----Original Message-----
From: Robert Roggenbuck [mailto:[EMAIL PROTECTED]
Sent: Monday, October 06, 2008 9:36 AM
To: David Marcinkowski
Cc: [email protected]
Subject: Re: [Dspace-tech] Internal Server Error when creating top level
community
@David:
I agree that there seems something wrong with Your DB-tables... To be
sure to find the right lines in the log file, open it and look at it's
end before You press the "create community" button. After You get the
error reload the view to the log file and You will see what's added
since Your action.
@all:
I do not know what the error message below could cause. May be someone
else?
Greetings
Robert
-----
David Marcinkowski schrieb:
> Hello Robert,
>
> The dspace.log is long...but I think this is the problem entry....I
> think it describes a missing field in the database.....
>
> Any suggestions will be apprechiated....
>
> David
>
> ______________________________________________________________________
> __
> _________
>
> Dspace.log
>
> 2008-09-30 10:46:38,271 ERROR
> org.dspace.app.webui.components.RecentSubmissionsManager @ caught
> exception:
> 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
>
>
>
> -----Original Message-----
> From: Robert Roggenbuck [mailto:[EMAIL PROTECTED]
> Sent: Monday, October 06, 2008 3:19 AM
> To: David Marcinkowski
> Cc: [email protected]
> Subject: Re: [Dspace-tech] Internal Server Error when creating top
level
> community
>
>
> 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(Rec
>> en
>> tCommunitySubmissions.java:85)
>>
>> at
>>
org.dspace.app.webui.servlet.HandleServlet.preProcessCommunityHome(Han
>> dl
>> 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(DSpaceServle
>> t.
>> java:151)
>>
>> at
>> org.dspace.app.webui.servlet.DSpaceServlet.doGet(DSpaceServlet.java:9
>> 9
>> )
>>
>> 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(Appli
>> ca
>> tionFilterChain.java:269)
>>
>> at
>>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFi
>> lt
>> erChain.java:188)
>>
>> at
>>
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVa
>> lv
>> e.java:213)
>>
>> at
>>
org.apache.catalina.core.StandardContextValve.invoke(StandardContextVa
>> lv
>> e.java:174)
>>
>> at
>>
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.ja
>> va
>> :127)
>>
>> at
>>
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.ja
>> va
>> :117)
>>
>> at
>>
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValv
>> e.
>> 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.pr
>> oc
>> essConnection(Http11BaseProtocol.java:665)
>>
>> at
>>
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoi
>> nt
>> .java:528)
>>
>> at
>>
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFoll
>> ow
>> erWorkerThread.java:81)
>>
>> at
>>
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPo
>> ol
>> .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.getRecentSubm
>> is
>> sions(RecentSubmissionsManager.java:132)
>>
>> at
>>
org.dspace.app.webui.components.RecentCommunitySubmissions.process(Rec
>> en
>> 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:40
>> 3
>> )
>>
>> at
>> org.dspace.browse.BrowseEngine.browseMini(BrowseEngine.java:198)
>>
>> at
>>
org.dspace.app.webui.components.RecentSubmissionsManager.getRecentSubm
>> is
>> 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(QueryExe
>> cu
>> torImpl.java:1531)
>>
>> at
>>
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorI
>> mp
>> l.java:1313)
>>
>> at
>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
>> v
>> a:
>> 188)
>>
>> at
>>
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2State
>> me
>> nt.java:452)
>>
>> at
>>
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJ
>> db
>> c2Statement.java:354)
>>
>> at
>>
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2
>> St
>> atement.java:258)
>>
>> at
>>
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Deleg
>> at
>> ingPreparedStatement.java:93)
>>
>> at
>>
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Deleg
>> at
>> ingPreparedStatement.java:93)
>>
>> at
>> org.dspace.storage.rdbms.DatabaseManager.query(DatabaseManager.java:2
>> 2
>> 1)
>>
>> at
>> org.dspace.browse.BrowseDAOPostgres.doQuery(BrowseDAOPostgres.java:38
>> 5
>> )
>>
>> ... 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.getRecentSubm
>> is
>> sions(RecentSubmissionsManager.java:132)
>>
>> at
>>
org.dspace.app.webui.components.RecentCommunitySubmissions.process(Rec
>> en
>> tCommunitySubmissions.java:80)
>>
>> at
>>
org.dspace.app.webui.servlet.HandleServlet.preProcessCommunityHome(Han
>> dl
>> 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(DSpaceServle
>> t.
>> java:151)
>>
>> at
>> org.dspace.app.webui.servlet.DSpaceServlet.doGet(DSpaceServlet.java:9
>> 9
>> )
>>
>> 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(Appli
>> ca
>> tionFilterChain.java:269)
>>
>> at
>>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFi
>> lt
>> erChain.java:188)
>>
>> at
>>
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVa
>> lv
>> e.java:213)
>>
>> at
>>
org.apache.catalina.core.StandardContextValve.invoke(StandardContextVa
>> lv
>> e.java:174)
>>
>> at
>>
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.ja
>> va
>> :127)
>>
>> at
>>
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.ja
>> va
>> :117)
>>
>> at
>>
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValv
>> e.
>> 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.pr
>> oc
>> essConnection(Http11BaseProtocol.java:665)
>>
>> at
>>
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoi
>> nt
>> .java:528)
>>
>> at
>>
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFoll
>> ow
>> erWorkerThread.java:81)
>>
>> at
>>
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPo
>> ol
>> .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:40
>> 3
>> )
>>
>> at
>> org.dspace.browse.BrowseEngine.browseMini(BrowseEngine.java:198)
>>
>> at
>>
org.dspace.app.webui.components.RecentSubmissionsManager.getRecentSubm
>> is
>> 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(QueryExe
>> cu
>> torImpl.java:1531)
>>
>> at
>>
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorI
>> mp
>> l.java:1313)
>>
>> at
>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
>> v
>> a:
>> 188)
>>
>> at
>>
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2State
>> me
>> nt.java:452)
>>
>> at
>>
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJ
>> db
>> c2Statement.java:354)
>>
>> at
>>
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2
>> St
>> atement.java:258)
>>
>> at
>>
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Deleg
>> at
>> ingPreparedStatement.java:93)
>>
>> at
>>
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Deleg
>> at
>> ingPreparedStatement.java:93)
>>
>> at
>> org.dspace.storage.rdbms.DatabaseManager.query(DatabaseManager.java:2
>> 2
>> 1)
>>
>> at
>> org.dspace.browse.BrowseDAOPostgres.doQuery(BrowseDAOPostgres.java:38
>> 5
>> )
>>
>> ... 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:40
>> 3
>> )
>>
>> at
>> org.dspace.browse.BrowseEngine.browseMini(BrowseEngine.java:198)
>>
>> at
>>
org.dspace.app.webui.components.RecentSubmissionsManager.getRecentSubm
>> is
>> sions(RecentSubmissionsManager.java:116)
>>
>> at
>>
org.dspace.app.webui.components.RecentCommunitySubmissions.process(Rec
>> en
>> tCommunitySubmissions.java:80)
>>
>> at
>>
org.dspace.app.webui.servlet.HandleServlet.preProcessCommunityHome(Han
>> dl
>> 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(DSpaceServle
>> t.
>> java:151)
>>
>> at
>> org.dspace.app.webui.servlet.DSpaceServlet.doGet(DSpaceServlet.java:9
>> 9
>> )
>>
>> 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(Appli
>> ca
>> tionFilterChain.java:269)
>>
>> at
>>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFi
>> lt
>> erChain.java:188)
>>
>> at
>>
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVa
>> lv
>> e.java:213)
>>
>> at
>>
org.apache.catalina.core.StandardContextValve.invoke(StandardContextVa
>> lv
>> e.java:174)
>>
>> at
>>
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.ja
>> va
>> :127)
>>
>> at
>>
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.ja
>> va
>> :117)
>>
>> at
>>
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValv
>> e.
>> 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.pr
>> oc
>> essConnection(Http11BaseProtocol.java:665)
>>
>> at
>>
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoi
>> nt
>> .java:528)
>>
>> at
>>
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFoll
>> ow
>> erWorkerThread.java:81)
>>
>> at
>>
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPo
>> ol
>> .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(QueryExe
>> cu
>> torImpl.java:1531)
>>
>> at
>>
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorI
>> mp
>> l.java:1313)
>>
>> at
>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
>> v
>> a:
>> 188)
>>
>> at
>>
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2State
>> me
>> nt.java:452)
>>
>> at
>>
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJ
>> db
>> c2Statement.java:354)
>>
>> at
>>
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2
>> St
>> atement.java:258)
>>
>> at
>>
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Deleg
>> at
>> ingPreparedStatement.java:93)
>>
>> at
>>
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Deleg
>> at
>> ingPreparedStatement.java:93)
>>
>> at
>> org.dspace.storage.rdbms.DatabaseManager.query(DatabaseManager.java:2
>> 2
>> 1)
>>
>> at
>> org.dspace.browse.BrowseDAOPostgres.doQuery(BrowseDAOPostgres.java:38
>> 5
>> )
>>
>> ... 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(QueryExe
>> cu
>> torImpl.java:1531)
>>
>> at
>>
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorI
>> mp
>> l.java:1313)
>>
>> at
>> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
>> v
>> a:
>> 188)
>>
>> at
>>
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2State
>> me
>> nt.java:452)
>>
>> at
>>
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJ
>> db
>> c2Statement.java:354)
>>
>> at
>>
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2
>> St
>> atement.java:258)
>>
>> at
>>
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Deleg
>> at
>> ingPreparedStatement.java:93)
>>
>> at
>>
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Deleg
>> at
>> ingPreparedStatement.java:93)
>>
>> at
>> org.dspace.storage.rdbms.DatabaseManager.query(DatabaseManager.java:2
>> 2
>> 1)
>>
>> at
>> org.dspace.browse.BrowseDAOPostgres.doQuery(BrowseDAOPostgres.java:38
>> 5
>> )
>>
>> at
>> org.dspace.browse.BrowseEngine.browseMini(BrowseEngine.java:198)
>>
>> at
>>
org.dspace.app.webui.components.RecentSubmissionsManager.getRecentSubm
>> is
>> sions(RecentSubmissionsManager.java:116)
>>
>> at
>>
org.dspace.app.webui.components.RecentCommunitySubmissions.process(Rec
>> en
>> tCommunitySubmissions.java:80)
>>
>> at
>>
org.dspace.app.webui.servlet.HandleServlet.preProcessCommunityHome(Han
>> dl
>> 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(DSpaceServle
>> t.
>> java:151)
>>
>> at
>> org.dspace.app.webui.servlet.DSpaceServlet.doGet(DSpaceServlet.java:9
>> 9
>> )
>>
>> 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(Appli
>> ca
>> tionFilterChain.java:269)
>>
>> at
>>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFi
>> lt
>> erChain.java:188)
>>
>> at
>>
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperVa
>> lv
>> e.java:213)
>>
>> at
>>
org.apache.catalina.core.StandardContextValve.invoke(StandardContextVa
>> lv
>> e.java:174)
>>
>> at
>>
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.ja
>> va
>> :127)
>>
>> at
>>
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.ja
>> va
>> :117)
>>
>> at
>>
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValv
>> e.
>> 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.pr
>> oc
>> essConnection(Http11BaseProtocol.java:665)
>>
>> at
>>
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoi
>> nt
>> .java:528)
>>
>> at
>>
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFoll
>> ow
>> erWorkerThread.java:81)
>>
>> at
>>
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPo
>> ol
>> .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
