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-boun...@list.georgialibraries.org [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Jason Stephenson Sent: Thursday, December 20, 2012 6:34 PM To: open-ils-general@list.georgialibraries.org Subject: Re: [OPEN-ILS-GENERAL] Error: Upgrade the Evergreen database schema Quoting Araik Manukyan <ar...@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