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
<<inline: image003.jpg>>
