[Koha] Koha login error

Dear sri, koha when logging in the following error is coming what should be done to fix this. n error has occurred!*Error 500*This message may have been caused by any of the following reasons: - You made use of an external link to an item that is no longer available - You followed an

Re: [Koha] SQL report for URL

Visit item type wise collection SQL report https://libpowertech.blogspot.com/2019/05/department-wise-number-of-books-in-your.html?m=1 On Thu, 20 Jul 2023, 2:32 pm Dr. Prajeesh Bhaskaran, wrote: > Hi > Please, can anyone help me to create a SQL report for getting the URL of > all the items based

Re: [Koha] hourly fines not calculating

Fine and rules/"overdue fines Cap", enter your maximum penalty calculation amount and replace 0. For example, change 0 to 6000, which is the maximum penalty amount to calculate. On Wed, 5 Jul 2023, 1:28 am Hector Gonzalez Jaime, wrote: > Tom, you should check your circulation rules, and verify

Re: [Koha] updating database Structure Error

Glad to hear it! Thank u. On Wed, 21 Jun 2023, 1:14 pm Mr. Sitali C. S., wrote: > Thanks a lot. It has worked like a charm. After adding the lines all I > needed to do was to restart. > Thank a lot for pointing me in the right direction. Much appreciated > > On Wed, 21 Jun 2023 a

Re: [Koha] updating database Structure Error

Hi! I added the lines: __ENCRYPTION_KEY__ The update went through without a problem. https://github.com/Koha-Community/Koha/blob/master/etc/koha-conf.xml Good Luck! On Wed, 21 Jun 2023, 1:04 am Mr. Sitali C. S., wrote: > Greetings, > > I need help with the following error; > >-

Re: [Koha] Local covers and the Coverflow plugin

Copy and paste the above SQL code. Save the report follow error, *The following error was encountered:* The database returned the following error: Table 'koha_library.biblioimages' doesn't exist Please check the log for further details. On Tue, 20 Jun 2023, 1:09 pm libr...@ssst.edu.ba, wrote: >

Re: [Koha] Koha upgrade 22.11.6 to 23.5.00 upgrade-schema error

It working, Thanks you Jonathan and all supports . On Wed, 7 Jun 2023, 12:48 pm Jonathan Druart, < jonathan.dru...@bugs.koha-community.org> wrote: > Hey, put a proper key there! Not "__ENCRYPTION_KEY__"! > It can be generated using the following command `pwgen 32` > > Le mer. 7 juin 2023 à

[Koha] Koha upgrade 22.11.6 to 23.5.00 upgrade-schema error

Hi All Just upgraded tonight from Koha 212.11.06.000 to 23.05.00 That all went fine. The About Koha page now says: "Warning: - Upgrade to 22.12.00.041 [09:43:21]: Bug 30649 - Increase the vendor EDI account password field to 256 characters ERROR: Exception

Re: [Koha] Koha Fines script not running.

Hi all jobs should always be run as your koha user. You can use 'sudo koha-shell instance' to switch to that user and then try to run the job again. Some other things to make sure of: system preference finesmode is set to "Calculate and charge" today is not a holiday in the calendar of the

Re: [Koha] Koha 23.05 released

Super !!!  to the entire Koha Team! On Thu, 1 Jun 2023, 2:14 am Kelly McElligott, wrote: > Yahoo!!! Congrats to the entire Koha Team! > > > Kelly McElligott, MLIS > (she/her) > Library Accounts Coordinator > ByWater Solutions > Koha

Re: [Koha] Koha 22.11.5v Fine amount did not Calculate

lendar of the library >- the maxfine setting in circulation rules is > 0 > > Hope this helps, > > Katrin > On 30.05.23 10:32, MASTeR Library wrote: > > Katrin Fischer sir, > I have Enclosed fines.pl error Screen link. > https://i.ibb.co/K2Qzy83/fines-error.

Re: [Koha] Koha 22.11.5v Fine amount did not Calculate

Katrin Fischer sir, I have Enclosed fines.pl error Screen link. https://i.ibb.co/K2Qzy83/fines-error.png On Tue, May 30, 2023 at 12:39 PM MASTeR Library wrote: > Katrin Fischer > Thank you for your reply, > I have run the fines.pl, following error? > Use of uninitialized value

Re: [Koha] Koha 22.11.5v Fine amount did not Calculate

pl, is there any error? > > Fines not calculating can have a lot of reasons. Are you using a > CurrencyFormat other than US? > > Hope this helps, > > Katrin > > On 20.05.23 15:25, MASTeR Library wrote: > > Hi, friends using koha 22.11.5 version please reply to me wit

Re: [Koha] Koha 22.11.5v Fine amount did not Calculate

Hi, friends using koha 22.11.5 version please reply to me with the above question. On Sat, May 20, 2023 at 10:39 AM MASTeR Library wrote: > Hi Koha Community Members, > I just updated my Koha from 22.11.3 to 22.11.5 when I upgraded the server > from Ubuntu MATE 22.11. patrons' acc

[Koha] Koha 22.11.5v Fine amount did not Calculate

Hi Koha Community Members, I just updated my Koha from 22.11.3 to 22.11.5 when I upgraded the server from Ubuntu MATE 22.11. patrons' account book overdrive fine is not calculated, only the date shown on the red colour fine amount is not displayed. I try to manually fine script commands. cd

Re: [Koha] Koha v 22.11.5 top quick search menu options not working.

Thank you so much Katrin Fischer sir, I have removed the entries in the "IntranetUserJs" system preference. my problems are solved and working well. On Mon, May 8, 2023 at 12:14 PM MASTeR Library wrote: > Thank you for your reply. > Yes, there are entries in IntranetUserJs s

Re: [Koha] Koha v 22.11.5 top quick search menu options not working.

he developer > tools in your browser. > > Are there any entries in IntranetUserJs system preference? > > Hope this helps, > > Katrin > > On 06.05.23 07:18, MASTeR Library wrote: > > Hi Koha Community Members, > > If I click on the quick menu options in Koha

Re: [Koha] Koha v 22.11.5 top quick search menu options not working.

3 at 10:48 AM MASTeR Library wrote: > Hi Koha Community Members, > If I click on the quick menu options in Koha 22.11.5, the options do not > change, for example, check-in, renew, search patrons, search the catalogue, > etc., if I click the Check-in option, but the search box does

[Koha] Koha v 22.11.5 top quick search menu options not working.

Hi Koha Community Members, If I click on the quick menu options in Koha 22.11.5, the options do not change, for example, check-in, renew, search patrons, search the catalogue, etc., if I click the Check-in option, but the search box does not change the above options. I have enclosed the screenshot

Re: [Koha] How To Add OCLC in Koha Z39.50 Server.

Dear Michael Kuhn Sir, Dear, I changed the settings as you said but it says book search result not found. I have attached the modified Z30.50 screenshot link below please reply. Z30.50 Screenshot link: https://i.ibb.co/vwrx0rZ/Z39-50-Server.png Book Search Result:

Re: [Koha] How To Add OCLC in Koha Z39.50 Server.

I Successfully Configuration to Z39.50 but the catalogue title search result "Connection failed to zcat.oclc.org" Z39.50 Server Configuration Details Link Enclosed Please check and reply to me. https://i.ibb.co/CWxwZ56/Screenshot-2023-05-05-16-06-01.png On Fri, May 5, 2023 at 3:54 PM Michael

[Koha] How To Add OCLC in Koha Z39.50 Server.

Hi Koha Community Members, How to Add OCLC WORLD Catalogue in Koha Z39.50 Server. http://classify.oclc.org/classify2/ -- Thanking you. Librarian, MAMCET Trichy-Chennai Trunk Road, Siruganur, Tiruchirappalli-621 105. ___ Koha

[Koha] How to get sql report on patron additional attributes.

Dear Team, how to get the sql report on Patron additional attributes for example Department, Student Roll number, blood group and etc? Sample SQL Code. SELECT ROW_NUMBER() OVER (ORDER BY LPAD(borrowers.cardnumber,100,' ') ASC) AS 'S.No', borrowers.cardnumber AS "Lib Membership

[Koha] Koha 22.05 OPAC Autocomplete Search Feature not working.

Dear Team, The autocomplete search function in the Koha OPAC search box is not working in Wikipedia Java Code, The Koha 22.05 latest version, please provide any suggestions. Reference. https://libpowertech.blogspot.com/2021/03/how-to-adding-to-opac-autocomplete.html

Re: [Koha] Modify Patron Transaction Invoices and Fee Receipts

Account payment invoice https://libpowertech.blogspot.com/2022/03/how-to-create-email-receipt-template.html?m=1 On Wed, 1 Mar 2023, 11:26 am Ms. Naveen Ali, wrote: > Hi Caroline, > > Thanks a lot for the information. > > I was looking for them in Tools->Notices and slips but was not able to map

Re: [Koha] Upgrade from - 17.11.02

Koha Upgrade the old stable version. https://libpowertech.blogspot.com/2019/11/how-to-upgrade-koha.html https://wiki.koha-community.org/wiki/Koha_on_Debian On Mon, Feb 13, 2023 at 1:21 PM Laxmi Lal Menaria wrote: > Good Morning All! > > We have installed koha - 17.11.02, and would like to

Re: [Koha] Fine calculation on over dues books

Visit the Link: https://libpowertech.blogspot.com/2019/08/koha-not-calculating-in-fine-amount.html On Wed, Jan 18, 2023 at 2:57 AM Katrin Fischer wrote: > Hi, > > please make sure that your fines.pl cronjob is set up correctly and > running. If you don't have server access, you can activate the

Re: [Koha] KOHA not getting install old or new version

koha install latest stable version https://libpowertech.blogspot.com/2021/03/how-to-install-koha-on-ubuntu-mate-2004.html On Tue, Nov 8, 2022 at 12:43 PM Laxmi Lal Menaria wrote: > Look these basic cleanup steps too here > >

Re: [Koha] OPAC CUSTOMIZATION ON KOHA 21.11.12

OPAC customisation visit https://youtu.be/SPVIW3y86J4 On Tue, 25 Oct 2022, 2:17 am Katrin Fischer, wrote: > Hi Murphy, > > in 21.11 the news and HTML/OPAC customizations are different tools. Go > to Tools > HTML customizations. > > Hope this helps, > > Katrin > > On 24.10.22 16:28, Igbudu

Re: [Koha] Error in creating instance

MSQL Password Error (Access Denied for User 'root'@'localhost' (using password: YES) - No Privileges?) https://libpowertech.blogspot.com/2022/09/msql-password-error-access-denied-for.html?m=1 On Thu, 22 Sep 2022, 10:43 am Mumanyi, Bravismore, wrote: > Hi Kumar > > I advise you re-check MySQL

[Koha] Catalog Error 500

*Good Morning All**started getting an error when selecting a title. If I search the catalog** and then select the title link I get the following error: **An Error has Occurred!* * Error 500* *Error attaching this link. *https://i.ibb.co/PhLwVm7/Capture.png Thanking you.. Librarian, MAMCET

[Koha] Koha 21.11.10 version, New Patrons email notice sending problem.

Good morning, I'm looking for tips to solve a New patron email notice sending problem. I noticed that Koha 21.11.10 version, New Patrons email notice only does not send, But book check-in, check-out, book renewal notification etc are working properly. -- Thanking you.. Librarian, MAMCET

Re: [Koha] to import bulk book details - please advise

How to Book Bibliography Data Convert Excel to MARC format https://www.youtube.com/watch?v=92bdWN054R0 On Tue, Jul 12, 2022 at 7:13 PM Bruns, Anke wrote: > Hi Edward, > > could you please explain your request a bit more? > > Do you explicitly want to import 5000 title records as duplicates of

Re: [Koha] Koha Sql Report Help

Fine Paid for Library Patrons (Koha SQL Reports Queries) Koha v 18 and above https://libpowertech.blogspot.com/2019/05/fine-paid-for-library-patrons-sql.html?m=1 On Sun, 26 Jun 2022, 7:36 am Shafrizan Affendi, wrote: > Hi, > > Recently I upgraded my Koha from ver 18 to 22.05. Some of my sql

[Koha] koha gmail sending problem (Google no longer supports the use of third-party apps or devices )

Hello Team, Due to the below reason koha gmail getting problem (Problem in sending mail kindly rectify the problem as soon as possible, If it is getting late to solve the problem as soon as possible. Aiter some other solutions for koha sending mail ) Less secure apps & your Google Account To help

[Koha] How to upload Bulk local cover images of books.

Hi Is it possible to bulk upload local cover images of books in koha. or any plugins tool available bulk local book cover image upload. -- Thanking you.. Librarian, MAMCET Trichy-Chennai Trunk Road, Siruganur, Tiruchirappalli-621 105.

Re: [Koha] How to Create Top 10 Circulation book with ISBN report

number=bi.biblionumber) > WHERE DATE(s.datetime) > DATE_SUB(CURRENT_DATE(),INTERVAL 6 MONTH) AND > DATE(s.datetime)<=CURRENT_DATE() AND s.itemnumber IS NOT NULL AND s.type IN > ('issue','renew') > GROUP BY b.biblionumber > ORDER BY circs DESC > LIMIT 10 > > Cheers! > Josh

[Koha] How to Create Top 10 Circulation book with ISBN report

Hi Is it possible to Create Top 10 Circulation book with ISBN number in SQL report, it is Available for Top Circulation book report: https://wiki.koha-community.org/wiki/SQL_Reports_Circulation#Top_10_Circulating_Books , but ISBN number missing. How to Add the ISBN Number in the report. i try

[Koha] Koha online bill copy format

How to Create an Email Receipt Template for Payment in Koha (Online Bill Copy) https://youtu.be/ARFcSJ_l76I https://libpowertech.blogspot.com/2022/03/how-to-create-email-receipt-template.html?m=1 -- Thanking you.. Librarian, MAMCET Trichy-Chennai Trunk Road, Siruganur,

[Koha] Koha OPAC Login to gmail ID (API)

Dear all koha fans. Anybody know how we can use email address, add password as opac userid and p/w in koha ( eg- opac userid-( ***@gmail.com p/w gmail account pw). -- Thanking you.. Librarian, MAMCET Trichy-Chennai Trunk Road, Siruganur,

Re: [Koha] Importing encrypted patron passwords

https://libpowertech.blogspot.com/2022/02/installing-multiple-instances-of-koha.html On Sun, 6 Feb 2022, 7:26 am Tomas Cohen Arazi, wrote: > You will create a new instance, say 'name' like this: > > $ koha-create --create-db name > > You will then load your backup on the empty db that was

[Koha] Koha Staff Login Issue Please help me.

I am encountered with error " Autolocation is switched on and you are logging in with an IP address that doesn't match your library". If any body knows the trouble shoot please help me. Enclosed Errr: https://i.ibb.co/YyDBnrB/koha-loing.png 1. Login into your staff client using a superlibrarian

[Koha] How to bulk change in item type

Hi How to change bulk item types in koha. for example item type for Book and change to Book bank item. -- Thanking you.. Librarian, MAMCET Trichy-Chennai Trunk Road, Siruganur, Tiruchirappalli-621 105. ___ Koha mailing list

Re: [Koha] KOHA INTERGRATION

KOHA ALL SQL REPORTS Visit: https://youtu.be/scuXS7wVFdM On Mon, 1 Nov 2021, 10:36 pm Lennon Mazonde, wrote: > Hi Steve, > > Koha has two fields where you can store an item's value - 952$g > (purchase price) and 952$v (replacement price). You can create an SQL > report in the reports module to

Re: [Koha] Unable to login in Web Installer 21.5

Koha installation https://libpowertech.blogspot.com/2021/03/how-to-install-koha-on-ubuntu-mate-2004.html?m=1 On Tue, 14 Sep 2021, 12:52 pm Sebastian Krieg, < sebastian.kr...@tuz-eisenach.de> wrote: > Hello Sanjay, > > there are two ways: > > 1. Please login in a shell at your koha server, change

Re: [Koha] [EXTERNAL] install koha

Visit the link Koha Full tutorial. basic koha installation and koha customization etc.. https://www.youtube.com/c/LibPowerTech On Wed, Sep 8, 2021 at 8:48 PM King, Fred wrote: > This won't tell you everything you need to know, but I did a video that > takes you from the Ubuntu command line