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
