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 * [email protected]
-----Original Message----- From: [email protected] [mailto:[email protected]] 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<[email protected]> 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' => > '[email protected]'}},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 > * [email protected] > > > -- Mike Rylander | VP, Research and Design | Equinox Software, Inc. / The Evergreen Experts | phone: 1-877-OPEN-ILS (673-6457) | email: [email protected] | web: http://www.esilibrary.com
