| Time |
S |
Nick |
Message |
| 00:01 |
|
|
Oak joined #koha |
| 00:28 |
|
|
NateC joined #koha |
| 00:30 |
|
eythian |
I found a place where koha generates a 2MB SQL query. This may be a bug. |
| 00:31 |
|
wizzyrea |
!! |
| 00:31 |
|
eythian |
SELECT * from borrowers WHERE (((( ( borrowers.firstname = 'a' OR borrowers.firstname LIKE 'a%' OR borrowers.firstname LIKE ' a%') OR ( borrowers.surname = 'a' OR borrowers.surname LIKE 'a%' OR borrowers.surname LIKE ' a%') OR ( borrowers.email = 'a' OR borrowers.email LIKE 'a%' OR borrowers.email LIKE ' a%') OR ( borrowers.othernames = 'a' OR borrowers.othernames LIKE 'a%' OR borrowers.othernames LIKE ' a%') OR ( borrowers.cardnumber = |
| 00:31 |
|
eythian |
'a' OR borrowers.cardnumber LIKE 'a%' OR borrowers.cardnumber LIKE ' a%') ))) OR ((( ( borrowers.branchcode = 'F' OR borrowers.branchcode= '' OR borrowers.branchcode IS NULL OR borrowers.branchcode LIKE 'F%' OR borrowers.branchcode LIKE ' F%') ))) OR ((( ( borrowers.borrowernumber = '1000005445' OR borrowers.borrowernumber= '' OR borrowers.borrowernumber IS NULL) ))) OR ((( ( borrowers.borrowernumber = '1000002562' OR borrowers.borrowernumb |
| 00:31 |
|
eythian |
er= '' OR borrowers.borrowernumber IS NULL) ))) OR ((( ( borrowers.borrowernumber = '8563' OR borrowers.borrowernumber= '' OR borrowers.borrowernumber IS NULL) ))) OR ((( ( borrowers.borrowernumber = '1000016441' OR borrowers.borrowernumber= '' OR borrowers.borrowernumber IS NULL) ))) OR .... |
| 00:33 |
|
|
samerrill joined #koha |
| 00:33 |
|
eythian |
ah, and now I see why it does that. |
| 00:34 |
|
eythian |
It builds a list of attributes that match the search for 'a' first, and then includes each of those. |
| 00:34 |
|
eythian |
That's what joins are for. |
| 01:04 |
|
|
samerrill1 joined #koha |
| 01:04 |
|
|
samerrill left #koha |
| 01:27 |
|
|
NateC left #koha |
| 01:36 |
|
|
NateC joined #koha |
| 01:37 |
|
|
Soupermanito joined #koha |
| 01:39 |
|
|
NateC left #koha |
| 01:40 |
|
|
Irma joined #koha |
| 01:47 |
|
rangi |
heya Irma |
| 01:47 |
|
rangi |
did space_librarian get hold of you? |
| 01:58 |
|
pianohacker |
rangi: are you familiar with zebra ccl syntax? |
| 01:59 |
|
rangi |
not particularly, hdl and gmcharlt seem to know the most, but i can take a crack |
| 01:59 |
|
gmcharlt |
ccl is pretty much the easiest of the supported syntaxes |
| 02:17 |
|
pianohacker |
gmcharlt: supposing you're still around, what's the best way to escape parentheses in ccl terms? putting it in quotes would work, from what I can read of the parser (indexdata--), but is a little hairy |
| 02:18 |
|
gmcharlt |
pretty sure quotes is it |
| 02:18 |
|
pianohacker |
bleh, okay. thanks |
| 02:18 |
|
rangi |
i thought jcamins or reed had done somthing with quotes before and searching |
| 02:18 |
|
pianohacker |
rangi: this is related to bug 5369 |
| 02:18 |
|
huginn |
Bug http://bugs.koha-community.org[…]w_bug.cgi?id=5369 normal, P5, ---, jcamins, NEW , se queries with paranthesis fail |
| 02:19 |
|
rangi |
ah right |
| 02:19 |
|
rangi |
there was one for subjects, or itemtypes or something |
| 02:19 |
|
pianohacker |
I'm pretty sure I can fix this with some careful =~ s///, but nothing in C4::Search is ever simple |
| 02:22 |
|
rangi |
http://bugs.koha-community.org[…]w_bug.cgi?id=5693 |
| 02:22 |
|
huginn |
Bug 5693: normal, PATCH-Sent, ---, reed, RESOLVED FIXED, if parentheses used in ccode then searches against ccode fail |
| 02:28 |
|
|
Oak left #koha |
| 02:38 |
|
huginn |
New commit(s) kohagit: Bug 6512: time missing from item circulation history <http://git.koha-community.org/[…]a40d00870f0a99295> / Bug 4993 checkpw_ldap - do bind just once <http://git.koha-community.org/[…]e07150ce873aa6a3d> |
| 02:42 |
|
jenkins_koha |
Starting build 300 for job Koha_master (previous build: SUCCESS) |
| 02:45 |
|
|
atz joined #koha |
| 02:51 |
|
|
Soupermanito left #koha |
| 02:55 |
|
eythian |
https://github.com/petdance/vi[…]ree/master/syntax <-- vim users, tt2.vim and tt2html.vim are handy |
| 02:57 |
|
eythian |
rangi: "get_template_and_user({template_name => "serials/member-search.tmpl"," |
| 02:57 |
|
eythian |
what's with the .tmp there? |
| 02:57 |
|
eythian |
*tmpl |
| 02:57 |
|
eythian |
do they get silently converted to .tt? |
| 02:58 |
|
rangi |
yup |
| 02:58 |
|
rangi |
some day ill sed them all out |
| 02:58 |
|
eythian |
cool |
| 03:02 |
|
eythian |
This: my $branches=defined $$patron{branchcode} ? GetBranchesLoop($$patron{branchcode}) : GetBranchesLoop()); |
| 03:02 |
|
eythian |
is the same as: |
| 03:03 |
|
eythian |
my $branches=GetBranchesLoop($patron->{branchcode}); |
| 03:03 |
|
eythian |
right? |
| 03:03 |
|
eythian |
or am I missing something? |
| 03:03 |
|
rangi |
no you arent, functionally its the same |
| 03:03 |
|
eythian |
good. |
| 03:03 |
|
rangi |
but the oneliner will warn if $patron->{branchcode} doesnt exist |
| 03:04 |
|
eythian |
hmm |
| 03:04 |
|
eythian |
yeah, it will |
| 03:04 |
|
eythian |
I can still make it cleaner though |
| 03:04 |
|
rangi |
yup |
| 03:10 |
|
huginn |
New commit(s) kohagit: Merge remote-tracking branch 'kc/new/bug_5094' into kcmaster <http://git.koha-community.org/[…]5b1f721d0303bc136> / Bug 5094 auth_by_bind authentication can fail even if given a correct password and... <http://git.koha-community.org/[…]caaa873be3dfcc5ef> / Bug 6512: time missing from item circulation history <http://g |
| 03:22 |
|
huginn |
New commit(s) kohagit: Bug 6350 : Updating history <http://git.koha-community.org/[…]7e0213efe4f23e3e9> |
| 03:25 |
|
jenkins_koha |
Project Koha_master build #300: SUCCESS in 42 mn: http://jenkins.koha-community.[…]/Koha_master/300/ |
| 03:25 |
|
jenkins_koha |
* dpavlin: Bug 4993 checkpw_ldap - do bind just once |
| 03:25 |
|
jenkins_koha |
* ian.walls: Bug 6512: time missing from item circulation history |
| 03:25 |
|
huginn |
Bug http://bugs.koha-community.org[…]w_bug.cgi?id=4993 critical, PATCH-Sent, ---, dpavlin, ASSIGNED , ldap search always anonymous when using auth_by_bind |
| 03:25 |
|
huginn |
Bug http://bugs.koha-community.org[…]w_bug.cgi?id=6512 normal, PATCH-Sent, ---, ian.walls, ASSIGNED , Time missing from Item circulation history table |
| 03:25 |
|
jenkins_koha |
Starting build 301 for job Koha_master (previous build: SUCCESS) |
| 03:58 |
|
|
Oak joined #koha |
| 03:59 |
|
Oak |
\o |
| 04:02 |
|
|
Brooke joined #koha |
| 04:03 |
|
Brooke |
kia ora |
| 04:03 |
|
Oak |
Hello Brooke :) |
| 04:03 |
|
Brooke |
:) |
| 04:05 |
|
Brooke |
wait a sec |
| 04:05 |
|
Brooke |
shouldn't you be uh |
| 04:05 |
|
Brooke |
on weekend :P |
| 04:05 |
|
Oak |
me? |
| 04:05 |
|
wahanui |
you are Arslan. I am a student doing masters in Library Science (2nd semester). I am a web developer and work in Joomla. |
| 04:05 |
|
Brooke |
ya you ;) |
| 04:06 |
|
Oak |
i work on Saturdays also :-| |
| 04:07 |
|
Brooke |
ick |
| 04:07 |
|
Oak |
it's funny, I was just thinking about taking the day off and do some personal things pending... |
| 04:07 |
|
jenkins_koha |
Project Koha_master build #301: SUCCESS in 42 mn: http://jenkins.koha-community.[…]/Koha_master/301/ |
| 04:07 |
|
jenkins_koha |
* ian.walls: Bug 6512: time missing from item circulation history |
| 04:07 |
|
Brooke |
;) |
| 04:07 |
|
jenkins_koha |
* JeremyC: Bug 5094 auth_by_bind authentication can fail even if given a correct password and userid |
| 04:07 |
|
huginn |
Bug http://bugs.koha-community.org[…]w_bug.cgi?id=6512 normal, PATCH-Sent, ---, ian.walls, ASSIGNED , Time missing from Item circulation history table |
| 04:07 |
|
jenkins_koha |
* Chris Cormack: Bug 6350 : Updating history |
| 04:07 |
|
huginn |
Bug http://bugs.koha-community.org[…]w_bug.cgi?id=5094 major, PATCH-Sent, ---, gmcharlt, ASSIGNED , auth_by_bind authentication can fail even if given a correct password and userid |
| 04:07 |
|
huginn |
Bug http://bugs.koha-community.org[…]w_bug.cgi?id=6350 trivial, P5, ---, nengard, NEW , Bug for tracking updates to the history file |
| 04:08 |
|
eythian |
http://www.youtube.com/watch?v=QH2-TGUlwu4 <-- youtube is trially a new progress bar |
| 04:09 |
|
eythian |
*trialling |
| 04:09 |
|
Oak |
thank you mr. robin, will check this link at once |
| 04:09 |
|
Oak |
:) |
| 04:09 |
|
eythian |
you better |
| 04:09 |
|
Brooke |
cool |
| 04:09 |
|
* Brooke |
just tried Mumble in the stead of vent and is hooked. |
| 04:10 |
|
* Oak |
sometimes do not understand at all what Brooke says |
| 04:10 |
|
Brooke |
it's a chat programme |
| 04:10 |
|
Brooke |
for gaming |
| 04:10 |
|
Brooke |
so like |
| 04:10 |
|
Brooke |
it's IRC but voice ;) |
| 04:10 |
|
Oak |
aah |
| 04:10 |
|
Brooke |
and pretty much no one understands me, so you're not alone. |
| 04:11 |
|
Oak |
oh good, i feel much better now |
| 04:11 |
|
Brooke |
I behave when I have to present or Lobby though :) |
| 04:13 |
|
Oak |
that must be fun to watch |
| 04:13 |
|
Oak |
and listen also |
| 04:13 |
|
Brooke |
on the lobbying front I am an unexpected shark |
| 04:13 |
|
Brooke |
presenting varies from pretty boring to not so bad |
| 04:13 |
|
Brooke |
nasty tendency to read me slides |
| 04:13 |
|
Brooke |
but that's better than rambling by a little |
| 04:14 |
|
Oak |
true dat |
| 04:14 |
|
Oak |
(heard you say that yesterday) ;) |
| 04:14 |
|
Oak |
true dat |
| 04:14 |
|
Brooke |
feedback varies depending on the topic |
| 04:14 |
|
Brooke |
heheh |
| 04:14 |
|
|
pianohacker left #koha |
| 04:16 |
|
Oak |
:) can we see you doing a presentation in any KohaCon videos? |
| 04:16 |
|
Oak |
or as a shark? |
| 04:16 |
|
Brooke |
I'm not in any videos yet |
| 04:16 |
|
Oak |
uh oh |
| 04:16 |
|
Brooke |
and I don't have anyone to Lobby for currently |
| 04:17 |
|
Oak |
that sounds funny |
| 04:17 |
|
Oak |
oh wait, it is funny |
| 04:18 |
|
Brooke |
here's the written form of testimony I gave |
| 04:18 |
|
Brooke |
http://mblc.state.ma.us/mblc/l[…]es/BWSJohnson.pdf |
| 04:19 |
|
Brooke |
many, many moons back |
| 04:19 |
|
Brooke |
I had karate fight night the night before, too |
| 04:19 |
|
Brooke |
so as I was walking up to the podium |
| 04:19 |
|
Brooke |
I was praying not to fall |
| 04:19 |
|
Brooke |
cause if I did |
| 04:19 |
|
Brooke |
I was so bruised the little mister would have been tossed in gaol. |
| 04:19 |
|
Oak |
hehe |
| 04:20 |
|
Oak |
little mister? |
| 04:20 |
|
wahanui |
i think little mister is a die hard Patriots fan. |
| 04:20 |
|
Brooke |
ha! |
| 04:21 |
|
Brooke |
wahanui botsnack Gillette Chili Dawg |
| 04:21 |
|
wahanui |
:) |
| 04:25 |
|
Oak |
on page two, Brooke, and wow. you are a writer. excellent writer. |
| 04:25 |
|
Brooke |
psha |
| 04:26 |
|
Brooke |
"Can't eat a speech" |
| 04:35 |
|
Oak |
Brooke, I'm a fan now. Officially. Sold. If anyone asks, count me in. |
| 04:35 |
|
Brooke |
heh |
| 04:36 |
|
* Brooke |
blushes. |
| 04:36 |
|
Oak |
:) |
| 04:41 |
|
Brooke |
just wish I didn't have a block on our history |
| 04:41 |
|
Brooke |
I felt like it was coming to me yesterday, but it slipped by coz I looked at too many numbers |
| 04:48 |
|
Oak |
i googled "Can't eat a speech" and found something... but I totally did not get what you just said. :) |
| 04:48 |
|
Oak |
Brooke, you are attending KohaCon this year... right? |
| 04:49 |
|
Brooke |
I have writer's block on http://wiki.koha-community.org/wiki/History |
| 04:49 |
|
Brooke |
and I've had it for ages. |
| 04:49 |
|
Brooke |
Yes, I will be at KohaCon |
| 04:49 |
|
Oak |
oh I did not know about that writer's block... |
| 04:50 |
|
Oak |
great.. .i was thinking i may never meet Matthew Perry or Audrey Tautou... but i sure can *try* to be at KohaCon |
| 04:51 |
|
* Brooke |
nods. |
| 04:51 |
|
Brooke |
don't miss it when it's so close |
| 04:51 |
|
Oak |
and annoy you, cait and druthb as much as i can |
| 04:51 |
|
Brooke |
it is neigh impossible to annoy druthb |
| 04:52 |
|
Oak |
we'll see |
| 04:52 |
|
Brooke |
I have deliberately tried to get her goat a couple times, and it's been largely to no avail. |
| 04:52 |
|
Brooke |
>:) |
| 04:53 |
|
Oak |
hmm, oh well, first i should start working on how to get there |
| 04:53 |
|
Brooke |
Train! |
| 04:55 |
|
Oak |
yes, may be. i should check routes. india pakistan are not two friendly neighbors |
| 04:55 |
|
Brooke |
there's that, but it's cheap. |
| 05:11 |
|
|
pianohacker joined #koha |
| 05:11 |
|
Brooke |
0/ |
| 05:16 |
|
|
Amit_Gupta joined #koha |
| 05:16 |
|
Amit_Gupta |
good morning koha ;) |
| 05:17 |
|
Oak |
Hello Amit_Gupta and pianohacker :) |
| 05:17 |
|
pianohacker |
hi |
| 05:17 |
|
wahanui |
bonjour, pianohacker |
| 05:17 |
|
pianohacker |
hi |
| 05:17 |
|
pianohacker |
slightly smarter bot than I gave it credit for |
| 05:17 |
|
pianohacker |
now bed |
| 05:17 |
|
pianohacker |
bye all |
| 05:17 |
|
|
pianohacker left #koha |
| 05:18 |
|
Brooke |
good morning amit |
| 05:39 |
|
|
Brooke left #koha |
| 06:04 |
|
Amit_Gupta |
heya Oak |
| 06:15 |
|
alex_a |
hello #koha |
| 06:27 |
|
|
mib_sun joined #koha |
| 06:28 |
|
mib_sun |
hi #koha |
| 06:32 |
|
|
bigbrovar left #koha |
| 06:37 |
|
|
magnus_away is now known as magnuse |
| 06:40 |
|
|
reiveune joined #koha |
| 06:40 |
|
reiveune |
hello |
| 06:40 |
|
|
prawesh joined #koha |
| 06:42 |
|
prawesh |
is anybody out there?? |
| 06:44 |
|
magnuse |
yeah, but it's not the most crowded of times, prawesh |
| 06:44 |
|
Oak |
i believe there is, in fact many of them |
| 06:45 |
|
Oak |
i should confirm from my window though |
| 06:45 |
|
|
Oak left #koha |
| 06:46 |
|
|
Amit_Gupta left #koha |
| 06:53 |
|
|
hdl joined #koha |
| 06:53 |
|
|
clrh joined #koha |
| 06:54 |
|
|
Guillaume joined #koha |
| 06:56 |
|
|
matts_away is now known as matts |
| 06:58 |
|
|
julian joined #koha |
| 07:00 |
|
julian |
hello ! |
| 07:00 |
|
magnuse |
bonjour france |
| 07:03 |
|
christophe_c |
hello magnuse, & all |
| 07:04 |
|
|
miguel left #koha |
| 07:06 |
|
magnuse |
bonjour christophe_c |
| 07:06 |
|
|
francharb joined #koha |
| 07:07 |
|
francharb |
hello all |
| 07:07 |
|
magnuse |
bonjour francharb |
| 07:08 |
|
|
miguelxercode joined #koha |
| 07:13 |
|
|
miguel joined #koha |
| 07:17 |
|
|
matts left #koha |
| 07:18 |
|
mib_sun |
shall I customize the search list format of books? When I am serching for a book the list contain the item type several types. how can I change this?? |
| 07:18 |
|
|
matts joined #koha |
| 07:21 |
|
|
cait_mib joined #koha |
| 07:21 |
|
cait_mib |
hi all |
| 07:25 |
|
christophe_c |
hi cait_mib |
| 07:27 |
|
cait_mib |
hi christophe_c |
| 07:30 |
|
clrh |
hello |
| 07:30 |
|
wahanui |
bonjour, clrh |
| 07:33 |
|
cait_mib |
hi clrh |
| 07:34 |
|
clrh |
hi cait_mib |
| 07:39 |
|
|
sophie_m joined #koha |
| 07:43 |
|
miguel |
good morning, buenos dÃas |
| 07:43 |
|
|
Oak joined #koha |
| 07:44 |
|
|
miguelxercode left #koha |
| 07:44 |
|
Oak |
so if I register, i can help with translating words for Urdu language http://translate.koha-community.org |
| 07:46 |
|
cait_mib |
yup |
| 07:46 |
|
cait_mib |
if you can only do suggest you should ask fredericd for more permissions |
| 07:46 |
|
Oak |
ooh hi cait :) |
| 07:46 |
|
cait_mib |
suggest will make a suggestiong, submit will add it |
| 07:46 |
|
Oak |
okay |
| 07:47 |
|
cait_mib |
suggestions are broken at the moment - I can't accept those for German :( |
| 07:51 |
|
prawesh |
can some one help me?? |
| 07:54 |
|
prawesh |
i have problem in generating barcode |
| 07:54 |
|
cait_mib |
what is your problem? |
| 07:54 |
|
prawesh |
after adding new items in new or old record, the barcode for it are not generated in pdf |
| 07:54 |
|
prawesh |
but for old items, it is generating the barcode |
| 07:54 |
|
cait_mib |
hm |
| 07:54 |
|
cait_mib |
I am sorry, I am not so familiar with the barcode module |
| 07:54 |
|
prawesh |
ok |
| 07:54 |
|
cait_mib |
which version are you using? |
| 07:54 |
|
cait_mib |
you chould check bugzilla.koha-community.org for known bugs and file a new one, or ask on the mailing list |
| 07:55 |
|
prawesh |
3.00.05.003 |
| 07:55 |
|
|
julian left #koha |
| 07:55 |
|
prawesh |
i had posted query in the mailing list, but didn't get any reply |
| 07:55 |
|
|
julian joined #koha |
| 07:55 |
|
prawesh |
i think i will post with details again |
| 07:55 |
|
cait_mib |
hm your version is quite old, not sure there was a problem |
| 07:56 |
|
cait_mib |
but if it's a but it's unlikely to be fixed, barcode modue was completely rewritten for 3.2 |
| 07:56 |
|
prawesh |
oh |
| 07:57 |
|
prawesh |
can i explain what happened?? |
| 07:57 |
|
prawesh |
to you |
| 07:57 |
|
prawesh |
may be it will help us |
| 07:58 |
|
cait_mib |
not sure I can help here |
| 07:58 |
|
prawesh |
ok |
| 07:58 |
|
cait_mib |
never used the old barcode module, did some tests with the new module |
| 07:58 |
|
cait_mib |
if you write to the mailnig list again include as many information as possible, version, steps to reproduce |
| 07:58 |
|
prawesh |
i think i will post it in mailing list again |
| 07:58 |
|
prawesh |
sure |
| 07:58 |
|
prawesh |
thank u |
| 07:58 |
|
cait_mib |
sorry that I don't have a solution for you |
| 07:59 |
|
prawesh |
no problem |
| 08:02 |
|
cait_mib |
ok, bye #koha |
| 08:02 |
|
Oak |
bye cait_mib |
| 08:02 |
|
|
cait_mib left #koha |
| 08:03 |
|
* magnuse |
wonders if it is a good idea to have stuff like jquery and yui below the language specific directories in koha-tmpl/ aren't they identical for all languages? |
| 08:08 |
|
Oak |
not related, but an alternative to yui: http://www.blueprintcss.org/ |
| 08:09 |
|
Oak |
in http://translate.koha-community.org/ur/, when I copy the English string to the edit box, and paste the Urdu word replacing English text, some places of % and s get changed... and look wrong. |
| 08:11 |
|
Oak |
and here: http://translate.koha-communit[…]ref.po/translate/ looks like the right column is messed up |
| 08:12 |
|
Oak |
not working i mean |
| 08:14 |
|
hdl |
magnuse: same feeling here. |
| 08:15 |
|
hdl |
I even think it could be interesting not to have them embedded but used as external dependencies. |
| 08:15 |
|
|
prawesh left #koha |
| 08:17 |
|
magnuse |
hdl: the submodule discussion? |
| 08:19 |
|
|
paul_p joined #koha |
| 08:22 |
|
magnuse |
kia ora paul_p |
| 08:23 |
|
paul_p |
hello world |
| 08:28 |
|
magnuse |
paul_p and hdl: do you think it would be a good or a bad if i try to announce another global sign off day (gsod!) on the same day as your "community day" (8th july?) |
| 08:28 |
|
magnuse |
could we risk "tripping over" each other? |
| 08:29 |
|
magnuse |
or is it "the more the merrier"? |
| 08:31 |
|
magnuse |
s/bad/bad idea/ |
| 08:31 |
|
|
magnuse is now known as magnus_bbl |
| 08:33 |
|
|
bigbrovar joined #koha |
| 08:35 |
|
paul_p |
definetly : the more the merrier ! no doubts ! |
| 08:38 |
|
|
sophie_m1 joined #koha |
| 08:38 |
|
|
sophie_m left #koha |
| 08:44 |
|
mib_sun |
hello, can some one help me please? I have a doubt in searching catalog. |
| 08:48 |
|
mib_sun |
shall I customize the search list format of books? |
| 08:52 |
|
|
sophie_m joined #koha |
| 08:53 |
|
|
sophie_m1 left #koha |
| 08:59 |
|
|
Oak left #koha |
| 09:00 |
|
|
magnus_bbl is now known as magnuse |
| 09:01 |
|
magnuse |
cool, thanks paul_p |
| 09:40 |
|
|
miguel left #koha |
| 09:40 |
|
|
ibeardslee left #koha |
| 09:41 |
|
|
miguel joined #koha |
| 09:41 |
|
|
ibeardslee joined #koha |
| 10:16 |
|
|
matts is now known as matts_away |
| 10:17 |
|
|
LBA left #koha |
| 10:25 |
|
|
mib_sun left #koha |
| 10:27 |
|
|
Irma left #koha |
| 10:58 |
|
|
NateC joined #koha |
| 11:00 |
|
|
NateC left #koha |
| 11:02 |
|
|
miguel left #koha |
| 11:02 |
|
|
miguel joined #koha |
| 11:19 |
|
|
jwagner joined #koha |
| 11:26 |
|
|
nengard joined #koha |
| 11:30 |
|
|
NateC joined #koha |
| 11:44 |
|
|
matts_away is now known as matts |
| 11:45 |
|
|
matts left #koha |
| 11:46 |
|
|
matts joined #koha |
| 11:48 |
|
|
sophie_m left #koha |
| 11:48 |
|
|
sophie_m joined #koha |
| 11:51 |
|
|
collum joined #koha |
| 11:52 |
|
|
paul_p left #koha |
| 12:01 |
|
|
JesseM joined #koha |
| 12:01 |
|
|
samerrill1 left #koha |
| 12:18 |
|
gmcharlt |
@quote random |
| 12:18 |
|
huginn |
gmcharlt: Quote #115: "chris: friends don't let friends use proprietary software." (added by chris_n at 05:36 PM, January 19, 2011) |
| 12:21 |
|
JesseM |
Nice quote :) |
| 12:30 |
|
magnuse |
yay! |
| 12:37 |
|
|
magnuse is now known as magnus_away |
| 12:42 |
|
|
tcohen joined #koha |
| 12:49 |
|
|
bigbrovar left #koha |
| 13:07 |
|
|
Guillaume left #koha |
| 13:22 |
|
|
magnus_away is now known as magnuse |
| 13:24 |
|
|
magnuse is now known as magnus_away |
| 13:28 |
|
|
sekjal joined #koha |
| 13:37 |
|
|
paul_p joined #koha |
| 13:43 |
|
|
fcapo joined #koha |
| 13:46 |
|
fcapo |
Hello, we have a huge slowdown problem on one of our Koha instances. It has ~150000 biblio records and I get 99,8% IO wait every partial rebuild. |
| 13:47 |
|
fcapo |
Our client want to have "almost live" record updates, so we must do rebuilds every 5 minutes or so, but that means a huge slowdown every 5 minutes. |
| 13:47 |
|
fcapo |
I heard some peoples got Koha instances with a lot more records than that and seems to have no problem. Anybody can share some tips? |
| 13:55 |
|
library_systems_guy |
fcapo I'm no expert but there are several things I would check |
| 13:55 |
|
library_systems_guy |
one is to double check and make sure you are only running a partial rebuild |
| 13:56 |
|
gmcharlt |
fcapo: another step is just to check for general disk I/O problems, and check your RAID settings on the filesystem you're using for zebra's indexes |
| 13:56 |
|
library_systems_guy |
the other is that you have sufficient hardware (mostly sufficient ram since we are using mysql in koha) |
| 13:56 |
|
gmcharlt |
e.g., if you're using RAID5 for that filesystem, you don't really need it |
| 13:56 |
|
* library_systems_guy |
agrees with gmcharlt |
| 13:57 |
|
gmcharlt |
if everything (zebra, mysql, apache) is sitting on one filesystem |
| 13:57 |
|
gmcharlt |
try separating it |
| 13:57 |
|
|
tcohen left #koha |
| 13:57 |
|
|
tcohen joined #koha |
| 13:57 |
|
gmcharlt |
if you're using virtualization, check the I/O tuning settings for the hypervisor |
| 13:59 |
|
library_systems_guy |
gmcharlt, what do you think about fcapo running ps aux to see what exactly is dying when he runs the rebuild |
| 13:59 |
|
fcapo |
The rebuilds really are partial (rebuild_zebra.pl -z -b -x) and the RAM seems sufficient (3,5G) |
| 13:59 |
|
library_systems_guy |
just to see exactly when the load spikes |
| 13:59 |
|
gmcharlt |
library_systems_guy: sure |
| 13:59 |
|
fcapo |
the load spikes at the end of zebraidx's work |
| 13:59 |
|
gmcharlt |
also strace on the zebraidx |
| 14:01 |
|
fcapo |
But checking for genral I/O disk problems seems like a good idea. |
| 14:02 |
|
fcapo |
Is it normal to get 98% IO wait when doing partial rebuilds? |
| 14:02 |
|
gmcharlt |
fcapo: the last step of zebraidx is always slow relative to the rest of the rebuild, but 98% i/o wait is excessive |
| 14:04 |
|
library_systems_guy |
does anybody have experience setting up OpacSupression |
| 14:05 |
|
fcapo |
Ok, thanks a lot for the help. I'll check with my sysadmin if we can find any disk or filesystem problem or misconfiguration. |
| 14:27 |
|
|
rhcl joined #koha |
| 14:27 |
|
|
rhcl left #koha |
| 14:28 |
|
|
rhcl joined #koha |
| 14:28 |
|
rhcl |
Well, heck, it's happening. |
| 14:28 |
|
gmcharlt |
? |
| 14:29 |
|
rhcl |
Missouri is forming a consortium. |
| 14:29 |
|
gmcharlt |
cool! |
| 14:29 |
|
rhcl |
The committee is ready to pick an ILS, and soliciting preliminary membership interest. |
| 14:31 |
|
rhcl |
We got the solicitation notice, the director wanted my input, and I gave it. |
| 14:34 |
|
|
fcapo left #koha |
| 14:58 |
|
reiveune |
bye |
| 14:59 |
|
|
reiveune left #koha |
| 15:00 |
|
|
talljoy_away is now known as talljoy |
| 15:06 |
|
|
alex_a left #koha |
| 15:08 |
|
|
hdl left #koha |
| 15:10 |
|
|
hdl joined #koha |
| 15:10 |
|
|
clrh left #koha |
| 15:12 |
|
|
julian left #koha |
| 15:13 |
|
|
clrh joined #koha |
| 15:14 |
|
|
clrh left #koha |
| 15:15 |
|
|
sophie_m left #koha |
| 15:17 |
|
|
Oak joined #koha |
| 15:17 |
|
Oak |
\o |
| 15:19 |
|
rhcl |
IO |
| 15:27 |
|
gmcharlt |
EIEIO |
| 15:27 |
|
rhcl |
:) |
| 15:31 |
|
|
matts is now known as matts_away |
| 15:36 |
|
|
christophe_c left #koha |
| 15:46 |
|
|
Oak left #koha |
| 15:53 |
|
|
Oak joined #koha |
| 15:56 |
|
|
hdl left #koha |
| 16:03 |
|
Oak |
when installing dependencies like: perl -MCPAN -e 'install "LWP::Simple"', does it do this: "Searching for the best CPAN mirrors (please be patient)" *every* time |
| 16:04 |
|
Oak |
i mean should it find 'best mirror' every time? why can't it just pick one and stick with it? |
| 16:05 |
|
|
rhcl left #koha |
| 16:07 |
|
|
Oak left #koha |
| 16:08 |
|
|
rhcl joined #koha |
| 16:24 |
|
library_systems_guy |
does anybody have experience setting up OpacSupression |
| 16:26 |
|
|
paul_p left #koha |
| 16:33 |
|
|
francharb left #koha |
| 16:47 |
|
|
nengard left #koha |
| 17:21 |
|
|
rhcl left #koha |
| 17:44 |
|
|
tcohen left #koha |
| 18:05 |
|
|
talljoy left #koha |
| 18:21 |
|
|
jwagner left #koha |
| 18:27 |
|
|
collum left #koha |
| 18:55 |
|
|
nengard joined #koha |
| 19:25 |
|
|
hdl joined #koha |
| 19:27 |
|
|
hdl1 joined #koha |
| 19:33 |
|
|
hdl left #koha |
| 19:35 |
|
|
ketchup joined #koha |
| 19:36 |
|
|
ketchup left #koha |
| 19:37 |
|
|
hdl1 left #koha |
| 19:47 |
|
|
Soupermanito joined #koha |
| 19:54 |
|
library_systems_guy |
so I have a code question. I'm not very familiar with the innerworkings of Koha yet and I'd like to pull some information from the database and display it on the results page |
| 19:54 |
|
library_systems_guy |
so I know I'd have to modify the tt page |
| 19:54 |
|
library_systems_guy |
but where do i make the call to the db? |
| 19:54 |
|
nengard |
in the matching pl file |
| 19:55 |
|
nengard |
each tt file has a matching pl file |
| 19:55 |
|
library_systems_guy |
ahh |
| 19:55 |
|
nengard |
the pl files are in folders outside of the tmpl folder |
| 19:55 |
|
nengard |
but template changes mean that when you upgrade you lose your changes |
| 19:56 |
|
library_systems_guy |
unless i commit them or stash my changes :D |
| 19:56 |
|
library_systems_guy |
right 0_0 |
| 19:56 |
|
nengard |
right |
| 19:57 |
|
nengard |
slef around? |
| 19:57 |
|
nengard |
@later tell slef i just got your message from a day ago about giving me an email address ... but I don't remember what I was asking ... email address for who? |
| 19:57 |
|
huginn |
nengard: The operation succeeded. |
| 20:22 |
|
|
nengard left #koha |
| 20:24 |
|
library_systems_guy |
so if i wanted to get started on some more serious development could I talk somebody into giving me tour of the codes physiology |
| 20:38 |
|
library_systems_guy |
maybe not :'( |
| 20:38 |
|
* library_systems_guy |
just wants to help |
| 20:41 |
|
|
aogle joined #koha |
| 20:41 |
|
|
rhcl joined #koha |
| 20:45 |
|
|
sekjal left #koha |
| 20:54 |
|
|
library_systems_guy left #koha |
| 21:25 |
|
|
rhcl left #koha |
| 21:31 |
|
|
francharb joined #koha |
| 21:37 |
|
|
JesseM left #koha |
| 21:41 |
|
|
rhcl joined #koha |
| 21:51 |
|
|
NateC left #koha |
| 21:55 |
|
|
francharb left #koha |
| 22:06 |
|
|
rhcl left #koha |
| 22:20 |
|
|
aogle left #koha |
| 22:24 |
|
|
NateC joined #koha |
| 22:40 |
|
|
NateC left #koha |
| 22:58 |
|
|
Brooke joined #koha |
| 22:59 |
|
Brooke |
kia ora! |
| 23:37 |
|
|
Brooke left #koha |
| 23:38 |
|
|
Irmaongo joined #koha |
| 23:58 |
|
|
Irmaongo left #koha |
