[OPEN-ILS-GENERAL] Export error

[Dan Scott]

On Tue, Sep 27, 2011 at 06:32:55AM -0400, Dan Scott wrote:
> 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!

Also noted - it should be "owning_lib" instead of "ownling_lib". I have
prepared a patch for the pertinent section of the documentation and will
be sending that to the DIG. :)