[OPEN-ILS-DEV] Upgrade problem with 2.2-beta1

[Lebbeous Fogle-Weekley]

Hello Martha,

I have made changes to address this problem, and they should be available
in the next beta.  See here for more information:
https://bugs.launchpad.net/evergreen/+bug/974410

Thanks!

Lebbeous

On Tue, 03 Apr 2012 09:00:06 -0400, Martha Driscoll
<driscoll at noblenet.org>
wrote:
> I upgraded one of my servers to 2.2-beta1 last night and ran into a 
> problem with 0700.schema.serial-holding-groups.sql:
> 
> psql:0700.schema.serial-holding-groups.sql:141: ERROR:  malformed JSON 
> string, neither array, object, number, string or atom, at character 
> offset 0 (before "(end of string)") at line 20.
> CONTEXT:  PL/Perl function "materialize_holding_code"
> 
> I ran script 0700 up to:
> 
> -- starting here, we materialize all existing holding codes.
> 
> It fails at this line:
> UPDATE serial.issuance SET holding_code = holding_code;
> 
> I upgraded another system earlier in the day, but that system had an 
> empty serial.issuance table and did not throw an error.
> 
> This server:
> debian squeeze
> postgres 9.0
> opensrf 2.1.0-alpha1
> upgrading from 2.2-alpha3 to 2-2.beta1

-- 
Lebbeous Fogle-Weekley
 | Software Developer
 | Equinox Software, Inc. / Your Library's Guide to Open Source
 | phone:  1-877-OPEN-ILS (673-6457)
 | email:  lebbeous at esilibrary.com
 | web:  http://www.esilibrary.com