I loaded this code on to a Sandbox for Bug Squashing Day and added Content Cafe credentials in the Apache config to get the Reviews & More link to to display on the search results page. However, I receive an Internal Server error when retrieving search results on the Sandbox. I see the following in osrfsys.log
[2015-06-11 20:45:12] /usr/sbin/apache2 [INFO:30045:CStoreEditor.pm:139:14340650193004519] editor[0|0] request en-US open-ils.cstore.json_query.atomic {"from":["actor.org_unit_ancestor_setting","opac.reviews_and_more_new_tab",""]}
open-ils.cstore 2015-06-11 20:45:12 [INFO:29028:osrf_application.c:1059:14340650193004520] CALL: open-ils.cstore open-ils.cstore.json_query.atomic {"from":["actor.org_unit_ancestor_setting","opac.reviews_and_more_new_tab",""]}
open-ils.cstore 2015-06-11 20:45:12 [ERR :29028:oils_sql.c:5797:14340650193004520] open-ils.cstore: Error with query [SELECT * FROM actor.org_unit_ancestor_setting( 'opac.reviews_and_more_new_tab', '' ) AS "actor.org_unit_ancestor_setting" ;]: 3484946 3484946: ERROR: invalid input syntax for integer: ""
LINE 1: ...ncestor_setting( 'opac.reviews_and_more_new_tab', '' ) AS "a...
Adding the same Content Cafe credentials in the Apache config for a Sandbox running a clean master build did not result in this error.
I loaded this code on to a Sandbox for Bug Squashing Day and added Content Cafe credentials in the Apache config to get the Reviews & More link to to display on the search results page. However, I receive an Internal Server error when retrieving search results on the Sandbox. I see the following in osrfsys.log
[2015-06-11 20:45:12] /usr/sbin/apache2 [INFO:30045: CStoreEditor. pm:139: 143406501930045 19] editor[0|0] request en-US open-ils. cstore. json_query. atomic {"from" :["actor. org_unit_ ancestor_ setting" ,"opac. reviews_ and_more_ new_tab" ,""]} osrf_applicatio n.c:1059: 143406501930045 20] CALL: open-ils.cstore open-ils. cstore. json_query. atomic {"from" :["actor. org_unit_ ancestor_ setting" ,"opac. reviews_ and_more_ new_tab" ,""]} oils_sql. c:5797: 143406501930045 20] open-ils.cstore: Error with query [SELECT * FROM actor.org_ unit_ancestor_ setting( 'opac.reviews_ and_more_ new_tab' , '' ) AS "actor. org_unit_ ancestor_ setting" ;]: 3484946 3484946: ERROR: invalid input syntax for integer: "" and_more_ new_tab' , '' ) AS "a...
open-ils.cstore 2015-06-11 20:45:12 [INFO:29028:
open-ils.cstore 2015-06-11 20:45:12 [ERR :29028:
LINE 1: ...ncestor_setting( 'opac.reviews_
Adding the same Content Cafe credentials in the Apache config for a Sandbox running a clean master build did not result in this error.