[OPEN-ILS-GENERAL] Reshelving 2.2Alpha1

[Sue Hopkins]

Hi,

I am running release 2.2-alpha1 and I cannot get any reshelving to work.  When I try to run the reshelving command from an srfsh prompt , I get the following:

srfsh# request open-ils.storage open-ils.storage.action.circulation.reshelving.complete "2h"

Received Exception:
Name: osrfMethodException
Status:  *** Call to [open-ils.storage.action.circulation.reshelving.complete] failed for session [1327496758.265765.13274967589115], thread trace [1]:
DBD::Pg::st execute failed: called with 3 bind variables when 1 are needed [for Statement "             UPDATE  asset.copy
                  SET   status = 0
                  WHERE id IN (
            SELECT cp.id
            FROM  asset.copy cp
                LEFT JOIN actor.org_unit_setting setting
                    ON (cp.circ_lib = setting.org_unit AND setting.name = 'circ.reshelving_complete.interval')
            WHERE cp.status = 7
                AND cp.status_changed_time < NOW() - CAST( COALESCE( BTRIM( setting.value,'"' ), ? )  AS INTERVAL)
                  )
" with ParamValues: 1=undef] at /usr/share/perl5/DBIx/ContextualFetch.pm line 52.


Status: 500
------------------------------------
Request Completed Successfully
Request Time in seconds: 0.063729
------------------------------------
:

Any ideas how I can get this working?

Sue Hopkins


[graphic]

Systems & Networking Manager
C/W MARS, Inc.
67 Millbrook Street, Suite 201
Worcester, MA 01606
Ph:   (508)-755-3323 ext-18
Fax: (508)-755-3721



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20120125/8690171c/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.jpg
Type: image/jpeg
Size: 3714 bytes
Desc: image003.jpg
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20120125/8690171c/attachment-0001.jpg>