Hi Armen: On Tue, Sep 27, 2011 at 01:44:14PM +0500, Armen wrote: > Dear Evergreen community > I am from the Fundamental Scientific Library of Armenia. We use Evergreen > 2.0.5 and now we need to import a database of bibliographic records from an > older version of Ervergreen, namely 1.4.0.4. I have clearly followed the > instructions available at this address > http://docs.evergreen-ils.org/1.6/draft/html/exportingbibrecordsintoMARC.htm > l. > > However, after the command > > " SELECT DISTINCT bre.id FROM biblio.record_entry AS bre > JOIN asset.call_number AS acn ON acn.record-bre.id > WHERE bre.deleted='false' and ownling_lib=101 \g > /home/opensrf/records.txt; " > > the system pops out an error, namely this > > "argument of JOIN/ON must be type boolean, not type bigint".
It looks like this is a typo in the documentation. I would expect the "ON" clause to read "ON acn.record = bre.id". Also, ensure that the ID of the library for which you are exporting the records is 101; you can check that in the actor.org_unit table. I hope this helps!
