[Koha] error occurs when adding new biblio
John Wesley Simpson Hibbs
john at swajime.com
Tue Jan 6 04:48:50 NZDT 2009
On Sun, 2009-01-04 at 18:09 -0700, Jesse Weaver wrote:
>
>
>
> On Sun, Jan 4, 2009 at 5:26 PM, John Wesley Simpson Hibbs
> <john at swajime.com> wrote:
>
>
> On Sun, 2009-01-04 at 16:19 -0700, Jesse Weaver wrote:
>
> >
> >
> > On Sun, Jan 4, 2009 at 12:08 PM, John Wesley Simpson Hibbs
> > <john at swajime.com> wrote:
> >
> > I've manually deleted the inaccessible records from
> > the koha sql database, and moved newer records #18 -
> > #21 into their place.
> > Now, though, it seems I can't get rid of the "gap"
> > in the numbering sequence. When I go to add a new
> > record, the next biblio number assigned is higher
> > than it ought to be.
> > The last record in the database is now #17, and yet
> > when I add a record it is assigned #22.
> > How can I fix this?
> >
> > # mysql -Dkoha -ukohaasuper -pkoha4mylibrary -e
> > "select biblionumber,isbn from biblioitems"
> >
> > +--------------+----------------+
> > | biblionumber | isbn |
> > +--------------+----------------+
> > | 1 | NULL |
> > | 2 | 003071592X (pb |
> > | 3 | 003069549X : |
> > | 4 | 002093081X : |
> > | 5 | 0030536111 | 0 |
> > | 6 | 0025349201 |
> > | 7 | 0025907859 : |
> > | 8 | 0026019604 |
> > | 9 | 0028610873 |
> > | 10 | 002870763X |
> > | 11 | 0028619811 |
> > | 12 | 002862114X (pb |
> > | 13 | 0028627288 |
> > | 14 | 0028627423 |
> > | 15 | 0028633822 |
> > | 16 | 0028639235 |
> > | 17 | 002864171X |
> > | 22 | 0060158719 : |
> > | 23 | 006016848X (cl |
> > +--------------+----------------+
> >
> >
> >
> > On Thu, 2009-01-01 at 21:45 -0600, John Wesley
> > Simpson Hibbs wrote:
> >
> >
> > >
> > > Has anybody found a solution to
> > > http://lists.katipo.co.nz/public/koha/2008-December/016248.html ?
> > >
> > > I'm getting exactly the same error:
> > >
> > > Koha error
> > > The following fatal error has occurred:
> > >
> > >
> > > Can't call method "fields" on an undefined value at /usr/share/koha/lib/C4/Biblio.pm line 1642.
> > >
> > > Apache
> > > Server version:
> > > Apache/2.2.8 (Ubuntu)
> > > Server built: Jun 25 2008
> > > 13:54:13
> > > Koha
> > > 3.00.00.107
> > > Koha DB
> > > 3.0000107
> > > MySQL
> > > mysql Ver 14.12 Distrib
> > > 5.0.51a, for
> > > debian-linux-gnu (i486)
> > > using readline 5.2
> > > OS
> > > Linux lamentations
> > > 2.6.24-22-generic #1 SMP
> > > Mon Nov 24 18:32:42 UTC
> > > 2008 i686 GNU/Linux
> > > Perl
> > > 5.008008
> > >
> > > I don't think I'm the only one experiencing this
> > > problem...
> > > This google search comes up with 112 hits:
> > > http://www.google.com/search?q=koha+%22Can%27t
> > > +call+method+fields+on+an+undefined+value%22+%
> > > 22line+1642%22
> > >
> > > --
> > > John Wesley Simpson Hibbs <john at swajime.com>
> > > SwaJime's Cove
> > >
> > > _______________________________________________
> > > Koha mailing list
> > > Koha at lists.katipo.co.nz
> > > http://lists.katipo.co.nz/mailman/listinfo/koha
> >
> >
> > --
> > John Wesley Simpson Hibbs <john at swajime.com>
> > SwaJime's Cove
> >
> > _______________________________________________
> > Koha mailing list
> > Koha at lists.katipo.co.nz
> > http://lists.katipo.co.nz/mailman/listinfo/koha
> >
> >
> >
> > (In reference to your numbering problem)
> >
> > This is part of MySQL's design, and is not something Koha
> > has control over, though it shouldn't cause you any
> > problems.
> >
> > It is possible to change this counter, but you'll still have
> > holes in the future if you delete records in the middle of
> > the numbering sequence.
> >
> > --
> > Jesse Weaver
> > Software Developer, LibLime
>
> Jess,
>
> Ok, just for grins, would you mind sharing with me how I can
> go about changing the counter?
> Whether it's malignant or not, it is really annoying me...
> BTW, Mr. Adrian Monk is on tv tonight, and I'm sure he'd agree
> with me.
>
>
>
> --
> John Wesley Simpson Hibbs <john at swajime.com>
> SwaJime's Cove
>
>
> So you have a bit of CDO (the letters should be in ALPHABETICAL ORDER,
> dangit)? ;)
>
> Anyway, the SQL you need is:
>
> ALTER TABLE biblio SET AUTO_INCREMENT = 18
>
> (after you delete the biblios after the jump)
>
> --
> Jesse Weaver
> Software Developer, LibLime
Jesse,
Awesome, thank you, very much. :-D
So, what I've done, for anybody else who might want to know:
UPDATE biblio SET biblionumber = 21 where biblionumber = 24;
UPDATE biblioitems SET biblioitemnumber = 21, biblionumber = 21
WHERE biblioitemnumber = 24 ;
ALTER TABLE biblio AUTO_INCREMENT = 24;
ALTER TABLE biblioitems AUTO_INCREMENT = 24;
This worked perfectly (unless I've messed up something else that I don't
know about yet). :-)
So, if I might ask another question...
I can do a search for say "guide", and get several books listed. It
seems, though, that I cannot do a search for "*". How can I list all
(24) of the books in the library?
24 down, ~1450 to go...
--
John Wesley Simpson Hibbs <john at swajime.com>
SwaJime's Cove
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20090105/438ba721/attachment-0001.htm
More information about the Koha
mailing list