[OPEN-ILS-GENERAL] bookbagupdate.pl

[Jayaraj JR]

We have tried to implement book bag update system. We have done as per the
instruction seen in the email discussion. We got the error message "
Reference Error _tree_killer not found while inspecting the HTML output. I
have checked the user book bag after running the perl script throgh
crontab. No data (book details) is seen either in the user account book bag
or in the OPAC home page. Kindly help to resolve the problem. The screen
shot is attached.

----------------------------------
Thanking You

Jayaraj J R
Library Information Assistant
IISER Thiruvananthapuram
Attachments area
Preview attachment book_bag.jpg
<https://mail.google.com/mail/u/0/?ui=2&ik=5c407d8536&view=att&th=14e535e0a96451ed&attid=0.2.3.0.1&disp=safe&realattid=f_ibng8sen0&zw>

Included below is the log file we got after running the bookbag_update.pl
file.

2015-07-01 17:04:45 :  ---------------- Script Starting ----------------
SELECT ID,(SELECT PARENT_OU FROM ACTOR.ORG_UNIT WHERE ID=(SELECT HOME_OU
FROM ACTOR.USR WHERE ID=A.OWNER)),DESCRIPTION FROM
CONTAINER.BIBLIO_RECORD_ENTRY_BUCKET A WHERE DESCRIPTION
IN('newitems','recentreturned','last14daytopcirc')

    SELECT DISTINCT "REC" FROM
(
SELECT (SELECT RECORD FROM ASSET.CALL_NUMBER WHERE RECORD>0 AND RECORD IS
NOT NULL AND
ID=(SELECT CALL_NUMBER FROM ASSET.COPY WHERE ID=A.TARGET_COPY
AND LOCATION IN(SELECT ID FROM ASSET.COPY_LOCATION WHERE OWNING_LIB IN(2,4)
AND OPAC_VISIBLE AND HOLDABLE AND CIRCULATE) AND OPAC_VISIBLE AND HOLDABLE
AND CIRCULATE AND ID != -1::BIGINT
)) "REC",
CHECKIN_SCAN_TIME::DATE FROM ACTION.CIRCULATION  A
WHERE CIRC_LIB IN(2,4) AND
CHECKIN_SCAN_TIME IS NOT NULL AND
TARGET_COPY IN(SELECT ID FROM ASSET.COPY WHERE CALL_NUMBER IN(SELECT ID
FROM ASSET.CALL_NUMBER WHERE RECORD>0 AND RECORD IS NOT NULL))
ORDER BY
CHECKIN_SCAN_TIME::DATE DESC LIMIT 200
) AS B
ORDER BY "REC" DESC
LIMIT 100

     SELECT DISTINCT "REC",COUNT(*) FROM
 (
SELECT (SELECT RECORD FROM ASSET.CALL_NUMBER WHERE ID=(SELECT CALL_NUMBER
FROM ASSET.COPY WHERE ID=A.TARGET_COPY) AND RECORD>0 AND RECORD IS NOT
NULL) "REC"
,XACT_START::DATE
FROM ACTION.CIRCULATION  A
WHERE CIRC_LIB IN(2,4) AND
(TARGET_COPY IN(SELECT ID FROM ASSET.COPY WHERE LOCATION IN(SELECT ID FROM
ASSET.COPY_LOCATION WHERE OWNING_LIB IN(2,4) AND OPAC_VISIBLE AND HOLDABLE
AND CIRCULATE) AND OPAC_VISIBLE AND HOLDABLE AND CIRCULATE AND ID !=
-1::BIGINT)) AND
XACT_START > NOW() - $$14 DAYS$$::INTERVAL
) AS B
GROUP BY "REC"
ORDER BY COUNT(*) DESC
LIMIT 100


SELECT * FROM
(
 SELECT DISTINCT "REC",
 (SELECT MAX(CREATE_DATE::DATE) FROM ASSET.COPY WHERE CALL_NUMBER = (SELECT
MAX(ID) FROM ASSET.CALL_NUMBER WHERE RECORD="REC")
 AND CIRC_LIB IN(2,4)) "THEDATE"

  FROM
(
SELECT (SELECT RECORD FROM ASSET.CALL_NUMBER WHERE ID=A.CALL_NUMBER AND
RECORD>0 AND RECORD IS NOT NULL) "REC",CREATE_DATE::DATE FROM ASSET.COPY  A
WHERE CIRC_LIB IN(2,4)
AND LOCATION IN(SELECT ID FROM ASSET.COPY_LOCATION WHERE OWNING_LIB IN(2,4)
AND OPAC_VISIBLE AND HOLDABLE AND CIRCULATE) AND OPAC_VISIBLE AND HOLDABLE
AND CIRCULATE AND ID != -1::BIGINT
ORDER BY
CREATE_DATE::DATE DESC LIMIT 300
) AS B
) AS C
where C."THEDATE" IS NOT NULL
ORDER BY C."THEDATE" DESC
LIMIT 100

2015-07-01 17:04:46 :  ---------------- Script End ----------------
-- 
धन्यवाद ,

जयराज जे आर                | Jayaraj J R
पुस्तकालय सूचना सहायक | Library Information Assistant
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20150704/7edc9084/attachment.html>