<br><br><div class="gmail_quote">On Sun, Jan 4, 2009 at 12:08 PM, John Wesley Simpson Hibbs <span dir="ltr"><<a href="mailto:john@swajime.com">john@swajime.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
I've manually deleted the inaccessible records from the koha sql database, and moved newer records #18 - #21 into their place.<br>
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.<br>
The last record in the database is now #17, and yet when I add a record it is assigned #22.<br>
How can I fix this?<br>
<br>
<font color="#000000"># mysql -Dkoha -ukohaasuper -pkoha4mylibrary -e "select biblionumber,isbn from biblioitems"</font><br>
<font color="#000000"> </font><br>
<font color="#000000">+--------------+----------------+</font><br>
<font color="#000000">| biblionumber | isbn |</font><br>
<font color="#000000">+--------------+----------------+</font><br>
<font color="#000000">| 1 | NULL |</font><br>
<font color="#000000">| 2 | 003071592X (pb |</font><br>
<font color="#000000">| 3 | 003069549X : |</font><br>
<font color="#000000">| 4 | 002093081X : |</font><br>
<font color="#000000">| 5 | 0030536111 | 0 |</font><br>
<font color="#000000">| 6 | 0025349201 |</font><br>
<font color="#000000">| 7 | 0025907859 : |</font><br>
<font color="#000000">| 8 | 0026019604 |</font><br>
<font color="#000000">| 9 | 0028610873 |</font><br>
<font color="#000000">| 10 | 002870763X |</font><br>
<font color="#000000">| 11 | 0028619811 |</font><br>
<font color="#000000">| 12 | 002862114X (pb |</font><br>
<font color="#000000">| 13 | 0028627288 |</font><br>
<font color="#000000">| 14 | 0028627423 |</font><br>
<font color="#000000">| 15 | 0028633822 |</font><br>
<font color="#000000">| 16 | 0028639235 |</font><br>
<font color="#000000">| 17 | 002864171X |</font><br>
<font color="#000000">| 22 | 0060158719 : |</font><br>
<font color="#000000">| 23 | 006016848X (cl |</font><br>
<font color="#000000">+--------------+----------------+</font><div><div></div><div class="Wj3C7c"><br>
<br>
On Thu, 2009-01-01 at 21:45 -0600, John Wesley Simpson Hibbs wrote:<br>
</div></div><blockquote type="CITE"><div><div></div><div class="Wj3C7c">
Has anybody found a solution to <a href="http://lists.katipo.co.nz/public/koha/2008-December/016248.html" target="_blank">http://lists.katipo.co.nz/public/koha/2008-December/016248.html</a> ?<br>
<br>
I'm getting exactly the same error:<br>
<br>
<b><font size="6">Koha error</font></b><br>
The following fatal error has occurred:<br>
<br>
<pre>Can't call method "fields" on an undefined value at /usr/share/koha/lib/C4/Biblio.pm line 1642.
</pre>
<table>
<tbody><tr>
<th align="center">
<div align="center"><b>Apache</b></div>
</th>
<td>
Server version: Apache/2.2.8 (Ubuntu) Server built: Jun 25 2008 13:54:13
</td>
</tr>
<tr>
<th align="center">
<div align="center"><b>Koha</b></div>
</th>
<td>
3.00.00.107
</td>
</tr>
<tr>
<th align="center">
<b>Koha DB</b>
</th>
<td>
3.0000107
</td>
</tr>
<tr>
<th align="center">
<b>MySQL</b>
</th>
<td>
mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline 5.2
</td>
</tr>
<tr>
<th align="center">
<b>OS</b>
</th>
<td>
Linux lamentations 2.6.24-22-generic #1 SMP Mon Nov 24 18:32:42 UTC 2008 i686 GNU/Linux
</td>
</tr>
<tr>
<th align="center">
<div align="center"><b>Perl</b></div>
</th>
<td>
5.008008
</td>
</tr>
</tbody></table>
<br>
I don't think I'm the only one experiencing this problem...<br>
This google search comes up with 112 hits:<br>
<a href="http://www.google.com/search?q=koha+%22Can%27t+call+method+fields+on+an+undefined+value%22+%22line+1642%22" target="_blank">http://www.google.com/search?q=koha+%22Can%27t+call+method+fields+on+an+undefined+value%22+%22line+1642%22</a><br>
<br>
<table cellpadding="0" cellspacing="0" width="100%">
<tbody><tr>
<td>
-- <br>
John Wesley Simpson Hibbs <<a href="mailto:john@swajime.com" target="_blank">john@swajime.com</a>><br>
SwaJime's Cove
</td>
</tr>
</tbody></table>
</div></div><pre>_______________________________________________
Koha mailing list
<a href="mailto:Koha@lists.katipo.co.nz" target="_blank">Koha@lists.katipo.co.nz</a>
<a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a>
</pre>
</blockquote><div class="Ih2E3d">
<br>
<table cellpadding="0" cellspacing="0" width="100%">
<tbody><tr>
<td>
-- <br>
John Wesley Simpson Hibbs <<a href="mailto:john@swajime.com" target="_blank">john@swajime.com</a>><br>
SwaJime's Cove
</td>
</tr>
</tbody></table>
</div></div>
<br>_______________________________________________<br>
Koha mailing list<br>
<a href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br>
<a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
<br></blockquote></div><br>(In reference to your numbering problem)<br><br>This is part of MySQL's design, and is not something Koha has control over, though it shouldn't cause you any problems.<br><br>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.<br clear="all">
<br>-- <br>Jesse Weaver<br>Software Developer, LibLime<br>