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

[Jason Stephenson]

Quoting Jason Stephenson <jstephenson at mvlc.org>:

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

That should be the 2.3.2 release tarball, sorry.



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



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