Comment 4 for bug 1431055

Revision history for this message
Kathy Lussier (klussier) wrote :

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.