IRC log for #koha, 2008-09-01

← Previous day | Today | Next day → | Search | Index

All times shown according to UTC.

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

← Previous day | Today | Next day → | Search | Index

koha1