[Koha] error occurs when adding new biblio

[Jesse Weaver]

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 listKoha at lists.katipo.co.nzhttp://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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20090104/4c497690/attachment.htm