On Sun, Jan 4, 2009 at 12:08 PM, John Wesley Simpson Hibbs <john@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+unde...
-- John Wesley Simpson Hibbs <john@swajime.com> SwaJime's Cove
_______________________________________________ Koha mailing listKoha@lists.katipo.co.nzhttp://lists.katipo.co.nz/mailman/listinfo/koha
-- John Wesley Simpson Hibbs <john@swajime.com> SwaJime's Cove
_______________________________________________ Koha mailing list Koha@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