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

[Jason Stephenson]

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

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

Did you get the same error message?

I believe the 2.3 release maintainer has added a fixed version of the  
script to the 2.3.3 release tarball. You might want to download that  
and upgrade to 2.3.3.


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



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