[Koha] error occurs when adding new biblio

[John Wesley Simpson Hibbs]

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