Re: [Koha] Zebra Error
Check if you've got the directory /usr/lib/idzebra-2.0/modules or the directory /usr/lib64/idzebra-2.0/modules on your server. Chances are it'll be the second option. If so, edit these four files /etc/koha/zebradb/zebra-authorities.cfg /etc/koha/zebradb/zebra-authorities-dom.cfg /etc/koha/zebradb/zebra-biblios.cfg /etc/koha/zebradb/zebra-biblios-dom.cfg In each, change the line reading: modulePath: /usr/lib/idzebra-2.0/modules to modulePath: /usr/lib64/idzebra-2.0/modules And then try reindexing your records. You could also try using the -x switch when reindexing I suppose there should be a bug filed for the incorrect module path on 64bit machines when installed via the tarball. I know that it is among the patches I apply manually whenever I upgrade a system. (Gave me no end of grief the first time) God bless, Nicholas ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Zebra Error
Hi, On Tue, Jun 3, 2014 at 11:19 AM, Nicholas van Rheede van Oudtshoorn vano...@gmail.com wrote: Are you on a 64bit system or a 32bit one. I know that on fedora 64, one has to adjust the zebra config files to point the modulepath to lib64 rather than lib Nick On Tue, Jun 3, 2014 at 1:44 PM, Mayank Srivastava mayanksri1...@gmail.com wrote: Didn't work :( yep that modulepath is known to give a bit of grief unless configured right. but then you are saying it is set right. so /me out of ideas atm :( What do you use for installation? Debian Wheezy 64-bit and Koha .deb packages cheers, -- Indranil Das Gupta Phone : +91-98300-20971 Blog: http://indradg.randomink.org/blog IRC : indradg on irc://irc.freenode.net Twitter : indradg -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=- Please exchange editable Office documents only in ODF Format. No other format is acceptable. Support Open Standards. For a free editor supporting ODF, please visit LibreOffice - http://www.documentfoundation.org ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Zebra Error
Hmmm - afraid I'm out of my depths too, then :-( Sorry - and best of luck! On Tue, Jun 3, 2014 at 2:03 PM, Indranil Das Gupta indr...@gmail.com wrote: Hi, On Tue, Jun 3, 2014 at 11:19 AM, Nicholas van Rheede van Oudtshoorn vano...@gmail.com wrote: Are you on a 64bit system or a 32bit one. I know that on fedora 64, one has to adjust the zebra config files to point the modulepath to lib64 rather than lib Nick On Tue, Jun 3, 2014 at 1:44 PM, Mayank Srivastava mayanksri1...@gmail.com wrote: Didn't work :( yep that modulepath is known to give a bit of grief unless configured right. but then you are saying it is set right. so /me out of ideas atm :( What do you use for installation? Debian Wheezy 64-bit and Koha .deb packages cheers, -- Indranil Das Gupta Phone : +91-98300-20971 Blog: http://indradg.randomink.org/blog IRC : indradg on irc://irc.freenode.net Twitter : indradg -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=- Please exchange editable Office documents only in ODF Format. No other format is acceptable. Support Open Standards. For a free editor supporting ODF, please visit LibreOffice - http://www.documentfoundation.org ___ 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] Zebra Error
Hi Nicholas, You were right, I updated the paths. While re-indexing i got some errors, I have attached them. When I search something, i get the following error: *Search biblios ERROR 114 1 1+0 RPN @attrset Bib-1 @attr 1=1016 @attr 4=6 @attr 5=1 states* Earlier the error code was: 109. Kindly look into them and help if possible. Thanks in advance! Regards Mayank Srivastava On Tue, Jun 3, 2014 at 11:31 AM, Nicholas van Rheede van Oudtshoorn vano...@gmail.com wrote: Check if you've got the directory /usr/lib/idzebra-2.0/modules or the directory /usr/lib64/idzebra-2.0/modules on your server. Chances are it'll be the second option. If so, edit these four files /etc/koha/zebradb/zebra-authorities.cfg /etc/koha/zebradb/zebra-authorities-dom.cfg /etc/koha/zebradb/zebra-biblios.cfg /etc/koha/zebradb/zebra-biblios-dom.cfg In each, change the line reading: modulePath: /usr/lib/idzebra-2.0/modules to modulePath: /usr/lib64/idzebra-2.0/modules And then try reindexing your records. You could also try using the -x switch when reindexing I suppose there should be a bug filed for the incorrect module path on 64bit machines when installed via the tarball. I know that it is among the patches I apply manually whenever I upgrade a system. (Gave me no end of grief the first time) God bless, Nicholas -- *Mayank Srivastava* Mob: +91 971 851 6955 New Delhi, India 11:51:07-03/06 zebraidx(20753) [log] zebra_start 2.0.47 e4e44d1916c6e80e01aad163b487ee41c22272ba 11:51:07-03/06 zebraidx(20753) [log] config /opt/koha-3.14.04/conf/etc/zebradb/zebra-biblios-dom.cfg 11:51:07-03/06 zebraidx(20753) [log] Loaded filter module /usr/lib64/idzebra-2.0/modules/mod-dom.so 11:51:07-03/06 zebraidx(20753) [log] Loaded filter module /usr/lib64/idzebra-2.0/modules/mod-safari.so 11:51:07-03/06 zebraidx(20753) [log] Loaded filter module /usr/lib64/idzebra-2.0/modules/mod-grs-marc.so 11:51:07-03/06 zebraidx(20753) [log] Loaded filter module /usr/lib64/idzebra-2.0/modules/mod-grs-xml.so 11:51:07-03/06 zebraidx(20753) [log] Loaded filter module /usr/lib64/idzebra-2.0/modules/mod-text.so 11:51:07-03/06 zebraidx(20753) [log] Loaded filter module /usr/lib64/idzebra-2.0/modules/mod-alvis.so 11:51:07-03/06 zebraidx(20753) [log] Loaded filter module /usr/lib64/idzebra-2.0/modules/mod-grs-regx.so 11:51:07-03/06 zebraidx(20753) [log] enabling shadow spec=/opt/koha-3.14.04/conf/var/lib/zebradb/biblios/shadow:30G 11:51:07-03/06 zebraidx(20753) [log] cache_fname = /opt/koha-3.14.04/conf/var/lib/zebradb/biblios/shadow/cache 11:51:07-03/06 zebraidx(20753) [log] dir /tmp/0GTdgg1wga/biblio 11:51:07-03/06 zebraidx(20753) [log] /opt/koha-3.14.04/conf/etc/zebradb/biblios/etc/dom-config.xml dom filter: loading config file /opt/koha-3.14.04/conf/etc/zebradb/biblios/etc/dom-config.xml 11:51:07-03/06 zebraidx(20753) [log] skip dom./opt/koha-3.14.04/conf/etc/zebradb/biblios/etc/dom-config.xml /tmp/0GTdgg1wga/biblio/exported_records 0 11:51:07-03/06 zebraidx(20753) [log] skip dom./opt/koha-3.14.04/conf/etc/zebradb/biblios/etc/dom-config.xml /tmp/0GTdgg1wga/biblio/exported_records 4100 11:51:07-03/06 zebraidx(20753) [log] skip dom./opt/koha-3.14.04/conf/etc/zebradb/biblios/etc/dom-config.xml /tmp/0GTdgg1wga/biblio/exported_records 4100 11:51:07-03/06 zebraidx(20753) [log] skip dom./opt/koha-3.14.04/conf/etc/zebradb/biblios/etc/dom-config.xml /tmp/0GTdgg1wga/biblio/exported_records 4100 11:51:07-03/06 zebraidx(20753) [log] skip dom./opt/koha-3.14.04/conf/etc/zebradb/biblios/etc/dom-config.xml /tmp/0GTdgg1wga/biblio/exported_records 4100 11:51:07-03/06 zebraidx(20753) [log] skip dom./opt/koha-3.14.04/conf/etc/zebradb/biblios/etc/dom-config.xml /tmp/0GTdgg1wga/biblio/exported_records 4100 11:51:07-03/06 zebraidx(20753) [log] skip dom./opt/koha-3.14.04/conf/etc/zebradb/biblios/etc/dom-config.xml /tmp/0GTdgg1wga/biblio/exported_records 4100 11:51:07-03/06 zebraidx(20753) [log] skip dom./opt/koha-3.14.04/conf/etc/zebradb/biblios/etc/dom-config.xml /tmp/0GTdgg1wga/biblio/exported_records 4100 11:51:07-03/06 zebraidx(20753) [log] skip dom./opt/koha-3.14.04/conf/etc/zebradb/biblios/etc/dom-config.xml /tmp/0GTdgg1wga/biblio/exported_records 4100 11:51:07-03/06 zebraidx(20753) [log] skip dom./opt/koha-3.14.04/conf/etc/zebradb/biblios/etc/dom-config.xml /tmp/0GTdgg1wga/biblio/exported_records 4100 11:51:07-03/06 zebraidx(20753) [log] skip dom./opt/koha-3.14.04/conf/etc/zebradb/biblios/etc/dom-config.xml /tmp/0GTdgg1wga/biblio/exported_records 4100 11:51:07-03/06 zebraidx(20753) [log] skip dom./opt/koha-3.14.04/conf/etc/zebradb/biblios/etc/dom-config.xml /tmp/0GTdgg1wga/biblio/exported_records 4100 11:51:07-03/06 zebraidx(20753) [log] skip dom./opt/koha-3.14.04/conf/etc/zebradb/biblios/etc/dom-config.xml /tmp/0GTdgg1wga/biblio/exported_records 4100 11:51:07-03/06 zebraidx(20753) [log] skip
Re: [Koha] Zebra Error
H - step in the right direction How long is that etc/zebradb/biblios/etc/dom-config.xml file? That is, how many lines? Is it 54 lines long? On Tue, Jun 3, 2014 at 2:25 PM, Mayank Srivastava mayanksri1...@gmail.com wrote: Hi Nicholas, You were right, I updated the paths. While re-indexing i got some errors, I have attached them. When I search something, i get the following error: *Search biblios ERROR 114 1 1+0 RPN @attrset Bib-1 @attr 1=1016 @attr 4=6 @attr 5=1 states* Earlier the error code was: 109. Kindly look into them and help if possible. Thanks in advance! Regards Mayank Srivastava On Tue, Jun 3, 2014 at 11:31 AM, Nicholas van Rheede van Oudtshoorn vano...@gmail.com wrote: Check if you've got the directory /usr/lib/idzebra-2.0/modules or the directory /usr/lib64/idzebra-2.0/modules on your server. Chances are it'll be the second option. If so, edit these four files /etc/koha/zebradb/zebra-authorities.cfg /etc/koha/zebradb/zebra-authorities-dom.cfg /etc/koha/zebradb/zebra-biblios.cfg /etc/koha/zebradb/zebra-biblios-dom.cfg In each, change the line reading: modulePath: /usr/lib/idzebra-2.0/modules to modulePath: /usr/lib64/idzebra-2.0/modules And then try reindexing your records. You could also try using the -x switch when reindexing I suppose there should be a bug filed for the incorrect module path on 64bit machines when installed via the tarball. I know that it is among the patches I apply manually whenever I upgrade a system. (Gave me no end of grief the first time) God bless, Nicholas -- *Mayank Srivastava* Mob: +91 971 851 6955 New Delhi, India ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Zebra Error
Yes 54 lines. On Tue, Jun 3, 2014 at 11:59 AM, Nicholas van Rheede van Oudtshoorn vano...@gmail.com wrote: H - step in the right direction How long is that etc/zebradb/biblios/etc/dom-config.xml file? That is, how many lines? Is it 54 lines long? On Tue, Jun 3, 2014 at 2:25 PM, Mayank Srivastava mayanksri1...@gmail.com wrote: Hi Nicholas, You were right, I updated the paths. While re-indexing i got some errors, I have attached them. When I search something, i get the following error: *Search biblios ERROR 114 1 1+0 RPN @attrset Bib-1 @attr 1=1016 @attr 4=6 @attr 5=1 states* Earlier the error code was: 109. Kindly look into them and help if possible. Thanks in advance! Regards Mayank Srivastava On Tue, Jun 3, 2014 at 11:31 AM, Nicholas van Rheede van Oudtshoorn vano...@gmail.com wrote: Check if you've got the directory /usr/lib/idzebra-2.0/modules or the directory /usr/lib64/idzebra-2.0/modules on your server. Chances are it'll be the second option. If so, edit these four files /etc/koha/zebradb/zebra-authorities.cfg /etc/koha/zebradb/zebra-authorities-dom.cfg /etc/koha/zebradb/zebra-biblios.cfg /etc/koha/zebradb/zebra-biblios-dom.cfg In each, change the line reading: modulePath: /usr/lib/idzebra-2.0/modules to modulePath: /usr/lib64/idzebra-2.0/modules And then try reindexing your records. You could also try using the -x switch when reindexing I suppose there should be a bug filed for the incorrect module path on 64bit machines when installed via the tarball. I know that it is among the patches I apply manually whenever I upgrade a system. (Gave me no end of grief the first time) God bless, Nicholas -- *Mayank Srivastava* Mob: +91 971 851 6955 New Delhi, India -- *Mayank Srivastava* Mob: +91 971 851 6955 New Delhi, India ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Zebra Error
H - in that case Mayank, I'm afraid I'm out of ideas! Maybe someone else can chime in on this one? Nick On Tue, Jun 3, 2014 at 2:31 PM, Mayank Srivastava mayanksri1...@gmail.com wrote: Yes 54 lines. On Tue, Jun 3, 2014 at 11:59 AM, Nicholas van Rheede van Oudtshoorn vano...@gmail.com wrote: H - step in the right direction How long is that etc/zebradb/biblios/etc/dom-config.xml file? That is, how many lines? Is it 54 lines long? On Tue, Jun 3, 2014 at 2:25 PM, Mayank Srivastava mayanksri1...@gmail.com wrote: Hi Nicholas, You were right, I updated the paths. While re-indexing i got some errors, I have attached them. When I search something, i get the following error: *Search biblios ERROR 114 1 1+0 RPN @attrset Bib-1 @attr 1=1016 @attr 4=6 @attr 5=1 states* Earlier the error code was: 109. Kindly look into them and help if possible. Thanks in advance! Regards Mayank Srivastava On Tue, Jun 3, 2014 at 11:31 AM, Nicholas van Rheede van Oudtshoorn vano...@gmail.com wrote: Check if you've got the directory /usr/lib/idzebra-2.0/modules or the directory /usr/lib64/idzebra-2.0/modules on your server. Chances are it'll be the second option. If so, edit these four files /etc/koha/zebradb/zebra-authorities.cfg /etc/koha/zebradb/zebra-authorities-dom.cfg /etc/koha/zebradb/zebra-biblios.cfg /etc/koha/zebradb/zebra-biblios-dom.cfg In each, change the line reading: modulePath: /usr/lib/idzebra-2.0/modules to modulePath: /usr/lib64/idzebra-2.0/modules And then try reindexing your records. You could also try using the -x switch when reindexing I suppose there should be a bug filed for the incorrect module path on 64bit machines when installed via the tarball. I know that it is among the patches I apply manually whenever I upgrade a system. (Gave me no end of grief the first time) God bless, Nicholas -- *Mayank Srivastava* Mob: +91 971 851 6955 New Delhi, India -- *Mayank Srivastava* Mob: +91 971 851 6955 New Delhi, India ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Zebra Error
Thanks for the help Nick, I'll keep trying, will let you know once its done! :) On Tue, Jun 3, 2014 at 12:07 PM, Nicholas van Rheede van Oudtshoorn vano...@gmail.com wrote: H - in that case Mayank, I'm afraid I'm out of ideas! Maybe someone else can chime in on this one? Nick On Tue, Jun 3, 2014 at 2:31 PM, Mayank Srivastava mayanksri1...@gmail.com wrote: Yes 54 lines. On Tue, Jun 3, 2014 at 11:59 AM, Nicholas van Rheede van Oudtshoorn vano...@gmail.com wrote: H - step in the right direction How long is that etc/zebradb/biblios/etc/dom-config.xml file? That is, how many lines? Is it 54 lines long? On Tue, Jun 3, 2014 at 2:25 PM, Mayank Srivastava mayanksri1...@gmail.com wrote: Hi Nicholas, You were right, I updated the paths. While re-indexing i got some errors, I have attached them. When I search something, i get the following error: *Search biblios ERROR 114 1 1+0 RPN @attrset Bib-1 @attr 1=1016 @attr 4=6 @attr 5=1 states* Earlier the error code was: 109. Kindly look into them and help if possible. Thanks in advance! Regards Mayank Srivastava On Tue, Jun 3, 2014 at 11:31 AM, Nicholas van Rheede van Oudtshoorn vano...@gmail.com wrote: Check if you've got the directory /usr/lib/idzebra-2.0/modules or the directory /usr/lib64/idzebra-2.0/modules on your server. Chances are it'll be the second option. If so, edit these four files /etc/koha/zebradb/zebra-authorities.cfg /etc/koha/zebradb/zebra-authorities-dom.cfg /etc/koha/zebradb/zebra-biblios.cfg /etc/koha/zebradb/zebra-biblios-dom.cfg In each, change the line reading: modulePath: /usr/lib/idzebra-2.0/modules to modulePath: /usr/lib64/idzebra-2.0/modules And then try reindexing your records. You could also try using the -x switch when reindexing I suppose there should be a bug filed for the incorrect module path on 64bit machines when installed via the tarball. I know that it is among the patches I apply manually whenever I upgrade a system. (Gave me no end of grief the first time) God bless, Nicholas -- *Mayank Srivastava* Mob: +91 971 851 6955 New Delhi, India -- *Mayank Srivastava* Mob: +91 971 851 6955 New Delhi, India -- *Mayank Srivastava* Mob: +91 971 851 6955 New Delhi, India ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Zebra Error
Hi Nick, The problem was solved by your suggestion, it was because of some debug code I had written in the script which was causing problem after that. I took a fresh copy and ran the re-indexing and now my search works. Thanks everyone in the thread for their help! God Bless! Mayank On Tue, Jun 3, 2014 at 12:09 PM, Mayank Srivastava mayanksri1...@gmail.com wrote: Thanks for the help Nick, I'll keep trying, will let you know once its done! :) On Tue, Jun 3, 2014 at 12:07 PM, Nicholas van Rheede van Oudtshoorn vano...@gmail.com wrote: H - in that case Mayank, I'm afraid I'm out of ideas! Maybe someone else can chime in on this one? Nick On Tue, Jun 3, 2014 at 2:31 PM, Mayank Srivastava mayanksri1...@gmail.com wrote: Yes 54 lines. On Tue, Jun 3, 2014 at 11:59 AM, Nicholas van Rheede van Oudtshoorn vano...@gmail.com wrote: H - step in the right direction How long is that etc/zebradb/biblios/etc/dom-config.xml file? That is, how many lines? Is it 54 lines long? On Tue, Jun 3, 2014 at 2:25 PM, Mayank Srivastava mayanksri1...@gmail.com wrote: Hi Nicholas, You were right, I updated the paths. While re-indexing i got some errors, I have attached them. When I search something, i get the following error: *Search biblios ERROR 114 1 1+0 RPN @attrset Bib-1 @attr 1=1016 @attr 4=6 @attr 5=1 states* Earlier the error code was: 109. Kindly look into them and help if possible. Thanks in advance! Regards Mayank Srivastava On Tue, Jun 3, 2014 at 11:31 AM, Nicholas van Rheede van Oudtshoorn vano...@gmail.com wrote: Check if you've got the directory /usr/lib/idzebra-2.0/modules or the directory /usr/lib64/idzebra-2.0/modules on your server. Chances are it'll be the second option. If so, edit these four files /etc/koha/zebradb/zebra-authorities.cfg /etc/koha/zebradb/zebra-authorities-dom.cfg /etc/koha/zebradb/zebra-biblios.cfg /etc/koha/zebradb/zebra-biblios-dom.cfg In each, change the line reading: modulePath: /usr/lib/idzebra-2.0/modules to modulePath: /usr/lib64/idzebra-2.0/modules And then try reindexing your records. You could also try using the -x switch when reindexing I suppose there should be a bug filed for the incorrect module path on 64bit machines when installed via the tarball. I know that it is among the patches I apply manually whenever I upgrade a system. (Gave me no end of grief the first time) God bless, Nicholas -- *Mayank Srivastava* Mob: +91 971 851 6955 New Delhi, India -- *Mayank Srivastava* Mob: +91 971 851 6955 New Delhi, India -- *Mayank Srivastava* Mob: +91 971 851 6955 New Delhi, India -- *Mayank Srivastava* Mob: +91 971 851 6955 New Delhi, India ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Zebra Error
Fantastic to hear! Although I think Indranil had the same suggestion, now that I read through the thread! Good luck with your further koha adventures!! God bless, Nick On Tue, Jun 3, 2014 at 3:15 PM, Mayank Srivastava mayanksri1...@gmail.com wrote: Hi Nick, The problem was solved by your suggestion, it was because of some debug code I had written in the script which was causing problem after that. I took a fresh copy and ran the re-indexing and now my search works. Thanks everyone in the thread for their help! God Bless! Mayank On Tue, Jun 3, 2014 at 12:09 PM, Mayank Srivastava mayanksri1...@gmail.com wrote: Thanks for the help Nick, I'll keep trying, will let you know once its done! :) On Tue, Jun 3, 2014 at 12:07 PM, Nicholas van Rheede van Oudtshoorn vano...@gmail.com wrote: H - in that case Mayank, I'm afraid I'm out of ideas! Maybe someone else can chime in on this one? Nick On Tue, Jun 3, 2014 at 2:31 PM, Mayank Srivastava mayanksri1...@gmail.com wrote: Yes 54 lines. On Tue, Jun 3, 2014 at 11:59 AM, Nicholas van Rheede van Oudtshoorn vano...@gmail.com wrote: H - step in the right direction How long is that etc/zebradb/biblios/etc/dom-config.xml file? That is, how many lines? Is it 54 lines long? On Tue, Jun 3, 2014 at 2:25 PM, Mayank Srivastava mayanksri1...@gmail.com wrote: Hi Nicholas, You were right, I updated the paths. While re-indexing i got some errors, I have attached them. When I search something, i get the following error: *Search biblios ERROR 114 1 1+0 RPN @attrset Bib-1 @attr 1=1016 @attr 4=6 @attr 5=1 states* Earlier the error code was: 109. Kindly look into them and help if possible. Thanks in advance! Regards Mayank Srivastava On Tue, Jun 3, 2014 at 11:31 AM, Nicholas van Rheede van Oudtshoorn vano...@gmail.com wrote: Check if you've got the directory /usr/lib/idzebra-2.0/modules or the directory /usr/lib64/idzebra-2.0/modules on your server. Chances are it'll be the second option. If so, edit these four files /etc/koha/zebradb/zebra-authorities.cfg /etc/koha/zebradb/zebra-authorities-dom.cfg /etc/koha/zebradb/zebra-biblios.cfg /etc/koha/zebradb/zebra-biblios-dom.cfg In each, change the line reading: modulePath: /usr/lib/idzebra-2.0/modules to modulePath: /usr/lib64/idzebra-2.0/modules And then try reindexing your records. You could also try using the -x switch when reindexing I suppose there should be a bug filed for the incorrect module path on 64bit machines when installed via the tarball. I know that it is among the patches I apply manually whenever I upgrade a system. (Gave me no end of grief the first time) God bless, Nicholas -- *Mayank Srivastava* Mob: +91 971 851 6955 New Delhi, India -- *Mayank Srivastava* Mob: +91 971 851 6955 New Delhi, India -- *Mayank Srivastava* Mob: +91 971 851 6955 New Delhi, India -- *Mayank Srivastava* Mob: +91 971 851 6955 New Delhi, India ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Focus lost when using barcode scanner
What browser are you using ? Do you have some code in preference intranetuserjs ? Le 03/06/2014 02:22, Marty a écrit : Thanks for your answer. I cleared the browser cache, but that does not seem to make any difference. And yes, it is using /circ/returns.pl It is doing exactly the same for checkout, but in both cases only when I use the barcode scanner. It is a keyboard wedge scanner we have been using for quite a while, and it scans fine. I do not really know where to go from here, if you have any other ideas, keep them coming. Thanks, Marty On Wednesday, May 21, 2014 1:59:06 PM, Fridolin SOMERS fridolin.som...@biblibre.com wrote: For check-in, are you using page : /circ/returns.pl ? You may clear your browser cache. Best regards, Le 20/05/2014 04:08, Marty a écrit : I have been really puzzled about this one, and I do not know if this is a koha issue, but maybe people have had the same problem. When I scan a barcode for checking out or checking in I loose focus after scanning the first item, I have to click on the box to get my focus back. The focus seems to move to the search box. Obviously this is really annoying if you have to scan more than one item. This behaviour started after I upgraded to Wheezy. When I type in barcodes manually there are no issues. When I scan barcodes in gedit, the behaviour seems to be exactly the same as when I type the barcode. So, if I scan barcode 12345, it shows that barcode and the cursor ends up on the next line, same as when I type the barcode and hit enter. Using Koha 3.15.00.029 on Linux debian 3.2.57-3 i686 GNU / Linux ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Fridolin SOMERS Biblibre - Pôles support et système fridolin.som...@biblibre.com ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] JQuery Help to Choose Tab
Hie,
I think I have a working code.
It simply simulates the user click on the tab title :
$(document).ready(function(){
$(#header_search a[href='#catalog_search']).click();
});
Best regards,
Le 03/06/2014 04:38, Nicole Engard a écrit :
Hi all,
I'm wondering if you could help. I want to have 'Search the Catalog'
selected first on the main staff client page, but the code has changed A
LOT in 3.16 and my old JQuery doesn't work. Any tips on how to write this
would be appreciated because my attempts have failed.
Nicole
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
--
Fridolin SOMERS
Biblibre - Pôles support et système
fridolin.som...@biblibre.com
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] report for items in transit
Hi, I am looking for a report for all items which are in transit. Thanks in advance. Vikram Zadgaonkar ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Statistic for daily catalogers achievement in date range
Hi all , some libraries need to monitor the achievement of their catalogers , I added 2 new reports to the wiki page , I hope it will be helpful for some libraries . http://wiki.koha-community.org/wiki/SQL_Reports_Library#Statistic_for_daily_catalogers_achievement_in_date_range_for_bib_records Statistic for daily catalogers achievement in date range for bib records - *Developer:* Karam Qubsi - *Module:* Cataloging - *Purpose:* Statistic for daily catalogers achievement in date range for bib records (you can change the date range I make it for the whole 2014 year in this example ) - *Status:* Complete SELECT DATE_FORMAT(I.timestamp, '%d-%c-%Y') AS Date, B.userid AS Staff, count(I.timestamp) AS CountFROM action_logs ILEFT JOIN borrowers BON I.user=B.borrowernumberWHERE I.module='CATALOGUING' AND I.action='ADD' AND date(I.timestamp) BETWEEN '2014-01-01' AND '2014-12-31' AND I.info!='biblio'GROUP BY Date,B.useridORDER BY DATE(timestamp) DESC [edit http://wiki.koha-community.org/w/index.php?title=SQL_Reports_Libraryaction=editsection=264 ]Statistic for daily catalogers achievement in date range for Item records - *Developer:* Karam Qubsi - *Module:* Cataloging - *Purpose:* Statistic for daily catalogers achievement in date range for item records (you can change the date range I make it for the whole 2014 year in this example ) - *Status:* Complete SELECT DATE_FORMAT(I.timestamp, '%d-%c-%Y') AS Date, B.userid AS Staff, count(I.timestamp) AS CountFROM action_logs ILEFT JOIN borrowers BON I.user=B.borrowernumberWHERE I.module='CATALOGUING' AND I.action='ADD' AND date(I.timestamp) BETWEEN '2014-01-01' AND '2014-12-31' AND I.info!='item'GROUP BY Date,B.useridORDER BY DATE(timestamp) DESC Bests -- *Karam Qubsi* ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Suggestion Management: Customizing the Order of Navigation Status Tabs
Hello, We are trying to customize the order in which the *navigation status tabs* must be appearing in suggestion management of Acquisition module in KOHA. By default its taking the order Accepted---Pending---Checked---Ordered we need it in a specific order Pending---Accepted---Checked---Ordered And by default *Pending Tab* must be selected when we open the Suggestion management Please Help Us. Any Pointers will be appreciated. Thanks in advance Regards ARUNKUMAR National Institute of Oceanography Dona-Paula, Goa, India ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] report for items in transit
We don't really use in transit, but I think this should do what you want: SELECT bt.itemnumber, b.title, i.itemcallnumber, i.barcode, bt.datesent, bt.frombranch, bt.tobranch FROM branchtransfers bt LEFT JOIN items i USING (itemnumber) LEFT JOIN biblio b USING (biblionumber) WHERE bt.datearrived IS NULL Katelyn Browne Middle/High School Librarian Capital City Public Charter School 100 Peabody Street NW Washington, DC 20011 (202) 387-0309 x1745 kbro...@ccpcs.org http://www.ccpcs.org/library/ On Tue, Jun 3, 2014 at 5:59 AM, vikram zadgaonkar vikramczadgaon...@gmail.com wrote: Hi, I am looking for a report for all items which are in transit. Thanks in advance. Vikram Zadgaonkar ___ 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] JQuery Help to Choose Tab
On Tue, Jun 3, 2014 at 12:58 AM, Fridolin SOMERS
fridolin.som...@biblibre.com wrote:
$(document).ready(function(){
$(#header_search a[href='#catalog_search']).click();
});
That works on every page in the staff client, but if I wanted it to work on
the main page only so I edited it like this:
$(document).ready(function(){
if (window.location.href.indexOf(cgi-bin/koha/mainpage.pl) -1) {
$(#header_search a[href='#catalog_search']).click();
}
});
And it's perfect!!! Thanks Fridolin!
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] report for items in transit
Thanks a lot. Its working. Vikram Zadgaonkar On Tue, Jun 3, 2014 at 6:04 PM, Katelyn Browne kbro...@ccpcs.org wrote: We don't really use in transit, but I think this should do what you want: SELECT bt.itemnumber, b.title, i.itemcallnumber, i.barcode, bt.datesent, bt.frombranch, bt.tobranch FROM branchtransfers bt LEFT JOIN items i USING (itemnumber) LEFT JOIN biblio b USING (biblionumber) WHERE bt.datearrived IS NULL Katelyn Browne Middle/High School Librarian Capital City Public Charter School 100 Peabody Street NW Washington, DC 20011 (202) 387-0309 x1745 kbro...@ccpcs.org http://www.ccpcs.org/library/ On Tue, Jun 3, 2014 at 5:59 AM, vikram zadgaonkar vikramczadgaon...@gmail.com wrote: Hi, I am looking for a report for all items which are in transit. Thanks in advance. Vikram Zadgaonkar ___ 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] JQuery Help to Choose Tab
Much faster and simple : each page (intranet and opac) has an id on the
body :
For example for mainpage :
$(document).ready(function(){
$(body#main_intranet-main #header_search
a[href='#catalog_search']).click();
});
Le 03/06/2014 15:19, Nicole Engard a écrit :
On Tue, Jun 3, 2014 at 12:58 AM, Fridolin SOMERS
fridolin.som...@biblibre.com wrote:
$(document).ready(function(){
$(#header_search a[href='#catalog_search']).click();
});
That works on every page in the staff client, but if I wanted it to work on
the main page only so I edited it like this:
$(document).ready(function(){
if (window.location.href.indexOf(cgi-bin/koha/mainpage.pl) -1) {
$(#header_search a[href='#catalog_search']).click();
}
});
And it's perfect!!! Thanks Fridolin!
--
Fridolin SOMERS
Biblibre - Pôles support et système
fridolin.som...@biblibre.com
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Statistic for daily catalogers achievement in date range
Does this require the cataloging logs to be turned on? Ours our turned off because it slows down things too much. __ Cecil Hillyard Washoe County Library -Tel: 775-327-8338 or 7750-327-8330 fax: 775-327-8334 -Original Message- From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Karam Qubsi Sent: Tuesday, June 03, 2014 3:02 AM To: Koha Subject: [Koha] Statistic for daily catalogers achievement in date range Hi all , some libraries need to monitor the achievement of their catalogers , I added 2 new reports to the wiki page , I hope it will be helpful for some libraries . http://wiki.koha-community.org/wiki/SQL_Reports_Library#Statistic_for_daily_catalogers_achievement_in_date_range_for_bib_records Statistic for daily catalogers achievement in date range for bib records - *Developer:* Karam Qubsi - *Module:* Cataloging - *Purpose:* Statistic for daily catalogers achievement in date range for bib records (you can change the date range I make it for the whole 2014 year in this example ) - *Status:* Complete SELECT DATE_FORMAT(I.timestamp, '%d-%c-%Y') AS Date, B.userid AS Staff, count(I.timestamp) AS CountFROM action_logs ILEFT JOIN borrowers BON I.user=B.borrowernumberWHERE I.module='CATALOGUING' AND I.action='ADD' AND date(I.timestamp) BETWEEN '2014-01-01' AND '2014-12-31' AND I.info!='biblio'GROUP BY Date,B.useridORDER BY DATE(timestamp) DESC [edit http://wiki.koha-community.org/w/index.php?title=SQL_Reports_Libraryaction=editsection=264 ]Statistic for daily catalogers achievement in date range for Item records - *Developer:* Karam Qubsi - *Module:* Cataloging - *Purpose:* Statistic for daily catalogers achievement in date range for item records (you can change the date range I make it for the whole 2014 year in this example ) - *Status:* Complete SELECT DATE_FORMAT(I.timestamp, '%d-%c-%Y') AS Date, B.userid AS Staff, count(I.timestamp) AS CountFROM action_logs ILEFT JOIN borrowers BON I.user=B.borrowernumberWHERE I.module='CATALOGUING' AND I.action='ADD' AND date(I.timestamp) BETWEEN '2014-01-01' AND '2014-12-31' AND I.info!='item'GROUP BY Date,B.useridORDER BY DATE(timestamp) DESC Bests -- *Karam Qubsi* ___ 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] Wipe Koha database (just auth and biblio records)
Hi Robin!
So you agree with me that Appendix F (Resetting the Koha Database) of
current (v3.16) manual is wrong?
2014-06-02 20:21 GMT-03:00 Robin Sheat ro...@catalyst.net.nz:
Pablo Bianchi schreef op ma 02-06-2014 om 14:33 [-0300]:
Am I right? This could be risky, having side effects?
This could have nasty side-effects.
By turning off the
constraint checks, you're not going to have any
messages telling you reasons why you shouldn't do what you're doing. For
example, circulation history, serial subscriptions, reserves, and
anything else that links with biblios and/or items aren't going to be
cleared. This means that you'll have entries in them pointing to things
that don't exist.
Problems that we can avoid just with *DELETE FROM biblio*?
Some better solutions might be to:
* Do 'DELETE FROM table;' and then reset the auto numbering back
to 1, something like 'ALTER TABLE table AUTO INCREMENT=1;'
This'll ensure that things that should be deleted via
constraints will be, or it won't let you do it. Also ensure that
things that aren't constraint-linked are deleted (I think
old_issues is one of these.)
Despite the autoincrement issue, the *DELETE FROM biblio* way wasn't
working for me. Now I'm not being able to reproduce the error, but I
remember was very similar than with truncate, about *foreign key constraint*
*.*
I wonder why with -d option of bulkmarcimport.pl I had similar problems
than with TRUNCATE, throw to stderr something like:
*#1701 - Cannot truncate a table referenced in a foreign key constraint
(`koha_MyInstance`.`aqorders`, CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY
(`biblionumber`) REFERENCES `koha_MyInstance`.`biblio` (`biblionumber`))*
What we can expect just taking a look to the source code:
*if ($delete) {*
* if ($biblios){*
*print deleting biblios\n;*
*$dbh-do(truncate biblio);*
* $dbh-do(truncate biblioitems);*
*$dbh-do(truncate items);*
* } else {*
*print deleting authorities\n;*
*$dbh-do(truncate auth_header);*
* }*
* $dbh-do(truncate zebraqueue);*
*}*
If this way is the right one, considering constraint checks, I can't see
why we can't use it. Perhaps we can set up something differently in
my.cnf...
Regards,
Pablo
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Wipe Koha database (just auth and biblio records)
Pablo, it's about relational integrity: if you turn foreign keys constrains
off, then OF COURSE you'll be able to delete whatever you want, and end up
with an inconsistent database.
As Robin pointed, using DELETE FROM, instead, will raise the ERRORS YOU
NEED TO BE AWARE OF, so you can acknowledge them, and make sure the db is
consistent. I.e. it will force you to delete linked data BEFORE you delete
the referenced one.
Regards
To+
El 03/06/2014 12:22, Pablo Bianchi pablo.bian...@gmail.com escribió:
Hi Robin!
So you agree with me that Appendix F (Resetting the Koha Database) of
current (v3.16) manual is wrong?
2014-06-02 20:21 GMT-03:00 Robin Sheat ro...@catalyst.net.nz:
Pablo Bianchi schreef op ma 02-06-2014 om 14:33 [-0300]:
Am I right? This could be risky, having side effects?
This could have nasty side-effects.
By turning off the
constraint checks, you're not going to have any
messages telling you reasons why you shouldn't do what you're doing. For
example, circulation history, serial subscriptions, reserves, and
anything else that links with biblios and/or items aren't going to be
cleared. This means that you'll have entries in them pointing to things
that don't exist.
Problems that we can avoid just with *DELETE FROM biblio*?
Some better solutions might be to:
* Do 'DELETE FROM table;' and then reset the auto numbering back
to 1, something like 'ALTER TABLE table AUTO INCREMENT=1;'
This'll ensure that things that should be deleted via
constraints will be, or it won't let you do it. Also ensure that
things that aren't constraint-linked are deleted (I think
old_issues is one of these.)
Despite the autoincrement issue, the *DELETE FROM biblio* way wasn't
working for me. Now I'm not being able to reproduce the error, but I
remember was very similar than with truncate, about *foreign key
constraint*
*.*
I wonder why with -d option of bulkmarcimport.pl I had similar problems
than with TRUNCATE, throw to stderr something like:
*#1701 - Cannot truncate a table referenced in a foreign key constraint
(`koha_MyInstance`.`aqorders`, CONSTRAINT `aqorders_ibfk_2` FOREIGN KEY
(`biblionumber`) REFERENCES `koha_MyInstance`.`biblio` (`biblionumber`))*
What we can expect just taking a look to the source code:
*if ($delete) {*
* if ($biblios){*
*print deleting biblios\n;*
*$dbh-do(truncate biblio);*
* $dbh-do(truncate biblioitems);*
*$dbh-do(truncate items);*
* } else {*
*print deleting authorities\n;*
*$dbh-do(truncate auth_header);*
* }*
* $dbh-do(truncate zebraqueue);*
*}*
If this way is the right one, considering constraint checks, I can't see
why we can't use it. Perhaps we can set up something differently in
my.cnf...
Regards,
Pablo
___
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] [Repost] Add a proposal for hosting KohaCon15
hi Folks last month the Koha mailing-list was playing up a bit… so we decided at today's Koha IRC meeting to repost Thomas' KohaCon15 email, in case people missed it the 1st time :) --- Begin forwarded message: From: Thomas Dukleth kohal...@agogme.com Subject: [Koha] Add a proposal for hosting KohaCon15 Date: 13 May 2014 4:21:22 AM NZST To: Koha-List koha@lists.katipo.co.nz Reply-To: Thomas Dukleth kohal...@agogme.com Anyone who would like to host KohaCon15 (international Koha conference to be held in 2015) should add some brief information about their proposal to the proposals summary table in the page on the Koha Wiki which I have prepared following the model used for previous KohaCons, http://wiki.koha-community.org/wiki/KohaCon15_Proposals . Please link your summary proposal to a more detailed proposal preferably in a new page on the Koha wiki or alternately hosted on your own webserver. If you have submitted a proposal for hosting KohaCon in the past but had not been selected, please submit a new proposal if you are interested in hosting KohaCon15. Do not be discouraged that some other proposal had been selected over yours in some previous year. [In the interest of promoting regional diversity in Koha, we have sometimes considered rules against selecting KohaCon proposals from the same region successively in case the most populous regions might come to excessively dominate voting for selecting a proposal, but in practise such rules may not have yet been necessary.] Anyone should be free to add additional relevant information to proposal information in the wiki, such as links and information for local hotel or other accommodations, attractions, etc. We want whatever information may be helpful for linking to a community wide ballot for selecting a particular proposal. As with all wiki content, it should be easy enough to edit by examining the form in which pre-existing content has been entered, when editing to add your own content. If you want more information about MediaWiki tables, see http://www.mediawiki.org/wiki/Help:Tables . Thomas Dukleth Agogme 109 E 9th Street, 3D New York, NY 10003 USA http://www.agogme.com +1 212-674-3783 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] KohaCon10 videos unavailable
Robin Sheat schreef op ma 26-05-2014 om 15:19 [+1200]: Does anyone know if those videos are available elsewhere? Preferably on a free (as in freedom) platform to reduce the risk of them becoming unavailable like this. Thanks to Kristina for providing me the files. I've uploaded all of them to archive.org: https://archive.org/details/KohaCon10 I've taken the liberty of telling archive.org that they are under the CC-BY-SA license, as that's the one that most closely matches Koha (being under the GPL) itself. Please let me know if anyone has any issues with this, or if they'd rather their talk wasn't there. Or if you see any typos in the metadata. In the meantime however, for your viewing pleasure, I present to you the following topics: * Rosalie Blake: Keynote at KohaCon10 * Lee Phillips: Ask a Librarian: Why I Love Koha * Walter McGinnis: Kete and Koha * Olugbenga Adara: Koha Uptake in Nigeria * Bob Birchall: Koha Governance * Chris Cormack: What's new in Koha 3.4 * David Friggens: Library Data for fun and profit * Stuart Yeats: eBooks - Why they break ISBNs * MJ Ray: Koha - A Cooperative View * Mark Osborne: Koha @ ASHS (Albany Senior High School) * François Marier: Freedom in the Library * Paul Poulain: Koha History * Sue Lavery Irma Birchall: When it's not the code that is locked up * Nicole C. Engard: Koha - Participation is Key * Amzari Abu Bakar: Efforts of promoting Koha ILS * Farasat Shafi-Ullah: From LAMP to Koha * Don Christie: Celebrating, promoting and supporting free software in libraries * George Oats: Open Library and Koha sitting in a tree * George Sue: Final Words -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Statistic for daily catalogers achievement in date range
Hi Cecil Yes the logs must be turned on because I used the action_logs table which requires this . Best regards On Tue, Jun 3, 2014 at 10:35 PM, Hillyard, Cecil chilly...@washoecounty.us wrote: Does this require the cataloging logs to be turned on? Ours our turned off because it slows down things too much. __ Cecil Hillyard Washoe County Library -Tel: 775-327-8338 or 7750-327-8330 fax: 775-327-8334 -Original Message- From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of Karam Qubsi Sent: Tuesday, June 03, 2014 3:02 AM To: Koha Subject: [Koha] Statistic for daily catalogers achievement in date range Hi all , some libraries need to monitor the achievement of their catalogers , I added 2 new reports to the wiki page , I hope it will be helpful for some libraries . http://wiki.koha-community.org/wiki/SQL_Reports_Library#Statistic_for_daily_catalogers_achievement_in_date_range_for_bib_records Statistic for daily catalogers achievement in date range for bib records - *Developer:* Karam Qubsi - *Module:* Cataloging - *Purpose:* Statistic for daily catalogers achievement in date range for bib records (you can change the date range I make it for the whole 2014 year in this example ) - *Status:* Complete SELECT DATE_FORMAT(I.timestamp, '%d-%c-%Y') AS Date, B.userid AS Staff, count(I.timestamp) AS CountFROM action_logs ILEFT JOIN borrowers BON I.user=B.borrowernumberWHERE I.module='CATALOGUING' AND I.action='ADD' AND date(I.timestamp) BETWEEN '2014-01-01' AND '2014-12-31' AND I.info!='biblio'GROUP BY Date,B.useridORDER BY DATE(timestamp) DESC [edit http://wiki.koha-community.org/w/index.php?title=SQL_Reports_Libraryaction=editsection=264 ]Statistic for daily catalogers achievement in date range for Item records - *Developer:* Karam Qubsi - *Module:* Cataloging - *Purpose:* Statistic for daily catalogers achievement in date range for item records (you can change the date range I make it for the whole 2014 year in this example ) - *Status:* Complete SELECT DATE_FORMAT(I.timestamp, '%d-%c-%Y') AS Date, B.userid AS Staff, count(I.timestamp) AS CountFROM action_logs ILEFT JOIN borrowers BON I.user=B.borrowernumberWHERE I.module='CATALOGUING' AND I.action='ADD' AND date(I.timestamp) BETWEEN '2014-01-01' AND '2014-12-31' AND I.info!='item'GROUP BY Date,B.useridORDER BY DATE(timestamp) DESC Bests -- *Karam Qubsi* ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- *Karam Qubsi* ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Statistic for daily catalogers achievement in date range
Hi all sorry there were a mistake in the reports in these lines : AND I.info!='biblio' AND I.info='biblio' AND I.info!='item' AND I.info='item' ( i fixed them on the wiki page ) Best wishes :) On Tue, Jun 3, 2014 at 6:01 PM, Karam Qubsi karamqu...@gmail.com wrote: Hi all , some libraries need to monitor the achievement of their catalogers , I added 2 new reports to the wiki page , I hope it will be helpful for some libraries . http://wiki.koha-community.org/wiki/SQL_Reports_Library#Statistic_for_daily_catalogers_achievement_in_date_range_for_bib_records Statistic for daily catalogers achievement in date range for bib records - *Developer:* Karam Qubsi - *Module:* Cataloging - *Purpose:* Statistic for daily catalogers achievement in date range for bib records (you can change the date range I make it for the whole 2014 year in this example ) - *Status:* Complete SELECT DATE_FORMAT(I.timestamp, '%d-%c-%Y') AS Date, B.userid AS Staff, count(I.timestamp) AS CountFROM action_logs ILEFT JOIN borrowers BON I.user=B.borrowernumberWHERE I.module='CATALOGUING' AND I.action='ADD' AND date(I.timestamp) BETWEEN '2014-01-01' AND '2014-12-31' AND I.info!='biblio'GROUP BY Date,B.useridORDER BY DATE(timestamp) DESC [edit http://wiki.koha-community.org/w/index.php?title=SQL_Reports_Libraryaction=editsection=264 ]Statistic for daily catalogers achievement in date range for Item records - *Developer:* Karam Qubsi - *Module:* Cataloging - *Purpose:* Statistic for daily catalogers achievement in date range for item records (you can change the date range I make it for the whole 2014 year in this example ) - *Status:* Complete SELECT DATE_FORMAT(I.timestamp, '%d-%c-%Y') AS Date, B.userid AS Staff, count(I.timestamp) AS CountFROM action_logs ILEFT JOIN borrowers BON I.user=B.borrowernumberWHERE I.module='CATALOGUING' AND I.action='ADD' AND date(I.timestamp) BETWEEN '2014-01-01' AND '2014-12-31' AND I.info!='item'GROUP BY Date,B.useridORDER BY DATE(timestamp) DESC Bests -- *Karam Qubsi* -- *Karam Qubsi* ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Fwd: Fw: Kohacon 15
Hello all, I am just forwarding a copy of the mail sent to the list to announce the intention of Ibadan, Nigeria to bid for KohaCon15. I guess also because of the lists issues it never did show up as intended. Cheers Olugbenga Adara - Forwarded Message - From: Olugbenga Adara gbengaad...@yahoo.com To: Koha List koha@lists.katipo.co.nz Cc: Adetunji Adepeju tunjiadep...@yahoo.com Sent: Wednesday, May 28, 2014 2:32:36 PM Subject: Kohacon 15 Hello all, This is to generally notify members of the Koha community that Projektlink Konsult Ltd has submitted a bid to host Kohacon15 in Ibadan, Nigeria. You can see our bid proposal at http://wiki.koha-community.org/wiki/KohaCon15_Proposals Many thanks to members who have encouraged us to submit a bid once again. We wish Cordoba a successful hosting later this year and also do look forward to welcoming members of the community in Ibadan sometime in 2015 Warm regards. Olugbenga Adara ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Appeal for developing/updating solr deployment documentation to BibLibre
In Bangladesh we are like to use solr in koha. http://wiki.koha-community.org/wiki/Solr_deployment Please update this documentation. Presently it is not working. -- Nur Ahammad Junior Assistant Librarian Independent University, Bangladesh *Read to Know. Read to Learn. Read to Lead* ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] KOHA is frequently giving following error
Dear All, KOHA is frequently giving following error. after reboot, it works fine for few hours then again gives below error. - Software error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) at /usr/share/koha/lib/C4/Context.pm line 803. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Auth.pm line 65. Compilation failed in require at /usr/share/koha/opac/cgi-bin/opac/opac-main.pl line 22. BEGIN failed--compilation aborted at /usr/share/koha/opac/cgi-bin/opac/opac-main.pl line 22. For help, please send mail to the webmaster ([no address given]), giving this error message and the time and date of the error. Version: 3.14 OS: Ubuntu 12.04 With regards, Vinod Kumar Mishra, Assistant Librarian, (Library In-Charge) Biju Patnaik Central Library, NIT Rourkela, Mob:91+9439420860 91+6612462103 (O) email: vinod_librar...@rediffmail.com : mishrav...@gmail.com ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] KOHA is frequently giving following error
Looks like you have a problem with your mysql server. I would look at the logs for it Chris On 4 June 2014 4:52:10 pm NZST, Vinod Kumar Mishra vinod_librar...@rediffmail.com wrote: Dear All, KOHA is frequently giving following error. after reboot, it works fine for few hours then again gives below error. - Software error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) at /usr/share/koha/lib/C4/Context.pm line 803. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Auth.pm line 65. Compilation failed in require at /usr/share/koha/opac/cgi-bin/opac/opac-main.pl line 22. BEGIN failed--compilation aborted at /usr/share/koha/opac/cgi-bin/opac/opac-main.pl line 22. For help, please send mail to the webmaster ([no address given]), giving this error message and the time and date of the error. Version: 3.14 OS: Ubuntu 12.04 With regards, Vinod Kumar Mishra, Assistant Librarian, (Library In-Charge) Biju Patnaik Central Library, NIT Rourkela, Mob:91+9439420860 91+6612462103 (O) email: vinod_librar...@rediffmail.com : mishrav...@gmail.com ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Sent from my Android device with K-9 Mail. Please excuse my brevity. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] KOHA is frequently giving following error
Hi Vinod, Your Koha server configuration OS.? On Wed, Jun 4, 2014 at 10:25 AM, Chris Cormack chr...@catalyst.net.nz wrote: Looks like you have a problem with your mysql server. I would look at the logs for it Chris On 4 June 2014 4:52:10 pm NZST, Vinod Kumar Mishra vinod_librar...@rediffmail.com wrote: Dear All, KOHA is frequently giving following error. after reboot, it works fine for few hours then again gives below error. - Software error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) at /usr/share/koha/lib/C4/Context.pm line 803. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Auth.pm line 65. Compilation failed in require at /usr/share/koha/opac/cgi-bin/opac/opac-main.pl line 22. BEGIN failed--compilation aborted at /usr/share/koha/opac/cgi-bin/opac/opac-main.pl line 22. For help, please send mail to the webmaster ([no address given]), giving this error message and the time and date of the error. Version: 3.14 OS: Ubuntu 12.04 With regards, Vinod Kumar Mishra, Assistant Librarian, (Library In-Charge) Biju Patnaik Central Library, NIT Rourkela, Mob:91+9439420860 91+6612462103 (O) email: vinod_librar...@rediffmail.com : mishrav...@gmail.com ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Sent from my Android device with K-9 Mail. Please excuse my brevity. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Regards, Amit Gupta ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] KOHA is frequently giving following error
Hi vinod, Its look like your mysqlserver is down. have look on mysql logs and check whether space is available for mysql to run. check whether your mysql server is running using: ps -ef | grep mysql On Wed, Jun 4, 2014 at 10:29 AM, Amit Gupta amitddng...@gmail.com wrote: Hi Vinod, Your Koha server configuration OS.? On Wed, Jun 4, 2014 at 10:25 AM, Chris Cormack chr...@catalyst.net.nz wrote: Looks like you have a problem with your mysql server. I would look at the logs for it Chris On 4 June 2014 4:52:10 pm NZST, Vinod Kumar Mishra vinod_librar...@rediffmail.com wrote: Dear All, KOHA is frequently giving following error. after reboot, it works fine for few hours then again gives below error. - Software error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) at /usr/share/koha/lib/C4/Context.pm line 803. BEGIN failed--compilation aborted at /usr/share/koha/lib/C4/Auth.pm line 65. Compilation failed in require at /usr/share/koha/opac/cgi-bin/opac/opac-main.pl line 22. BEGIN failed--compilation aborted at /usr/share/koha/opac/cgi-bin/opac/opac-main.pl line 22. For help, please send mail to the webmaster ([no address given]), giving this error message and the time and date of the error. Version: 3.14 OS: Ubuntu 12.04 With regards, Vinod Kumar Mishra, Assistant Librarian, (Library In-Charge) Biju Patnaik Central Library, NIT Rourkela, Mob:91+9439420860 91+6612462103 (O) email: vinod_librar...@rediffmail.com : mishrav...@gmail.com ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Sent from my Android device with K-9 Mail. Please excuse my brevity. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Regards, Amit Gupta ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- *Warm Regards,Vishal Patil*Software Engineer - Nucsoft Ltd. phone: 022 32080161 www.osslabs.biz www.nucsoft.com vishal.pa...@osslabs.biz http://nucsoft.com/nucweb/images/OSS_labs.jpg ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Appeal for developing/updating solr deployment documentation to BibLibre
When I run ./rebuild_solr.pl -i It produces SolrAPI = http://localhost:8983/solr/koha How many indexed documents = 0; Please help to solve this problem. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
