Re: [Koha] Unable to Access Koha # Critical

Hi Hugo, Thank you for the reply. I have not modified the file at /etc/mysql/my.cnf. I do not have good knowledge about MySQL. Only my.cnf file back is enough or entire folder /etc/mysql is required to be backedup ? From where do I get standard installation of my.cnf. please advise. regards Sat

[Koha] Circulation by Call Number

How do I add title in the SQL report below to generate circulation statistics by call number? SELECT count(statistics.type) AS 'Checkouts', (items.itemcallnumber) AS > 'Call Number', (items.barcode) AS 'Accession Number' > FROM borrowers > LEFT JOIN statistics ON > (statistics.borrowernumber=bor

Re: [Koha] Unable to Access Koha # Critical

Hi Indranil, The system is dedicated to Koha Server only. The diskspace details are as follows. root@gechlibrary:/home/satish# df -h Filesystem Size Used Avail Use% Mounted on udev2.0G 4.0K 2.0G 1% /dev tmpfs 396M 1.1M 395M 1% /run /dev/sda1 413G 5.6G 3

Re: [Koha] Unable to Access Koha # Critical

Hi Is it possible you have done dome modification at my.cnf? mysql can't start... perhaps it was a modification in the past and now has been reboot the changes have been activated... I suggest to start analyzing my.cnf if you have not knowledge on this file, perhaps backup it, and replace by my.cn

Re: [Koha] Unable to Access Koha # Critical

Satish, Just a hunch... Pls check free diskspace Regards -indranil On Tue 3 Sep, 2019, 12:12 PM SATISH, wrote: > Hi, > > With Koha 16.11.11 / Package Installation/ Ubuntu 14.04 Desktop with > MySQL - mysql Ver 14.14 Distrib 5.5.57 > > I am not able to access to Koha Server. however, I can con

[Koha] Unable to Access Koha # Critical

Hi, With Koha 16.11.11 / Package Installation/ Ubuntu 14.04 Desktop with MySQL - mysql Ver 14.14 Distrib 5.5.57 I am not able to access to Koha Server. however, I can connect to System (from SSH, putty). I am unable to connect to mysql database. I am not sure about any reason, because, it was ru

Re: [Koha] Time-based Circulation Statistics

Hi Admire, what you can do is use the timestamps in the statistics table and group by them. The reports library has some circulation in the 'hourly' section that might give you a good starting point: https://wiki.koha-community.org/wiki/SQL_Reports_Circulation#Hourly Hope this helps, Katrin O

Re: [Koha] Issue with email configuration_not able to send email to patron

Hello, have you configured email server? Vikram Zadgaonkar On Tue, Sep 3, 2019 at 10:55 AM Library biet wrote: > Hi, > This is Shashikiran M working as Asst Librarian, I installed KOHA live DVD > on my new system and then it was updated to KOHA 19.05 at that time i'm > able to send email to pat

[Koha] Alerts for every Nth check out

Hi, I am trying to set up Koha for local kid's library in my town. I would like to know if it is possible for Koha to alert staff members when a patron checks out every 10th book? ie, someway for staff to know that John Smith is checking out 10th/20th/30th ... book? We would like to reward such

[Koha] Issue with email configuration_not able to send email to patron

Hi, This is Shashikiran M working as Asst Librarian, I installed KOHA live DVD on my new system and then it was updated to KOHA 19.05 at that time i'm able to send email to patron, after that I took backup from my old system and restored into the new system (PC) after restoring the database into th

[Koha] which is best ubuntu version to install koha

Hi which is best ubuntu version to install koha -- Y.Yatheesh Babu ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] [Debian][Buster] Can Buster be used in production?

Hello Fellow Kohaers, Is anyone using Debian 10 (Buster) as a platform for Koha? My main attraction to it is native support for MariaDB 10.3 which fixes the AUTO_INCREMENT bug. I have a test install (Koha 19) that seems fine but I thought I would try for feedback before deploying it in product