- Koha - lists.katipo.co.nz

Reset the password for superlibrarian ?
by Quỳnh Vũ Đỗ 18 May '20

18 May '20

Hello everyone, Thanks to useful advice provided by the list community, I was able to upgrade from Koha 3.18 to Koha 19.11.05 I could open the Staff login window. I am now faced with login in to Koha as administrator to perform some maintenance tasks. I managed to found how to get into a Koha shell and run the script /usr/share/koha/bin/devel/create_superlibrarian.pl With Usage: create_superlibrarian.pl --userid <userid> --password <password> --branchcode <branchcode> --categorycode <categorycode> --cardnumber <cardnumber> So I tried with values without any quotes, with double quotes and simple quotes to always face the same error: DBD::mysql::st execute failed: Duplicate entry 'BGH000001' for key 'cardnumber' [for Statement "INSERT INTO `borrowers` ( `borrowernumber`, `branchcode`, `cardnumber`, `categorycode`, `dateenrolled`, `dateexpiry`, `flags`, `password`, `privacy`, `surname`, `userid`) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" with ParamValues: 0=undef, 1='TLU', 2='BGH000001', 3='CB', 4='2020-05-16T14:29:34', 5='2021-05-16T14:29:34', 6='1', 7='!', 8=1, 9=undef, 10="2"] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1834. But as the superlibraian already exists, then I cannot insert an other one - so the duplicate entry. What I would need is a simple UPDATE statement to reset the password of the superlibrarian with userid thanglong with a "newpassword" Is it safe to enter the following command from a mysql shell USE koha_library; UPDATE `borrowers` SET `password` = PASSWORD("newpassord") WHERE `userid`="thanglong"; I eventually tried it, but still was not able to log in. Any hint on how to reset that password for the first row of the table boowers? Thanks for reading Quynh ================= M. Vũ Đỗ Quỳnh (Ph.D) Trường Đại học Thăng Long - Université de Thang Long - Thang Long University (Hanoi, Vietnam) Phó Hiệu Trưởng, phụ trách HTQT - Vice-recteur chargé de la coopération internationale - Vice-Rector in charge of International Cooperation Web: http://thanglong.edu.vn/

2 2

Staff login problems after upgrading from Koha 3.18 to 19.11
by Quỳnh Vũ Đỗ 18 May '20

18 May '20

Hello everyone, Our library has been using a Vietnamized version of Koha 3.18 since mid 2014, running on Ubuntu server 14.04 LTS. No upgrade of the system has been made since and the server had a hardware problem (mainboard) last February. In an attempt to restore the Koha 3.18 database (a dump sql file of 1.8 Gb), I installed Koha 19.11 on an Ubuntu 16.04.6 LTS Desktop with a LAMP stack. After consulting with the mailing list yesterday, I followed the steps that were indicated, i.e Drop the 19.11 koha_library database, recreate it empty and then import the Koha 3.18 database sql dump file. Then I went to the staff login page http://localhost:8080 where I was welcomed by the login window for the web installation. I followed all the steps with success although at the crucial one (starting upgrading from 3.18 to 19.11) I had a Server timeout after 10-15 minutes waiting. I repeated the start upgrade procedure and was met again with a server Timeout. Then I had to go to work. At my office, I used the Easykoha Live DVD to install Koha 16.05 along with Ubuntu 14.04 LTS on an experimental partition. I then followed the same procedure as described a bove to do an upgrade of our Koha 3.18 database towards Koha 16.05. This, because the structure between the two database versions did not seem too differ too much (only two more tables in the 16.05 version). The upgrade from 3.18 to 16.05 was not successful though and I had a full web page filled with the errors that were met. When I came back home, I had the nice surprise to see that the upgrade from 3.18 to 19.11 had succeeded as I was welcomed by this message: "Updating database structure: Everything went OK. Update Done" and a blue button telling "Continue to log in to Koha". After clicking the button, I had a display of "Software error" that said: DBIx::Class::Storage::DBI::_dbh_execute(): Unknown column 'me.anonymized' in 'field list' at /usr/share/koha/lib/Koha/Objects.pm line 93 The line 93 (in bold below) is part of a subroutine as follows: sub find { my ( $self, @pars ) = @_; my $object; unless (!@pars || none { defined($_) } @pars) { *my $result = $self->_resultset()->find(@pars);* if ($result) { $object = $self->object_class()->_new_from_dbic($result); } } return $object; } Any hints on how to solve this problem would be greatly appreciated. Thanks for your attention and help. Quynh ================= M. Vũ Đỗ Quỳnh (Ph.D) Trường Đại học Thăng Long - Université de Thang Long - Thang Long University (Hanoi, Vietnam) Phó Hiệu Trưởng, phụ trách HTQT - Vice-recteur chargé de la coopération internationale - Vice-Rector in charge of International Cooperation Web: http://thanglong.edu.vn/

3 7

Opac not searchable after upgrading database from Koha 3.18 to 19.11
by Quỳnh Vũ Đỗ 15 May '20

15 May '20

Hello everyone After upgrading a Koha database from version 3.18 to 19.11, I was not able to log in in the staff/administration of Koha as I obtained a "Software Error" message. However, I was able to get to the OPAC page (at http://localhost:8000/) but any search returned nothing. I checked with Phpmyadmin that the biblio table of koha_library was effectively filled with the data of the 3.18 database (which it was), but the search of strings that were present returned nothing. Does someone have encountered that problem and knows the solution? I am thinking of running in a terminal the command "koha-rebuild-zebra" but I prefer to listen to some sound advice first. Thanks for reading Quynh ================= M. Vũ Đỗ Quỳnh (Ph.D) Trường Đại học Thăng Long - Université de Thang Long - Thang Long University (Hanoi, Vietnam) Phó Hiệu Trưởng, phụ trách HTQT - Vice-recteur chargé de la coopération internationale - Vice-Rector in charge of International Cooperation Web: http://thanglong.edu.vn/

1 0

tiny bit of help needed with report
by Lisa Peel 15 May '20

15 May '20

Hello I apologise for the simplicity of this question but could really use some help. I want to use the Hourly report in the KOHA wiki for ‘Checkouts by Hour in Selected Date Range’ as below SELECT YEAR(statistics.datetime) AS Year, MONTH(statistics.datetime) AS Month, DAY(statistics.datetime) AS Day, HOUR(statistics.datetime) AS Hour, count(*) AS Checkouts FROM statistics WHERE statistics.datetime BETWEEN '2014-01-06 13:00:59' AND '2014-01-09 16:59:59' AND statistics.type = 'issue' GROUP BY Year, Month, Day, Hour However, I also need to add branch code as well so I can determine the number of checkouts by library but I am struggling to know what extra code to add? My knowledge of SQL is very, very limited and any help would be really appreciated Regards Lisa Mrs Lisa Peel Head of Learning Resources, SEG Services Swiss Education Group ________ Avenue des Alpes 62 CH-1820 Montreux, Switzerland Mobile: +41 (0)79 228 0151<tel://+41(0)792280151> Skype: biblio1897<skype://biblio1897> www.swisseducation.com<https://www.swisseducation.com/en/> Facebook<https://www.facebook.com/swisseducationgroup> | Instagram<https://www.instagram.com/swisseducationgroup/> | Linkedin<https://www.linkedin.com/company/seg-swiss-education-group> [http://signature.swisseducation.com/SEG2019.jpg]<https://www.swisseducation.com/en/> Confidentiality and Disclaimer: This message contains confidential information and is intended only for the individual named. Email messages are provided for informational purposes, therefore the sender does not accept liability for any errors or omissions in the contents of this message.

3 3

invalid marcxml
by tunix＠tuxflow.de 15 May '20

15 May '20

We have a problem with our MARCXML data in KOHA. The order of the fields must be changed for many records. The problem affects all records that are newly created or changed by us. All <datafield> elements must appear after the <controlfield> elements. So far the <datafield> element with the unique ID of the record (MARC field 999 $c) is placed before the <controlfield> elements. The wrong order violates the MARCXML guidelines. before editing: <leader>00996xxx x22002417x 4200</leader> <controlfield tag="001">23330</controlfield> <controlfield tag="003">DE-1278</controlfield> <controlfield tag="007">t|</controlfield> <controlfield tag="008">161220s2002 xxu||||| |||| 00| 0 ger d</controlfield> <datafield tag="020" ind1=" " ind2=" "> <subfield code="a">3-89012-956-0</subfield> <subfield code="c">51,00 </subfield> </datafield> after editing: <leader>01059xxx x2200265x 4200</leader> <datafield tag="999" ind1=" " ind2=" "> <subfield code="c">9911</subfield> <subfield code="d">9911</subfield> </datafield> <controlfield tag="001">23330</controlfield> <controlfield tag="003">DE-1278</controlfield> <controlfield tag="005">20190604142304.0</controlfield> <controlfield tag="007">t|</controlfield> <controlfield tag="008">161220s2002 xxu||||| |||| 00| 0 ger d</controlfield> <datafield tag="020" ind1=" " ind2=" "> <subfield code="a">3-89012-956-0</subfield> <subfield code="c">51,00 </subfield> </datafield>

5 6

Migrating Koha database from version 3.18 to 19.11?
by Quỳnh Vũ Đỗ 14 May '20

14 May '20

Hello everyone Our library has been using a Vietnamized version of Koha 3.18 since mid 2014, running on Ubuntu server 14.04 LTS. No upgrade of the system has been made since and the server had a hardware problem (mainboard) last February. We have a mysqldump of the Koha database (size about 1,8 GB). So what we are trying to do is to install the latest Koha version (19.11) on a fresh Ubuntu 16.04.6 LTS (Desktop) and then to replenish the empty Koha tables through SQL inserts in the tables using sql exports of the related fields from the old database. For that we have been comparing the structure of the tables of Koha 3.18 and 19.11 with the tool provided at http://schema.koha-community.org/ Can this way of proceeding, although tedious it might be, be successful or not ? If not, could someone have suggestions ? Thanks for your attention. Quynh ================= M. Vũ Đỗ Quỳnh (Ph.D) Trường Đại học Thăng Long - Université de Thang Long - Thang Long University (Hanoi, Vietnam) Phó Hiệu Trưởng, phụ trách HTQT - Vice-recteur chargé de la coopération internationale - Vice-Rector in charge of International Cooperation Web: http://thanglong.edu.vn/

5 4

Call for news: April 2020 Koha Newsletter
by Koha Newsletter 14 May '20

14 May '20

I'm collecting news for the April newsletter. Send anything noteworthy to: k o h a news AT gmail dot com News criteria: --------------------------- ** For events **: - Please include dates for past events. If I can't find dates I may not add it. - Announcements for future events with dates T.B.A. are fine ...Eg., Kohacon - For past events , **** one month back is the cut-off ****. * News items can be of any length. * Images are fine * Anything and everything Koha. * Submit by the 26th of the month. If you are working on an interesting project or development related to Koha, please let me know and I'll include it in the development section. Thank you! -- Chad Roseburg Editor, Koha Community Newsletter

1 0

Koha-US Call for Presentation Proposals
by Lisette Scheer 13 May '20

13 May '20

Hello, Koha-US would like to invite you to propose a presentation for our annual conference, held in September 2020. Proposals will be due the 31st of May 2020. The conference will take place Tuesday, September 22nd to Friday, September 25th, 2020 in McKinney, TX. We are planning on making a decision about if this conference will be held in person or online by July 17th, 2020. Please make sure your presentation could be delivered exclusively online if needed. You can fill out the form here. <https://docs.google.com/forms/d/e/1FAIpQLScP-D-n0CLxgPNeGX6947h7E9e9VEVN4cp…> Our theme for the 2020 conference will be: Fresh Perspectives Please e-mail info(a)koha-us.org if you have any questions. Lisette Scheer Koha-US 2020 President

1 0

Maintenance Branches - String Freeze
by Joy Nelson 13 May '20

13 May '20

Hello all! String Freeze will go into effect on Friday, May 15, 2020 for the 19.11, 19.05, 18.11 branches. Monthly releases for those branches will be out on Friday, May 22, 2020. Thank you! -- Joy Nelson President, Koha Division ByWater Solutions <http://bywatersolutions.com> Support and Consulting for Open Source Software Phone/Fax (888)900-8944 What is Koha? <http://bywatersolutions.com/what-is-koha/>

1 0

Kohacon2020 will go ahead - online and in person
by Kathryn Tyree 13 May '20

13 May '20

Kia ora koutou katoa, I hope you are all safe and well, wherever you are. The Kohacon team at Catalyst are excited to announce the following decision: we will go ahead with Kohacon2020. Kohacon2020 will be a hybrid online and in-person event, appropriate to the New Zealand and global rules on travel at the time. Following the success of the online Kohathon event, we realised that Koha storytelling, teaching, learning, planning and coding can happen, whether we are together online or in person. We already know that this is a strength of our project. Conference programme: - As much as possible, it will stay the same: https://2020.kohacon.org/posts/programme/ - We are thinking about live streamed presentations, streamed library tours and social events, workshops delivered using an online training platform, and we already have collaboration tools for us to work together on Koha - we'll just make sure everyone knows how to participate. Information for conference attendees: - If you would like to register as an online-only participant, you will hear more soon about how to register. We are very excited that the online element of the conference will make it accessible to more people. - We will keep in touch about NZ travel restrictions, to help you decide whether to plan attending in person. Booking travel is not recommended by us at this stage. We still plan to make a decision in July about how we will proceed "in person" so travel may be booked if possible. Information for conference speakers: - Speakers, please could you email kohacon2020(a)catalyst.net.nz to say whether or not you willing to speak at the conference, if your presentation will be delivered online-only. - Please also provide your speaker bio (information about yourself) if you haven't already . We will be in touch again with further details for speakers. Thank you all for supporting the conference so far. We will be in touch again soon. Extra special thanks to our conference sponsors: Bywater Solutions, EBSCO, PTFS-Europe and Catalyst. Best wishes, Kathryn, on behalf of the Kohacon team -- Kathryn Tyree Koha Services Manager Catalyst IT DDI: +64 4 803 2414 Tel: +64 4 499 2267 www.catalyst.net.nz CONFIDENTIALITY NOTICE: This email is intended for the named recipients only. It may contain privileged, confidential or copyright information. If you are not the named recipient, any use, reliance upon, disclosure or copying of this email or its attachments is unauthorised. If you have received this email in error, please reply via email or call +64 4 499 2267.

1 0