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@swajime.com> SwaJime's Cove
I must have just hit some unlucky records right off of the bat. After I gave up on these two, the next ten books I entered were ok. If it might help to resolve this issue, here is some more information: library_url:8080/cgi-bin/koha/cataloguing/addbiblio.pl?biblionumber=_ 2: ISBN 0020583516 - Can't call method "title" on an undefined value at /usr/share/koha/intranet/cgi-bin/cataloguing/addbiblio.pl line 880. 10: ISBN 0028610903 - Can't call method "title" on an undefined value at /usr/share/koha/intranet/cgi-bin/cataloguing/addbiblio.pl line 880. library_url:8080/cgi-bin/koha/cataloguing/additem.pl?biblionumber=_ 2: Can't call method "fields" on an undefined value at /usr/share/koha/lib/C4/Biblio.pm line 1642. 10: Can't call method "fields" on an undefined value at /usr/share/koha/lib/C4/Biblio.pm line 1642. And this is what I see in the koha database: mysql> select * from biblio where biblionumber=2 or biblionumber=10; +--------------+---------------+----------------------------+------------------------------------------------------+----------+--------------------+--------+-------------+---------------+---------------------+-------------+----------+ | biblionumber | frameworkcode | author | title | unititle | notes | serial | seriestitle | copyrightdate | timestamp | datecreated | abstract | +--------------+---------------+----------------------------+------------------------------------------------------+----------+--------------------+--------+-------------+---------------+---------------------+-------------+----------+ | 2 | BKS | Birch, Beryl Bender. | Power yoga : | NULL | "A Fireside book." | 0 | NULL | 1995 | 2009-01-01 18:11:11 | 2009-01-01 | NULL | | 10 | BKS | Lockwood, Georgene Muller. | The complete idiot's guide to organizing your life / | NULL | NULL | 0 | NULL | 1996 | 2009-01-01 21:22:27 | 2009-01-01 | NULL | +--------------+---------------+----------------------------+------------------------------------------------------+----------+--------------------+--------+-------------+---------------+---------------------+-------------+----------+ 2 rows in set (0.00 sec) mysql> select * from biblioitems where biblionumber=2 or biblionumber=10; +------------------+--------------+--------+--------+----------+--------------+------+-----------------+-------------------+------------+------------+-----------------+----------------+------------------+------------------+-----------------------+---------------------+--------+----------------+-------+--------+------------+--------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------! --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------! -----------------------------------------------+-----------+--! --------+---------+-----------+---------+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------! ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------! -----------------------------------------------------------------------! ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------! ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------! -----------------------------------------------------------------------! -------------------------------------------------------------------------------------------------------+ | biblioitemnumber | biblionumber | volume | number | itemtype | isbn | issn | publicationyear | publishercode | volumedate | volumedesc | collectiontitle | collectionissn | collectionvolume | editionstatement | editionresponsibility | timestamp | illus | pages | notes | size | place | lccn | marc ! | url | cn_source | cn_class | cn_item | cn_suffix | cn_sort | totalissues | marcxml ! ! | +------------------+--------------+--------+--------+----------+--------------+------+-----------------+-------------------+------------+------------+-----------------+----------------+------------------+------------------+-----------------------+---------------------+--------+----------------+-------+--------+------------+--------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------! --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------! -----------------------------------------------+-----------+--! --------+---------+-----------+---------+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------! ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------! -----------------------------------------------------------------------! ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------! ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------! -----------------------------------------------------------------------! -------------------------------------------------------------------------------------------------------+ | 2 | 2 | NULL | NULL | BK | 0020583516 : | NULL | NULL | Simon & Schuster, | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2009-01-01 18:11:11 | ill. ; | 286 p. : | NULL | 24 cm. | New York : | 93048099 | 01435cam a2200301 a 4500001000800000005001700008008004100025010001700066020003900083040001800122050002400140082001800164100002800182245011900210260004200329300002900371500002300400504006200423650002900485856009600514856008800610856009000698856007900788906004500867942001200912955020000924999000901124 2053267 20060725220304.0 931217s1995 nyua b 001 0 eng a 93048099 a0020583516 : c$15.00 ($20.00 Can.) aDLC cDLC dDLC 00 aRA781.68 b.B57 1995 00 a613.7/046 220 1 aBirch, Beryl Bender. 95 10 aPower yoga : bthe total strength and flexibility workout / cBeryl Bender Birch ; photographs by Nicholas DeSciose. aNew York : bSi! mon & Schuster, cc1995. a286 p. : bill. ; c24 cm. a"A Fireside book." aIncludes bibliographical references (p. [275]) and index. 0 aAṣṭāṅga yoga. 96 42 3Contributor biographical information uhttp://www.loc.gov/catdir/bios/simon051/93048099.html 42 3Publisher description uhttp://www.loc.gov/catdir/description/simon032/93048099.html 41 3Table of contents only uhttp://www.loc.gov/catdir/enhancements/fy0631/93048099-t.html 41 3Sample text uhttp://www.loc.gov/catdir/enhancements/fy0641/93048099-s.html a7 bcbc corignew d1 eocip f19 gy-gencatlg 2ddc cBK apc01 to SA00 12-17-93; sh07 12-20-93; sh07 to jc00 12-20-93; jc06 to CPSO 12-23-93; jc12 01-04-94; recvd in D̀DC 01-06-94, aa07 01-07-94; CIP ver. pv08 01-03-95; entry reclassified jc03 07-25-95 c2 d2 | http://www.loc.gov/catdir/bios/simon051/93048099.html | http://www.loc.gov/catdir/description/simon032/93048099.html | http://www.loc.gov/catdir/enhancements/fy0631/93048099-t.html | http://www.loc.! gov/catdir/enhancements/fy0641/93048099-s.html | ddc | N! ULL | NULL | NULL | | NULL | <?xml version="1.0" encoding="UTF-8"?> <record xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.loc.gov/MARC21/slim http://www.loc.gov/ standards/marcxml/schema/MARC21slim.xsd" xmlns="http://www.loc.gov/MARC21/slim"> <leader>01435cam a2200301 a 4500</leader> <controlfield tag="001">2053267</controlfield> <controlfield tag="005">20060725220304.0</controlfield> <controlfield tag="008">931217s1995 nyua b 001 0 eng </controlfield> <datafield tag="010" ind1=" " ind2=" "> <subfield code="a"> 93048099 </subfield> </datafield> <datafield tag="020" ind1=" " ind2=" "> <subfield code="a">0020583516 :</subfield> <subfield code="c">$15.00 ($20.00 Can.)</subfield> </datafield> <datafield tag="040" ind1=" " ind2=" "> <subfield code="a">DLC</subfield> <subfield code="c">DLC</subfield> <subfield code="d">DLC</subfield> </datafield> <datafield tag="050" ind1="0" ind2="0"> <subfield code="a">RA781.68</subfield> <subfield code="b">.B57 1995</subfield> </datafield> <datafield tag="082" ind1="0" ind2="0"> <subfield code="a">613.7/046</subfield> <subfield code="2">20</subfield> </datafield> <datafield tag="100" ind1="1" ind2=" "> <subfield code="a">Birch, Beryl Bender.</subfield> <subfield code="9">5</subfield> </datafield> <datafield tag="245" ind1="1" ind2="0"> <subfield code="a">Power yoga :</subfield> <subfield code="b">the total strength and flexibility workout /</subfield> <subfield code="c">Beryl Bender Birch ; photographs by Nicholas DeSciose.</subfield> </datafield> <datafield tag="260" ind1=" " ind2=" "> <subfield code="a">New York :</subfield> <subfield code="b">Simon & Schuster,</subfield> <subfield code="c">c1995.</subfield> </datafield> <datafield tag="300" ind1=" " ind2=" "> <subfield code="a">286 p. :</subfield> <subfield code="b">ill. ;</subfield> <subfield code="c">24 cm.</subfield> </datafield> <datafield tag="500" ind1=" " ind2=" "> <subfield code="a">"A Fireside book."</subfield> </datafield> <datafield tag="504" ind1=" " ind2=" "> <subfield code="a">Includes bibliographical references (p. [275]) and index.</subfield> </datafield> <datafield tag="650" ind1=" " ind2="0"> <subfield code="a">As?t?a?n?ga yoga.</subfield> <subfield code="9">6</subfield> </datafield> <datafield tag="856" ind1="4" ind2="2"> <subfield code="3">Contributor biographical information</subfield> <subfield code="u">http://www.loc.gov/catdir/bios/simon051/93048099.html</subfield> </datafield> <datafield tag="856" ind1="4" ind2="2"> <subfield code="3">Publisher description</subfield> <subfield code="u">http://www.loc.gov/catdir/description/simon032/93048099.html</subfield> </datafield> <datafield tag="856" ind1="4" ind2="1"> <subfield code="3">Table of contents only</subfield> <subfield code="u">http://www.loc.gov/catdir/enhancements/fy0631/93048099-t.html</subfield> </datafield> <datafield tag="856" ind1="4" ind2="1"> <subfield code="3">Sample text</subfield> <subfield code="u">http://www.loc.gov/catdir/enhancements/fy0641/93048099-s.html</subfield> </datafield> <datafield tag="906" ind1=" " ind2=" "> <subfield code="a">7</subfield> <subfield code="b">cbc</subfield> <subfield code="c">orignew</subfield> <subfield code="d">1</subfield> <subfield code="e">ocip</subfield> <subfield code="f">19</subfield> <subfield code="g">y-gencatlg</subfield> </datafield> <datafield tag="942" ind1=" " ind2=" "> <subfield code="2">ddc</subfield> <subfield code="c">BK</subfield> </datafield> <datafield tag="955" ind1=" " ind2=" "> <subfield code="a">pc01 to SA00 12-17-93; sh07 12-20-93; sh07 to jc00 12-20-93; jc06 to CPSO 12-23-93; jc12 01-04-94; recvd in D?DC 01-06-94, aa07 01-07-94; CIP ver. pv08 01-03-95; entry reclassified jc03 07-25-95</subfield> </datafield> <datafield tag="999" ind1=" " ind2=" "> <subfield code="c">2</subfield> <subfield code="d">2</subfield> </datafield> </record> | | 10 | 10 | NULL | NULL | BK | 0028610903 | NULL | NULL | Alpha Books, | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2009-01-01 21:20:36 | ill. ; | xvii, 301 p. : | NULL | 24 cm. | New York : | 96079348 | 01155cam a2200325 a 4500001000700000003000800007005001700015008004100032010001700073020001500090035002000105040002600125042001400151050002200165082001200187100003500199245008000234246004300314246002500357260003700382300003500419504006600454650002400520650002500544856008900569906004500658942001200703955010300715999001100818 694003 TxLlSwa 20070509115739.0 961025s1996 nyu b 001 0 eng d a 96079348 a0028610903 a(OCoLC)36210747 aMiPorPS cMiPorPS dDLC alccopycat 00 aTX147 b.L595 1996 00 a640 221 1 aLockwood, Georgene Muller. 931 14 aThe complete idiot's guide to organizing your life / cby Georgene Lockwood. 3 aIdiot! ʼs guide to organizing your life 3 aOrganizing your life aNew York : bAlpha Books, cc1996. axvii, 301 p. : bill. ; c24 cm. aIncludes bibliographical references (p. [285]-286) and index. 0 aHome economics. 932 0 aTime management. 933 42 3Publisher description uhttp://www.loc.gov/catdir/enhancements/fy0716/96079348-d.html a7 bcbc ccopycat d2 eopcn f19 gy-gencatlg 2ddc cBK apb21 01-16-97 to cat.; jf05 to subj. 03/05/97; jf04 to S.L. 03-06-97; sf00 03-05-97; je10 03-12-97 c10 d10 | http://www.loc.gov/catdir/enhancements/fy0716/96079348-d.html | ddc | NULL | NULL | NULL | | NULL | <?xml version="1.0" encoding="UTF-8"?> <record xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.loc.gov/MARC21/slim http://www.loc.gov/ standards/marcxml/schema/MARC21slim.xsd" xmlns="http://www.loc.gov/MARC21/slim"> <leader>01155cam a2200325 a 4500</leader> <controlfield tag="001">694003</controlfield> <controlfield tag="003">TxLlSwa</controlfield> <controlfield tag="005">20070509115739.0</controlfield> <controlfield tag="008">961025s1996 nyu b 001 0 eng d</controlfield> <datafield tag="010" ind1=" " ind2=" "> <subfield code="a"> 96079348 </subfield> </datafield> <datafield tag="020" ind1=" " ind2=" "> <subfield code="a">0028610903</subfield> </datafield> <datafield tag="035" ind1=" " ind2=" "> <subfield code="a">(OCoLC)36210747</subfield> </datafield> <datafield tag="040" ind1=" " ind2=" "> <subfield code="a">MiPorPS</subfield> <subfield code="c">MiPorPS</subfield> <subfield code="d">DLC</subfield> </datafield> <datafield tag="042" ind1=" " ind2=" "> <subfield code="a">lccopycat</subfield> </datafield> <datafield tag="050" ind1="0" ind2="0"> <subfield code="a">TX147</subfield> <subfield code="b">.L595 1996</subfield> </datafield> <datafield tag="082" ind1="0" ind2="0"> <subfield code="a">640</subfield> <subfield code="2">21</subfield> </datafield> <datafield tag="100" ind1="1" ind2=" "> <subfield code="a">Lockwood, Georgene Muller.</subfield> <subfield code="9">31</subfield> </datafield> <datafield tag="245" ind1="1" ind2="4"> <subfield code="a">The complete idiot's guide to organizing your life /</subfield> <subfield code="c">by Georgene Lockwood.</subfield> </datafield> <datafield tag="246" ind1="3" ind2=" "> <subfield code="a">Idiot?s guide to organizing your life</subfield> </datafield> <datafield tag="246" ind1="3" ind2=" "> <subfield code="a">Organizing your life</subfield> </datafield> <datafield tag="260" ind1=" " ind2=" "> <subfield code="a">New York :</subfield> <subfield code="b">Alpha Books,</subfield> <subfield code="c">c1996.</subfield> </datafield> <datafield tag="300" ind1=" " ind2=" "> <subfield code="a">xvii, 301 p. :</subfield> <subfield code="b">ill. ;</subfield> <subfield code="c">24 cm.</subfield> </datafield> <datafield tag="504" ind1=" " ind2=" "> <subfield code="a">Includes bibliographical references (p. [285]-286) and index.</subfield> </datafield> <datafield tag="650" ind1=" " ind2="0"> <subfield code="a">Home economics.</subfield> <subfield code="9">32</subfield> </datafield> <datafield tag="650" ind1=" " ind2="0"> <subfield code="a">Time management.</subfield> <subfield code="9">33</subfield> </datafield> <datafield tag="856" ind1="4" ind2="2"> <subfield code="3">Publisher description</subfield> <subfield code="u">http://www.loc.gov/catdir/enhancements/fy0716/96079348-d.html</subfield> </datafield> <datafield tag="906" ind1=" " ind2=" "> <subfield code="a">7</subfield> <subfield code="b">cbc</subfield> <subfield code="c">copycat</subfield> <subfield code="d">2</subfield> <subfield code="e">opcn</subfield> <subfield code="f">19</subfield> <subfield code="g">y-gencatlg</subfield> </datafield> <datafield tag="942" ind1=" " ind2=" "> <subfield code="2">ddc</subfield> <subfield code="c">BK</subfield> </datafield> <datafield tag="955" ind1=" " ind2=" "> <subfield code="a">pb21 01-16-97 to cat.; jf05 to subj. 03/05/97; jf04 to S.L. 03-06-97; sf00 03-05-97; je10 03-12-97</subfield> </datafield> <datafield tag="999" ind1=" " ind2=" "> <subfield code="c">10</subfield> <subfield code="d">10</subfield> </datafield> </record> | +------------------+--------------+--------+--------+----------+--------------+------+-----------------+-------------------+------------+------------+-----------------+----------------+------------------+------------------+-----------------------+---------------------+--------+----------------+-------+--------+------------+--------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------! --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------! -----------------------------------------------+-----------+--! --------+---------+-----------+---------+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------! ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------! -----------------------------------------------------------------------! ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------! ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------! -----------------------------------------------------------------------! -------------------------------------------------------------------------------------------------------+ 2 rows in set (0.00 sec) mysql> exit
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@swajime.com> SwaJime's Cove
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- John Wesley Simpson Hibbs <john@swajime.com> SwaJime's Cove
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
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@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@swajime.com> > SwaJime's Cove > > _______________________________________________ > Koha mailing list > Koha@lists.katipo.co.nz > http://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
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@swajime.com> SwaJime's Cove
participants (2)
-
Jesse Weaver -
John Wesley Simpson Hibbs