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

I can't sort on a field from table m, when table m is not involved in
the query.

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
>>> <o.goldschm...@tuhh.de <mailto:o.goldschm...@tuhh.de>> 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
>>> DSpace-tech@lists.sourceforge.net
>>> 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
> DSpace-tech@lists.sourceforge.net
> 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
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette

Reply via email to