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

araik araik at flib.sci.am
Wed Oct 28 08:06:25 EDT 2009


Hello list,
We  installed Evergreen 1.6 version on  ubuntu interpid 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 




More information about the Open-ils-general mailing list