From: Brad B. <bbu...@uc...> - 2013-08-19 21:53:20
|
Some of our item records have makeshift bib numbers beginning with "ocm". These numbers with the ocm prefix are OCLC numbers and they are listed in the 001 field when there is no Horizon bib number associated with the record. This is causing VuFind to choke on the while loop in the getStatuses function in Horizon.php. As a consequence of this we lose all of the item information for /every/ record on the results page. On a search that doesn't have one of these gray ducklings <http://dldc3.lib.uchicago.edu/vufind/Search/Results?lookfor=art&type=AllFields&submit=Search&limit=60&sort=relevance>, we get status, call number, and location for every item as expected, however, on any search that returns one of these records <http://dldc3.lib.uchicago.edu/vufind/Search/Results?lookfor=science&type=AllFields&submit=Search&limit=60&sort=relevance>, we lose this information for all items in the result list (even those that don't have the "ocm" prefix). This is true of the blueprint theme as well as our custom theme. I'm not seeing any errors in the php log, however, I do see them in the firebug console at the end of the output from the ajax call. The errors are as follows: \/Horizon.php on line 448.","ERROR [2] - mssql_query(): message: Invalid column name 'ocm01250086'.\n (severity 16)<br \/>\n Occurred in \/data\/dldc3\/vufind2\/module\/VuFind\/src\/VuFind\/ILS\/Driver \/Horizon.php on line 448.","ERROR [2] - mssql_query(): Query failed<br \/>\n Occurred in \/data\/dldc3\/vufind2\/module\/VuFind\/src\/VuFind\/ILS\/Driver\/Horizon.php on line 448.","ERROR [2] - mssql_fetch_assoc() expects parameter 1 to be resource, boolean given<br \/>\n Occurred in \/data\/dldc3\/vufind2\/module\/VuFind\/src\/VuFind\/ILS\/Driver\/Horizon.php on line 449." I didn't open a jira ticket for this because I wasn't sure if our practice was commonplace. We will, however, need to do some error handling on this. My question for the list is, where is the best place to handle this? I realize I might be able to do something in the getStatuses function, however, I'm not sure that is the best place to fix it. Does anybody know how I should go about this? Your help is greatly appreciated. Brad Busenius |