[OPEN-ILS-DEV] Evergreen 1.404..Can't search for patrons, or get wierd Postgres error
Hunt, Phil
hunt at nelinet.net
Fri Jun 12 09:51:05 EDT 2009
It is version 1.4.0.4
Phil Hunt
Program Director, Information Technology
NELINET, Inc.
' Direct Phone: (508)597-1924
' 1.508.460.7700 x1924
6 FAX (508)460-9455
* hunt at NELINET.net
-----Original Message-----
From: open-ils-dev-bounces at list.georgialibraries.org [mailto:open-ils-dev-bounces at list.georgialibraries.org] On Behalf Of Mike Rylander
Sent: Friday, June 12, 2009 08:37 AM
To: Evergreen Development Discussion List
Subject: Re: [OPEN-ILS-DEV] Evergreen 1.404..Can't search for patrons,or get wierd Postgres error
On Thu, Jun 11, 2009 at 4:31 PM, Hunt, Phil<hunt at nelinet.net> wrote:
> I finally figured out the proglems I was having with postgres 8.2
What version of Evergreen is this?
--miker
>
> I added 2 patrons, 1 as a system admin, one as a std patron. It showed
> some relatively minor errors during the add, but I got 'User update
> succeeded', the errors seen were like this:
>
> Use of uninitialized value $p[0] in join or string at
> /usr/local/share/perl/5.10.0/OpenSRF/Application.pm line 118, <STDIN>
> line1.
> Use of uninitialized value $p[0] in join or string at
> /usr/local/share/perl/5.10.0/OpenSRF/Application.pm line 118, <STDIN>
> line1.
> Use of uninitialized value $p[0] in join or string at
> /usr/local/share/perl/5.10.0/OpenSRF/Application.pm line 118, <STDIN>
> line1.
> Use of uninitialized value $p[0] in join or string at
> /usr/local/share/perl/5.10.0/OpenSRF/Application.pm line 118, <STDIN>
> line1.
> Use of uninitialized value $p[0] in join or string at
> /usr/local/share/perl/5.10.0/OpenSRF/Application.pm line 118, <STDIN>
> line1.
> Use of uninitialized value $p[0] in join or string at
> /usr/local/share/perl/5.10.0/OpenSRF/Application.pm line 118, <STDIN>
> line1.
> Argument "1244750664.98621995.466378585992" isn't numeric in numeric ne
> (!=) at /openils/lib/perl5/OpenILS/Application/Actor.pm line 505,
> <STDIN> line 1.
> Argument "1244750664.98621995.466378585992" isn't numeric in numeric ne
> (!=) at /openils/lib/perl5/OpenILS/Application/Actor.pm line 505,
> <STDIN> line 1.
> Use of uninitialized value $p[2] in join or string at
> /usr/local/share/perl/5.10.0/OpenSRF/Application.pm line 118, <STDIN>
> line1.
>
>
>
> If I do a search by barcode, they lookup fine.
>
> If I do a search for patron, using any patron fields, I get this in the
> error log for actor...
>
> Use of uninitialized value in hash element at
> /openils/lib/perl5/OpenILS/Utils/CStoreEditor.pm line 193, <STDIN> line
> 1.
> received error : service=open-ils.storage :
> method=open-ils.storage.actor.user.crazy_search : params=$VAR1 =
> [{'email' => {'group' => 0,'value' =>
> 'normal at nowhere.com'}},51,['family_name ASC','first_given_name
> ASC','second_given_name ASC','dob DESC'],1,'4','2'];
> Exception: OpenSRF::EX::ERROR 2009-06-11T16:24:35
> OpenILS::Application::AppUtils
> /openils/lib/perl5/OpenILS/Application/AppUtils.pm:178 System ERROR:
> Exception: OpenSRF::DomainObject::oilsMethodException
> 2009-06-11T16:24:35 OpenSRF::AppRequest
> /usr/local/share/perl/5.10.0/OpenSRF/AppSession.pm:1009 <500> *** Call
> to [open-ils.storage.actor.user.crazy_search] failed for session
> [1244751875.053172252.2513939484], thread trace [1]:
> DBD::Pg::db selectcol_arrayref failed: ERROR: more than one row
> returned by a subquery used as an expression
> CONTEXT: SQL function "org_unit_descendants" statement 1 [for Statement
> " SELECT DISTINCT LOWER(users.family_name),
> LOWER(users.first_given_name), LOWER(users.second_given_name),
> LOWER(users.dob), LOWER(users.id)
> FROM actor.usr AS users
> JOIN (SELECT id as id FROM actor.usr u WHERE
> LOWER(email) ~ ?) AS search ON (search.id = users.id)
> JOIN actor.org_unit_descendants(4, 2) d ON (d.id
> = users.home_ou)
>
> WHERE users.deleted = FALSE
> ORDER BY LOWER(users.family_name) ASC,
> LOWER(users.first_given_name) ASC, LOWER(users.second_given_name) ASC,
> LOWER(users.dob) DESC, LOWER(users.id)
> LIMIT 51
> "] at /openils/lib/perl5/OpenILS/Application/Storage/Publisher/actor.pm
> line 572.
>
> Caught error from 'run' method: Exception: OpenSRF::EX::ERROR
> 2009-06-11T16:24:35 OpenSRF::Application
> /usr/local/share/perl/5.10.0/OpenSRF/Application.pm:200 System ERROR:
> Call to open-ils.storage for method
> open-ils.storage.actor.user.crazy_search
> failed with exception: Exception: OpenSRF::EX::ERROR
> 2009-06-11T16:24:35 OpenILS::Application::AppUtils
> /openils/lib/perl5/OpenILS/Application/AppUtils.pm:179 System ERROR:
> Exception: OpenSRF::DomainObject::oilsMethodException
> 2009-06-11T16:24:35 OpenSRF::AppRequest
> /usr/local/share/perl/5.10.0/OpenSRF/AppSession.pm:1009 <500> *** Call
> to [open-ils.storage.actor.user.crazy_search] failed for session
> [1244751875.053172252.2513939484], thread trace [1]:
> DBD::Pg::db selectcol_arrayref failed: ERROR: more than one row
> returned by a subquery used as an expression
> CONTEXT: SQL function "org_unit_descendants" statement 1 [for Statement
> " SELECT DISTINCT LOWER(users.family_name),
> LOWER(users.first_given_name), LOWER(users.second_given_name),
> LOWER(users.dob), LOWER(users.id)
> FROM actor.usr AS users
> JOIN (SELECT id as id FROM actor.usr u WHERE
> LOWER(email) ~ ?) AS search ON (search.id = users.id)
> JOIN actor.org_unit_descendants(4, 2) d ON (d.id
> = users.home_ou)
>
> WHERE users.deleted = FALSE
> ORDER BY LOWER(users.family_name) ASC,
> LOWER(users.first_given_name) ASC, LOWER(users.second_given_name) ASC,
> LOWER(users.dob) DESC, LOWER(users.id)
> LIMIT 51
> "] at /openils/lib/perl5/OpenILS/Application/Storage/Publisher/actor.pm
> line 572.
>
> ========================================
> So the questions are, why do I see these errors during an add?
>
> And 2) why does a simple lookup fail so badly....
>
> Phil Hunt
> Program Director, Information Technology
> NELINET, Inc.
>
> ' Direct Phone: (508)597-1924
> ' 1.508.460.7700 x1924
> 6 FAX (508)460-9455
> * hunt at NELINET.net
>
>
>
--
Mike Rylander
| VP, Research and Design
| Equinox Software, Inc. / The Evergreen Experts
| phone: 1-877-OPEN-ILS (673-6457)
| email: miker at esilibrary.com
| web: http://www.esilibrary.com
More information about the Open-ils-dev
mailing list