- Koha - lists.katipo.co.nz

Re: [Koha] error occurs when adding new biblio
by John Wesley Simpson Hibbs 05 Jan '09

05 Jan '09

On Sun, 2009-01-04 at 18:09 -0700, Jesse Weaver wrote: > > > > On Sun, Jan 4, 2009 at 5:26 PM, John Wesley Simpson Hibbs > <john(a)swajime.com> wrote: > > > 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(a)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(a)swajime.com> > > > SwaJime's Cove > > > > > > _______________________________________________ > > > Koha mailing list > > > Koha(a)lists.katipo.co.nz > > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > > -- > > John Wesley Simpson Hibbs <john(a)swajime.com> > > SwaJime's Cove > > > > _______________________________________________ > > Koha mailing list > > Koha(a)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(a)swajime.com> > SwaJime's Cove > > > So you have a bit of CDO (the letters should be in ALPHABETICAL ORDER, > dangit)? ;) > > Anyway, the SQL you need is: > > ALTER TABLE biblio SET AUTO_INCREMENT = 18 > > (after you delete the biblios after the jump) > > -- > Jesse Weaver > Software Developer, LibLime Jesse, Awesome, thank you, very much. :-D So, what I've done, for anybody else who might want to know: UPDATE biblio SET biblionumber = 21 where biblionumber = 24; UPDATE biblioitems SET biblioitemnumber = 21, biblionumber = 21 WHERE biblioitemnumber = 24 ; ALTER TABLE biblio AUTO_INCREMENT = 24; ALTER TABLE biblioitems AUTO_INCREMENT = 24; This worked perfectly (unless I've messed up something else that I don't know about yet). :-) So, if I might ask another question... I can do a search for say "guide", and get several books listed. It seems, though, that I cannot do a search for "*". How can I list all (24) of the books in the library? 24 down, ~1450 to go... -- John Wesley Simpson Hibbs <john(a)swajime.com> SwaJime's Cove

1 0

Questions on Koha 3.0
by Marie Wardall 05 Jan '09

05 Jan '09

I have a few questions that I hope someone can help me with. Sorry for all the questions and if the questions are duh questions. 1. Label Layouts (printing barcodes & Spine labels) unable to edit or create a new layout for barcodes—currently using the layouts that are there leaves us with title author information overlapping the barcode. How can I edit or create a new layout? I've followed the directions from the manual and have been able to do it in it an older version of Koha. 2. In Circulation when I have a patron up and I'm on the Checkout tab there are buttons across the top ie: Edit, Change Password, Add Child, Print, & More. I don't recall changing anything with these buttons but we are now missing the Print and the More buttons. Print allowed us to print a quick reminder for a student to take home with them about an overdue and the More button allowed us to set permissions for Patrons. If you know how to get those buttons back that would be great. 3. Along with the Print Button....When the page printed out before we had a replacement price listed on it along with the title, author, format, date due and status. We'd like to get replacement price to show up again when we get the Print and More buttons back. Does anyone know where we would do this? Thanks in advance for any help anyone can give us on these issues. Marie Marie J. Wardall Library Media Specialist Mountain Bay Elementary School 8602 Schofield Ave. Weston, WI 54476 mwardall(a)dce.k12.wi.us Phone: 715-355-0302 ext. 5824 Change Today, Change Tomorrow, Keep Changing

4 3

Weeding
by Sharon Moreland 05 Jan '09

05 Jan '09

Hello, We have been on Koha 3.0 for a few months now and our libraries need to weed items. When was the 'Withdraw' authorized value added to Koha and more to the point, what is the purpose of this button at /catalogue/moredetail.pl? We are interested in hearing best practices for weeding items and permanently deleting them from the catalog (in 3.0). Sharon Moreland NExpress Shared Catalog

2 1

koha
by vinod kumar 05 Jan '09

05 Jan '09

I have add in 100 books in admin page but opac page not serch the book

2 1

Marc Frameworks
by Marie Wardall 05 Jan '09

05 Jan '09

I'm working with the Marc Frameworks in Koha 3.0 and moving everything to the 0 Tab so that we don't have to click on each tab when cataloging. In doing so when I test the Marc Bilbiographic Framework I'm getting this error: Test: subfields not in same tabs Result: Not all subfields for the following tags are in the same tab (or marked 'ignored' Code: BKS Description: Books Tag: 600 Tabs in use: 0, 6 I am unable to catalog anything using either the Bks or default frameworks. Does anyone have any ideas or do I have to run something that I'm forgetting about or missing? Thanks in advance, Marie J. Wardall Library Media Specialist Mountain Bay Elementary School 8602 Schofield Ave. Weston, WI 54476 mwardall(a)dce.k12.wi.us Phone: 715-355-0302 ext. 5824 Change Today, Change Tomorrow, Keep Changing

2 1

Changing library name
by Jenny Scott-Thompson 05 Jan '09

05 Jan '09

Hi, Is there any way to change the name of your library on an existing install of Koha, or do I have to reinstall? I remember it being one of the things I had to type in when installing, but I can't find it in the admin settings now. Thanks, Jenny -- Jenny Scott-Thompson jhs46(a)cantab.net

2 1

OPAC display statuses
by Rachel Hollis 05 Jan '09

05 Jan '09

Greetings colleagues, using NOT_LOAN under Authorized Values for the library's reference materials, items display as not available, which makes sense. However other items not available display a status/reason for non-availability. How or where can I modify these reference materials such that they display a status/reason? Following is an example: 1. Dynamic HTML : the definitive reference Availability: No items available: 2. Good capitalism, bad capitalism, and the economics of growth and prosperity Availability: No items available: On order (1), 3. A farewell to alms : a brief economic history of the world Availability: No items available: Checked out (1), What do I need to do to have the first title display a reason as do the other titles? What we're working with: Koha version: 3.01.00.001 OS version: Linux library 2.6.18-6-686 #1 SMP Fri Jun 6 22:22:11 UTC 2008 i686 GNU/Linux Perl version: 5.008008 MySQL version: mysql Ver 14.12 Apache version: Server version: Apache/2.2.3 Zebra version: Zebra 2.0.32 Rachel Hollis, librarian Stevens-Henager College, Boise Idaho Campus ________________________________ This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited.

2 1

Holds
by Marie Wardall 05 Jan '09

05 Jan '09

I want to make sure I am understanding the Holds areas. We're running Koha 3.01.00.008 Holds Queue-Should all items that are on hold (reserve) show up here? Right now when I click on this it shows that no items are found even though I know there are materials on hold for patrons. Holds to Pull-Shows me the items students have put on hold/reserve that are available on the shelf and need to be pulled. Holds Awaiting Pickup- are things that we have checked in and confirmed to be on reserve for the patron and we have set aside so that we can notify the patron. TIA, Marie Marie J. Wardall Library Media Specialist Mountain Bay Elementary School 8602 Schofield Ave. Weston, WI 54476 mwardall(a)dce.k12.wi.us Phone: 715-355-0302 ext. 5824 Change Today, Change Tomorrow, Keep Changing

3 2

Re: [Koha] error occurs when adding new biblio
by John Wesley Simpson Hibbs 04 Jan '09

04 Jan '09

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(a)swajime.com> SwaJime's Cove

2 4

Re: [Koha] Over Due ( Fine ) Calculation problem
by thandu venkat narayana 03 Jan '09

03 Jan '09

Dear All, I am using koha 2.2.8 on windows-xp platform, How can I calculate the overdues? I made setup in Parameters - Issuing rules - Fines setup. But it is not working Regards Venkat Connect with friends all over the world. Get Yahoo! India Messenger at http://in.messenger.yahoo.com/?wm=n/

1 0