- Koha - lists.katipo.co.nz

Koha database recovery from crashed disk
by Mpore Nshuti Evelyne 05 Sep '18

05 Sep '18

My client's server hard disk crashed. They had not made any backups since the use of Koha ILS. So my option was to recover database from MySQL database files (copy from old to new installation). But the problem i am having is that on loading the staff client interface, the web installation restarts and after selecting defaults, i get a Software Error like this: DBIx::Class::Storage::DBI::_dbh_execute(): Table 'koha_library.search_field' doesn't exist at /usr/share/koha/lib/Koha/Objects.pm line 110. I really need help.

3 2

942 c - that alone should tell you all you need to know about this question
by Kelly Drake 04 Sep '18

04 Sep '18

Cataloging Gurus, What is the purpose of the 942 c? If we require all records to have an item record, and an item type in that record, what then is the purpose of the 942c? There are several places where it is noted that requiring the 942c is good practice, but I can't find anything on why. The Search Index section of the koha documentation lists: 942$c itemtype:w but I'm not sure what that means. Is the 942c included in an index? -- Kelly Drake HELM Project Manager kelly(a)flo.org | Conference calls: https://zoom.us/j/9606207016

2 2

Data Problem error
by Scott Owen 04 Sep '18

04 Sep '18

So one of my Koha boxes kicked this error up: _______________________________________________________________________ Data problems Some of your tables have problems with their auto_increment values which may lead to data loss. *You should not ignore this warning.* The problem is that InnoDB does not keep auto_increment across SQL server restarts (it is only set in memory). So on server startup the auto_increment values are set to max(table.id)+1. To know how to avoid this problem see the related wiki page: DBMS auto increment fix <https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix> Problems foundCheckouts The following ids exist in both tables *issues* and *old_issues*: 18862, 18863 _____________________________________________________________________ Is the link provided in the error message still current ?? Should I follow it ?? and/or ...is the error kicked by the two items 18862 and 18863 ??

1 0

Don't forget to vote for the KohaCon19 location!
by Caroline Cyr-La-Rose 04 Sep '18

04 Sep '18

Hello everyone! For those who haven't gotten around to it, don't forget to vote for the KohaCon19 location! To vote, go to http://kohacon19.inlibro.net The proposals are available on the wiki: https://wiki.koha-community.org/wiki/KohaCon19_Proposals A reminder of the rules for voting: * Everyone can vote * One vote per person * You must first register with your e-mail address (preferably your institutional e-mail) * You will receive an e-mail with the link to the survey * You must rank both options, with your first choice on top The vote is open until September 30, 2018, 23:59 UTC. The winner will be announced during the October General IRC meeting and also here on the mailing list. Again, on behalf of the whole community, I thank both groups for offering to host KohaCon19 and I wish them good luck! Caroline Cyr La Rose, MLIS Head of training and support, inLibro caroline.cyr-la-rose(a)inlibro.com

1 0

Announcing a new user feedback plugin for Koha ILS
by Indranil Das Gupta 04 Sep '18

04 Sep '18

Kia ora! The Koha OPAC is a rich environment that provides several facilities to its users. Many libraries around the world have built a complete digital presence (aka library portal) around it. Yet one feature that is missing natively in the Koha OPAC is an user feedback form. On the happy occasion of Janmasthami, I am pleased to inform you about release of a new Koha plugin - the AskALibrarian plugin that adds the ability to allows Koha's OPAC users to send a direct feedback to the library staff. The plugin is licensed under GNU GPL v3.0 (in simple English that means it is Free/Libre/Mukt Software) and is available for download from our GitHub repository here - https://github.com/l2c2technologies/koha-plugin-askalibrarian There is a blogpost on it at http://blog.l2c2.co.in/index.php/2018/09/01/askalibrarian-koha-feedback-for… And an explainer video at https://www.youtube.com/watch?v=j_IJ2unkvbs With regards, Indranil Das Gupta L2C2 Technologies Phone : +91-98300-20971 WWW : http://www.l2c2.co.in Blog : http://blog.l2c2.co.in IRC : indradg on irc://irc.freenode.net Twitter : indradg

3 2

Error: Invalid username or password after upgrade to 18.05
by Eugen Bastron 04 Sep '18

04 Sep '18

Dear colleagues, after upgrade from 17 to 18.05 I get error if I try to connect to Koha with the admin user. I have already tried to change the password in MySQL and then in koha-conf, but without result. With my admin user I can connect to the database over terminal. Maybe someone could help me resolve this error? Best regards, Eugen Bastron

2 2

ISBN display
by Rubén Fernández Asensio 04 Sep '18

04 Sep '18

Hello all, I understand that by MARC specifications the ISBN hyphens "may be system generated as display constants" and are not supposed to be carried in the MARC record: http://www.loc.gov/marc/bibliographic/bd020.html However all OPAC views show them without hyphens and I haven't found any system preference to switch them on. On the contrary, I found references to a patch to suppress them, at least in MARC view: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2592 What's the appropriate way to switch on hyphen display in Normal and ISBD views, if possible at all? I'm using Koha 18.05. Ruben

5 6

Re: [Koha] Encoding and Character Sets in Koha
by Narcis Garcia 03 Sep '18

03 Sep '18

I sent you a complete export of MARC framework. El 23/08/18 a les 15:07, Katrin Fischer ha escrit: > Hi Narcis, > > I am sorry, but that's not the MARC record. Please check if you have the > LDR/000 in your MARC framework. You can also copy the MARC from the MARC > view on the staff detail page (link below the bibliographic details). > > Katrin > > *Gesendet:* Donnerstag, 23. August 2018 um 13:06 Uhr > *Von:* "Narcis Garcia" <informatica(a)actiu.net> > *An:* "Katrin Fischer" <Katrin.Fischer.83(a)web.de> > *Betreff:* Re: Encoding and Character Sets in Koha > > We are using own framework derived from default one. > No tag added or removed to framework; only changed visibilities and > captions. > > SELECT * FROM koha_biblio.biblio WHERE biblionumber = 2; > +--------------+---------------+------------------+-------------------+----------+-------+--------+-------------+---------------+---------------------+-------------+----------+ > | biblionumber | frameworkcode | author | title | > unititle | notes | serial | seriestitle | copyrightdate | > timestamp | datecreated | abstract | > +--------------+---------------+------------------+-------------------+----------+-------+--------+-------------+---------------+---------------------+-------------+----------+ > | 2 | FIG | Hammet, Dashiell | El halcon Maltés | > NULL | NULL | 0 | NULL | NULL | 2018-06-19 > 11:43:59 | 2018-06-19 | NULL | > +--------------+---------------+------------------+-------------------+----------+-------+--------+-------------+---------------+---------------------+-------------+----------+ > > > > > El 23/08/18 a les 09:43, Katrin Fischer ha escrit: > > Hi, > > how did you catalog them? Did you use a standard or a modified > framework? Z39.50/SRU? Can you show us the MARC of your record? > > Hope this helps, > > Katrin > > *Gesendet:* Donnerstag, 23. August 2018 um 09:22 Uhr > *Von:* "Narcis Garcia" <informatica(a)actiu.net> > *An:* "Koha list" <koha(a)lists.katipo.co.nz> > *Betreff:* [Koha] Encoding and Character Sets in Koha > When cataloguing books with non-english characters, I see well saved > strings at database (from OS console), but Koha web interface is not > showing those unicode characters as expected. > > MariaDB works with character set utf8mb4 > Apache works with charset UTF-8 > All Koha database tables have collarion utf8_unicode_ci > Koha HTML output is UTF-8 encoded and includes Content-Type... > charset=utf-8 > > Using Koha 17.11.06-1 on Debian 9. > > I don't find Koha's system preferences about this. What can I review? > > Thanks. > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha >

4 14

Unsubscribe request
by Bourdon, Diane 01 Sep '18

01 Sep '18

Please remove my email address from your list. Thank you Diane Bourdon Resource Centre (Library) Technician St. Joseph-Scollard Hall Catholic Secondary School Nipissing-Parry Sound District Catholic School Board (NPSC) 675 O'Brien St. North Bay, ON, P1B 9R3 (705) 494-8600 ext. 3247 SJSH Library offers resources and information to satisfy the educational needs and interests of our students and staff. Its mission is to provide a comfortable and welcoming environment to foster lifelong learners, researchers, and critical thinkers; to promote the love of reading; and to stimulate student curiosity and innovation for the benefit of society.

3 3

Koha Community Newsletter: August 2018
by kohanews 01 Sep '18

01 Sep '18

The Koha Community Newsletter for August 2018 is here: https://koha-community.org/koha-community-newsletter-august-2018/ Many thanks to the folks who submitted articles and news to this month's newsletter. Please feel free to email me with any corrections or suggestions. -- Chad Roseburg Editor, Koha Community Newsletter

1 0