[OPEN-ILS-DEV] Error when creating items

[Robert Nix]

Mike,

When I am entering in the new information for the copy it will not let me
add a shelf location. The location has three question marks in it ??? and
when I click the box to change it there is no text box that comes up like
the rest of the fields. Do I need to go into the postgresql and add the row
back in there manually or is there another way to do it? Is there a file I
can download like a sql file that can rebuild the database? I don't have any
real information in it yet and I want to make sure that there are no other
problems with the database itself before I continue so this would be the
desireable direction to move in for me.

On Wed, Mar 12, 2008 at 12:52 PM, Mike Rylander <mrylander at gmail.com> wrote:

> On Wed, Mar 12, 2008 at 10:37 AM, Robert Nix <glibrarysystem at gmail.com>
> wrote:
> > Bill,
> >
> >     I was able to locate the postgresql log and this is the error that I
> > found:
> >
> > 2008-03-12 14:22:10 UTC LOG:  autovacuum: processing database "postgres"
> > 2008-03-12 14:22:56 UTC WARNING:  there is no transaction in progress
> >  2008-03-12 14:23:01 UTC ERROR:  insert or update on table "copy"
> violates
> > foreign key constraint "copy_location_fkey"
> > 2008-03-12 14:23:01 UTC DETAIL:  Key (location)=(1) is not present in
> table
> > "copy_location".
> >  2008-03-12 14:23:07 UTC WARNING:  there is no transaction in progress
> >
> > It looks like it doesn't want us to copy from the table but I can't be
> sure.
> > What would be the next step?
> >
>
> It looks like the shelving location "Stacks", which is inserted by
> default during installation, has been removed.  If you have added more
> shelving locations and removed that one then you'll need to log out of
> the staff client and log back in, as it caches those.  The expectation
> is that shelving locations intended for use would not be removed
> during normal operating hours.
>
> You'll need at least one shelving location in the database, and the
> location field will default to 1 (the id for the Stack location) if
> you do not provide one when creating the copies.
>
> Hope that gets you further.
>
> --miker
>
> >
> >
> >  On Tue, Mar 11, 2008 at 5:48 PM, Bill Erickson <erickson at esilibrary.com
> >
> > wrote:
> > >
> > > Robert Nix wrote:
> > > > Bill,
> > > >
> > > >   I have looked at the log and it seems to show that there is an
> error
> > > > committing transactions with multiple modules. This could be from
> the
> > > > initial module that fails to commit the transaction. I am attaching
> a
> > > > copy of the osrfsys.log file. I took a sample from initial logon to
> exit
> > > > so the actual error is at the bottom of the file but I just wanted
> to
> > > > show that it was up and running and is able to interact with the
> client.
> > > > Any help on the subject would be greatly appreciated.
> > >
> > > So, you were able to create the copy OK:
> > >
> > > -> editor[1|1] created a new asset.copy object with ID 32
> > >
> > > but the database commit failed:
> > >
> > > -> open-ils.cstore: Error committing transaction
> > >
> > > My next stop would be the Postgres logs.  It should provide some
> > > SQL-level error message that sheds light on the commit failure.  I
> don't
> > > recall offhand, however, where those logs are by default.
> > >
> > >
> > >
> > >
> > > -bill
> > >
> > >
> > > --
> > > Bill Erickson
> > > | VP, Software Development & Integration
> > > | Equinox Software, Inc. / The Evergreen Experts
> > > | phone: 877-OPEN-ILS (673-6457)
> > > | email: erickson at esilibrary.com
> > > | web: http://esilibrary.com
> > >
> >
> >
>
>
>
> --
> Mike Rylander
>  | VP, Research and Design
>  | Equinox Software, Inc. / The Evergreen Experts
>  | phone: 1-877-OPEN-ILS (673-6457)
>  | email: miker at esilibrary.com
>  | web: http://www.esilibrary.com
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://list.georgialibraries.org/pipermail/open-ils-dev/attachments/20080312/96b1c9e7/attachment.html