[OPEN-ILS-GENERAL] Problems with export

[Paul Hoffman]

On Wed, Aug 10, 2011 at 07:12:56AM -0400, Armen wrote:
> 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.6.0.6. I have
> clearly followed the instructions available at this address
> http://docs.evergreen-ils.org/1.6/draft/html/exportingbibrecordsintoMARC.html.
> 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".
> 
> Please help me with this problem.

Try this:

    ... WHERE NOT bre.deleted AND ...

> Thanks in advance
> 
> Armen

Paul.

-- 
Paul Hoffman <paul at flo.org>
Systems Librarian
Fenway Libraries Online
c/o Wentworth Institute of Technology
550 Huntington Ave.
Boston, MA 02115
(617) 445-2914
(617) 442-2384 (FLO main number)