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

Mike Rylander mrylander at gmail.com
Wed Oct 28 11:54:43 EDT 2009


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


More information about the Open-ils-general mailing list