On Fri, Jun 12, 2009 at 9:51 AM, Hunt, Phil<[email protected]> wrote: > It is version 1.4.0.4 >
Hrm... the multiple-rows error is suggestive of a misconfigured org tree. Can you post the output of the following psql commands: SELECT * FROM actor.org_unit_type; SELECT * FROM actor.org_unit; TIA, --miker > > 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 > -- 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
