Time Nick Message 00:13 ebegin Hi all. What is the ETA for 3.2beta? 00:14 chobbs OK, marclint is both cool and humbling :) 00:17 gmcharlt ebegin: 3.2 alpha2 by the end of th wekend 00:17 gmcharlt beta as soon as the blockers are closed 00:17 ebegin ok. Thanks. 00:38 brendan so year one birthday and my car treats me to a flat tire :) 00:41 * chris_n hands brendan a virtual jack 00:42 brendan and new tire please :) 00:44 chris_n maybe fix-a-flat? 00:44 * chris_n finally coerces his zebra back to work 00:44 brendan for now pumping it up with a bike pump in a few hours 00:44 brendan a nice work-out for the arms 00:44 brendan tame that zebra 00:48 chris http://blog.bigballofwax.co.nz/2010/03/05/friday-afternoon-funnies/ 00:54 brendan :) 00:58 gmcharlt atu clearly has a future as a very direct therapist 01:01 chobbs Is there a particular pastebin you all use for sharing code snippets in chat? 01:03 gmcharlt pastebot: help 01:04 gmcharlt chobbs: http://paste.workbuffer.org/ 01:05 chobbs Thanks! 01:06 chobbs Anyone know of a good way to pick out one marc record (by number) in a marc file of 90K records? I'm currently looping through all records and using a counter to locate the record of interest. It feels kinda ugly :) 01:08 gmcharlt well, that's pretty much the way to do it 01:09 gmcharlt if you need to do it repeated on the same set of records, you could load and index them, then retrieve the records of interest 01:10 chobbs Well ,the problem is that loading them isn't working, and I'm trying to figure out why :) 01:10 chobbs More accurately, loading seems to work, but indexing is breaking. 01:10 chobbs I've run marclint on the exported_records and it blows up on record 78552, so I'm trying to id what's wrong with that record. 01:11 gmcharlt is 78552 the biblionumber of the database or the sequence number of the bib in the original file? 01:12 chobbs Good question. It's the number zebra_rebuild squawked on. 01:12 chobbs Which would that be? 01:13 gmcharlt could you paste the specific squawk? 01:13 chobbs I knew you were going to ask that - it's scrolled out of my terminal buffer, so I'll need to re-run zebra_build :( 01:14 gmcharlt screen is your friend ;) 01:14 chobbs Actually, it ought to be in theirc log, since I showed it to Chris earlier - wait one. 01:15 chobbs I'm actually in screen, but still no joy :) 01:17 pastebot "chobbs" at 192.168.15.101 pasted "zebra_rebbuild squawk" (4 lines) at http://paste.workbuffer.org/9 01:18 chobbs marclint is having trouble with the record as well - looks like I'm missing a record terminator of some sort 01:19 gmcharlt what do you get when you run yaz-marcdump the_record.mrc 01:19 chobbs let me wait and see - 90,000 records :) 01:20 chobbs well, no errors 01:21 chobbs but it stopped after 21,945 titles 01:22 chobbs (assuming this is a legitimate way of counting records: grep '^245 [0-9][0-9] \$a' out.txt | wc -l ) 01:22 chobbs and it's not 01:22 gmcharlt indicator regex should be [ 0-9][ 0-9] 01:23 chobbs I have 90,589 records, which is pretty much right on 01:23 chobbs yup, figured that out :) 01:23 gmcharlt what does grep -v '^[0-9]' out.txt | grep -v '^$' show ? 01:24 chobbs 90616, which is correct 01:24 chobbs actually, it might be 10 over, if memory serves 01:24 chobbs I thought I had 90,606 01:27 pastebot "chobbs" at 192.168.15.101 pasted "OK, there are errors in there:" (10 lines) at http://paste.workbuffer.org/10 01:28 chobbs found the 10 extra lines :) 01:28 chobbs found the 10 extra lines :) 01:29 gmcharlt ok - less out.txt and grep for ^( will show you the bad records 01:30 chobbs got it 01:30 pastebot "chobbs" at 192.168.15.101 pasted "Bad record" (12 lines) at http://paste.workbuffer.org/11 01:31 chobbs So how would I go about finding the record in my source MARC file, and figure out what I did wrong while building it? I'm in the process of conversion, btw. 01:32 gmcharlt select biblionumber from biblioitems where marc like '1201666%'; 01:33 chobbs sweet 01:34 gmcharlt or if that doesn't work 01:34 gmcharlt select biblionumber from biblioitems where marc like '%Vid22005-04-1150%'; 01:35 chobbs grr. no results in either case. 01:36 gmcharlt try this 01:36 gmcharlt select biblionumber from biblioitems where marc like '%nam2208509%'; 01:36 gmcharlt and 01:37 gmcharlt select biblionumber from biblioitems where length(marc) > 99999; 01:37 * chobbs wonders if biblioitems is indexed: 43 seconds to select count(*) ? 01:37 gmcharlt select(*) is always slow in InnoDB - it's just a quirk of that storage engine 01:38 gmcharlt select count(*), even 01:38 chobbs ah, ok. :) 01:38 chobbs OK, biblionumber 78852 01:39 * gmcharlt takes a wild guess that the lowest biblionumber is your DB is 301 01:40 chobbs select min(biblionumber) from biblioitems; 1 01:40 gmcharlt eh, oh well :) 01:41 chobbs select length(marc) from biblioitems where biblionumber=78852; 120239 01:41 gmcharlt could you paste biblioitems.marcxml for that bib? 01:42 chobbs how would i get that? 01:42 chobbs ne'er mind 01:43 pastebot "chobbs" at 192.168.15.101 pasted "marcxml for 78552" (446 lines) at http://paste.workbuffer.org/12 01:45 chobbs that's not the right one :( 01:45 chobbs hold on 01:46 pastebot "chobbs" at 192.168.15.101 pasted "marcxml for 78552" (89 lines) at http://paste.workbuffer.org/13 01:46 chobbs The new one is based on this url - is this the right way to access it? http://koha:8080/cgi-bin/koha/catalogue/detail.pl?biblionumber=78552 01:47 gmcharlt yep 01:47 gmcharlt is it biblionumber 78852 or 78552 that's the bad one? 01:48 chobbs grumble 01:49 chobbs holy crap we have a lot of those items :) 01:50 chobbs wow, an 8MB marcxml file :) 01:51 gmcharlt whee! 01:51 gmcharlt adding -x to rebuild_zebra.pl causing it to process the bibs in thier MARC XML form 01:51 chobbs Yeah, it's 200K lines long - you sure you want me to paste it, or can we assume it's just plain not going to like it :) 01:51 gmcharlt let's not kill chris' pastebot :) 01:52 gmcharlt ... and that way, it would ignore the 99,999 byte limit of MARC record blob 01:53 gmcharlt but practically speaking, you'll need to duplicate that bib and spread its items around 01:53 chobbs OK, but looking at it, it seems broken. 01:53 chobbs the 952 fields seem to be run together 01:53 gmcharlt what does select count(*) from items where biblionumber = 78852 show? 01:53 chobbs 695 01:54 gmcharlt thought so 01:54 chobbs but that's way wrong 01:54 gmcharlt anyway, try rerrunning rebuild_zebra.;pl with the -x option 01:54 chobbs grep '<subfield code="p">3147' Downloads/bib-78852.marcxml | wc -l 01:54 chobbs 9961 01:54 chobbs 3147 being our barcodes 01:55 gmcharlt ah - is it a magazine? 01:55 chobbs nope, some ridiculous video adapter for computers. 01:55 chobbs tempted to just drop it :) 01:55 gmcharlt indeed 01:56 chobbs although we apparently got them fairly recently (03/2005) 01:56 gmcharlt did somebody really go to the trouble of barcoding over 3,000 video adapters? 01:56 chobbs no, they barcoded 9,961! 01:56 chobbs 3147 is the start of our barcode tag number 01:57 gmcharlt ah right 01:57 gmcharlt what on earth did the poor slop who did it do to get that task? ;) 01:57 chobbs that was the year before I took over, so no idea :) 01:58 chobbs alright, I appreciate your help identifying the problem. Now to figure out what to do about it. 01:58 * chobbs shakes head. 01:58 chobbs That's like 5% of our biblioitems table :) 01:58 gmcharlt more seriously, removing that bib and items for now would make sense - you can then munge that record to split it into a few dozen copies of the bib 01:59 chobbs is that as easy as delete from biblio, biblioitem where biblionumber=78852; ? 01:59 chobbs and items, of course 01:59 gmcharlt just deleting from biblio will cascade all the way 01:59 chobbs in mysql, or through koha? 01:59 gmcharlt in mysql 01:59 chobbs wow, real relationships :) 02:00 gmcharlt are they wonderful things? 02:00 gmcharlt then rerun rebuild_zebra 02:00 chobbs indeed 02:00 chobbs wilco 02:01 chobbs and thanks to screen, I can shut down my computer and head home. Really appreciate the help! 02:04 gmcharlt you're welcome 02:07 brendan my $dbh = C4::Context->dbh; 02:07 brendan oh man sorry wrong window :) 02:07 gmcharlt it's *my* $dbh, I tell you 02:08 * brendan hits head on wall 02:08 brendan poor wall 02:18 chris_n hehe 02:18 chris_n it's Friday eve, brendan ;) 02:18 brendan heh 02:19 chris_n but it sure looks as though you have a handle on things... especially the db 02:19 * brendan feels like my head is stuck in this loop 02:19 gmcharlt time to unroll the loop and do something else for a bit 02:20 brendan not sure all I can think about is MFHD_ITEM etc. 03:33 Amit_G heya brendan 03:34 brendan heya Amit_G 03:45 chobbs gmcharlt: Rrbuild went smoothly this time. Thanks again! 04:20 brendan success 04:52 Nouman zebra process is not running 04:52 Nouman http://pastebin.org/101498 05:17 Nouman Ropouch r u there? 05:19 Nouman http://pastebin.org/101498 05:19 Nouman could any body help me? 05:29 Nouman could any body help me? 05:31 masonj Nouman: you have another zebrasrv already running, i think 05:31 Nouman Masonj: I am doing fresh installation, I have delete previous one 05:31 masonj $ killall zebrasrv 05:32 masonj $ ps -ef|grep zebrasrv 05:33 masonj make sure no other zebrasrv is running, before you start a new zebrasrv 05:33 Nouman I have applied these both 05:33 masonj '13:49:31-03/03 [fatal] Failed to bind to unix:/var/run/koha/zebradb/authoritysocket [File exists]' 05:33 masonj cool 05:34 masonj now start zebrasrv.... 05:34 Nouman o/p is http://pastebin.org/101510 05:34 Nouman Mansonj: Im installing koha-3.00.05 on debian-lenny 05:35 masonj u didnt kill zebra 05:35 Nouman there are two options to start zebra, which one should I select 05:35 masonj # kill 3160 05:36 masonj zebrasrv -f /etc/koha/koha-conf.xml 05:36 masonj starts zebra ;) 05:38 Nouman Masonj: http://pastebin.org/101512 05:38 Amit_G heya Nouman 05:39 masonj # kill -9 3160 05:39 masonj still didnt kill it :/ 05:39 Amit_G heya masonj 05:39 masonj hiya amit 05:41 Nouman Masonj: is zebra now running or not 05:42 Nouman ? 05:42 masonj on your box?, i dont know :) 05:43 Nouman ps -ef|grep zebrasrv root 3429 3413 0 14:40 pts/0 00:00:00 grep zebrasrv 05:43 masonj no, its not running - on your box 05:43 Nouman I dont recognize that whether zebra is running or not o/p is here 05:44 Nouman kill -9 3160 lumhs-b70715be2:/home/nouman# ps -ef|grep zebrasrv root 3429 3413 0 14:40 pts/0 00:00:00 grep zebrasrv 05:44 masonj . 05:44 masonj koha 3160 3128 0 13:49 pts/0 00:00:00 zebrasrv -f /etc/koha/koha-conf.xml 05:44 Nouman Hey Amit 05:44 masonj . 05:45 masonj that shows that a zebrasrv process is running (id=3160) 05:45 masonj so.... start up a zebrasrv ;) 05:45 Nouman Masonj: Im not getting what is its mean? 05:47 masonj hmmm, i gotta go soon... :/ 05:47 Nouman http://pastebin.org/101516 is it runnig or not 05:48 Amit_G Nouman: not running your zebra 05:48 Nouman Amit_G: thanks. plz could u with me as I can complete installation 05:48 masonj no, its not running - on your box 05:49 Nouman ok should I give commands now 05:50 Amit_G Noumna: r u on which OS 05:50 Nouman Im installing koha-3.00.05 on debian-lenny 05:50 Nouman still show same problem http://pastebin.org/101518 05:52 masonj stop zebra, again.... then.. 05:53 masonj EXPORT KOHA_CONF="/home/koha/koha3-prod/etc/koha-confxxxxxxx.xml"; 05:53 masonj EXPORT PERL5LIB='/home/koha/git/koha3-prodxxxxxx' 05:54 masonj $ sudo zebrasrv -f /etc/koha/koha-conf.xm 05:54 masonj l 05:54 masonj try running zebasrv as root, not koha user 05:55 masonj now i go.... bye 05:59 Nouman he is the http://pastebin.org/101521 05:59 Nouman zebra is running or not could any body tell me? if it is running, how can I stop it? 06:02 Amit_G Nouman: Your zebra is running 06:06 Amit_G heya davi 06:12 davi hi Amit_G 06:12 davi How is it going? 06:13 Nouman ps -ef|grep zebrasrvroot 3573 3413 0 15:10 pts/0 00:00:00 grep zebrasrv 06:14 Nouman Amit: is it stop now? if it stop then what should I go to complete the installation 06:27 Nouman I need some help regarding zebra initilization 06:27 Nouman could any one help me 06:31 Nouman nouman@lumhs-b70715be2:/usr/share/koha/bin$ sudo -u $KOHA misc/bin/zebraqueue_daemon.pl sudo: no passwd entry for misc/bin/zebraqueue_daemon.pl! 06:31 Nouman I have above problem 06:33 Nouman is any body there? 06:41 Nouman .. 06:41 Nouman nouman@lumhs-b70715be2:~/koha-3.00.05$ sudo -u $KOHA misc/bin/zebraqueue_daemon.pl sudo: no passwd entry for misc/bin/zebraqueue_daemon.pl! 06:41 Nouman I have above problem 07:09 Ropuch Morning #koha 07:24 Nouman Ropuch r u there? 07:24 Nouman could u help me 07:26 Ropuch Hello Nouman 07:27 Ropuch What's the problem? 07:34 Nouman Ropuch: 07:34 Nouman nouman@lumhs-b70715be2:~/koha-3.00.05$ sudo -u $KOHA misc/bin/zebraqueue_daemon.pl sudo: no passwd entry for misc/bin/zebraqueue_daemon.pl! 07:34 Nouman this is the problem 07:36 Ropuch ok 07:36 Ropuch First thing: $KOHA is variable rather than value 07:37 Nouman so what should I do 07:37 Ropuch sudo -u koha misc/bin/./zebraqueue_daemon.pl 07:38 Nouman no it is not working 07:39 Ropuch What does it say? 07:39 Nouman http://pastebin.org/101550 07:40 Ropuch You have koha up and running? 07:41 Nouman mean? Im not getting 07:41 Ropuch You installed koha? 07:41 Nouman yeah, koha-3.00.04_fixed was installed on this pc 07:42 Ropuch No, that's not what I mean 07:42 Ropuch Have you finished your 3.00.05 instaltion? 07:42 Nouman I remove it and installing 07:42 Nouman no Im still in step 5 07:43 Nouman when I want to install 07:43 Nouman http://<servername>:8080/ 07:43 Nouman it is not installing 07:44 Ropuch You've followed all steps? 07:44 Nouman Yeah, I followed each and every step 07:44 Nouman exactly 07:44 Ropuch Ok 07:44 Ropuch mysql -u root -p 07:45 Ropuch I have an idea what could be wrong 07:45 Nouman Now Im at MYsql> 07:45 Ropuch Ok 07:45 Ropuch create database koha; 07:46 Nouman I have created already 07:46 Ropuch grant all on koha.* to 'kohaadmin'@'localhost' idetified by 'katikoan' 07:47 paul_p hello #koha 07:47 Ropuch Just add ; at the end of line 07:48 Ropuch Hello paul_p 07:49 Nouman I have done it already 07:49 Nouman when I want to run koha installer 07:49 Nouman it show http://pastebin.org/101552 07:50 Ropuch Hm 07:51 Ropuch grep VirtualHost /etc/apache2/sites-enabled/koha 07:53 Nouman http://pastebin.org/101553 07:55 Ropuch Hm. can you try http://121.52.186.197:8080 07:55 Nouman yeah Im trying this 07:55 Nouman it show 07:55 Nouman Not Found The requested URL / was not found on this server. Apache/2.2.9 (Debian) Server at 10.1.2.36 Port 8080 07:56 Ropuch http://10.1.2.36:8080 07:56 Nouman I tried this also but it is also not working, it also show the same prolem 07:57 Ropuch It's odd 07:58 Ropuch Can you replace VirtualHost 121.52.186.197 with VirtualHost 127.0.1.1 07:59 Ropuch In /etc/apache2/sites-available/koha 07:59 Nouman My pc is on netting 08:00 Ropuch I'm not sure I understand 08:00 Nouman actual ip outiside this system is 121.52.186.197 but on my pc it is 10.1.2.36 08:00 Ropuch Oh 08:00 Ropuch Nevermind 08:01 Nouman through same configuration, some one have installed koha on this pc 08:01 Nouman but when I tried to remove and install again 3.00.05 it show this problem 08:02 Ropuch What koha version was installed earlier? 08:02 Nouman 3.00.04_fixed 08:02 Ropuch And it was working, right? 08:03 Nouman all was right but catalgue search from my own system was not working even after completing fast index 08:03 Nouman but search from z39.50 was working 08:04 Ropuch Nouman: you're installing koha for testing,m right? The opac don't need to be accesible from outside? 08:05 Nouman No I want to deploy koha in my organization.. 08:05 Nouman opac as well as intranet search was not working even books were added. while z39.50 was workin. I have imported books via z39.50 08:07 Nouman I replace pwd 12 instead of katikoan of mysql 08:07 Nouman is it my mistake ot it is alright. 08:07 Ropuch It's ok 08:08 Ropuch I was sure you're doing insytall for test only 08:08 Ropuch And inthat case leaving default is better idea for troubleshoting 08:08 Ropuch And avoiding troubles in general 08:09 Ropuch Actually i strongly advice you to do local koha install, test it 08:09 Ropuch And then tune it to your need 08:10 Ropuch Problem with The requested URL / was not found... is not koha-related 08:12 Nouman Yeah! I kept each and every thing by default. 08:12 Nouman What should I do now 08:18 Ropuch I'm just average koha user, not apache expert 08:18 Nouman ok 08:18 Ropuch You replace VirtualHost 121.52.186.197 with VirtualHost 10.1.2.36 08:19 Ropuch And have koha locally untill you'll figure out how to fix apache problem 08:20 Nouman locally? Im not getting 08:20 Nouman I installed at localhost 08:22 Ropuch I mean: you can have working koha that will be anly accesible from local machnes (within 10.1.* network) 08:22 Ropuch You can add some record, configure it 08:23 Ropuch And by the time you decide it's time to go live, I'm sure you'l find the way to fix apache issues 08:26 Nouman but koha is not running 08:26 Nouman so how can I add and configure records 08:28 Ropuch Set VirtualHost to 10.1.2.36, restart apache and try http://10.1.2.36:8080 08:31 Ropuch Hi brendan 08:32 brendan hi Ropuch 08:34 Nouman could any body help me about apache server 08:34 Nouman I have problem 08:41 Nouman when I want to run koha installer or local host at my browser it show 08:41 Nouman http://pastebin.org/101592 08:42 Nouman plz assist me 09:20 Nouman I have some problem could any one one tell me 09:20 Nouman when I want to run koha installer or local host at my browser it show 09:20 Nouman http://pastebin.org/101592 09:21 Nouman plz solve my issue 09:27 slef Nouman: your apache is misconfigured. Check /var/log/apache2/error.log 09:27 slef also make sure the "apache2ctl -S" output lists koha-httpd.conf 09:28 slef I'll just check whether the INSTALL.debian-lenny is correct 09:29 slef So I assume you finished step "4. Configure and start Apache". 09:31 Nouman Slef: it show File does not exist: /htdocs 09:34 slef Nouman: Could you run "grep ServerName /etc/koha-httpd.conf" please? 09:35 Ropuch Hi slef 09:36 Nouman slef: it show grep 121.52.156.200 /etc/koha-httpd.conf grep: /etc/koha-httpd.conf: No such file or directory 09:38 Nouman I need help 09:39 slef Nouman: want to give me access to your computer? 09:39 slef you can watch over my shoulder 09:39 slef (or boot me out, as you like) 09:39 slef if your connection is reasonably high-speed 09:40 slef Oh my mistake! 09:40 slef grep ServerName /etc/koha/koha-httpd.conf 09:40 slef it moved 09:40 slef retry with that command 09:40 slef hi Ropuch 09:40 Ropuch ;> 09:41 Nouman slef: how can I give u acces to my computer in debian-lenny.. I dont know the way. tell me as I can give u access 09:41 Ropuch slef: Nouman seems to be behind NAT 09:41 slef Nouman: try the grep command above first 09:41 slef Ropuch: it won't stop me. 09:42 Ropuch heheh 09:42 slef Ropuch: everyone is behind NAT, even me. 09:43 Nouman I have given. it did not show any output just happen 09:44 Ropuch slef: it's just easier to explain someone to install ssh server, taht's what I meant 09:44 Ropuch ;> 09:44 Ropuch Ok, bbiab 09:47 Nouman http://pastebin.org/101608 09:47 slef Nouman: ok, I'll send you connection details in private 09:47 slef erm, that is output 09:47 Nouman ok 09:48 Nouman output... mean? 09:48 slef OK, have you visited http://lumhs-b70715be2:8080/ ? 09:48 Nouman no 09:48 slef try that - that is where your Koha is installed 09:49 slef whether or not it can hear you - different question :-/ 09:49 Nouman Im not getting what r u saying 09:49 Nouman koha was installed last time 09:50 slef Visit http://lumhs-b70715be2:8080/ and Koha may appear. 09:50 Nouman but now i removed and now trying to install koha it is now showing 09:51 Nouman When I want to put servername:8080 or localhost it show the problem 09:51 slef That is because Koha is listening at lumhs-b70715be2:8080, not servername:8080 or localhost. 09:51 Nouman I removed apache2 and installed it again but change 09:51 slef Removing apache2 will not change where Koha is listening. 09:52 slef Can you put the output of "apache2ctl -S" into pastebin, please? 09:53 Nouman http://pastebin.org/101614 09:54 slef What happens when you visit http://lumhs-b70715be2:8080/ ? 09:54 Nouman it show networki time out 09:55 Nouman http://pastebin.org/101616 09:56 Nouman I was accessing koha in past as http://10.1.2.36:8080 09:56 Nouman I just removed koha and starting fresh installation 09:57 Nouman after that it show this problem 09:57 slef OK 09:57 slef Open the file /etc/koha/koha-httpd.conf 09:58 slef below each ServerName line, add 09:58 slef ServerAlias 10.1.2.36 09:58 slef then save and exit, /etc/init.d/apache2 reload 09:58 slef then retry 09:58 slef What was happening was that Koha is only listening on an address that does not work. 09:59 slef The installer autodetected the address that does not work because your local DNS configuration is slightly broken. 09:59 Nouman http://pastebin.org/101617 09:59 Nouman this is the already connection 10:00 slef Not enough to break most things, but enough to break autodetection. 10:00 slef OK, that is interesting. 10:00 Nouman is it right or not? 10:00 slef I think its address is http://121.52.186.197:8080/ 10:00 slef Try changing line 6 to say 10:00 slef <VirtualHost *:80> 10:01 slef and the similar line later on to say 10:01 Nouman My computer is on netting by Network administrator 10:01 slef <VirtualHost *:8080> 10:01 slef then save&exit, then /etc/init.d/apache2 reload 10:01 Nouman from my computer and network it will be accessed 10.1.2.36 while outside it will be accessed 121.52 10:03 slef so you need to have * in the VirtualHost lines I think 10:03 slef to listen on multiple addresses 10:04 slef I think most servers don't need that, so it isn't the default 10:04 Nouman should I write this way <VirtualHost 121.52.186.197*:8080> 10:06 Nouman or <VirtualHost *:80> only 10:09 slef <VirtualHost *:80> only 10:17 Nouman slef How can I save file 10:17 Nouman I have open this via vi 10:17 slef ZZ 10:17 slef (shift-z twice) 10:23 Nouman slef: I cant do it 10:24 Nouman when I try to do vi /etc/koha/koha-httpd.conf 10:24 slef why not? 10:24 Nouman it is opening but When I want to edit there become error 10:24 Nouman editing is not happeing 10:25 Nouman gedit also open the file but it cant save 10:26 Nouman shift+z twice is not saving the file 10:26 Nouman I think it is read only file and changes could not be happeing 10:31 Nouman changes are not saving 10:34 slef yes, you maybe need to "sudo vi /etc..." 10:34 Nouman even I type to localhost it show same msg 10:39 Nouman slef: I have changed but still show message 10:40 slef what is exact message? 10:41 Nouman http://pastebin.org/101631 10:41 Nouman on top of browser it show 404 not found 10:47 Nouman slef: r u ther? 11:01 slef back 11:01 slef ah, you mean you saved the file? 11:01 slef Did you /etc/init.d/apache2 reload ? 11:05 Amit_G heya slef 11:10 slef Amit_G: hi 11:16 Nouman slef: it show error 11:17 magnus am i overdue for a bit of lunch or does http://koha-community.org/tarballs-of-koha-3-2-available/ imply that http://git.koha.org/cgi-bin/gitweb.cgi?p=Koha;a=tree;f=misc/translator;hb=HEAD is missing a script called install-code.pl? 11:19 Nouman Slef It now show another error 11:19 Nouman http://pastebin.org/101644 11:20 slef magnus: it is in http://git.koha.org/cgi-bin/gitweb.cgi?p=Koha;a=tree;f=misc/translator;h=b3b99b51b65989d74b4a5a71ec93ba7ee9f23e11;hb=d3ca0bd7f6d953e667d29327eb20ee5a7b7be130 11:20 slef Nouman: can you try mysql -u kohaadmin -p koha with the password you gave the installer? 11:21 Nouman No I have give different password to installer and give here different 11:21 Nouman bz same password is not working 11:21 slef Nouman: if that fails, then you need to repeat step "2.2 Create the Koha database" 11:25 magnus slef: thanks, definitely time for lunch then... 11:26 Nouman Slef: I already create this but password to mysql -u kohaadmin -p is changed with the installer 11:27 Nouman so is it necessary to keep same password as I given default in Makefile.PL 11:27 Nouman while '12' in katikoan 11:27 Nouman sorry '12' in mysql 11:27 Nouman what should I do now 11:29 slef You could edit /etc/koha/koha-conf.xml to include the new password. 11:32 Nouman Slef: couple of thanks.. installation is in working. 11:32 Nouman I cant explain my feeling 11:32 Nouman Slef: lot of thanks again 11:33 slef It's OK. I do this stuff all the time for software.coop 11:33 slef usually rather quicker than 3 hours ;-) 11:33 slef but then people need to pay the co-op. 11:34 Nouman IM engaging koha since last 3 months 11:34 Nouman Actually since last 6 months 11:34 Ropuch Nouman: you should have try irc earlier ;> 11:35 Nouman Yeah offcourse 11:35 Nouman what a tremendous acheivement..... 11:35 Ropuch Glad to hear you have your Koha :) 11:35 Nouman Thanks Ropuch 11:36 Nouman one error is still there so should I skip it or fix it 11:36 Nouman http://pastebin.org/101648 11:37 slef That looks to me like $KOHA is not set. 11:37 slef try replacing it with the name of your koha system user account 11:38 Nouman I kept every thing default so what should be my koha system user a/c 11:41 slef checking INSTALL 11:41 Nouamn mean? 11:42 slef "it's also recommended that you create a Koha system user, which you will have specified during the install process." 11:42 slef So I think it was up to you. 11:43 Nouamn Im not getting 11:43 Nouamn if i write su koha then it show koha@lumhs-b70715be2:/home/nouman$ 11:43 Nouamn u mean it? 11:44 Nouamn Im not getting ur point 11:47 Nouamn Slef: r u there? 11:47 Nouamn Im in so hurry to populate web installer 11:48 slef I think that means: sudo -u koha misc/... 11:51 Nouamn it also show same message 11:51 Nouamn I tried it also several times 11:56 Nouamn Slef: r u there? 11:56 Nouamn and should I continue installation without it or first I must fix it 12:01 Nouamn 04Ropuch01 12:01 Nouamn r u there? 12:03 Ropuch Nouamn: try 12:03 Ropuch sudo -u koha misc/bin/zebraqueue_daemon.pl & 12:03 Ropuch Hello nengard 12:03 nengard hiya 12:05 Nouamn Ropuch: its output show 12:05 Nouamn [1] 6724 12:05 Nouamn mean it is working? should I go for installation 12:06 Ropuch ps a | grep zebra 12:06 Ropuch If ist shows line with /usr/bin/perl misc/bin/zebraqueue_daemon.pl 12:06 slef There is no way it will show the same message 12:06 slef "[1] 6724" just means it went into the background 12:07 slef ps 6724 to see its details 12:09 Nouamn it is hanged message is below 12:09 Nouamn sudo -u koha misc/bin/zebraqueue_daemon.pl & [1] 6754 nouman@lumhs-b70715be2:~$ sudo: misc/bin/zebraqueue_daemon.pl: command not found 12:09 Nouamn and it is still in process 12:11 Nouamn http://pastebin.org/101654 12:11 Nouamn is it successful or not? 12:13 Nouamn 04Ropuch 12:13 Nouamn ?? 12:16 slef Hi. I'm stopping answering here because it's all being sent to the email list anyway. BBL. 12:17 Nouamn Slef: plz solve this problem as I can go with installation 12:21 Nouamn Ropuch: plz check it http://pastebin.org/101658 12:47 Nouman http://pastebin.org/101658 12:48 Nouman plz solve my problem 12:52 slef Your problem is that your database is not installed. 12:52 slef Have you run the web installer? 12:53 slef "Note: if you are running in this mode, you may wish to defer starting the 12:53 slef zebraqueue until you've run the web installer (see below)." 12:58 NOuman But database is already exist when I want to create it show already exist 13:02 slef But there is nothing in it 13:02 slef You need to run the web installer to put things in it. 13:04 slef nengard: please don't post just to agree with your boss :-( 13:04 nengard slef - he's not my boss 13:04 slef nengard: I thought you worked for both biblibre and bywater? 13:05 nengard i'm an independant contractor who works for several companies and several libraries and several individuals 13:05 nengard my primary company is bywater 13:05 nengard and so my boss is brendan 13:06 nengard and yes bywater has a deal with biblibre and i do work for them 13:06 nengard and bywater has a contract with equinox and i do work for them 13:06 nengard and bywater has a contract with ptfs and i do work for them 13:07 slef but you have no contract with software.coop, so I'm unhappy you take sides without making your affiliation(s) clear. 13:07 Ropuch :) 13:07 nengard i'm not taking any sides 13:07 nengard that is my own opinion 13:07 nengard i enjoy seeing which companies are doing what with which libraries 13:07 nengard am i not allowed to have my own opinion because i work for a company? 13:08 slef You are allowed to have an opinion, but I think it is naughty to +1 someone you have a commercial relationship with when that isn't obvious to the most causal observer. 13:09 nengard oh please!!! 13:09 slef Why does seeing which companies are doing what with which libraries mean that it should be reposted to koha-community.org and not simply linked? 13:09 slef I don't see that at all. 13:10 slef I also don't understand why I'm locked out of koha-community.org, but I want time to try to regain access and/or talk to wizzyrea before getting too upset with that. 13:11 slef (In case anyone else can look: I got "ERROR: Incorrect password" and I've tried the "Lost your password" but it hasn't arrived.) 13:11 nengard just cause you don't agree doesn't mean you can just assume we all have anterior motives - promoting that libraries are switching to Koha is necessary to further the popularity of Koha - and if that means having the library linked to a vendor so be it - i read these releases way before i worked for any support vendor and i know many libraries that do - it's koha news as much as it's vendor news 13:11 nengard and on that note i'm going to stop this discussion cause i've had one hell of a week and i'm not in the mood to fight with anyone else 13:12 gmcharlt slef: I'll reset your password and pm you 13:13 slef gmcharlt: thanks. 13:14 slef On the context: I think nengard has a clear conflict of interest as several of us do, but new readers would not know that. 13:15 slef On the substance: I think that company X has persuaded company Y to sign a contract for koha is more often news about how persuasive the vendor sales team is and does not say much about koha. 13:16 slef I'm a bit unhappy if koha-community.org becomes simply like koha.org but shared between more companies than liblime. 13:16 gmcharlt thought the PRs do give users one piece of information when they're evaluating vendors - customers of that vendor who have not necessarily been vetted by the future as "good references" 13:18 davi They can evaluate vendors by other methods 13:19 gmcharlt doesn't mean that any possible source of information should be removed 13:20 slef How would a link to the announcement on a company site not acheive the same? 13:21 gmcharlt slef: I apologize - WP-MU is fighting with me on getting your password reset - I'm sure wizzyrea will help once she's online 13:22 gmcharlt also, it's possible the email got caught up in a spam filter 13:22 slef gmcharlt: thanks for trying. 13:22 Nate slef: this is Nate from ByWater... 13:22 slef Yes, I keep strumming the mailbox to make sure, but it's coming into one that I don't control 100%. 13:22 Nate we in no way intend our prs to be proclimations of who we sign 13:23 Nate we dont say X signed Y 13:23 Nate we say Y is using X to get Koha 13:23 Nate we title the release that way to avoid that 13:23 Nate if it is taken another way we apologise 13:24 davi Just say "Y is using Koha" 13:24 davi if you want 13:24 slef Point remains - if it has "is using X" then it should be on your site and linked, not reposted. 13:24 Nate until the community has decided which way to post releases we will hold them 13:25 Nate we will wait for the community at large to decide which semantics are appropriate adn proceed from theere 13:25 Nate we in no way intend on making this a big issue, and will do whatever we all decide is appropriate 13:26 Nate ByWater does not look at teh community site as a way to promote our company. 13:26 slef ok, but I'm not convinced that neutral point of view will prevail because I think most of koha-community are still vendor-linked, so it may need some very persuasive brass-necked people :-/ 13:26 Nate If the community decides that it is appropriate to use it as such an outlet, we will graciously accept, otherwise we will refrain 13:27 slef Nate: on a related note, do you have a social media policy for your workers? 13:28 Nate I can get back to you on that 13:28 slef ok, np 13:30 slef Mainly I wondered if you always have a sig like Brendan's if it's on company time, or if that is only the directors. 13:30 slef no worries 13:31 slef munin: do you ever tell people the later messages? 13:31 munin slef: Error: "do" is not a valid command. 13:31 slef munin: hello 13:31 munin slef: Error: "hello" is not a valid command. 13:32 slef hmm 13:32 jdavidb Mornin'. owen. 13:32 owen Hi 13:33 jwagner Hi owen. 13:36 slef hi owen - I think I'm having interesting times again :-/ 13:36 owen Victim of a Chinese curse? 13:36 slef seem to be 13:42 slef gmcharlt: I think http://koha-community.org/ knows that I want to try to change its title to something like "Koha Library Software Community" and that is why it is resisting - it's gone Artificially Intelligent ;-) 13:43 gmcharlt aye, the problem of the days - turn your back for a second, and your software starts racing towards the Singularity 13:43 slef (we call Koha an LMS more than an ILS, and we call it free software not open source) 13:43 slef gmcharlt: in 12 minutes time, it will invent Skynet. 13:44 slef biab 13:56 chris_n well, the scroll back buffer is hot this morning ;-) 13:56 adegroff happy Friday all 14:05 jwagner @wunder 20740 14:05 munin jwagner: The current temperature in Hollywood, College Park, Maryland is 3.8�C (9:04 AM EST on March 05, 2010). Conditions: Mostly Cloudy. Humidity: 49%. Dew Point: -6.0�C. Windchill: 1.0�C. Pressure: 30.03 in 1016.8 hPa (Rising). 14:10 jwagner @quote random 14:10 munin jwagner: Quote #47: "pianohacker bah, go collision attack the front of a moving car" (added by brendan at 05:15 PM, November 16, 2009) 14:10 magnus ouch 14:11 jdavidb @quote random 14:11 munin jdavidb: Quote #52: "<wizzyrea> Ahh, it's like putting on your slippers" (added by gmcharlt at 03:50 PM, January 28, 2010) 14:15 chris_n @wunder 28334 14:15 munin chris_n: The current temperature in Erwin, North Carolina is 2.0�C (8:42 AM EST on March 05, 2010). Conditions: Clear. Humidity: 52%. Dew Point: -7.0�C. Windchill: -1.0�C. Pressure: 30.09 in 1019 hPa (Rising). 14:22 chris_n does the catalog search in the staff interface not rank results by relevancy? 14:22 chris_n or rather 14:22 chris_n it says it does, but does not appear to? 14:28 CGI149 hello 14:30 owen chris_n: A bug was filed recently about search results being different in the staff client 14:30 magnus chris_n: i get the results in the same order both in opac and staff (running HEAD) 14:30 owen I wonder if it's the same issue 14:32 magnus bug 4116 14:32 munin 04Bug http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=4116 critical, P5, ---, henridamien@koha-fr.org, ASSIGNED, results from cataloging search is different from advanced search results 14:33 owen Oh, no, I guess that's different. 14:33 owen Cataloging search has always been different than regular search 14:34 chris_n it appears that if I search for "An Exact Title" and I have an item by that title, it appears near the bottom of the list rather than the top 14:36 owen title or keyword search? 14:36 chris_n http://tinypic.com/view.php?pic=2j0edl5&s=6 14:37 chris_n keyword 14:37 chris_n but it still should rank at the top 14:37 chris_n I'd think 14:37 chris_n http://i45.tinypic.com/2j0edl5.jpg # less clutter 14:39 chris_n owen: same ranking search both by title and keyword 14:40 owen I get a similar result, which I can't even explain by pointing to additional keyword hits in subject or notes fields 14:41 * chris_n wonders if the ranking algorithm is sorting backwards 14:41 chris_n try a title search 14:42 chris_n of course, if it is like most "problems," I'm simply missing the obvious ;) 14:43 owen What do you mean? 14:44 chris_n owen: the problem I'm seeing occurs when searching by title as well 14:45 chris_n hence, my thought that maybe the sorting is backwards (ie. from least relevant to most relevant) 14:46 wizzyrea slef: it won't become like koha.org if I can avoid it 14:47 chris_n can anyone else running 3.01.00.120 or greater confirm the problem with relevance ranking? 14:48 chris_n g'morning wizzyrea 14:48 wizzyrea morning koha peeps 14:48 chris_n how's the battle with the docbook format going? 14:51 slef wizzyrea: yo! Any idea what's with the password resetter? I'll go check my mailbox again. 14:52 wizzyrea I can't put any SPF records for the domain on until the DNS situation is resolved :( 14:52 wizzyrea so it's likely getting flagged/dumped as spam 14:54 slef I'm pretty sure we don't use SPF, which is broken by design. 14:54 wizzyrea oh, and there's no reverse DNS 14:55 wizzyrea yet 14:56 wizzyrea which is probably the more problematic situation of the two 14:57 slef That's more likely a problem, yes. 14:58 owen chris_n: http://screencast.com/t/MTcwYTZm 15:00 owen chris_n: And the title search: http://screencast.com/t/NzBlMjQ3NTA 15:05 chris_n hmm 15:05 chris_n it appears to be an issue with the one title I mentioned 15:05 chris_n other titles appear to sort correctly 15:06 * chris_n scratches his head 15:06 slef Do I need to ask on the mailing list or at a community meeting about fixing the koha-community.org site name? 15:07 slef Or how best to approach it? 15:07 wizzyrea what do you want it to be? 15:07 slef I was trying to come up with a globally-acceptable one... my best so far is "Koha Library Software Community" 15:07 owen I think it needs a discussion and a vote. 15:08 slef If it gets taken to a first-past-the-post vote, the US view will simply outnumber all. 15:09 wizzyrea well I actually like your suggestion, fwiw 15:09 wizzyrea not a great deal of brain cycles went into the current title 15:09 wizzyrea great number* 15:09 slef Well, I'll email it and we'll see, but I expect some flaming because we're unhappy about "open source" and "ILS" again. 15:10 slef as in "there's nothing wrong with open source" which isn't a discussion I enjoy having, as someone who was involved with the Open Source Initiative before it failed ;-) 15:10 slef having one's nose rubbed in one's mess is never fun 15:10 wizzyrea hehe 15:11 wizzyrea my thought is: it's so new, if we change it... no one will care. 15:11 wizzyrea the software is Koha, we are it's community 15:11 wizzyrea we can say it's free software and and ILS somewhere else 15:12 * wizzyrea is a beg forgiveness rather than ask permission type 15:12 collum I like your suggestion, as well. I think the terms "open source" and "ILS" will eventually become dated. 15:12 slef let me post a "does anyone mind..." sort of thing then 15:12 wizzyrea there was literally no thought involved in titling the page 15:12 gmcharlt +1 "Koha Library Software Community" 15:13 wizzyrea nah I say don't even ask we'll just change it and ask forgiveness 15:13 wizzyrea if someone complains 15:13 wizzyrea (which I don't anticipate) 15:13 * owen will not complain 15:13 gmcharlt +1 to just making that change 15:14 wizzyrea done and done 15:14 tomascohen hi, is there a consensus between koha devs 15:14 tomascohen on how to deal with XML within the project? 15:15 tomascohen I've made some examples for patron import 15:15 tomascohen using XML::Simple 15:15 tomascohen and, before integrating it to koha, i'd like to ask 15:16 tomascohen perhaps XML::SAX is more suitable for large data sets 15:16 tomascohen ideas? thoughts? 15:16 gmcharlt Koha uses XML::Simple in several places, but I have a slight allergy to it 15:16 owen wizzyrea: Did you see the unapi example I msged you the other day? 15:17 tomascohen nope 15:17 tomascohen wizzyrea: no 15:18 wizzyrea yes I did 15:18 wizzyrea tomascohen: ? 15:18 tomascohen gmcharlt: You prefer not to use a DOM based lib? 15:18 tomascohen wizzyrea: sory, it was a mistake, not a good IRC user yet 15:18 wizzyrea oh ;) np np 15:19 wizzyrea tomascohen: we were talking about things that were ever so slightly controversial earlier, I thought you might be voicing an opinion ^.^ 15:20 gmcharlt tomascohen: didn't say that - it's more that XML::Simple can sometimes need an undue amount of fiddling to produce a consistent data structure that doesn't break on certain legal variations in the input 15:21 gmcharlt XML::LibXML or XML::SAX I think would be better for heavy-duty parsing 15:21 gmcharlt and I think it would be worth trying XML::Twig 15:22 tomascohen gmcharlt: as we provide a example csv, I plan to provide a proper xsd for checking xml consistency and help other apps devs to test their output 15:25 magnus wizzyrea: http://koha-community.org/hello-world/ still says "open source" and "ils"... 15:25 wizzyrea um... yes, it does 15:25 gmcharlt and now it doesn't 15:26 magnus great! 15:27 tomascohen wizzyrea: anything that contributes to integrate the community efforts will have my support 15:28 tomascohen that was our goal when creating the spanish-speaking koha community 15:38 paul_p hi world 15:38 moodaepo @wunder 56001 15:38 munin moodaepo: The current temperature in South on Monks, Mankato, Minnesota is -0.6�C (9:36 AM CST on March 05, 2010). Conditions: Clear. Humidity: 64%. Dew Point: -6.0�C. Windchill: -5.0�C. Pressure: 30.26 in 1024.6 hPa (Falling). 15:38 paul_p does anyone know how you could configure mysql to avoid a sql query taking all ressources ? 15:40 moodaepo paul_p: maybe by user is the only option? 15:41 paul_p what i'm looking for is avoiding a mySQL crash if someone does something silly like "SELECT * FROM biblio JOIN items" in the SQL reports 15:41 paul_p atm, if you do that, mysql builds a result set that is biblio*items large. 15:42 paul_p on a 180 000items DB, that means consume more than 8GB of data, and kill the myslq 15:42 paul_p (tested yesterday :\ ) 15:42 wizzyrea oh my 15:42 moodaepo I'd look into setting a decent query timeout (?) 15:43 wizzyrea http://www.google.com/#q=koha&hl=en&fp=1 15:43 wizzyrea is it #2 for anyone else? 15:43 wizzyrea (the title hasn't been spidered yet, don't freak) 15:43 paul_p wizzyrea: nop, for me it's the last entry of page 1 15:43 gmcharlt #9 for me 15:44 moodaepo wizzyrea: seems to be #4 for me on that link. 15:44 wizzyrea how weird 15:44 owen #7 for me 15:44 moodaepo we are talking about koha-community right? 15:44 wizzyrea yea 15:44 wizzyrea signed into google? 15:44 wizzyrea or no? 15:44 wizzyrea (maybe it's some magic of weighting searches based on your history) 15:44 paul_p signed, it's 1st, as I "upped" it. 15:44 * moodaepo heh koha hockey is #2 15:44 * owen is happy to see my Koha blog beating liblime.com in that list :P 15:45 paul_p unsigned, it's last entry of page 1 15:46 moodaepo paul_p: max_execution_time and memory_limit might be something to check for you 15:46 wizzyrea unsigned in on mine it's #2 15:46 paul_p owen: for me, you blog isn't on page 1 (sorry for that) 15:46 gmcharlt #9 if I do it via lynx and reject Google's cookies 15:46 moodaepo unsigned in #5 15:47 wizzyrea welp... so we can say "on the first page" 15:47 gmcharlt seems like it 15:48 wizzyrea I was excited about it showing up #2, now I'm not as excited 15:48 wizzyrea will give the spider a few more days to work... going to check to make sure our links are pointing to the right thing 15:49 chris_n #7 here also 15:51 paul_p moodaepo: /me blind, but can't find "max_execution_time" on mysql doc 15:53 moodaepo paul_p: I just had google mention that to me so it could be an older setting 15:54 moodaepo sql_select_limit then (?) > http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html 15:55 * owen thinks Google is good at showing me what I want to see 15:57 wizzyrea owen: isn't it crazy that they know you so well. Scary. 15:58 moodaepo wizzyrea++ omniscient_google+-?! 16:00 schuster so did my eyes deceive me or did I see that 3.2.beta may be out next week? 16:00 paul_p moodaepo++ 16:03 tomascohen gmcharlt: XML::Twig looks great, I like $twig->purge; 16:04 tomascohen Do u think i'd be ok to put XML::Twig as a dependency? 16:05 gmcharlt not for 3.2, I think, but should be fine for 3.4 16:09 gmcharlt but I'd see great potential for moving more XML processing over to XML::Twig in 3.4 16:20 CGI833 hi 16:21 schuster ;) 16:27 CGI833 does anyone one 16:28 CGI833 know if it is possible to insert cartography in to koha ? 16:29 slef definitely possible 16:30 slef wizzyrea: can we install a table sorter plugin on koha-community.org please? thd suggested it yonks ago and I think I researched it around the time the new site launched. Let me know if I should dig up links. 16:41 wizzyrea we have tables to sort? lol 16:41 wizzyrea j/k, I'll look :) 16:41 owen slef: do you mean for the vendor list? 16:43 wizzyrea actually, I suppose it would be good to know what we need it for 16:43 slef yes 16:43 wizzyrea what if we did something different than table sorting 16:43 wizzyrea can you give me a couple of days to think about the ultimate goal of the support company pages? 16:44 owen Links to different views perhaps? 16:44 wizzyrea I'm thining that a post category + tags would be a better way to handle it 16:44 slef wizzyrea: I think thd-away did a long analysis when new.koha.org launched 16:44 wizzyrea (excluding the cat from the main timeline, of course) 16:45 wizzyrea I will look back through the list for his comments 16:45 * wizzyrea can see a way it could work in her mind 16:46 slef I'll take a look for it in a mo 16:46 wizzyrea okies 16:46 * wizzyrea is also working on a quite huge other project today, and is grateful for help :) 16:47 slef me too 16:54 chobbs Conversion question: what's the appropriate value to put in 952_q to reflect that an item is checked out? 16:56 chobbs Or will that become populated when I import into 'issues'? 16:57 slef chobbs: it should be the due date, I think. 16:58 slef http://koha.org/documentation/manual/3.0/cataloging/item-fields-data-migration 16:58 slef I'm not sure what "Display only field" means there. 16:59 chobbs That's what I thought, but it isn't showing them checked out. That may be because I 've not yet imported into the issues table yet - I've only imported MARC records (with 952 fields attached). 16:59 chobbs Guess I'll work on loading the issues and see if that clears it up. 17:01 gmcharlt chobbs: you'll need to both load issues and set the 952$q value to the yyyy-mm-dd due date 17:02 gmcharlt you can do the latter by using sql item update items.onloan, then running the sync_items_in_marc.pl script 17:02 chobbs good deal, thanks for the info. at least I know I have the 952$q qorking correctly in my conversion script. 17:02 chobbs cool! 17:03 slef wizzyrea: http://old.nabble.com/-Koha-announce--Announcing-...-New-koha.org-Website-based-on-Plone-td23434214.html#a23447686 17:03 wizzyrea sweet ty 17:08 wizzyrea i've already stated that the demos should be handled differently... I'm curious about this map bit, that would be neat to include, and I think the cat/tags would clear up the support company page organization 17:08 wizzyrea localization is another issue, but patience will be required there as I'm new to WP+localization (perfectly happy and willing to learn though) 17:09 wizzyrea as it stands, I'll link to koha-fr.org 17:09 wizzyrea which needs to be done anyway 17:10 slef I don't really see how cat/tags will clear up the support company page organization because there would still be a sort order, wouldn't there? 17:11 wizzyrea mm not necessarily 17:11 wizzyrea every vendor has a post, every post has multiple tags 17:11 wizzyrea click the tags, you get only things relative to that 17:11 wizzyrea so list just the tags, only see the relevant posts 17:12 wizzyrea seewhatimean? 17:12 wizzyrea no sort 17:12 wizzyrea only tags 17:13 slef so we still have someone always top and someone always last? 17:13 wizzyrea I suppose within tags 17:14 wizzyrea but you would have a lot fewer within each tag listing 17:14 slef I think what will happen is the seller listed last on the "view all" would still be last on each tag. 17:15 cm greetings! has anyone here tinkered with facets? I've added the collection code to mine, but I can't figure out how to get it to display the description instead of the code. 17:15 wizzyrea I can look into randomizing the order of posts, dk what else to tell you 17:15 slef I think there are basically two good solutions: random and user-sortable. 17:16 slef I tend to think that user-sortable table and trim down the info on the community site as much as possible (almost all vendors have their own sites anyway) is the better of the two, but if you don't want me to code it, I don't mind it being something else. 17:17 wizzyrea if you have the time and the desire to code it, we can leave that as an option 17:18 * wizzyrea has something tickling her mind about a plugin that handles this kind of thing... 17:18 slef I think I looked up one plugin... I can make a table sortable with javascript, but I can't randomise the starting order or handle non-JS browsers without a plugin IIRC. 17:19 wizzyrea slef: can you give me a few days to think about the vendor page problem? I have a couple of thoughts and I'd rather not go all balls out crazy until I have a chance to think about it a little more :) 17:26 slef wizzyrea: sure. 17:27 slef wizzyrea: I think you have 85% of the info I have on it now. 17:27 wizzyrea okies cool beans 17:27 slef wizzyrea: but I have no idea what I'm doing tomorrow, so if I don't do this now, I'll probably not get time for a week! 18:03 CGI306 hello.. Can anyone tell me How can I find a last borrower of deleted item book 18:06 CGI306 hello.. Can anyone tell me How can I find a last borrower of deleted item book 18:08 jdavidb If you still know the barcode, it should be in the statistics log, as an "issue" transaction. 18:08 brendan looking the old_issues tables 18:09 brendan whoops -- misread the questions :) 18:09 CGI306 yes but item no is not present in old 18:09 CGI306 issues tabe 18:09 CGI306 I have barcode 18:09 CGI306 and I want to know the person who had that book last 18:09 CGI306 From Barcode I got Item number from DeletedItems table 18:10 jdavidb The item number and borrowernumber would be in the statistics table. 18:10 brendan if the item was checked out before and returned -- I'm sure that it should appear in the old_issues 18:10 CGI306 yes it is appearing but Item number is missing 18:10 brendan ahhhh 18:10 CGI306 Let me check the statistic table 18:10 brendan make sense 18:10 brendan hi jdavidb :) 18:11 brendan good day to you 18:11 jdavidb Howdy, brendan! :D you too. 18:12 wizzyrea slef: still around? 18:16 CGI306 Can I have Same Item number for different ItemType? 18:17 CGI306 because I am getting the results from statistics table but there are so many records for that.. and none of that have a borrowernumber that I am looking for 18:18 jdavidb W?HERE type = "issue" SORT BY datetime DESC might be useful 18:47 CGI306 hey guys thanks a lot.. I got the result that I want.. 18:49 * jdavidb has done his good deed for the day, can safely revert to grumpy-mode. 18:53 chris :) 18:54 jdavidb Howdy, chris. :) 18:55 chris craft2.0 today 18:56 chris http://craft2.org/ 18:56 chris laurel is selling her tshirts there, so im on kid duty 18:57 jdavidb ooooo... 19:08 slef wizzyrea: yes 19:08 slef oic 19:38 * owen wonders how the Koha-list poster could be connecting to his virtual machine via ssh but not be able to SFTP 19:38 owen Aren't they the same protocol? 19:40 wizzyrea he could probablty scp 19:42 gmcharlt owen: same protocol, but it is possible to have a server accept ssh login but not sftp 19:45 slef and the other way around 19:46 slef the ssh connection starts up and then there is a subsystem requested 20:40 CGI833 not the same protocol, sftp is an extension of ssh 20:41 CGI833 will someone be kind enough to indicate in what way can I associate an image with a new record? 20:42 CGI833 I can't seem to find any field that allows image upload in the new record interface :P 20:42 owen There isn't. 20:42 owen What kind of image do you want to add? 20:43 CGI833 regular jpeg ou png... actually a map. the image format would be irrelevant 20:44 owen There's always the 856 tag, you could put in the URL to the location on your server where the image was stored 20:49 CGI833 thanks for the reply :) but the client wants images to be displayed along with the reference info.. since it intends to use it to catalog cartography. So I guess I'll have to search for a new system 20:50 owen It sounds like you want a digital library rather than a library catalog 20:52 CGI833 well.. the client wants a ILMS that has images ... you know clients... they can't understand why though they can see the sun, they can't reach it :P 20:52 CGI833 thanks for the help :) 20:53 chris_n CGI833: there is some image storage functionality in Koha 20:53 chris_n but not inside marc records 20:53 chris_n we store images for patrons 20:53 CGI833 I've read in the manual 20:53 chris_n and also images for patron cards 20:53 CGI833 yes 20:53 CGI833 but I needed it to be associated with a record 20:54 chris_n the short is this: it might not be hard to take that and do some additional coding to do what you want 20:54 chris_n the db could get quite big, however 20:57 CGI833 that woud not be an issue though I truelly would rather not to have the images in the database. If I where to code it, I'd place it somewhere on the web server. they're as public as it gets anyway 20:58 CGI833 problem is the system is cgi. and i'd have to learn it 20:58 CGI833 well.. perl 22:00 chobbs Here's a UI question: in our current ILS, when a patron card is scanned whiel checking out the prior patron, it loads the new patron and you can immediately scan items. How tough would it bne top get similar functionality in Koha? 22:01 * chobbs marvels at his typing... 22:01 chobbs I'm envisioning somethink javascripty that matches a regex for our patron barcodes and submits the proper form if it sees one. 22:03 gmcharlt would be easy to do it exactly like that 22:04 chobbs So when can I get a copy of it ;-) 22:04 gmcharlt can you program in javascripty? ;) 22:05 chobbs Not so much... not to say I couldn't learn (just) enough to figure this one out. 22:06 chobbs Assuming I got something hacked toegther, how easy is it to extend Koha so that I could enter the regex through system adminsitration 22:06 gmcharlt fairly straightforward, though a bit fiddling 22:06 chobbs iow, to make something portable enough for others to use 22:06 gmcharlt in the simplest case, you'd make a system preference 22:06 gmcharlt however, since a number of Koha users run multiple libraries in a single database 22:07 chobbs yikes, I see where that leasds :) 22:07 gmcharlt yeah ... 22:07 gmcharlt but if you want to get your feet wet, doing it as a global system preference would be a good start 22:08 chobbs But in theory, I could use a system preference for the regex and somehow incorporate the info from that into a js script and I'm off and running 22:08 chobbs Cool, somethign to do this weekend then :) 22:09 brendan wow I don't have a clue what you said or asked up their chobbs 22:10 chobbs btw, did get my issues imported and it looks pretty good. The only oddity is that OPAC shows all items checked out in the search, but the detail for a biblio looks right 22:11 chobbs brendan: imagine a librarian checking out student after student (we're at a school). The way koha works now, they have to mouse to the patron field to process the next kid. What I'm sugegsting is that the item field would have a script attached that recognizes patron cards and lets them scan right into the book field. 22:12 chobbs So instead of scan card, scan book, scan book, click in patron field, scan card, scan book - instead they scann card, scan book, scan book, scan card, scan book, scan card, scan book, scan book, etc... 22:12 chobbs would elimiate a lot of mousing and clicking 22:13 * chobbs still marvels at his typing. Must be Friday. 22:13 brendan that's how I use the system though? 22:14 brendan i.e you wand the patron card number into checkout spot -- it loads the new borrower... right? 22:14 chobbs only if the cursor is in the top field on the page. Once that happens, the focus moves to the item field and you have to click back to the top field to wand the next patron. 22:15 chobbs my sugegstion allows you to wand the patron card into the item box and it would automatically load the next patron. Right now you get a "The barcode was not found" error if you try that. 22:15 brendan right... 22:15 gmcharlt one barcode input field to find them ... 22:16 * brendan was thinking wrong box.... 22:16 chobbs no worries - it's a bit visual to describe in irc :) 22:16 brendan :) 22:16 brendan I think we are on the same page now 22:16 chobbs now i just need to write it :) 22:17 brendan yup would be a nice improvement and greatly appreciated 22:19 chobbs gmcharlt: any idea why opac would be showing all items checked out? See here for ex: http://koha.nhusd.k12.ca.us/cgi-bin/koha/opac-search.pl?q=sorcerer%27s+stone 22:20 brendan gmcharlt - RE: wiki - how much of the old info are you looking to bring over? or just assign someone to be responsible for porting a page/section on old wiki --> to new_update_awesome_koha_community wiki... 22:23 gmcharlt chobbs: you may need to reindex 22:23 chobbs i'll give that a shot 22:23 chobbs at least it won't blow up with my thousands of adapters again :) 22:24 gmcharlt brendan: I'm neutral on that question, really 22:24 brendan yeah it seems that parts are useful and others... I could care less about 22:24 gmcharlt I'm happy to bring over old content if we can get a recentish dump 22:25 gmcharlt or reconstruct it from the various crawls that people have been making 22:25 gmcharlt but there's a lot to be said for start with a blank slate and just manually copying over the good bits 22:26 gmcharlt and of course, the answer to that question may well be different for en vs ua vs es vs fr, etc. 22:26 brendan yup, that's the big key there 23:11 chobbs Is there any magic for creating authority records from MARC records? This is one area I've not spent much time looking at yet. 23:12 SelfishMan ha, perfect timing since I was about to ask the same thing 23:13 chobbs I'm wondering if I need to build the authority marc file separately as my conversion script loops through my bibliio marcs. 23:13 chobbs I don't have any real idea what I'm talking about tho :) 23:15 * chobbs isn't exactly sure what an authority record actually is