[OPEN-ILS-GENERAL] Problem of importing the Gutenberg records

[Araik Manukyan]

Thank you for your quick response.

We are sending your requested files that we have received during the
conversation.

----- Original Message ----- 
From: "Mike Rylander" <mrylander at gmail.com>
To: "Evergreen Discussion Group" 
<open-ils-general at list.georgialibraries.org>
Sent: Wednesday, October 28, 2009 8:54 AM
Subject: Re: [OPEN-ILS-GENERAL] Problem of importing the Gutenberg records


Would you mind sending that file?

TIA,

--miker

2009/10/28 araik <araik at flib.sci.am>:
> Hello list,
>
> We installed Evergreen 1.6 version on ubuntu 8.10 server.
> We tried importing the Project Gutenberg records to our server, as 
> described
> on the following link
> http://www.open-ils.org/dokuwiki/doku.php?id=evergreen-admin:importing:bibrecords&s[]=import&s[]=record.
> We passed 3 steps successful and we have file gutenberg.sql.
> After trying to implement the step 4, \i ~/gutenberg.sql,
> we have the following error
>
> **************************************************
> evergreen=# \i /root/gutenberg.sql
> SET
> BEGIN
> setval
> --------
> 1
> (1 row)
>
> psql:/root/gutenberg.sql:16: ERROR: trigger
> "zzz_update_materialized_simple_record_tgr" for table "real_full_rec" does
> not exist
> CONTEXT: SQL function "disable_materialized_simple_record_trigger"
> statement 1
> psql:/root/gutenberg.sql:17: ERROR: current transaction is aborted,
> commands ignored until end of transaction block
> psql:/root/gutenberg.sql:18: invalid command \N
> psql:/root/gutenberg.sql:19: invalid command \N
> psql:/root/gutenberg.sql:20: invalid command \N
> psql:/root/gutenberg.sql:21: invalid command \N
> psql:/root/gutenberg.sql:42: invalid command \.
> psql:/root/gutenberg.sql:44: ERROR: syntax error at or near "1"
> LINE 1: 1 a 040 pgusa
> ^
> psql:/root/gutenberg.sql:45: ERROR: current transaction is aborted,
> commands ignored until end of transaction block
> psql:/root/gutenberg.sql:47: invalid command \.
> psql:/root/gutenberg.sql:49: ERROR: syntax error at or near "6"
> LINE 1: 6 1 five years of theosophy
> ^
> psql:/root/gutenberg.sql:51: invalid command \.
> psql:/root/gutenberg.sql:53: ERROR: syntax error at or near "15"
> LINE 1: 15 1 five years of theosophy text eng electronic electronic ...
> ^
> psql:/root/gutenberg.sql:55: invalid command \.
> psql:/root/gutenberg.sql:57: ERROR: syntax error at or near "1"
> LINE 1: 1 1 project gutenberg 14378
> *********************************************************************************************
>
> Could you tell the reason of our problem?
>
> Thank you in advance
>
> Araik
> Fundamental Scientific Library of NAS RA



-- 
Mike Rylander
 | VP, Research and Design
 | Equinox Software, Inc. / The Evergreen Experts
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  miker at esilibrary.com
 | web:  http://www.esilibrary.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: gutenberg.sql
Type: application/octet-stream
Size: 3842 bytes
Desc: not available
Url : http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20091028/6c73d5a2/attachment-0004.obj 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: gutenberg.bre
Type: application/octet-stream
Size: 2061 bytes
Desc: not available
Url : http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20091028/6c73d5a2/attachment-0005.obj 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: gutenberg.ingest
Type: application/octet-stream
Size: 4176 bytes
Desc: not available
Url : http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20091028/6c73d5a2/attachment-0006.obj 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: gutenberg.marc
Type: application/octet-stream
Size: 531 bytes
Desc: not available
Url : http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20091028/6c73d5a2/attachment-0007.obj