From: Jay R. <ja...@gm...> - 2013-08-20 14:37:11
|
It's not working because getStatuses is attempting to retrieve the statuses from the Horizon item table. The records are retrieved by bib#. There is no record of the OCLC number in the item table. For the Horizon driver you MUST have the bib#. The way I've worked around it is to have marcout export the bib# for every record to the 999 tag subfield a. I am not a cataloger so don't shoot me if that's not absolutely correct. You can choose the tag and subfield you prefer with marcout. On Mon, Aug 19, 2013 at 4:53 PM, Brad Busenius <bbu...@uc...>wrote: > 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 > > > > ------------------------------------------------------------------------------ > Introducing Performance Central, a new site from SourceForge and > AppDynamics. Performance Central is your source for news, insights, > analysis and resources for efficient Application Performance Management. > Visit us today! > http://pubads.g.doubleclick.net/gampad/clk?id=48897511&iu=/4140/ostg.clktrk > _______________________________________________ > Vufind-tech mailing list > Vuf...@li... > https://lists.sourceforge.net/lists/listinfo/vufind-tech > > |