[OPEN-ILS-GENERAL] Error: Upgrade the Evergreen database schema

[Araik Manukyan]

Dear friends,

 

We are upgrading from Everegreen 2.2.1 to 2.3.1. The transition was going
smoothly untill the final step. When try to upgrade the Evergreen database
scheme with the command 

---

psql -U evergreen -h localhost -f version-upgrade/2.3.0-2.3.1-upgrade-db.sql
evergreen

---

 

an error occurs. Here is the error text.

 

---

BEGIN

psql:version-upgrade/2.3.0-2.3.1-upgrade-db.sql:3: ERROR:  syntax error at
or near ":"

LINE 1: ...pgrade_log (version, applied_to) VALUES ('2.3.1', :eg_versio...

                                                             ^

psql:version-upgrade/2.3.0-2.3.1-upgrade-db.sql:5: ERROR:  syntax error at
or near ":"

LINE 1: SELECT evergreen.upgrade_deps_block_check('0740', :eg_versio...

                                                          ^

psql:version-upgrade/2.3.0-2.3.1-upgrade-db.sql:134: ERROR:  current
transaction is aborted, commands ignored until end of transaction block

psql:version-upgrade/2.3.0-2.3.1-upgrade-db.sql:137: ERROR:  syntax error at
or near ":"

LINE 1: SELECT evergreen.upgrade_deps_block_check('0742', :eg_versio...

                                                          ^

psql:version-upgrade/2.3.0-2.3.1-upgrade-db.sql:269: ERROR:  current
transaction is aborted, commands ignored until end of transaction block

ROLLBACK

---

 

Any ideas? 

 

Regards, Arayik.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20121220/e91397d2/attachment.htm>