- Koha - lists.katipo.co.nz

missing circulation history (old_issues table lost 96% of records)
by Benjamin Anderson 09 May '19

09 May '19

Hi, About 4 months ago we upgraded from version 3.18.05.100 to 18.11.01.000. Just recently, our librarian let me know that the circulation history now only has the last month or so, whereas it used to have everything since the library began circulating books. She is convinced that this issue was not manifest after the initial upgrade, but only started a few weeks ago (some months after the upgrade). She doesn't know if it happened all at once or incrementally. Unfortunately, I only have db backups going back 2 days and by the time I was alerted to the problem, those backups also were missing the full old_issues set. I'm not familiar with the db schema, but in taking a look I noticed that the db snapshot from before the migration had 16,255 records: administrator@sjbs-library-server:~$ mysql -D koha_sjbs -u koha_sjbs -e "select count(*) from old_issues;" +----------+ | count(*) | +----------+ | 16255 | +----------+ meanwhile the current db only has 598 records. In googling, I came across the auto increment issue, but I'm pretty sure that's what I'm dealing with here. Questions: 1) Any idea how we lost all these records? Is there a configuration setting somewhere that would explain this? Or is something else going on? 2) Can I re-import the old_issues from the db snapshot I have with 16k rows into the current db? I understand this would take a little finessing because there isn't an id in the old schema and the auto increment is on the issues table (not old_issues). Assuming I got all of that worked out, is this a reasonable thing to do? 3) How do I keep more than 2 snapshots of db backups? I'd prefer to keep a month or so. Thanks, Ben

2 1

Regarding DBMS Auto increment fix
by Sambhunath Sahoo 09 May '19

09 May '19

Dear friends, *Is DBMS auto increment fix required for Koha 18.11.05 (Current version)? Yes/No* In Koha wiki site, it shows only for Koha 16.05, 16.11, and 17.05. There is nothing written for Koha 18.05 and Koha 18.11. Regards, Sambhunath Sahoo/सम्भुनाथ साहु Information Scientist, Central Library, Tezpur University, Tezpur-784028 Assam Mobile: 9085252152, 8895488636 Phone : 03712-27-3229 E-Mail : sambhumlis(a)gmail.com, sambhu(a)tezu.ernet.in *ORCID ID:* 0000-0001-9162-879X *Researcher ID:* K-4446-2018

4 3

Run opac and intranet on different domains
by Coehoorn, Joel 09 May '19

09 May '19

We're looking at running our opac at catalog.york.edu and our intranet at circulation.york.edu. Both addresses will resolve to the same server when we go live, and I already have the Apache virtual host configuration working internally. I even have http => https redirection working. What else do I need to do to configure Koha to support this? For example, the "Open in OPAC" links when browsing the catalog from the intranet need to know the other name; where would I set that? What else should I watch for? Joel Coehoorn Director of Information Technology 402.363.5603 *jcoehoorn(a)york.edu <jcoehoorn(a)york.edu>* *Please contact helpdesk(a)york.edu <helpdesk(a)york.edu> for technical assistance.* The mission of York College is to transform lives through Christ-centered education and to equip students for lifelong service to God, family, and society

4 3

Cant Check in an item
by Luisa Korodrau 09 May '19

09 May '19

I have just installed Koha 18.11. I checked out a book and while trying to check in the same item, the system prompted me the following: "the item has not been checked in due to a configuration issue in your system. You must ask an administrator to take a look at the about page and search for the data problems section". I need your help with this issue please. Thanks Luisa

2 1

Re: [Koha] Run opac and intranet on different domains
by Tim McMahon 08 May '19

08 May '19

I thought that was all that was needed, but it's been so long since I set ours up. There could be something I forgot. It's a good idea to send your replies to the group so people will know you haven't found your answer. (I sent this to you and the list) On 5/8/19 2:13 PM, Coehoorn, Joel wrote: > Yes, I've seen that. It's here as an example of one place to change. > Are there any others you know about? > > > > > Joel Coehoorn > Director of Information Technology > 402.363.5603 > *jcoehoorn(a)york.edu <mailto:jcoehoorn@york.edu>* > > > > > *Please contact helpdesk(a)york.edu <mailto:helpdesk@york.edu> for > technical assistance.* > > > The mission of York College is to transform lives through > Christ-centered education and to equip students for lifelong service > to God, family, and society > > > On Wed, May 8, 2019 at 2:12 PM Tim McMahon <tmcmahon(a)wlpl.org > <mailto:tmcmahon@wlpl.org>> wrote: > > Did you go to System Preferences, OPAC tab, OPACBaseURL and set > that to > https://catalog.york.edu? > > > On 5/8/19 1:33 PM, Coehoorn, Joel wrote: > > We're looking at running our opac at catalog.york.edu > <http://catalog.york.edu> and our intranet at > > circulation.york.edu <http://circulation.york.edu>. Both > addresses will resolve to the same server when > > we go live, and I already have the Apache virtual host configuration > > working internally. I even have http => https redirection working. > > > > What else do I need to do to configure Koha to support this? For > example, > > the "Open in OPAC" links when browsing the catalog from the > intranet need > > to know the other name; where would I set that? What else should > I watch > > for? > > > > Joel Coehoorn > > Director of Information Technology > > 402.363.5603 > > *jcoehoorn(a)york.edu <mailto:jcoehoorn@york.edu> > <jcoehoorn(a)york.edu <mailto:jcoehoorn@york.edu>>* > > > > *Please contact helpdesk(a)york.edu <mailto:helpdesk@york.edu> > <helpdesk(a)york.edu <mailto:helpdesk@york.edu>> for technical > > assistance.* > > > > > > The mission of York College is to transform lives through > > Christ-centered education and to equip students for lifelong > service to > > God, family, and society > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> > > https://lists.katipo.co.nz/mailman/listinfo/koha > > -- > Tim McMahon > Technical Service and Interlibrary Loan > West Liberty Public Library > > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> > https://lists.katipo.co.nz/mailman/listinfo/koha > -- Tim McMahon Technical Service and Interlibrary Loan West Liberty Public Library

1 0

Marc and Marcxml bilbioitems fields
by Coehoorn, Joel 08 May '19

08 May '19

Using the schema.koha-community.org site, I can see back in 16.05 the biblioitems table had fields for both *marc *and *marcxml *data. In 16.11 the *marc* field was removed, and only *marcxml *remained. In 17.05 and later, both fields are gone. Did these fields move somewhere else, or were they just deleted? We have some data (OCLC number) we'd like to use in a report, and we believe this data was only in the marc or marcxml field. There may be a place for the OCLC number in the database, but if so we believe we have mapped it improperly. We'd like to be able to get a report to export these numbers for our holdings. Joel Coehoorn Director of Information Technology 402.363.5603 *jcoehoorn(a)york.edu <jcoehoorn(a)york.edu>* *Please contact helpdesk(a)york.edu <helpdesk(a)york.edu> for technical assistance.* The mission of York College is to transform lives through Christ-centered education and to equip students for lifelong service to God, family, and society

2 2

koha-US general meeting: Wednesday, May 8th, 2019
by Jason Robb 06 May '19

06 May '19

Date: Wednesday, May 8th, 2019 Time: 10:30 AM - 11:30 AM CDT (time converter <https://www.timeanddate.com/worldclock/fixedtime.html?msg=koha-US+general+m…> ) Location: https://kslib.zoom.us/j/110290143 Agenda: *https://docs.google.com/document/d/1e5fN2lV3aqGD7iE9JBzV_M4MHzuKZ5Nmz0q4GrJIyIg/edit?usp=sharing <https://docs.google.com/document/d/1e5fN2lV3aqGD7iE9JBzV_M4MHzuKZ5Nmz0q4GrJ…>* This month, we'll have an update on the koha-US conference, continued discussion about working groups, and time to talk about bugs and issues with extra focus on 18.11. If you have specific topics for the agenda, please send them to secretary(a)koha-us.org Meetings are held via Zoom video conferencing. A microphone and webcam are recommended but not required. Zoom is available for Windows, Mac, and Linux on desktops and Android and iOS on mobile devices. For help getting started, visit: *https://support.zoom.us/hc/en-us/categories/200101697 <https://support.zoom.us/hc/en-us/categories/200101697>* These meetings are free and open to any and all. Jason Robb koha-US secretary

1 0

On shelf holds
by Chris Brown 06 May '19

06 May '19

Hello, I have a really dumb question: what is meant by an "on-shelf hold"? I take it to mean placing a hold on a book that is actually in the library rather than checked out to a patron. Is that right? Chris Brown

3 2

language code for Sanskrit in 008 field-SAN
by vikram zadgaonkar 06 May '19

06 May '19

Dear All, I have entered books data in Sanskrit Language but I am not getting option to search by Sanskrit language in Advanced search. has any one has solution for this? Vikram Zadgaonkar

3 2

Creation of separate OPAC for each library in Library group
by Habib Jaffri 05 May '19

05 May '19

Dear community members Kindly help us to develop the separate OPAC interface for each library in on library group *Syed Habib Akhter JaffriProject Coordinator / Principal Librarian* *Pakistan Scientific & Technological Information Centre (PASTIC)* *Quaid-Azam University Campus* *Islamabad* *Ph: 051-9248107* *Cell: 0333-6999542*

2 1