[OPEN-ILS-DEV] Creating Patrons

[Robert]

Hi Dan or Jason,

  Have you come up with anything on my issue yet based on the output that I
sent to you?

On Wed, May 21, 2008 at 4:01 PM, Dan Scott <denials at gmail.com> wrote:

> 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.pmline
> > 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://list.georgialibraries.org/pipermail/open-ils-dev/attachments/20080523/af0b211a/attachment.html