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

[Araik Manukyan]

Dear Jason,

We have simply added *-v eg_version=2.3.1* to the script so that it became

*psql -U evergreen -h localhost -v eg_version=2.3.1 -f
version-upgrade/2.3.0-2.3.1-upgrade-db.sql evergreen*

Yet, the command did not work. Should we modify the command in a different
way? If it is not difficult, can you share with us the exact script?


Thanks in advance,
Araik.


-----Original Message-----
From: open-ils-general-bounces at list.georgialibraries.org
[mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of
Jason Stephenson
Sent: Thursday, December 20, 2012 6:34 PM
To: open-ils-general at list.georgialibraries.org
Subject: Re: [OPEN-ILS-GENERAL] Error: Upgrade the Evergreen database schema

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


-----
В этом сообщении вирусы не обнаружены.
Проверено AVG - www.avg.com
Версия: 2012.0.2221 / Вирусная база данных: 2637/5475 - Дата выпуска:
20.12.2012

-----
В этом сообщении вирусы не обнаружены.
Проверено AVG - www.avg.com
Версия: 2012.0.2221 / Вирусная база данных: 2637/5475 - Дата выпуска:
20.12.2012