[OPEN-ILS-DEV] Open-ils-dev Digest, Vol 55, Issue 6

[Kim Scannell]

Hooray! All fixed now.  I'll still come after you to buy you a beer :)
Thanks Jason

>
> On Sun, Oct 10, 2010 at 11:32 AM, Kim Scannell <kscannell at cntrmail.org> wrote:
>> Thanks Jason, I tried to checkout a precat as admin and got the same error.
>> Error log says:
>> ?insert or update on table "copy" violates foreign key constraint
>> "copy_location_fkey"
>> 2010-10-09 18:29:10 CDT DETAIL: ?Key (location)=(1) is not present in
>> table "copy_location".
>
> Ah, that explains it.  The precat code is trying to create an item
> with a copy/shelving location that no longer exists in your
> installation.  This is a hardcoded value, so the easiest fix is insert
> such a row directly into the database.  In a stock Evergreen
> installation, this location would be called Stacks.  You could also
> change the id for one of your existing locations to 1, but that's not
> as easy as it could be.
>
> This should be safe to enter into psql, but if it blows up your
> database or something, just don't come after me. :-)  Always a good
> idea to do such things after business hours and to have a fresh
> backup.
>
> BEGIN;
> UPDATE asset.copy_location SET id = 1 WHERE id = 114; -- this moves
> your existing Stacks from 114 to 1
> UPDATE asset.copy SET location = 1 WHERE location = 114; -- this
> mirrors the change amongst your items
> COMMIT; -- this makes it all happen, and until this is entered, your
> tables may be locked, affecting production use
>
> --
> Jason Etheridge
> ?| VP, Tactical Development
> ?| Equinox Software, Inc. / Your Library's Guide to Open Source
> ?| phone:? 1-877-OPEN-ILS (673-6457)
> ?| email:? jason at esilibrary.com
> ?| web:? http://www.esilibrary.com
>
> Happy 4th birthday, Evergreen!
>

Kim Scannell
The Center Library
library.thecenterweb.org