Time Nick Message 10:03 Amit mason r u there 10:03 Amit hi 09:15 mason ok - i need to switch back to some work now, nearly finished.. 09:14 Amit because i m comparing line by line code of both 09:13 mason what part of file? 09:13 mason you looked? 09:13 Amit module 09:13 Amit i think something is missing in search.pm 09:13 Amit no 09:12 mason might not be a bug in search-results code , might be a bug do with some values in our items.* records too 09:11 Amit i will be test 09:11 Amit ok 09:10 mason can u take a backup of yr k3beta, and upgrade it to stable, and see if it breaks.... 09:10 Amit while searching 09:09 Amit in availibility 09:09 Amit because in koha beta its show all the branches 09:09 Amit i am also compare the code of koha-beta and koha stable 09:09 mason i havent tried on a git HEAD yet, tho... 09:09 Amit hmm 09:08 mason i tested it on a k3-stable last nite, and it looked like the bug is in there, on mine 09:07 Amit ok 09:07 mason about only some of a bib's items showing as being available in a search result 09:06 mason right , the bug you mentioned to be before 09:04 Amit koha 09:04 Amit availbity of branches in koa 09:03 Amit my question is 09:02 mason so whats your question? 09:02 Amit hi 09:02 mason hi amit 09:01 Amit for availiblity of branches in koha 09:01 Amit there is a question 09:01 Amit List 09:01 Amit Hi 07:52 Amit list 07:52 Amit hi 05:50 Amit in koha for branch 05:50 Amit there is some availabilty problem 05:50 Amit Hi 05:48 Presently Enough. I must away. I'll continue the effort on the morrow. Thank you kindly for your aid and patience. 05:41 Presently The host parameter in the koha-conf.xml file: should it be localhost or the name of the computer or the ip address or dns name? 05:32 Presently The file has returned. 05:32 Presently Solved that mystery. 05:32 Presently ALright. 05:27 Presently I need to find it. 05:26 mason 69ed 05:25 Presently Or been 86ed. 05:25 Presently It has absquatlulated! 05:25 Presently I nanoed it.... 05:25 Presently But where'd it go? 05:25 mason woah, babies have arrived here 05:24 Presently "/etc/koha/koha-conf.xml" doesn't exist. 05:23 mason u cant start a new zeb if an existing one is using that port/socket........ 05:22 Presently Hmmmm. 05:22 mason yr zeb *was* listening and responding to queries 05:21 Presently I started two daemons via /etc/init.d 05:21 Presently Perhaps my koha-conf.xml file is wrong? 05:21 mason you have an existing zeb running? 05:21 Presently Is there a chance that zebra simply isn't listening for incomming requests? 05:20 Presently http://pastebin.com/m714848f2 05:17 Presently Play well. 05:17 Presently Thanks. 05:17 chris ack, i have to bail from work and catch my bus to volleyball, good luck 05:17 Presently I infered from README.debian there there would be. 05:16 Presently And I suspect the web-install. It stopped at step three and asked me to login. There were no options for any thing at all. 05:16 mason hmm, lemme grep.. 05:16 Presently But I must have done some thing incorrect. 05:15 Presently and perl -I /usr/share/koha/lib rebuild_zebra.pl -b -w 05:15 Presently I did it three times using perl -I /usr/share/koha/lib rebuild_zebra.pl -b -r 05:15 chris mason can you remember how to query zebra with yaz to see how many records it has? 05:15 chris we are utterly sure its all reindexed eh? 05:15 Presently O dear.... 05:14 chris hmm this is a new one for me 05:14 chris so i dont think its that one 05:14 chris even when not restricting to main 05:14 mason good 05:14 Presently | MAIN | MAIN | 05:14 chris yeah zebra is returning no results 05:14 Presently I seem to. 05:14 mason ive been caught by that bug.... 05:13 mason do you have a 'main' branch 05:13 mason select * from branches where branchcode = 'MAIN'; 05:13 Amit i have a Dell server with 12GB but it search slow with zebra 05:13 Presently http://pastebin.com/m295f7975 05:12 chris amit: there isnt really one, anything you can run debian etch on :) 05:12 chris when you run the search, what is zebra saying? 05:12 chris that all looks pretty good 05:11 Amit what is the minimum requirement of server to run zebra 05:11 Amit hi 05:10 Presently http://pastebin.com/m3b8da252 05:10 mason pastebin it.. 05:09 Presently This gives the biblio information. 05:07 chris (with the ; :)) 05:07 chris select marcxml from biblioitems where biblionumber=the biblionumber from that result 05:07 mason and this is the punchline.... 05:06 chris then 05:06 chris if so 05:06 Presently It does. 05:06 chris and with the ; does the mundi query give you one now? 05:06 Presently select count(*) from biblio; gives the correct number. 05:05 Presently Never mind: forgot the ; again. 05:05 chris as many as youd expect? 05:05 chris even 05:05 chris select count(*) from biblio; 05:05 chris select count(*) from bibliol 05:05 Presently Well that's not good. 05:04 chris nothing with that title exists 05:04 mason ah, yep 05:04 chris ahh theres the problem then 05:04 Presently select * from biblio where title like '%mundi%' gives nothing, by the bye. 05:04 Presently Though, it should have filled it out nonetheless, no? 05:04 mason so, goofy biblioitems.marcxml field = goofy upgrade 05:03 Presently I was not using marc for the first iteration: I have only with the upgrade decided to use it. 05:03 chris and that might have not been upgraded right 05:03 Presently Aha! 05:03 mason sure 05:03 chris zebra indexes the marc that it gets from bibioitems table 05:02 chris and check the marc is ok 05:02 chris then find the corresponding biblioitem 05:02 chris what you want to do is find the biblio in the mysql db 05:02 mason aaaah 05:02 Presently I am using the same db. 05:02 Presently Well, I have the old 2.2 koha, but I don't think that any config files point to it. 05:02 chris mason: its one upgraded from 2.2 05:01 mason and you are reindexing the wrong zeb db 05:01 mason other common mistakes... u have more than one koha on yr system 05:00 chris does masons sql find any results in the mysql db? 05:00 mason hmm, well , im out of immediate ideas 04:57 Presently I also searched with out any extra parameters. 04:57 Presently The bibliography should exist: I put it in last week. 04:56 mason uh, yeah 04:56 mason select * from biblio where title like '%mundi%' 04:56 chris ie, just from the search the catalog(ue) bar thats on all the pages? 04:56 chris have you tried just a keyword search, without the branch limit 04:55 mason soooo, does that bib exist in yr db? 04:55 Presently Searching for just culina mundi also fails. 04:55 Presently No results match your search for 'ti,wrdl: culina mundi' with limit(s): ' branch:MAIN' in The David R. Litwin Library Catalog. 04:53 Presently Fair enough. 04:53 mason stick to titles for inital debugging 04:53 Presently Sorry, I neglected to mention that, didn't I.? 04:53 Presently From the intranet. 04:53 Presently No. 04:53 mason thats not zebra... 04:53 Presently No results match your search for 'au,wrdl: waugh' with limit(s): ' branch:MAIN' in The David R. Litwin Library Catalog. 04:52 Presently I know it is doing some thing right, for I see the different types of media. 04:52 mason ? 04:52 mason 'waugh' is a title 04:52 Presently But it still doesn't find Mr. Waugh. 04:50 mason no probs, the zebra stuff is weird the first few times 04:49 Presently mason: Thanks for your help. 04:49 mason ok, back to some work for me too 04:48 Amit ok 04:47 mason bugs.koha.org 04:47 Amit k 04:47 mason Amit, i think you should log your availability bug 04:43 mason $ set your KOHA_CONF env before u run it too 04:42 Presently I'm about to do it. 04:42 mason your 'waugh' bib may exist in yr koha mysql db, but zebra doesnt know about it yet 04:42 mason if you are having zebra issues , a reindex is a easy way to ensure yr zebra indexes are up-to-date 04:41 mason cant remember... 04:41 Presently By the bye, the webinstaller stops at step three. Is that all there is? 04:40 Amit mason r u there 04:39 mason $ rebuild_zebra.pl -b -r 04:39 Presently What is a reindex? 04:39 Presently Something else, then. 04:39 mason have you done a reindex? 04:39 Presently Ah. 04:38 mason i think your zeb is fine 04:38 Presently Really? Then why does a search for waugh fail? 04:38 mason hmm, looks ok to me 04:38 Amit there is some availbilty issuse 04:38 Amit i have problem in my koha 04:37 Presently Not mine: http://pastebin.com/m46575c8b 04:37 mason thats what a happy zebrasrv looks like starting, and searching 04:36 mason http://pastebin.com/mcfcbd35 04:33 mason /usr/bin/zebrasrv -f /etc/koha/koha-conf.xml 04:33 mason gve it a conf arg 04:33 mason watch yr zeb logs as you search, confirm that your zebra procs are actually getting queries 1st 04:31 mason tail -f /var/log/koha/*.log 04:31 mason but u can tail your zeb logs too... 04:31 Presently Hold on: http://pastebin.com/m63e854fa 04:31 mason and start them in the forground, so i can see what they are doing better 04:30 mason so , what i do here... is kill my zeb processes 04:28 Presently http://pastebin.com/mcc7eff7 04:26 Presently I'll check. 04:26 Presently I should. 04:26 mason ps -ef 04:26 mason you have the zebrasrv process running? 04:26 Presently bash: ps-ef: command not found 04:26 mason ps-ef | grep zeb ??? 04:25 Presently With zebra. 04:25 mason zebra or no zebra ? 04:24 Presently For the search is still not working. 04:20 Presently Quite. Is there a way to rerun the web-installer? 04:18 Presently Poor Don Quixote, the daft knight. And Sancho, so easily duped by dreams of his Ãnsula! 04:18 Presently I'm half-way through the second volume. 04:17 Presently Funny, I'm reading that now.... 04:17 chris heh, ok don quioxite :) 04:17 Presently That's when the language started going down-hill. 04:17 Presently Middle English at least. 04:17 Presently Absolutely. 04:17 chris thee and thou? 04:17 Presently Hyper-correct, with some oddities thrown in. 04:16 chris how far back then? :-) 04:16 Presently Very. 04:16 Presently I correct others when they err. Often much to their chagrin. 04:16 chris ahh, how proper do you want to go? 04:16 Presently I do. I want to teach them all proper English. 04:15 mason wont somebody think of the children! 04:15 chris heh 04:15 mason i want to add a 'txtspk' language 04:15 chris here 04:15 chris you a member of the library 04:15 chris eg, we dont call people patrons' 04:14 chris there are regional varieties 04:14 chris even with out the missing u's 04:14 Presently And the Puritans. 04:14 chris yep 04:14 Presently Silly Mr. Webster. 04:14 chris or american english at least 04:14 Presently HAHA! 04:14 chris its americanese 04:14 chris well its not english 04:14 Presently I'll stop. 04:13 Presently Not making a deal. Merely ranting over improper English. Hehe. 04:13 Presently And are the Americans such a driving froce for New Zealandish software? 04:13 chris its not an issue, we just need localised english options again 04:12 chris because thats what american libraries expect to see 04:11 Presently Why would they do such a deed? 04:11 chris hence catalog, color etc 04:10 chris yep, as i say, its been americanified 04:10 Presently But International English is still British English.... 04:10 chris but its been americanified 04:10 Amit good morning 04:10 chris (it was all british english to start with .. or nz english anyway) 04:10 Amit hi 04:10 Presently Very nice. 04:09 mason hi amit, 04:09 chris there should be one soon 04:09 Presently :-) 04:09 Presently Is there a British ENglish option, or must I edit each file? 04:09 chris ahh a man after my own heart 04:09 chris yeah, for 3.0 (if you chose zebra for searching when running the wbe installer thing) 04:09 Presently By the way, how do I change the cotolog nonsense to catalogue? 04:09 Presently I'll get those done, then. 04:09 Presently Phew. 04:08 Presently Oh. 04:08 chris yes 04:08 Presently Are they necessary to search? 04:08 Amit yes 04:08 Presently Yes. 04:08 chris have you done all the bits to do with zebra? 04:08 chris this is in your 3.0 now? 04:07 Presently Starting to be scared.... No search is turning up results.... 04:06 Amit IST 04:06 Amit Hi List Good morning 03:42 chris that'd do it 03:29 Presently Ah. 'Twas missing the ; at the end. 03:25 Presently Must I run another command so as to save the change made? 03:17 Presently Hmmm. I perform the update items command and then check to see that it has been executed succesfully, only to find it hasn't. Furthermore, when I push the up arrow to see what I entered, it gives me both commands many times.... 03:10 Presently Alright. Thanks for your help. 03:10 mason cya 03:10 chris bbiab 03:09 chris meeting time 03:08 chris something like that .. but with the right values :) 03:08 chris eg update items set holdingbranch='MAIN' where itemnumber=123 03:08 chris update items set holdingbranch='something' where itemnumber=the number of the one you need to change 03:07 chris yep 03:07 Presently I performed the action and I see that I simply forgot to mark the branch for that entry. Can I change it directly from the mysql command? If so, how? 03:05 chris cant hurt 03:05 chris yeah 03:05 Presently Though I may have added new entries.... Better do it again. 03:05 chris cool 03:04 Presently I backed up the database before I began. Just to be sure. 03:04 chris yeah its a nice day for a change 03:04 mason i are bathed in sunlight 03:03 chris so far so good 03:03 mason hows the monday... 03:02 chris hey mason 03:02 mason heya chrissa 03:02 chris you can never have too many backups 03:02 chris just in case 03:02 chris maybe mysqldump the db first 03:02 chris or that :-) 03:02 Presently Thanks. I'll try that now. 03:02 chris or you can change their holding branches 03:02 Presently Oh. I think I know how that may have happened. If I'm right, I'll just delete those entries. 03:02 chris well thats what mysql is complaining about 03:01 Presently How odd. 03:01 chris then you either make that branch (in the branches table) 03:01 Presently That's the problem?! 03:01 chris it will list all the items that have their holdingbranch set to a branch that doesnt exist 03:01 chris select items.* from items where holdingbranch not in (select branchcode from branches); 03:01 Presently I can do that much, though I am not a mysql-knowledgeable person. :) 03:01 chris and run 03:01 chris if you get into your Koha db 03:00 chris yep 03:00 Presently Via mysql? 03:00 chris you know how to get into mysql from commandline? 03:00 Presently Chris: I must say, I didn't quite understand that part. 03:00 chris # items.* from items where holdingbranch not in (select branchcode from branches) 03:00 chris select 03:00 chris # 03:00 chris have you tried running 02:59 Presently Is there any one here that might help with my databaso conversion problem? If so, have a look at http://pastebin.com/m342827fd. THanks.