[OPEN-ILS-DEV] Creating Patrons

[Dan Scott]

Hi Robert:

The "ERROR:  more than one row returned by a subquery used as an
expression" error probably means that your org_unit hierarchy is not
set up correctly. You can't have, say, a Library as a child of another
Library.

Can you run "SELECT * FROM actor.org_unit;" and dump the output
somewhere that we can look at it?

Dan

2008/5/21 Robert <glibrarysystem at gmail.com>:
> Jason,
>
>   Can you explain why I keep getting an error whenever I do have all the
> Application Permissions matching and have the extra permissions that the
> group needs to create patrons but whenever they go to the register patron
> section in the client they get an error? The error that they receive is:
>
> * Fix Me *
> Error parsing JSON [SyntaxError: missing } after property list]
> {"payload":[],"debug": "osrfMethodException :  *** Call to
> [open-ils.actor.user.perm.highest_org.batch] failed for session
> [1211399185.124956.121139918510140], thread trace [1]:\n  * ! EXCEPTION ! *
> \nTYPE: OpenSRF::EX::ERROR\nMess: System ERROR \nMess: Call to
> open-ils.storage for method open-ils.storage.permission.user_has_perm
> \nMess:  failed with exception:   * ! EXCEPTION ! * \nMess: TYPE:
> OpenSRF::EX::ERROR\nMess: Mess: System ERROR \nMess: Mess:   * ! EXCEPTION !
> * \nMess: Mess: TYPE: OpenSRF::DomainObject::oilsMethodException\nMess:
> Mess: Mess: <500>   *** Call to [open-ils.storage.permission.user_has_perm]
> failed for session [1211399185.30416808.793166052467], thread trace
> [1]:\nMess: Mess: Mess: DBD::Pg::db selectrow_arrayref failed: ERROR:  more
> than one row returned by a subquery used as an expression\nMess: Mess: Mess:
> CONTEXT:  SQL function \"org_unit_descendants\" statement 1\nMess: Mess:
> Mess: SQL statement \"SELECT  * FROM actor.org_unit_descendants( $1 , $2 )
> WHERE id =  $3 \"\nMess: Mess: Mess: PL/pgSQL function \"usr_has_home_perm\"
> line 23 at perform\nMess: Mess: Mess: SQL function \"usr_has_perm\"
> statement 1\nMess: Mess: Mess:  [for Statement \"\t\tSELECT
> permission.usr_has_perm(?,?,?)\nMess: Mess: Mess: \"] at
> /openils/lib/perl5/OpenILS/Application/Storage/Publisher/permission.pm line
> 47.\nMess: Mess: Mess: \nMess: Mess: \nMess: Mess: Loc.: 996
> OpenSRF::AppRequest \nMess: Mess: Loc.:
> /openils/lib/perl5/OpenSRF/AppSession.pm \nMess: Mess: Time: Wed May 21
> 15:46:25 2008\nMess: \nMess: Loc.: 162 OpenILS::Application::AppUtils
> \nMess: Loc.: /openils/lib/perl5/OpenILS/Application/AppUtils.pm \nMess:
> Time: Wed May 21 15:46:25 2008\nMess:  : \nLoc.: 185 OpenSRF::Application
> \nLoc.: /openils/lib/perl5/OpenSRF/Application.pm \nTime: W,"status":500}
>
> On Wed, May 21, 2008 at 11:00 AM, Jason Etheridge <jason at esilibrary.com>
> wrote:
>>
>> On Tue, May 20, 2008 at 8:53 PM, Grant Johnson <fgjohnson at upei.ca> wrote:
>> > What permissions are needed to create Patrons and select the Profile
>> > Group.
>> > I can only get Admin to be able to do this but circ staff need this
>> > functionality.
>>
>> Hi Grant,
>>
>> I think you need: CREATE_USER, CREATE_USER_GROUP_LINK,
>> CREATE_PATRON_STAT_CAT_ENTRY_MAP, UPDATE_USER, and VIEW_USER.  You may
>> also want to give BAR_PATRON and UNBAR_PATRON.
>>
>> And then for the profile groups, each one optionally has a specific
>> permission associated with it that staff must have in order to set
>> that profile.
>>
>> You can see this in the bootstrap cgi interface, under User Group
>> Hierarchy Setup when viewing a specific group.  The field is called
>> ApplicationPermission.
>>
>> In the example I'm looking at, the Staff group has an ApplicationPerm
>> of group_application.user.staff, so that specific permission is needed
>> if I were to create a Staff user.
>>
>> These application perms are also inherited by descendant permission
>> groups.  So there might be a Staff -> Catalogers group, that would
>> also need that permission at a minimum.  If the Catalogers group also
>> had an explicit ApplicationPerm configured, then that would be needed
>> as well.
>>
>> Does this help?
>>
>> --
>> Jason Etheridge
>>  | VP, Community Support and Advocacy
>>  | Equinox Software, Inc. / The Evergreen Experts
>>  | phone: 1-877-OPEN-ILS (673-6457)
>>  | email: jason at esilibrary.com
>>  | web: http://www.esilibrary.com
>
>



-- 
Dan Scott
Laurentian University