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

[Jason Stephenson]

Quoting Araik Manukyan <araik at flib.sci.am>:

> 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

Yeah, I think that upgrade script has a bug that was fixed later.

You can get around it by adding -v eg_version=2.3.1 on the command  
line for psql when you run the upgrade script.



>
> ---
>
> 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.
>
>



-- 
Jason Stephenson
Assistant Director for Technology Services
Merrimack Valley Library Consortium
Chief Bug Wrangler, Evergreen ILS