On Tue, Apr 28, 2015 at 05:13:55PM +0200, Oliver Goldschmidt wrote: > Thanks again, but I guess that's not all. Changing m_text_value to > m.text_value in the EPerson class is still throwing an NPE, because the > SQL query is still not correct: > 2015-04-28 17:04:36,075 DEBUG org.dspace.storage.rdbms.DatabaseManager @ > Running query "SELECT * FROM eperson e ORDER BY ?" with parameters: > m.text_value
Um, can one use parameters that way in SQL? I thought not. Shouldn't
this be done by composing the SELECT using string concatenation? We
don't get "m.text_value" from the user, do we?
> I can't sort on a field from table m, when table m is not involved in
> the query.
You're quite right: "m" is not defined in the statement. Guessing
from the name, I'd say this was meant to be ordering a select from
metadatavalue, since that is the only table which has a 'text_value'
column.
[digs through the code]
Something is quite wrong. The query at EPerson line 518 is:
SELECT * FROM eperson e
LEFT JOIN metadatavalue m on (m.resource_id = e.eperson_id and
m.resource_type_id = ? and m.metadata_field_id = ?)
ORDER BY ?
> I will investigate this a little more. Perhaps the parameters s and t
> are switched by accident?
>
> Best regards
> Oliver
>
> Am 28.04.2015 um 16:34 schrieb Oliver Goldschmidt:
> > Thank you, Monika. That makes sense - I will try to try that locally.
> >
> > Best regards
> > Oliver
> >
> > Am 28.04.2015 um 16:10 schrieb Monika C. Mevenkamp:
> >> looks to me like a typo in the code
> >>
> >> https://github.com/DSpace/DSpace/blob/master/dspace-api/src/main/java/org/dspace/eperson/EPerson.java#L502
> >> and
> >> https://github.com/DSpace/DSpace/blob/master/dspace-api/src/main/java/org/dspace/eperson/EPerson.java#L510
> >>
> >> where it says s = "m_text_value”; it should be s = “m.text_value";
> >>
> >> Monika
> >>
> >> ________________
> >> Monika Mevenkamp
> >> phone: 609-258-4161
> >> Princeton University, Princeton, NJ 08544
> >>
> >>
> >>> On Apr 27, 2015, at 11:26 AM, Oliver Goldschmidt
> >>> <[email protected] <mailto:[email protected]>> wrote:
> >>>
> >>> Hello,
> >>>
> >>> I have a problem in DSpace 5.1. After upgrading from DSpace 4.2 I cannot
> >>> change publication permissions or workflow step permissions on a
> >>> collection or select users in the permission system.
> >>> I have tracked down the error and it seems to be most likely a bug, but
> >>> I'm not 100% sure...
> >>>
> >>> Trying to use
> >>> http://dspace-instance/tools/eperson-list?multiple=false
> >>> <http://dspace-instance/tools/eperson-list?multiple=false>
> >>> (after having logged in as admin) is throwing an NPE:
> >>> 2015-04-27 17:19:52,812 DEBUG org.dspace.storage.rdbms.DatabaseManager @
> >>> Running query "SELECT * FROM eperson e ORDER BY ?" with parameters:
> >>> m_text_value
> >>> 2015-04-27 17:19:52,817 WARN
> >>> org.dspace.app.webui.servlet.InternalErrorServlet @
> >>> :session_id=XX...XX:internal_error:-- URL Was:
> >>> https://dspace.tub.tuhh.de/tools/eperson-list?multiple=false
> >>> -- Method: GET
> >>> -- Parameters were:
> >>> -- multiple: "false"
> >>>
> >>> java.lang.NullPointerException
> >>> at org.dspace.eperson.EPerson.findAll(EPerson.java:518)
> >>>
> >>> The reason for this error is, that I do not have a field m_text_value in
> >>> the table eperson, so the query fails.
> >>>
> >>> Is this a bug or have I missed something upgrading the database?
> >>>
> >>> Best regards
> >>> Oliver
> >>>
> >>>
> >>> ------------------------------------------------------------------------------
> >>> One dashboard for servers and applications across
> >>> Physical-Virtual-Cloud
> >>> Widest out-of-the-box monitoring support with 50+ applications
> >>> Performance metrics, stats and reports that give you Actionable Insights
> >>> Deep dive visibility with transaction tracing using APM Insight.
> >>> http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
> >>> _______________________________________________
> >>> DSpace-tech mailing list
> >>> [email protected]
> >>> https://lists.sourceforge.net/lists/listinfo/dspace-tech
> >>> List Etiquette:
> >>> https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
> >>
> >
> >
> >
> > ------------------------------------------------------------------------------
> > One dashboard for servers and applications across Physical-Virtual-Cloud
> > Widest out-of-the-box monitoring support with 50+ applications
> > Performance metrics, stats and reports that give you Actionable Insights
> > Deep dive visibility with transaction tracing using APM Insight.
> > http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
> >
> >
> > _______________________________________________
> > DSpace-tech mailing list
> > [email protected]
> > https://lists.sourceforge.net/lists/listinfo/dspace-tech
> > List Etiquette:
> > https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
>
> ------------------------------------------------------------------------------
> One dashboard for servers and applications across Physical-Virtual-Cloud
> Widest out-of-the-box monitoring support with 50+ applications
> Performance metrics, stats and reports that give you Actionable Insights
> Deep dive visibility with transaction tracing using APM Insight.
> http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
> _______________________________________________
> DSpace-tech mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
> List Etiquette:
> https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
--
Mark H. Wood
Lead Technology Analyst
University Library
Indiana University - Purdue University Indianapolis
755 W. Michigan Street
Indianapolis, IN 46202
317-274-0749
www.ulib.iupui.edu
signature.asc
Description: Digital signature
------------------------------------------------------------------------------ One dashboard for servers and applications across Physical-Virtual-Cloud Widest out-of-the-box monitoring support with 50+ applications Performance metrics, stats and reports that give you Actionable Insights Deep dive visibility with transaction tracing using APM Insight. http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
