Re: [Koha] DBMS auto increment fix
Dear All, I had tried the fix given on page: https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix with steps as given below: - Edit /etc/mysql/my.cnf - Locate the [mysqld] section and add: init-file=/var/lib/mysql/init-file_kohadev.sql - Create a file /var/lib/mysql/init-file_kohadev.sql - Edit it with the following contents Restart MySQL This solution works for single mysql instance having multiple database, then we have to repeat all these statements for all the DBs. But my problem is that I am using mysql_mutli and there are different mysql instance for each Koha instance, considering master-slave instances, I have to use mysql_mutli. So, how should I use these statements in case of mysql_multi. Can anyone guide me in this regard? On Wed, Sep 27, 2017 at 1:29 PM, SATISH wrote: > Hi, > > Koha updated from 16.11.09 to 16.11.11.000 / Package Installation/ Ubuntu > 14.04 Desktop > and using Mysql Version 14.14 Distrib 5.5.57 > > I have faced problems regarding check-in earlier. Therefore, Is it relevant > / necessary for the said version of Koha to follow instructions given in > the URL on DBMS auto increment > https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix > > I mean to ask, should I edit /etc/mysq as defined in the wiki page. > > With Thanks > Satish MV > Librarian, > Govt. Engineering College, Hassan. > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > -- Thanks & Regards Sunil Sharma ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Bulk Patron Image upload zip file giving Error 500
Hi Marc,
Thanks for the valuable input.
Let me debug these lines which you had point out and get back to you if I
will get any solution with this.
On Fri, Jul 21, 2017 at 12:33 PM, Marc Véron wrote:
> Hi Sunil
>
> I have the impression that the error occurs on line 118 of
> picture-upload.pl
>
> unless( system( "unzip", $tempfile, '-d', $dirname ) == 0 ) {
>
> It seems that the zip is extracted but the program thinks that something
> went wrong with extracting and exits (following lines).
>
> Because the error occurs since Debian 8.3 I suppose that system(...)
> returns an other value than with Debian 8.2
>
> For the return values of system see:
> http://perldoc.perl.org/functions/system.html
>
> Just my 2 cents...
>
> Marc
>
>
> Am 21.07.2017 um 06:29 schrieb Sunil Sharma:
>
>> Hello Friends,
>>
>> If someone faced the problem mentioned in my previous mail attached below
>> and having any solution, please guide.
>>
>> I am using Koha 16.05.12 with Debian 8.3 OS on my cloud server.
>>
>> Currently, I am facing a very strange problem while uploading a single
>> patron image via Koha Bulk Patron image upload tool, the image file is
>> uploading fine. But When I tried using *zip file* of all patron images
>> with
>> a mapped text file named as IDLINK.TXT, As soon as I browse the zip file
>> and try to upload the images, the images are uploaded but instead of
>> result
>> page, the page will through error 500.
>>
>> I had checked many Koha versions i.e. Koha 3.22.x, Koha 16.05.x, Koha
>> 16.11.x but same *error 500* will be the result.
>>
>> To troubleshoot the problem I had tested the same Koha versions with same
>> zip file at my local virtual machine but the strange problem which I
>> found,
>> that* all Koha* versions with bulk patron upload feature *worked fine on
>> Debian 8.2 *but *through error 500 with Debian 8.3 and onwards i.e. 8.4,
>> 8.8 etc. *
>>
>>
>> I had tested with different Apache versions but on Debian 8.2 all things
>> worked fine, but on Debian 8.3 no success (may be any security fetch or
>> something wrong is there)
>>
>> As there are a lot of other application are running on my cloud server so
>> I
>> can't change the OS. Please guide me what will I do?
>>
>> The Koha error logs are as given below:
>>
>>
>>
>>
>>
>> *[Thu Jul 12 13:43:02.2017] [http:error] [pid 16357] [client x.x.x.x]
>> AH02429: Response header name ' extracting' contains invalid characters,
>> aborting request, referer:
>> http://example.com/cgi-bin/koha/tools/picture-upload.pl
>> <http://example.com/cgi-bin/koha/tools/picture-upload.pl>[Thu Jul 12
>> 13:50:38.2017] [http:error] [pid 14327] [client x.x.x.x] AH02429: Response
>> header name ' inflating' contains invalid characters, aborting request,
>> referer: http://example.com/cgi-bin/koha/tools/picture-upload.pl
>> <http://example.com/cgi-bin/koha/tools/picture-upload.pl>[Thu Jul 12
>> 13:59:27.2017] [http:error] [pid 25507] [client x.x.x.x] AH02429: Response
>> header name ' inflating' contains invalid characters, aborting request,
>> referer: http://example.com/cgi-bin/koha/tools/picture-upload.pl
>> <http://example.com/cgi-bin/koha/tools/picture-upload.pl>*
>>
>>
>> Any pointers would be of help.
>>
>>
>> On Fri, Jul 14, 2017 at 3:19 PM, Sunil Sharma
>> wrote:
>>
>> Hi Ian Bays,
>>>
>>> Thank you very much for the valuable input.
>>>
>>> I had checked and you are right that all patron images are uploading
>>> correctly but was failing when trying to show the results page with the
>>> error 500 as you observed.
>>>
>>> Now, it is confirmed with your mail that something is wrong. Please guide
>>> if you will find any solution for this problem.
>>>
>>> If someone else faced this problem and having solution, please guide.
>>>
>>>
>>>
>>> On Fri, Jul 14, 2017 at 2:19 PM, Ian Bays
>>> wrote:
>>>
>>> Hello,
>>>>
>>>> I have noticed the same problem uploading a zip file of patron images
>>>> and
>>>> saw similar messages in the log file.
>>>>
>>>> However on checking the patron records saw the images so I concluded
>>>> that
>>>> the upload was working correctly but was failing when trying to show the
>>>> results page with the error 500.
>>>>
>>>> There is d
Re: [Koha] Bulk Patron Image upload zip file giving Error 500
Hello Friends, If someone faced the problem mentioned in my previous mail attached below and having any solution, please guide. I am using Koha 16.05.12 with Debian 8.3 OS on my cloud server. Currently, I am facing a very strange problem while uploading a single patron image via Koha Bulk Patron image upload tool, the image file is uploading fine. But When I tried using *zip file* of all patron images with a mapped text file named as IDLINK.TXT, As soon as I browse the zip file and try to upload the images, the images are uploaded but instead of result page, the page will through error 500. I had checked many Koha versions i.e. Koha 3.22.x, Koha 16.05.x, Koha 16.11.x but same *error 500* will be the result. To troubleshoot the problem I had tested the same Koha versions with same zip file at my local virtual machine but the strange problem which I found, that* all Koha* versions with bulk patron upload feature *worked fine on Debian 8.2 *but *through error 500 with Debian 8.3 and onwards i.e. 8.4, 8.8 etc. * I had tested with different Apache versions but on Debian 8.2 all things worked fine, but on Debian 8.3 no success (may be any security fetch or something wrong is there) As there are a lot of other application are running on my cloud server so I can't change the OS. Please guide me what will I do? The Koha error logs are as given below: *[Thu Jul 12 13:43:02.2017] [http:error] [pid 16357] [client x.x.x.x] AH02429: Response header name ' extracting' contains invalid characters, aborting request, referer: http://example.com/cgi-bin/koha/tools/picture-upload.pl <http://example.com/cgi-bin/koha/tools/picture-upload.pl>[Thu Jul 12 13:50:38.2017] [http:error] [pid 14327] [client x.x.x.x] AH02429: Response header name ' inflating' contains invalid characters, aborting request, referer: http://example.com/cgi-bin/koha/tools/picture-upload.pl <http://example.com/cgi-bin/koha/tools/picture-upload.pl>[Thu Jul 12 13:59:27.2017] [http:error] [pid 25507] [client x.x.x.x] AH02429: Response header name ' inflating' contains invalid characters, aborting request, referer: http://example.com/cgi-bin/koha/tools/picture-upload.pl <http://example.com/cgi-bin/koha/tools/picture-upload.pl>* Any pointers would be of help. On Fri, Jul 14, 2017 at 3:19 PM, Sunil Sharma wrote: > Hi Ian Bays, > > Thank you very much for the valuable input. > > I had checked and you are right that all patron images are uploading > correctly but was failing when trying to show the results page with the > error 500 as you observed. > > Now, it is confirmed with your mail that something is wrong. Please guide > if you will find any solution for this problem. > > If someone else faced this problem and having solution, please guide. > > > > On Fri, Jul 14, 2017 at 2:19 PM, Ian Bays > wrote: > >> Hello, >> >> I have noticed the same problem uploading a zip file of patron images and >> saw similar messages in the log file. >> >> However on checking the patron records saw the images so I concluded that >> the upload was working correctly but was failing when trying to show the >> results page with the error 500. >> >> There is definitely something wrong but you might like to check to see if >> the upload actually worked OK. >> >> Best regards. >> Ian >> >> On 13/07/2017 06:32, Sunil Sharma wrote: >> >>> Hello Friends, >>> >>> I am using Koha 16.05.12 with Debian 8.3 OS on my cloud server. >>> >>> Currently, I am facing a very strange problem while uploading a single >>> patron image via Koha Bulk Patron image upload tool, the image file is >>> uploading fine. But When I tried using *zip file* of all patron images >>> with >>> a mapped text file named as IDLINK.TXT, As soon as I browse the zip file >>> and try to upload the file, the page will through error 500. >>> >>> I had checked many Koha versions i.e. Koha 3.22.x, Koha 16.05.x, Koha >>> 16.11.x but same *error 500* will be the result. >>> >>> To troubleshoot the problem I had tested the same Koha versions with same >>> zip file at my local virtual machine but the strange problem which I >>> found, >>> that* all Koha* versions with bulk patron upload feature *worked fine on >>> Debian 8.2 *but *through error 500 with Debian 8.3 * >>> >>> I had tested with different Apache versions but on Debian 8.2 all things >>> worked fine, but on Debian 8.3 no success (may be any security fetch or >>> something wrong is there) >>> >>> As there are a lot of other application are running on my cloud server >>> so I >>> can't change the OS.
Re: [Koha] Bulk Patron Image upload zip file giving Error 500
Hi Ian Bays, Thank you very much for the valuable input. I had checked and you are right that all patron images are uploading correctly but was failing when trying to show the results page with the error 500 as you observed. Now, it is confirmed with your mail that something is wrong. Please guide if you will find any solution for this problem. If someone else faced this problem and having solution, please guide. On Fri, Jul 14, 2017 at 2:19 PM, Ian Bays wrote: > Hello, > > I have noticed the same problem uploading a zip file of patron images and > saw similar messages in the log file. > > However on checking the patron records saw the images so I concluded that > the upload was working correctly but was failing when trying to show the > results page with the error 500. > > There is definitely something wrong but you might like to check to see if > the upload actually worked OK. > > Best regards. > Ian > > On 13/07/2017 06:32, Sunil Sharma wrote: > >> Hello Friends, >> >> I am using Koha 16.05.12 with Debian 8.3 OS on my cloud server. >> >> Currently, I am facing a very strange problem while uploading a single >> patron image via Koha Bulk Patron image upload tool, the image file is >> uploading fine. But When I tried using *zip file* of all patron images >> with >> a mapped text file named as IDLINK.TXT, As soon as I browse the zip file >> and try to upload the file, the page will through error 500. >> >> I had checked many Koha versions i.e. Koha 3.22.x, Koha 16.05.x, Koha >> 16.11.x but same *error 500* will be the result. >> >> To troubleshoot the problem I had tested the same Koha versions with same >> zip file at my local virtual machine but the strange problem which I >> found, >> that* all Koha* versions with bulk patron upload feature *worked fine on >> Debian 8.2 *but *through error 500 with Debian 8.3 * >> >> I had tested with different Apache versions but on Debian 8.2 all things >> worked fine, but on Debian 8.3 no success (may be any security fetch or >> something wrong is there) >> >> As there are a lot of other application are running on my cloud server so >> I >> can't change the OS. Please guide me what will I do? >> >> The Koha error logs are as given below: >> >> >> >> >> >> *[Thu Jul 12 13:43:02.2017] [http:error] [pid 16357] [client x.x.x.x] >> AH02429: Response header name ' extracting' contains invalid characters, >> aborting request, referer: >> http://example.com/cgi-bin/koha/tools/picture-upload.pl >> <http://example.com/cgi-bin/koha/tools/picture-upload.pl>[Thu Jul 12 >> 13:50:38.2017] [http:error] [pid 14327] [client x.x.x.x] AH02429: Response >> header name ' inflating' contains invalid characters, aborting request, >> referer: http://example.com/cgi-bin/koha/tools/picture-upload.pl >> <http://example.com/cgi-bin/koha/tools/picture-upload.pl>[Thu Jul 12 >> 13:59:27.2017] [http:error] [pid 25507] [client x.x.x.x] AH02429: Response >> header name ' inflating' contains invalid characters, aborting request, >> referer: http://example.com/cgi-bin/koha/tools/picture-upload.pl >> <http://example.com/cgi-bin/koha/tools/picture-upload.pl>* >> >> >> >> Any pointers would be of help. >> >> >> > -- > Ian Bays > Director of Projects, PTFS Europe Limited > Content Management and Library Solutions > +44 (0) 800 756 6803 (phone) > +44 (0) 7774 995297 (mobile) > +44 (0) 800 756 6384 (fax) > skype: ian.bays > email: ian.b...@ptfs-europe.com > > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > -- Thanks & Regards Sunil Sharma ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Bulk Patron Image upload zip file giving Error 500
Hello Friends, I am using Koha 16.05.12 with Debian 8.3 OS on my cloud server. Currently, I am facing a very strange problem while uploading a single patron image via Koha Bulk Patron image upload tool, the image file is uploading fine. But When I tried using *zip file* of all patron images with a mapped text file named as IDLINK.TXT, As soon as I browse the zip file and try to upload the file, the page will through error 500. I had checked many Koha versions i.e. Koha 3.22.x, Koha 16.05.x, Koha 16.11.x but same *error 500* will be the result. To troubleshoot the problem I had tested the same Koha versions with same zip file at my local virtual machine but the strange problem which I found, that* all Koha* versions with bulk patron upload feature *worked fine on Debian 8.2 *but *through error 500 with Debian 8.3 * I had tested with different Apache versions but on Debian 8.2 all things worked fine, but on Debian 8.3 no success (may be any security fetch or something wrong is there) As there are a lot of other application are running on my cloud server so I can't change the OS. Please guide me what will I do? The Koha error logs are as given below: *[Thu Jul 12 13:43:02.2017] [http:error] [pid 16357] [client x.x.x.x] AH02429: Response header name ' extracting' contains invalid characters, aborting request, referer: http://example.com/cgi-bin/koha/tools/picture-upload.pl <http://example.com/cgi-bin/koha/tools/picture-upload.pl>[Thu Jul 12 13:50:38.2017] [http:error] [pid 14327] [client x.x.x.x] AH02429: Response header name ' inflating' contains invalid characters, aborting request, referer: http://example.com/cgi-bin/koha/tools/picture-upload.pl <http://example.com/cgi-bin/koha/tools/picture-upload.pl>[Thu Jul 12 13:59:27.2017] [http:error] [pid 25507] [client x.x.x.x] AH02429: Response header name ' inflating' contains invalid characters, aborting request, referer: http://example.com/cgi-bin/koha/tools/picture-upload.pl <http://example.com/cgi-bin/koha/tools/picture-upload.pl>* Any pointers would be of help. -- Thanks & Regards Sunil Sharma ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Book Status shown as "Available" for checkout books
Hello Friends, I am using Koha 3.22.6 on Debian jessie. I am facing a major issue in Koha staff page. For example, if I have 5 copies under a record and I issued 4 books out of 5. Then when I search for this record in opac the opac search result page display result fine like 4 books check-out, 1 book available. But the same record on staff page display that 5 books as available. Even when I check the detail for that record under status it display checkout barcode status as checkout to "xyz" due date "" with Available under it, means both status. Is this any bug in Koha 3.22.x or any other reason. Any pointers would be of help. -- Thanks & Regards Sunil Sharma ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Search By Barcode having 1, 2 or 3 digit not working in Koha 3.20 or in 3.22
Hi Katrin, Yes, when I check this system preference it is set on as "automatically". When I changed it to "Only if * added" search is performing fine. Thanks for the help. On Fri, Apr 29, 2016 at 7:41 PM, Katrin Fischer wrote: > Hi, > > How are you searching for the barcode? > Did you turn on the QueryAutoTruncate system preference? > > Hope this helps, > > Katrin > > Am 29.04.2016 um 13:16 schrieb Sunil Sharma: > > Hello Friends, > > > > I checked both Koha 3.20.x as well as Koha 3.22.x on Debian 8 OS, Zebra > > version 2.0.61. My other search is working fine but when I search any > > barcode having 1, 2 or 3 digit, the search result page will not reflect > > proper search result both in Koha OPAC as well as on Staff-Admin page. > > > > For example, when I search 123 it will give the records having barcode as > > 1231, 1232, 1233, same as if I will search for barcode 121 then it will > > give result for biblio having accession no. 121220, 121121 and so on. > Even > > these barcodes (121 or 123) are present in Koha. > > > > Any pointers would be of help. > > > > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > -- Thanks & Regards Sunil Sharma ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Search By Barcode having 1, 2 or 3 digit not working in Koha 3.20 or in 3.22
Hello Friends, I checked both Koha 3.20.x as well as Koha 3.22.x on Debian 8 OS, Zebra version 2.0.61. My other search is working fine but when I search any barcode having 1, 2 or 3 digit, the search result page will not reflect proper search result both in Koha OPAC as well as on Staff-Admin page. For example, when I search 123 it will give the records having barcode as 1231, 1232, 1233, same as if I will search for barcode 121 then it will give result for biblio having accession no. 121220, 121121 and so on. Even these barcodes (121 or 123) are present in Koha. Any pointers would be of help. -- Thanks & Regards Sunil Sharma ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Merge Records via List not working in Koha 3.22.x
Hello Friends, I am using Koha 3.22.5 on Debian 8 OS. I have many duplicate title in my catalog, So I want to merge such records through Koha List module using merge function, At the end of the process it will show succesfully merged. But in actual it will neither merge items from source to destination record nor it will delete the other records except reference as it worked in previous version Koha 3.18 or koha 3.20. Any pointers would be of help. -- Thanking you, Sunil Sharma ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Error indexing koha
Hi Araik, I am not sure about your actual problem, but the error message "Record didn't contain match fields in (bib1,Local-number)" showing that it may be an issue in your *koha to marc mapping*, Please look around this and the solution is within there. //BR Sunil On Mon, Sep 30, 2013 at 4:28 PM, Araik Manukyan wrote: > Hi Friends ! > > Recently I have upgraded Koha version from 3.08.07 to 3.12.04 .It works > but > we can't find new catologized records. > > We removed old zebra index and tried indexing with ./rebuild_zebra.pl -b > -a - z -v command . > It brings such error and show only 226 records > > > > > > 1101 > > > Records exported: 1103 > > > > REINDEXING zebra > > > > 14:45:56-30/09 zebraidx(2582) [warn] Record didn't contain match fields in > (bib1,Local-number) > > > > CLEANING > > How > > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Report on Titles in the collection
Here is the query, what you want :- SELECT items.barcode, biblio.title FROM items LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber) GROUP BY items.biblionumber HAVING ( COUNT(*) > 1 ) On Mon, Aug 26, 2013 at 7:15 AM, Madhura Deodhar IES Library < library.m...@gmail.com> wrote: > I want a list of titles having more than one items . Can anyone help me > with the SQL query? > > -- > *Regards,* > ** > *Madhura M.Deodhar* > *Librarian > *IES Management College and Research Centre > VMD Lotlikar Vidya Sankul > Opp.Lilavati Hospital, Bandra Reclamation > Bandra (West) Mumbai - 50 > 61378327(direct) > 9869385665/9167004647 > > http://iesmglib.blogspot.com > > *P **Please consider the environment before printing this e-mail.* > * > * > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > //BR Sunil ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Fwd: Routing list notice not working properly
Dear all, I configure the postfix mail server for koha 3.08.11 in debian-6. All notice going fine, except routing list. Actually the routing list notice to subscriber list is going fine after receiving a new serial but only title of that particular serial is displayed in the mail, other information get skip. For e.g. my routing list notice is set like this;- Koha Module: Serial (routing list) Code: RLIST Message Subject: Serial is now available Message Body:- Dear Borrower, The following magazine/journal has been arrived in the Library and Information Center, and available for reference : <>, <> , <> <>, <> Thanks, Library and Information Center *Now, when we receive the mail it contain the following text only, * Dear Borrower, The following magazine/journal has been arrived in the Library and Information Center, and available for reference : sample Journal, , , Thanks, Library and Information Center so, it is clear that only biblio.title is supported by this notice. Please help me in this regard. Any help would be appreciated. //BR Sunil ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Want to raise a bug about fine module
Hi I am not understanding the term Multiple overlapping fines, could you please explain me how this should resolve my problem. Thanks in Advance, Sunil On Tue, May 21, 2013 at 10:13 AM, Manos PETRIDIS wrote: > I wonder if this could be accomplished by using multiple overlapping fines. > > MP > > Από το iPhone μου > > 21 Μαϊ 2013, 2:53 μ.μ., ο/η sunil sharma έγραψε: > > > Dear All, > > > > In fine module, currently we can set fine for a particular patron > category > > and for any item type. A number of option available in current fine > > criteria like loan period, fine amount, fine charging interval etc. But > > this limit a library to apply a constant fine amount for a category > whether > > the no. of days for which fine is applicable are 10 days or 100 days. > What > > I want to say that in koha there should be increasing fine amount > criteria. > > i.e when fine is calculated it should calculate like this:- > > > > Let say, After 'x' days the fine amount is 'a' > > After 'x+y' days the fine amount become 'a+b' > > > > where, x - the loan period > > a - fine amount after x days > > y - A constant period after which the fine gets change > > b - the fine amount applicable after 'x+y' days > > > > > > Please give your suggestion and help me in this regard. > > > > > > //BR > > Sunil > > ___ > > Koha mailing list http://koha-community.org > > Koha@lists.katipo.co.nz > > http://lists.katipo.co.nz/mailman/listinfo/koha > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Want to raise a bug about fine module
Dear All, In fine module, currently we can set fine for a particular patron category and for any item type. A number of option available in current fine criteria like loan period, fine amount, fine charging interval etc. But this limit a library to apply a constant fine amount for a category whether the no. of days for which fine is applicable are 10 days or 100 days. What I want to say that in koha there should be increasing fine amount criteria. i.e when fine is calculated it should calculate like this:- Let say, After 'x' days the fine amount is 'a' After 'x+y' days the fine amount become 'a+b' where, x - the loan period a - fine amount after x days y - A constant period after which the fine gets change b - the fine amount applicable after 'x+y' days Please give your suggestion and help me in this regard. //BR Sunil ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Routing list notice not working properly
Dear all, I configure the postfix mail server for koha 3.08.11 in debian-6. All notice going fine, except routing list. Actually the routing list notice to subscriber list is going fine after receiving a new serial but only title of that particular serial is displayed in the mail, other information get skip. For e.g. my routing list notice is set like this;- Koha Module: Serial (routing list) Code: RLIST Message Subject: Serial is now available Message Body:- Dear Borrower, The following magazine/journal has been arrived in the Library and Information Center, and available for reference : <>, <> , <> <>, <> Thanks, Library and Information Center *Now, when we receive the mail it contain the following text only, * Dear Borrower, The following magazine/journal has been arrived in the Library and Information Center, and available for reference : sample Journal, , , Thanks, Library and Information Center so, it is clear that only biblio.title is supported by this notice. Please help me in this regard. Any help would be appreciated. //BR Sunil ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Need Help in Koha Multiple instance
Thanx a lot for all your valuable suggestions. Problem solved by exporting the variable for that particular instance. And making script to resolve that permanently. Sunil On Sun, Apr 21, 2013 at 6:53 AM, Mason James wrote: > > On 2013-04-20, at 10:28 PM, sunil sharma wrote: > > > Hello all, > > > > I installed koha 3.8.x multiple instances on a debian-squeeze server by > > refering this link: > > > http://wiki.koha-community.org/wiki/Installing_Multiple_Instances_of_Koha. > > > use the debian packages, if you are attempting multiple instances of > Koha... > > http://wiki.koha-community.org/wiki/Koha_3.x_on_Debian_Squeeze > > > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Need Help in Koha Multiple instance
Hello all, I installed koha 3.8.x multiple instances on a debian-squeeze server by refering this link: http://wiki.koha-community.org/wiki/Installing_Multiple_Instances_of_Koha . But I am facing problem in rebuilding zebra in multiple instances. Actually when I installed one instance for example koha1, it installed perfectly and rebuildzebra.pl work fine after uploading my database. After installing another instance say koha2, it also installed perfectly and rebuildzebra.plalso works fine. But now the problem is that, now if I again come at my first instance i.e. koha1, make rebuildzebra.pl command to run again, it takes database of my 2nd instance. This is because in zebra configuration file while rebuild zebra it show like this:- Zebra configuration information Zebra biblio directory = /var/lib/*koha2*/zebradb/biblios Zebra authorities directory = /var/lib/*koha2*/zebradb/authorities Koha directory = /usr/share/*koha2*/intranet/cgi-bin In place of *koha2*, this should take *koha1* in my first instance of koha, which is making wrong zebra rebuild and show me biblio of koha2 instance in koha1 instance. How should I resolve this problem. Can Anyone help me in this regard? Thanks in advance for your help, Sunil ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Google SMTP for mailing service
Dear sheikh, Yes, It is possible to use googlesmtp service for sending emails in koha. The step by step procedure for ubuntu system is as follows:- *1. Installation of postfix mail server package. * Open a a terminal and apply following command, apt-get install postfix Select no configuration in the post installation screen. *2. Copy the configuration file.* cp /usr/share/postfix/main.cf.debian /etc/postfix/main.cf *3. Install following packages too* apt-get install libsasl2-2 apt-get install libsasl2-modules apt-get install ca-certificates *4. Open the following file and add some lines.* gedit /etc/postfix/main.cf Add the following lines at the bottom of the file. relayhost = [smtp.gmail.com]:587 smtp_sasl_auth_enable = yes smtp_sasl_password_maps = hash:/etc/postfix/sasl_passwd smtp_sasl_security_options = noanonymous smtp_tls_CAfile = /etc/postfix/cacert.pem smtp_use_tls = yes *5. Create a new file to save the gmail password.* gedit /etc/postfix/sasl_passwd Add the following line in the opened file. [smtp.gmail.com]:587urgmai...@gmail.com:yourpassword Add your gmail user name and password. *6. Change the permission of following file.* chmod 400 /etc/postfix/sasl_passwd *7. Translate the /etc/postfix/sasl_passwd to Postfix lookup tables.* postmap /etc/postfix/sasl_passwd *8. Create the /etc/aliases.db* postalias hash:/etc/aliases *9. Create the /etc/postfix/cacert.pem.* cat /etc/ssl/certs/Equifax_Secure_CA.pem >> /etc/postfix/cacert.pem *10. Restart Postfix.* /etc/init.d/postfix restart Be Sure that you done the below step before to start email in Koha notices:- Administration > Patron categories > Overdue notice required > Yes Koha Administration > Patrons > Enhancedmessagingpreferences > Allow I think this is all you need. Enjoy!!! //BR Sunil On Mon, Oct 22, 2012 at 5:29 PM, sheikh303 wrote: > Is it possible to use google smtp service for sending emails in koha? > thanks > > > > -- > View this message in context: > http://koha.1045719.n5.nabble.com/Google-SMTP-for-mailing-service-tp5730442.html > Sent from the Koha-general mailing list archive at Nabble.com. > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] koha-index-daemon
Dear Friend, > /etc/init.d/koha-index-daemon: line 67: log_daemon_msg: command not found > > /etc/init.d/koha-index-daemon: line 68: daemon: command not found > > /etc/init.d/koha-index-daemon: line 71: log_end_msg: command not found > > Both log_daemon_msg and log_end_msg commands belong to LSB-related > packages. On Debian/Ubuntu that would be lsb-core. On RedHat derivates > it might be redhat-lsb. As for the daemon command, I can't tell. > > I checked out the redhat-lsb package on my centos 6.2 machine, the package is already installed and the newest. My 2nd error of line 68: daemon: command not found is resolved after installing the daemon-tool as told by Mr.Bernardo. But the two errors of line 67 & 71 remains as it is, i.e. > /etc/init.d/koha-index-daemon: line 67: log_daemon_msg: command not found > /etc/init.d/koha-index-daemon: line 71: log_end_msg: command not found Can You or anybody else please help me in this regard to solve out my problem. *Thanx in Advance*, *Sunil* ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] koha-index-daemon
Dear Friend,
Thanx for your quick reply, By installing 'daemon' program, the error of
line 68 is removed but still the error in remianing 2 linesis as it is.
i.e.
$ /etc/init.d/koha-index-daemon start
shows error:-
/etc/init.d/koha-index-daemon: line 59: log_daemon_msg: command not found
/etc/init.d/koha-index-daemon: line 63: log_end_msg: command not found
And such as,
/etc/init.d/koha-index-daemon stop
shows error:-
/etc/init.d/koha-index-daemon: line 67: log_daemon_msg: command not found
/etc/init.d/koha-index-daemon: line 71: log_end_msg: command not found
Can you pleasee see in this matter again. Please help me in this regard.
Thanx in Advance,
*Sunil*
On Fri, Sep 21, 2012 at 3:25 PM, Bernardo Gonzalez Kriegel <
bgkrie...@gmail.com> wrote:
> Sunil,
> the problem, as indicated by this line
>
> /etc/init.d/koha-index-daemon: line 68: daemon: command not found
>
> is that you don't have the 'daemon' program.
>
> On Centos this is unavailable, so go to http://libslack.org/daemon/ ,
> download the source, compile and install.
>
> Regards,
> Bernardo
>
> --
> Bernardo Gonzalez Kriegel
> bgkrie...@gmail.com
>
>
>
> On Fri, Sep 21, 2012 at 6:12 AM, sunil sharma wrote:
>
>> Dear All,
>>
>> I am facing an error while executing my koha-index-daemon file using *
>> "koha-index-daemon-ctl.sh"*.
>>
>>
>> My koha-index-daemon-ctl.sh file is as:
>>
>> #!/bin/sh
>>
>> # This file is part of Koha.
>> #
>> # Koha is free software; you can redistribute it and/or modify it under
>> the
>> # terms of the GNU General Public License as published by the Free
>> Software
>> # Foundation; either version 2 of the License, or (at your option) any
>> later
>> # version.
>> #
>> # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
>> # WARRANTY; without even the implied warranty of MERCHANTABILITY or
>> FITNESS
>> FOR
>> # A PARTICULAR PURPOSE. See the GNU General Public License for more
>> details.
>> #
>> # You should have received a copy of the GNU General Public License along
>> with
>> # Koha; if not, write to the Free Software Foundation, Inc., 59 Temple
>> Place,
>> # Suite 330, Boston, MA 02111-1307 USA
>>
>> ### BEGIN INIT INFO
>> # Provides: koha-index-daemon-$DBNAME
>> # Required-Start:$local_fs $syslog
>> # Required-Stop: $local_fs $syslog
>> # Default-Start: 2 3 4 5
>> # Default-Stop: 0 1 6
>> # X-Interactive: false
>> # Short-Description: Start/stop koha-index-daemon for $DBNAME
>> ### END INIT INFO
>>
>> . /lib/lsb/init-functions
>>
>> USER=koha
>> GROUP=koha
>> DBNAME=koha
>> NAME=koha-index-daemon-$DBNAME
>> LOGDIR=/var/log/koha
>> PERL5LIB=/usr/share/koha/lib
>> KOHA_CONF=/etc/koha/koha-conf.xml
>> ERRLOG=$LOGDIR/koha-index-daemon.err
>> STDOUT=$LOGDIR/koha-index-daemon.log
>> OUTPUT=$LOGDIR/koha-index-daemon-output.log
>>
>> export KOHA_CONF
>> export PERL5LIB
>>
>> INDEXDAEMON="koha-index-daemon"
>> INDEXDAEMON_OPTS="--timeout 30 --conf $KOHA_CONF \
>> --directory /var/tmp/koha-index-daemon-$DBNAME"
>>
>> DAEMONOPTS="--name=$NAME \
>> --errlog=$ERRLOG \
>> --stdout=$STDOUT \
>> --output=$OUTPUT \
>> --verbose=1 --respawn --delay=30"
>>
>> USER="--user=$USER.$GROUP"
>>
>>
>> case "$1" in
>> start)
>> log_daemon_msg "Starting Koha indexing daemon ($DBNAME)"
>> if daemon $DAEMONOPTS $USER -- $INDEXDAEMON $INDEXDAEMON_OPTS; then
>> log_end_msg 0
>> else
>> log_end_msg 1
>> fi
>> ;;
>> stop)
>> log_daemon_msg "Stopping Koha indexing daemon ($DBNAME)"
>> if daemon $DAEMONOPTS $USER --stop -- $INDEXDAEMON
>> $INDEXDAEMON_OPTS;
>> then
>> log_end_msg 0
>> else
>> log_end_msg 1
>> fi
>> ;;
>> restart)
>> log_daemon_msg "Restarting the Koha indexing daemon ($DBNAME)"
>> if daemon $DAEMONOPTS $USER --restart -- $INDEXDAEMON
>> $INDEXDAEMON_OPTS; then
>> log_end_msg 0
>> else
>> log_end_msg 1
>> fi
>> ;;
>> *)
>> log_success_msg "Usage: /etc/init.d/$NAME {start|stop|restart}"
>> exit 1
>> ;;
>> esac
>>
&g
[Koha] Zebra not updating biblios automatically in koha 3.8
Dear All, I installed Koha 3.8.02 and also check latest version of koha 3.8.04 on centos 6.2, The same problem I am facing in both of these version. when I enter any new biblio, it is not updated automatically to zebra, I am using zebra latest version 2.0.54 and all cronjobs are set. I also manually check zebra functioning by ./rebuild_zebra.pl -b -a -v -z but it shows export biblios zero, but I already added some bilios to koha yet it shows exported zero. And, when I use ./rebuild_zebra.pl -b -a -v -r then it rebuild all the biblios and my all added biblio shows in result i.e. exported 10 biblios. My question is that why ./rebuild_zebra.pl -b -a -v -z option is not working. where is the problem, because my zebra working fine in 3.6, is there any problem in koha 3.8. or any other issue. Please help me out. Thanx in advance. Sunil ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] SQL commands appearing on report
Hi,
You Can also do a trick to your intranet CSS file, or simply go to
system preference -> IntranetUserCSS
and enter:
#sql_output {display: none; }
and save the preferences.
Regards,
Sunil
On Tue, Aug 28, 2012 at 1:38 AM, Shelley & Kurt Kemperman <
ksckemper...@chartermi.net> wrote:
> We recently updated to version 3.8 and suddenly the SQL command lines are
> appearing at the top of any report we run/print. Any ideas to get rid of
> this?
> __**_
> Koha mailing list http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/**mailman/listinfo/koha
>
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Date format
Dear Sandeep, Do the following steps in Excel, If you open the excel sheet with open office, then: 1. Select whole column to which you want to apply the required date format. 2. Right click on any cell, and select Format cell, under Number tag option, Select Date format, in right pane select the desired format i.e. 1999-11-30, the Format Code is -MM-DD for that as you see under the same window, when you select that. 3. Apply or Click OK the whole column now set to ur required format. If you are using MS Office 2007 or 2010 then the steps are like below: 1. Select whole column to which you want to apply the required date format. 2. Right click on any cell, and select Format cell, under Number tag option, where Date format given, the last option is custom format. 3. Select Custom Format and in right pane under Type Text box, type your desired format i.e. -MM-DD, and select that from below as you add that format. 4. Apply or Click OK the whole column now set to ur required format. Hope your problem will solved now. BR// Sunil -- On Sat, Jun 9, 2012 at 5:30 PM, SANDEEP BHAVSAR wrote: > Dear All > > Kindly help me in converting date format from DD-MM- to -MM-DD in > Excel > If possible give the solution step by step. I tried with "Text to > Colums" options in Excel. > > > > -- > Thanks and Regards > > Sandeep Bhavsar > Librarian > Dr.V.N.Bedekar Institute of Management Studies > Thane(W) 400601 > MUMBAI. INDIA > @@ > email: sandeep.bhav...@gmail.com > Mob : 9029 345777 > elibrary :http://www.vpmthane.org/im/elib/main.htm > @@ > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] How to Delete Records with no Item
Dear Amit, Thanks for your quick reply, I try the steps you write to me, /usr/share/koha/bin/migration_tool# ./rebuild_zebra.pl -b -r -x But this step not work for me, the records are still there with no items. Any further help is required in this regards Thanks in advance //sunil On Sat, May 19, 2012 at 5:15 PM, amit bondwal wrote: > Hi sunil. > > You can rebuild zebra by running following command. > > /usr/share/koha/bin/migration_tool# ./rebuild_zebra.pl -b -r -x > > it will reset your zebra settings and will rebuild it. > Try this may be this can help you. > > > > On Sat, May 19, 2012 at 5:11 PM, sunil sharma [via Koha] > wrote: > > Dear All, > > > > I am Sunil, currently facing a problem. I am working on koha 3.06.04. And > > in my koha there are a lot of record entry in which there are no item > > added. And I want to remove all of them in one go because there are a lot > > of such entries in my database where no item is added in my framework > > records. So anyone suggest me in this regard is helpful to me. > > > > Thanks in advance, > > Sunil > > ___ > > Koha mailing list http://koha-community.org > > [hidden email] > > http://lists.katipo.co.nz/mailman/listinfo/koha > > > > > > > > If you reply to this email, your message will be added to the discussion > > below: > > > http://koha.1045719.n5.nabble.com/How-to-Delete-Records-with-no-Item-tp5712285.html > > To unsubscribe from Koha, click here. > > NAML > > > -- > View this message in context: > http://koha.1045719.n5.nabble.com/How-to-Delete-Records-with-no-Item-tp5712285p5712287.html > Sent from the Koha-general mailing list archive at Nabble.com. > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] How to Delete Records with no Item
Dear All, I am Sunil, currently facing a problem. I am working on koha 3.06.04. And in my koha there are a lot of record entry in which there are no item added. And I want to remove all of them in one go because there are a lot of such entries in my database where no item is added in my framework records. So anyone suggest me in this regard is helpful to me. Thanks in advance, Sunil ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Want to add more feature or module in koha
Dear All, I am Sunil from India and I want to start my carrier with koha, open-source Integrated Library System. I am working at koha from last 4 months and currently at some developing level, I observe all the feature of koha but I want to add some more feature in koha-community's koha like in liblime koha, which are: 1. Libraries can create new receipt templates for reach library by clicking New Receipt Template in the Receipt Template Manager which we add in any sys pref i.e. at Tools. (in other words: Koha will features customizable print slips and a management interface for the creation, alteration, saving, and deleting of customize print slips & circulation receipts). 2. Koha features a rich set of features around holds: including: - Ability to fill local holds first (thus reducing transportation costs) - Enriched holds queue report, including sort and pagination support for large list printing and functionality so a hold can be filled (triggered) or passed to another library directly from the report - New hold notices – for holds canceled and/or expired 3. the last I want to generate my report in word format also, as by default it is in csv format. Hope the community help me on these topics. Thanks in Advance, Sunil ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
