Thank you! Not sure how we missed this, it was very clear in the docs.
-------------------------------------------------------------
John Furfey
Digital Systems and Services Coordinator
MBLWHOI Library
Woods Hole, MA 02543 USA
PHONE: 508-289-7435
EMAIL: jfur...@mbl.edu
http://www.mblwhoilibrary.org
----- Original Message -----
From: "Claudia Juergen" <claudia.juer...@ub.uni-dortmund.de>
To: "John Furfey" <jfur...@mbl.edu>
Cc: "Dspace Tech" <dspace-tech@lists.sourceforge.net>
Sent: Friday, January 23, 2009 11:15:17 AM GMT -05:00 US/Canada Eastern
Subject: Re: [Dspace-tech] Eperson error in 1.5 migration
Hi John,
during upgrade, did you run database_schema_14-15.sql as indicated in the
docs. This will create the language column in eperson, see
alter table eperson add column language VARCHAR(64);
update eperson set language = 'en';
Hope that helps
Claudia Jürgen
> Hello,
>
> We're in the process of bringing up a new server with 1.5, migrating from
> 1.4. One problem we're encountering is that we can't see any of the
> epeople in the system. On checking the database, the table exists and
> there's data for the epeople, but we can't see them in the jspui. Here are
> some errors from dspace.log when trying to perform actions on epeople list
> (/dspace-admin/edit-people).
>
> Any ideas?
>
>
> 2009-01-23 10:29:42,566 ERROR
> org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/jspui].[jsp]
> @ Servlet.service() for servlet jsp threw exception
> java.lang.IllegalArgumentException: No such column language
> at org.dspace.storage.rdbms.TableRow.getStringColumn(TableRow.java:247)
> at org.dspace.eperson.EPerson.getLanguage(EPerson.java:509)
> at
> org.apache.jsp.tools.eperson_002dlist_jsp._jspService(eperson_002dlist_jsp.java:643)
>
> at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> at
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:328)
>
> at
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315)
> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
> 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.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691)
>
> at
> org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:469)
>
> at
> org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:403)
>
> at
> org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
>
> at org.dspace.app.webui.util.JSPManager.showJSP(JSPManager.java:91)
> at
> org.dspace.app.webui.servlet.admin.EPersonListServlet.doDSGet(EPersonListServlet.java:138)
>
> 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.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter(RegisteredOnlyFilter.java:98)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
>
> 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:151)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
> 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:685)
>
> at java.lang.Thread.run(Thread.java:619)
> 2009-01-23 10:29:42,567 ERROR
> org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/jspui].[eperson-list]
>
> @ Servlet.service() for servlet eperson-list threw exception
> java.lang.IllegalArgumentException: No such column language
> at org.dspace.storage.rdbms.TableRow.getStringColumn(TableRow.java:247)
> at org.dspace.eperson.EPerson.getLanguage(EPerson.java:509)
> at
> org.apache.jsp.tools.eperson_002dlist_jsp._jspService(eperson_002dlist_jsp.java:643)
>
> at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> at
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:328)
>
> at
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315)
> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
> 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.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691)
>
> at
> org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:469)
>
> at
> org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:403)
>
> at
> org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
>
> at org.dspace.app.webui.util.JSPManager.showJSP(JSPManager.java:91)
> at
> org.dspace.app.webui.servlet.admin.EPersonListServlet.doDSGet(EPersonListServlet.java:138)
>
> 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.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter(RegisteredOnlyFilter.java:98)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
>
> 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:151)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
> 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:685)
>
> at java.lang.Thread.run(Thread.java:619)
> 2009-01-23 10:29:42,567 WARN
> org.dspace.app.webui.servlet.InternalErrorServlet @
> :session_id=571359C094F8071DBCD9FF85958B4907:internal_error:-- URL Was:
> http://mblwhoidspace.mbl.edu:8080/jspui/tools/eperson-list?multiple=false
> -- Method: GET
> -- Parameters were:
> -- multiple: "false"
>
> java.lang.IllegalArgumentException: No such column language
> at org.dspace.storage.rdbms.TableRow.getStringColumn(TableRow.java:247)
> at org.dspace.eperson.EPerson.getLanguage(EPerson.java:509)
> at
> org.apache.jsp.tools.eperson_002dlist_jsp._jspService(eperson_002dlist_jsp.java:643)
>
> at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
> at
> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:328)
>
> at
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315)
> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
> 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.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691)
>
> at
> org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:469)
>
> at
> org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:403)
>
> at
> org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
>
> at org.dspace.app.webui.util.JSPManager.showJSP(JSPManager.java:91)
> at
> org.dspace.app.webui.servlet.admin.EPersonListServlet.doDSGet(EPersonListServlet.java:138)
>
> 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.dspace.app.webui.filter.RegisteredOnlyFilter.doFilter(RegisteredOnlyFilter.java:98)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
>
> 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:151)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
> 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:685)
>
> at java.lang.Thread.run(Thread.java:619)
> 2009-01-23 10:29:42,569 WARN org.dspace.app.webui.util.UIUtil @ Unable to
> send email alert
> javax.mail.NoSuchProviderException: smtp
> at javax.mail.Session.getService(Session.java:782)
> at javax.mail.Session.getTransport(Session.java:708)
> at javax.mail.Session.getTransport(Session.java:651)
> at javax.mail.Session.getTransport(Session.java:631)
> at javax.mail.Session.getTransport(Session.java:686)
> at javax.mail.Transport.send0(Transport.java:166)
> at javax.mail.Transport.send(Transport.java:98)
> at org.dspace.core.Email.send(Email.java:362)
> at org.dspace.app.webui.util.UIUtil.sendAlert(UIUtil.java:480)
> at
> org.dspace.app.webui.servlet.InternalErrorServlet.doGet(InternalErrorServlet.java:86)
>
> 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.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691)
>
> at
> org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471)
>
> at
> org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:403)
>
> at
> org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
>
> at
> org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:364)
> at
> org.apache.catalina.core.StandardHostValve.throwable(StandardHostValve.java:213)
>
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
> 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:151)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
> 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:685)
>
> at java.lang.Thread.run(Thread.java:619)
>
>
> -------------------------------------------------------------
> John Furfey
> Digital Systems and Services Coordinator
> MBLWHOI Library
> Woods Hole, MA 02543 USA
> PHONE: 508-289-7435
> EMAIL: jfur...@mbl.edu
> http://www.mblwhoilibrary.org
> ------------------------------------------------------------------------------
>
> This SF.net email is sponsored by:
> SourcForge Community
> SourceForge wants to tell your story.
> http://p.sf.net/sfu/sf-spreadtheword_______________________________________________
>
> DSpace-tech mailing list
> DSpace-tech@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
>
------------------------------------------------------------------------------
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech