Re: [Koha] How to return from version 17.05 to 16.05

Hi Luis, did you use the database that was updated to 17.05 before or a backup database that was still 16.05? koha-upgrade-schema only works 'upwards', it won't be able to downgrade a database to the old structure. In 17.05 there was one major change in moving the marcxml from biblioitems

Re: [Koha] Koha giving frequent software errors

Hello Jonathan, Yes, error 2(connection error) occurs randomly when we work on Koha. There is no particular scenario in which it happens. We are using Koha 17.05. How can I differentiate between a warning and a bug? Regards, Gurpreet From: Jonathan Druart

Re: [Koha] Register can not be saved

Hi Luis, there is no error message? Can you check the koha-error-log or plack-error-log? Katrin On 09.08.2017 20:58, Luis Moises Rojas wrote: Sorry it is: EDIT RECORD. When you modify any things, and saved it: nothing change. On Wed, Aug 9, 2017 at 2:54 PM, Katrin

Re: [Koha] How are authority records connected with biblio records ?

Hi Dave, I think for migrations something like this would work: - Import your authorities. Koha will force 001 to match auth_header.authid. - Create a file with the auth_header.authid and your old authority number if there is one - Add $9 to your authority controlled fields in your MARC

Re: [Koha] How to return from version 17.05 to 16.05

Hello, Backup database was still 16.05. On Wed, Aug 9, 2017 at 11:37 AM, Katrin wrote: > Hi Luis, > > did you use the database that was updated to 17.05 before or a backup > database that was still 16.05? > > koha-upgrade-schema only works 'upwards', it won't be able

Re: [Koha] How to return from version 17.05 to 16.05

Now we are going to restore a new backup (two weeks ago) El 9 ago. 2017 11:39 AM, "Luis Moises Rojas" escribió: > Hello, > > Backup database was still 16.05. > > > On Wed, Aug 9, 2017 at 11:37 AM, Katrin wrote: > >> Hi Luis, >> >> did you use

Re: [Koha] How to return from version 17.05 to 16.05

Hello everybody, Everything was ok. We restore the database (of course, we were wrong, and we restore a 16.05 database) We are working again, after 4 days. Thanks to all On Wed, Aug 9, 2017 at 11:54 AM, Luis Moises Rojas wrote: > Now we are going to restore a new

[Koha] Register can not be saved

Hello everybody, If we call a book, and selected EDIT REGISTER, we changed some data (i.e, the title), when we saved it: NOTHING happen. Changes are not saved and without any error. Any idea? -- *Luis Moisés Rojas P.* ___ Koha mailing list

Re: [Koha] Unknown column 'metadata' in 'field list'

Dear Vimal, Please try with this query SELECT biblio.biblionumber, biblio.author, biblio.title, biblioitems.editionstatement, biblioitems.publishercode, SUBSTRING(biblioitems.marcxml, LOCATE('', biblioitems.marcxml, LOCATE('', biblioitems.marcxml, LOCATE('', biblioitems.marcxml,

Re: [Koha] Confusion over "item type"

Chris, You should look for the pref item-level_itypes and its documentation. Marcel Van: Koha namens Chris Brown Verzonden: woensdag 9 augustus 2017 13:12 Aan: koha@lists.katipo.co.nz Onderwerp:

[Koha] Confusion over "item type"

Hello, MARC records 942$c and 952$y both appear to specify an "item type". They appear to be mapped to koha fields biblio.itemtype and items.itype respectively. Please could someone explain to me the difference between them? In particular when I define a circulation rule for a specific item type,

Re: [Koha] Search for "see also" records shows NO RESULTS FOUND

Hi On 3 August 2017 I wrote: # # # After an update from Koha 3.20.4 we work on a new host with Debian GNU/Linux 8 and Koha 17.05.1. Our catalog contains authority records with "see also" records. For example the subject "Buchkultur" (MARC 150 $a) has a "see also" record

Re: [Koha] Reminder: Internet broadcast of Koha-US

Hi Christopher, I tried joining the meetings but couldn't connect. Are there any recordings of the events, and will they be made public at some point? Regards, Lennon Mazonde On 08/08/2017 21:57, Christopher Davis wrote: Dear Colleagues, I am excited about the Koha-US conference

Re: [Koha] How to handle the support providers list (was Re: Spam from BestBookBuddies (OpenLX))

Kia ora! I still hold the firm opinion that deleting the list is a cop out. The listing is one of the best ways that new Libraries find support if they are reluctant to do things themselves. Folks might want to think about linking Hea to this page so that people that are considering Koha

Re: [Koha] Koha giving frequent software errors

Hello Gurpreet, Answers inline: On Wed, 9 Aug 2017 at 11:26 ILOBWeb wrote: > Hello everyone, > > We are using Koha for our resource centre and we are getting frequent > software errors while working on it. Errors are like - > > Error 1 : > Software error: > > Wrong CSRF

Re: [Koha] How to handle the support providers list (was Re: Spam from BestBookBuddies (OpenLX))

Just to cross the topics, we already had this discussion earlier: https://lists.katipo.co.nz/public/koha/2015-July/043138.html "Proposal to remove the 'Paid support' list" On Wed, 9 Aug 2017 at 12:17 Mark Tompsett wrote: > Greetings, > > Nathan A. Curulla suggested: > >

Re: [Koha] Unknown column 'metadata' in 'field list'

Vimal, Koha 17.05 has been released with bug 17898. With it you should see a new "Update" column on the report list if you have reports using the biblioitems.marcxml columns. There is a "Update SQL" button, when clicked a script will update the query to use the new biblio_metadata column. This

Re: [Koha] Possibilities and Help in Translation

Hello, It depends on which version of Koha you are going to use, but I would suggest to translate the latest (17.05). Regards, Jonathan On Wed, 9 Aug 2017 at 10:14 Balaji Ravichandran wrote: > Hi Jonathan, > I have started Translating Koha to தமிழ்(Tamil) for the version

Re: [Koha] Register can not be saved

Probably you need to rebuild the zebra index. Is the indexer daemon enabled? On Aug 9, 2017 21:58, "Luis Moises Rojas" wrote: > Sorry it is: EDIT RECORD. > When you modify any things, and saved it: nothing change. > > On Wed, Aug 9, 2017 at 2:54 PM, Katrin

Re: [Koha] Koha giving frequent software errors

Hi, I forget to mention before that I got connection reset error when I clicked on Help. At that time, following message was logged in error logs file. [Wed Aug 09 14:05:20.165528 2017] [cgi:error] [pid 13318] [client 199.116.173.196:43345] AH01215: [Wed Aug 9

Re: [Koha] Patron Club feature

Hi Michael, The below link has a reference to using MariaDB. It says - Koha does not work well with MySQL 5.7 which is shipped with Ubuntu 16.04. use MariaDB instead. https://wiki.koha-community.org/wiki/Koha_on_Debian#MySQL.7CMariaDB I agree with your view in Bug 18962. Now I have the

Re: [Koha] Reminder: Internet broadcast of Koha-US

Lennon, Thank you for your message. Try again to connecting again- it should be working now. Cordially, Christopher Davis Systems & E-Services Librarian Uintah County Library cgda...@uintah.utah.gov (435) 789-0091 <14357890091> ext.261 uintahlibrary.org basinlibraries.org

Re: [Koha] How to handle the support providers list (was Re: Spam from BestBookBuddies (OpenLX))

* BWS Johnson (abesottedphoe...@yahoo.com) wrote: Kia ora! I still hold the firm opinion that deleting the list is a cop out. The listing is one of the best ways that new Libraries find support if they are reluctant to do things themselves. Folks might want to think about linking Hea to

Re: [Koha] Patron Club feature

Hi Krishna, I think this bug is the reason why the patron clubs didn't install properly: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19067 It's on his way into the next stable releases. For DBMS, see here:

Re: [Koha] Spam from BestBookBuddies (OpenLX)

Thanks Jonathan, for pointing out that link on lislinks.com - it was a un-intended mistake - not knowing that replying to different people would get consolidated on one page. I have now deleted them, and will take care of such things in future. My new request for registration can be the

Re: [Koha] Patron Club feature

Hi Krishna You wrote: The other open bugs in patron clubs feature all relate to using MySQL. Looks like the clubs feature will get installed properly only if MariaDB is used.Mark Alexander and Michael Kuhn, are you using MySQL ? Have you tried the clubs feature using Maria DB ? Yes, we

Re: [Koha] Register can not be saved

Hi Luis, there is no 'edit register' in the english version. Is this maybe a translation? Katrin On 09.08.2017 20:46, Luis Moises Rojas wrote: Hello everybody, If we call a book, and selected EDIT REGISTER, we changed some data (i.e, the title), when we saved it: NOTHING happen. Changes

Re: [Koha] Register can not be saved

Sorry it is: EDIT RECORD. When you modify any things, and saved it: nothing change. On Wed, Aug 9, 2017 at 2:54 PM, Katrin wrote: > Hi Luis, > > there is no 'edit register' in the english version. Is this maybe a > translation? > > Katrin > > > On 09.08.2017 20:46,

[Koha] Koha giving frequent software errors

Hello everyone, We are using Koha for our resource centre and we are getting frequent software errors while working on it. Errors are like - Error 1 : Software error: Wrong CSRF token at /usr/share/koha/intranet/cgi-bin/members/memberentry.pl line 291. For help, please send mail to the

Re: [Koha] How are authority records connected with biblio records ?

Hi David I originally tried the script link_bibs_to_authorities.pl but there were two issues with it: 1. After running for days it would use up all available memory and stop working In my case I used this script for a maximum of around 200'000 bibliographic records. I see in your

Re: [Koha] Possibilities and Help in Translation

Hi Jonathan, I have started Translating Koha to தமிழ்(Tamil) for the version 17.05. There is also a version of Koha 3.22 and many other versions. Can you please provide suggestions on how to select versions for translating? Some are marked as obsolete. Kindly help is selecting versions. On 3

[Koha] How to handle the support providers list (was Re: Spam from BestBookBuddies (OpenLX))

Greetings, Nathan A. Curulla suggested: > Maybe we should change the listing to “contributing support companies” or > something like that. While I think that is a good idea, and then companies without community participation get removed, the problem still remains: people don't read. We've put

Re: [Koha] Patron Club feature

Excerpts from Krishna K's message of 2017-07-30 06:02:15 +: > We recently upgraded to 17.05.01 from 16.11.05. When we try to use the > clubs feature by clicking on Tools-> Patron Clubs link, we are getting 404 > error. We dont seem to be having the clubs.pl file. What should we do ? >

Re: [Koha] How are authority records connected with biblio records ?

Hi , Thanks for your answer Chris. Is there some kind of plan / road map to get it working or should I just go ahead and try to fix it in a side branch of my own ? Is anyone coordinating the work for this ? Best Regards, Dave On 08/03/2017 10:42 PM, Chris Cormack wrote: * David

Re: [Koha] How to return from version 17.05 to 16.05

Hello, This is the error: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() [for Statement "SELECT biblioitemnumber, marcxml FROM biblioitems WHERE biblionumber=? " with ParamValues:

Re: [Koha] How are authority records connected with biblio records ?

Hi David I am migrating several million records from an existing vtls system to koha. We are using mariadb, koha 17.05 (have pulled from master yesterday ), elastic search 5.4 and plack on debian systems. As I wanted to preserve all the authority to biblio record links I wrote my own

Re: [Koha] Spam from BestBookBuddies (OpenLX)

Greetings all, I personally agree that work needs to be done on this list. Maybe we should change the listing to “contributing support companies” or something like that. If you want to get listed in the Koha Yellow Pages, pony up some time on bug testing, dev submittals etc.. Invest in the

Re: [Koha] Spam from BestBookBuddies (OpenLX)

> Maybe we should change the listing to “contributing support companies” or > something like that. I think that's an interesting idea, but the larger problem remains: There will always be contention around how the support companies list is made, no matter what. I think we've done pretty well

Re: [Koha] How to return from version 17.05 to 16.05

Hello, Finally we have reinstalled 16.05 We ran: sudo koha-upgrade-schema libraryname sudo koha-rebuild-zebra -v -f libraryname sudo koha-rebuild-zebra -a -f libraryname In sudo koha-upgrade-schema we have severals "Select" errors. When you try to find a BOOK it says: No found If we search an

Re: [Koha] Patron Club feature

Please check this bug I filed: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19067 Regards El mié., 9 ago. 2017 a las 12:13, Mark Alexander () escribió: > Excerpts from Krishna K's message of 2017-07-30 06:02:15 +: > > We recently upgraded to 17.05.01 from

Re: [Koha] How are authority records connected with biblio records ?

Hi Micheal, I originally tried the script link_bibs_to_authorities.pl but there were two issues with it: 1. After running for days it would use up all available memory and stop working 2. It does not preserve the links we have today between auths and biblios but does its best to connect