Time  Nick      Message
16:42 owen      kados around, by any chance?
16:43 chris     owen: u tried this http://simms.celt.dias.ie/~gavin/opac/ ?
16:43 chris     its zippy
16:44 owen      What's experimental about it?  Do you know the story?
16:44 chris     are you on the koha-devel list?
16:44 chris     see the message from gavin
16:44 owen      yeah, but I haven't caught up in the last couple days
16:44 chris     ahh
16:44 chris     that will explain it
16:45 chris     hes got some ideas worth trying to speed up the opac
16:45 chris     but now i must go to my meeting
16:46 owen      Definitely speedy
16:53 GenjiZzZz rach: whenever you see this, have a look at the sidebar again, ive implemented the branch search. search for 'reincarnation' then search within, select Wellington. two test items will result.
18:09 Genjiaway hiya. back from shower.
23:35 Genji     a quiet day in koha channel.
02:14 Genji     hiya paul
02:14 paul      helly Genju
02:14 paul      (Genji, sorry)
02:17 Genji     how goes?
02:59 JYL57     hello
02:59 paul      hello le nord est ;-)
02:59 hdl       hello
02:59 JYL57     Salut Paul !
02:59 JYL57     salut hdl
03:00 JYL57     j'ai des maintenances à faire pour Koha, 2.2.3 pour bientôt ?!
03:01 JYL57     Paul, j'ai déjà posé la question à hdl il y a qques semaines, mais on m'en reparle ici...
03:01 JYL57     comment faire pour une recherche sur nom + prénom ?!
03:01 paul      fin de semaine voitre semaine prochaine.
03:01 paul      dans quel écran ?
03:01 JYL57     intranet + opac
03:02 paul      je ne comprends pas la question.
03:02 JYL57     on a bien une zone auteur, mais on stocke pas le prénom
03:02 paul      ah, ok, je pensai que tu parlais des lecteurs...
03:02 paul      pour étendre les recherches, tu peux utiliser le "see also".
03:02 JYL57     chez nous dans l'OPAC par exemple, personne ne trouve "victor hugo" !
03:02 paul      le prénom est ou chez vous ?
03:03 paul      (et le nom ?)
03:03 JYL57     je crois que c'est en 700 quelque chose... (avec Jocker!)
03:04 JYL57     ce qui est sûr, c'est que prénom et noms sont séparés !!
03:05 paul      l'auteur doit être dans le 200$f
03:05 paul      donc :
03:05 paul      Koha >> Paramètres >> grilles de catalogage >> grille par défaut >> 200 >> modifier
03:05 paul      dans la zone seealso, tu entres '700a','700b'
03:06 paul      avec les ' et une virgule entre chaque zone
03:06 JYL57     oui, j'ai déjà fait ça je crois...
03:06 paul      dorénavant, toutes les recherches sur l'auteur inclueront automatiquement les champs 700a et b
03:06 JYL57     ça a marché pour la recherche sur titre + sous-titre
03:06 paul      et bien tu n'as plus qu'à le faire pour les auteurs.
03:06 paul      ;-)
03:06 JYL57     bon, il faut que je vérifie mes paramétrages...
03:07 JYL57     autre point si tu as 2 mn
03:07 JYL57     nos perfs tombent un peu en ce moment
03:07 JYL57     Il y a pas un reindex à lancer sur mysql ??!
03:08 JYL57     j'ai pas vu ça dans les docs d'admin sur kohadocs...
03:09 JYL57     faut dire qu'on est passé de 500 à 5000 bouquins et de 10 à 300 lecteurs...faut sûrement réaligner les index !
03:10 paul      mmm... a priori rien à faire
03:10 paul      c'est quoi votre serveur ?
03:10 JYL57     paul, je reviens sur le 'see also'. Il génère un OR dans la clause where ?!
03:10 paul      ???
03:11 JYL57     c'est un bon pentium avec 512 Mo et Mysql 4.0 je crois.
03:11 paul      et la chute de perf est réellement importante ?
03:11 paul      j'ai un client avec 50 000 documents et une grille unimarc très grosse
03:11 JYL57     si il fait 'select... where nom = 'victor hugo' Or prenom = 'victor hugo', ça m'aide pas !
03:11 paul      et il n'a pas trop de pb d perfs.
03:12 paul      ben non, évidemment. Il cherche les 2 séparémment. Koha n'est pas bète ;-)
03:12 paul      (et pour ca, il emploie des tables d'index spécifiques)
03:12 JYL57     pour les perfs, j'y passe tout à l'heure alors je jugerai...
03:12 JYL57     Ok, good !
03:13 JYL57     tu confirmes qu'il n'y à pas d'administration à faire sur le mysql ?!
03:14 paul      je confirme
03:14 JYL57     Merci ! bonne journée !
03:14 paul      bonne journée
03:18 Genji     ah. how goes paul?
03:19 paul      Genji, i'm fine, thanks.
03:19 paul      (a lot of frenchies today...
03:19 paul      )
03:19 Genji     so i noticed.
03:19 Genji     #koha has been rather dead, today.
03:20 paul      yes, somtimes quiet, sometimes very busy...
03:20 osmoze    hello all
03:21 Genji     Ahhhhh!
03:23 JYL57     paul, hdl , j'ai oublié une question
03:23 Genji     okay, an easy way to insert my little sidebar into any template, is for the template editor of a specific template to create a table, enclose their normal body in one column, and TMPL_INCLUDE NAME="Sidebar.inc" in the other column..... that would work?
03:24 JYL57     comment gérer les nouveautés ?! j'explique: on souhaite les identifier à l'entrée et éventuellement au retour
03:24 paul      genji, tables should not be used for such things.
03:24 paul      maybe a <div id="bloc20"> should do what' you're looking for
03:25 paul      in HTML, tables should be only used to show lists of datas, not to place things on the page.
03:25 paul      anyway, don't hesitate to commit to cvs-head, as it's developper area.
03:25 Genji     if i remember how.
03:25 paul      so, even if it's not perfect, someone will take care of it, for sure.
03:26 paul      JYL57 : question complexe, qui n'a pas de réponse uniqe.
03:26 JYL57     suis preneur pour une solution simple !
03:26 JYL57     si itemtype = 'nouveaute' je peux contrôler la diffusion, mais je pers le type de document...
03:27 Genji     Regarder juste la traduction m'a incité à penser. "ce qui ??"
03:27 JYL57     Sorry Genji, you're right, I should speak english here...
03:28 Genji     hehe
03:28 Genji     hey, it was fun using babelfish.
03:28 paul      (in fact, we should speak english when english ppl are here. otherwise, french is fine)
03:28 Genji     am taking for a simple solution! if itemtype = ' nouveaute' I can control the sea-green diffusion, but I the type of document...
03:28 Genji     sea-green diffusion?
03:28 JYL57     Nope ! as Koha is international, english is useful
03:30 JYL57     perdre = to lose
03:30 JYL57     je perds = I'm losing
03:32 JYL57     Paul, rereading the log I understand that Koha searches for name and then for surname ("Il cherche les 2 séparémment") ?!
03:32 paul      of course.
03:33 JYL57     can you explain or point me to the search syntax ?!
03:33 JYL57     Ok, but I have neither name = 'victor hugo' nor surname =  'victor hugo' !!
03:34 JYL57     I do have part of my search in two separate fields !
03:34 paul      don't care about how koha do a search. It works, that should be enough for you ;-)
03:35 JYL57     Ok
03:35 paul      (in fact, it search into a table where words are stored 1 by 1)
03:35 JYL57     marc_word
03:35 paul      (so searching victor hugo means searching biblios that have victor & hugo as word)
03:35 paul      yes
03:36 JYL57     Ok, another final one ! any way to populaye back from koha to marc_tables ?!
03:36 paul      populate what ?
03:36 JYL57     s/populaye/populate/
03:36 JYL57     itemtype
03:37 JYL57     I've changed the bulkmarcimport script, it's ok for new biblio, but I can't redo my already stored ones
03:37 JYL57     I had tried to hack the bulkmarcimport with a new /u option (for update)
03:38 paul      you need to use NEWmodbiblio instead of NEWnewbiblio
03:38 JYL57     but it failed... It would be useful for many people I think
03:38 paul      (it will destroy any local data, except items)
03:38 Genji     paul, by the way, think it was you who took out my bugfix to modsubject...
03:40 JYL57     I used newmodbiblio but wasn't successful if I remember well, will try again soon for sure !
03:43 paul      Genji what about modsubject hack ?
03:43 Genji     sub modsubject {
03:43 Genji         my ( $bibnum, $force, @subject ) = @_;
03:43 Genji         my $dbh = C4::Context->dbh;
03:43 Genji         my $error = &OLDmodsubject( $dbh, $bibnum, $force, @subject );
03:43 Genji      return ($error);
03:43 Genji     }    # sub modsubject
03:44 Genji     doesn't update marc. so, useless for catalogsearch.
03:44 Genji     fix.
03:44 Genji     insert this between my $error and return.
03:44 Genji     if ($error eq ''){
03:44 Genji         # When MARC is off, ensures that the MARC biblio table gets updated with new
03:44 Genji         # subjects, of course, it deletes the biblio in marc, and then recreates.
03:44 Genji         # This check is to ensure that no MARC data exists to lose.
03:45 Genji          if (C4::Context->preference("MARC") eq '0'){
03:45 Genji              my $MARCRecord = &MARCkoha2marcBiblio($dbh,$bibnum);
03:45 Genji              my $bibid = &MARCfind_MARCbibid_from_oldbiblionumber($dbh,$bibnum);
03:45 Genji              &MARCmodbiblio($dbh,$bibid, $MARCRecord);
03:45 Genji           }
03:45 Genji         }
03:45 Genji     works well in my install.
03:47 paul      when did i took out this fix ?
03:58 Genji     itemtype has the same problem. transfering a book doesn't update the marc database with new holdingbranch info.
03:58 Genji     only the old db.
03:58 Genji     err.. not itemtype... items.holdingbranch.
07:17 Genji     whens the bugfixing session?
07:17 Genji     in 2 hours?
07:20 Genji     eh yes.. in two hours... hrm.... ill try for a short nap..
07:43 paul      ca s'en va et ca revient ;-)
07:47 FrancoisL C'est une chanson populaire...
08:06 kados     hi all
08:06 kados     does anyone know: do we fully support UNICODE in Koha?
08:06 paul      'morning joshua
08:06 paul      not at al.
08:06 paul      but that's something SAN want to implement
08:07 kados     right
08:07 kados     hi paul :-)
08:07 kados     today I will test your scripts
08:07 kados     after the bugsquashing session
08:08 paul      results are really great on my biggest DB, so they should be atonishing for you.
08:08 kados     I'm excited to try it!
08:08 FrancoisL Hi, Paul & Joshua ! I don't know if UNICODE will make it this year - the list is already quite long...
08:08 paul      (& i'm sure it can be improved. For example, no need to index the old title. only 10-15 chars should be enough)
08:08 paul      (resulting in a smaller table
08:08 paul      francoisL, I agree with you
08:08 kados     hmmm ... why not index the old title?
08:09 paul      (did you see my request for a phone coll ?)
08:09 kados     no ...
08:09 paul      ??? kados ?
08:09 kados     paul: I didn't see request for a phone call ...
08:09 paul      (sorry, the phone call request is for francoisL)
08:09 kados     ahh
08:09 kados      :-)
08:09 paul      (private msg)
08:10 kados     so does Koha support UNICODE in the DB at least?
08:10 paul      yes, if you setup mysql with it
08:10 paul      but for searches you may have some trouble.
08:11 FrancoisL ??? Paul: where did you request the phone call ? I'll call you in 10 minutes... ?
08:11 paul      (francois L : a little private irc message 3 minuts ago)
08:12 paul      (in 10mn it's OK. It's to speak of SAN, of course)
08:12 FrancoisL (Sorry : did not see it - it's there though... My fault. I call you in 5 minutes)
08:13 hdl       hi kados
08:13 hdl       and all
08:21 kados     hi hdl
08:30 kados     First Bugsquashing Session in 30 minutes
08:35 kados     anyone have indradg's email address?
08:45 kados     T Minus 15 minutes till the first Bugsquashing Session
08:50 kados     T Minus 10 minutes till the first Bugsquashing Session
08:56 kados     T Minus 05 minutes till the first Bugsquashing Session
09:00 kados     OK ... Bugsquashing Time
09:00 kados     Who's here?
09:00 paul      i'm here
09:00 paul      (as well as hdl)
09:00 kados     :-)
09:01 kados     indradg and slef said they would be here too ... let's give them a minute or three ;-)
09:01 kados     anyone have' indradg's email address?
09:02 kados     so before they arrive, let's decide how to query the bugzilla ;-)
09:02 kados     I created a query 2.2 and HEAD: all bugs except enhancement requests
09:02 GenjiNap  hiya
09:02 GenjiNap  im here
09:02 kados     hey Genji ... welcome ;-)
09:02 Genji     took a beautiful nap.
09:03 kados     with that query I get 87 bugs listed
09:03 paul      Genji i've commited you modsubject code in 2.2
09:03 kados     does this query sound ok to everyone?
09:04 kados     (the query is saved )
09:04 Genji     sure.
09:04 paul      how can I run it ?
09:04 kados     ok ... so ... I guess we will start without slef and indradg
09:04 kados     paul: it should be listed under saved queries
09:05 paul      (i've only mine, not yours)
09:05 kados     Run the remembered query
09:05 kados     strange
09:05 kados     maybe it's only a local setting?
09:05 kados     ok ... here's how I built it
09:05 paul      (i think it depends on your login)
09:05 kados     program: koha
09:05 kados     version: 2.2 and HEAD
09:06 kados     Severity: all except enhancement
09:06 paul      (cvs you mean, not head)
09:06 kados     right ;-)
09:06 paul      OK, getting 87 same as you
09:06 kados     great
09:06 kados     start at the bottom?
09:07 Genji     whats the url for the bugtracker?
09:07 kados     Genji: bugs.koha.org
09:07 paul      http://bugs.koha.org/cgi-bin/bugzilla/buglist.cgi?bug_status=NEW&bug_status=ASSIGNED&bug_status=REOPENED&bug_severity=blocker&bug_severity=critical&bug_severity=major&bug_severity=normal&bug_severity=minor&bug_severity=trivial&email1=&emailtype1=substring&emailassigned_to1=1&email2=&emailtype2=substring&emailreporter2=1&bugidtype=include&bug_id=&changedin=&votes=&chfieldfrom=&chfieldto=Now&chfieldvalue=&version=2.2.0&version=CVS&short_desc=&short
09:07 paul      desc_type=allwordssubstr&long_desc=&long_desc_type=allwordssubstr&bug_file_loc=&bug_file_loc_type=allwordssubstr&field0-0-0=noop&type0-0-0=noop&value0-0-0=&cmdtype=doit&namedcmd=2.2&newqueryname=&order=Reuse+same+sort+as+last+time
09:07 paul      (a little bit too long...)
09:07 kados     here's a better one:
09:07 kados     http://tinyurl.com/bvnnw
09:08 kados     Genji: find it?
09:08 kados     so ... starting from the bottom:
09:08 kados     986: checkmarc.pl should notice null frameworkcode
09:09 kados     paul: you're listed as owner ... is that correct?
09:10 paul      which ordering do you use ?
09:10 Genji     The named query 2.2 and HEAD: all bugs except enhancement requests seems to no longer exist.
09:10 kados     Gen use http://tinyurl.com/bvnnw
09:10 kados     Genji: use http://tinyurl.com/bvnnw ;-)
09:10 paul      (because for me 986 is in the middle of everything, not on bottom)
09:10 Genji     did
09:10 kados     paul: I used order by bug id number
09:11 paul      ok, i did it by severity ;-)
09:11 kados     hehe ...
09:11 kados     which is better? does it matter?
09:11 paul      no.
09:11 paul      OK for 986, I accept it.
09:11 kados     great ...
09:11 kados     how about a timeframe?
09:12 kados     (I'll make a note on the bug so we remember)
09:13 paul      i think we should just say : I solve them by severity
09:13 kados     ok
09:13 paul      (from bloquing to enh)
09:13 kados     right ... sounds good
09:13 paul      this one is normal, sounds the correct severity
09:13 kados     right ... ok ready to move to 985?
09:14 paul      yes, & it's a strange one ;-)
09:14 kados     985: Deleting from OPAC Virtual Shelves crashes
09:14 kados     right
09:14 kados     I think I remember a similar problem but I also think it is now fixed
09:14 kados     can anyone else confirm the bug?
09:15 Genji     don't have a readymade dataset to try with.
09:15 paul      can't reproduce it
09:15 Genji     i.e haven't got any virtual shelves made yet.
09:15 kados     ok ... I'll take this one since I remember it
09:16 kados     I'll make sure it's fixed and if not I'll let everyone know
09:16 paul      ok
09:16 kados     984: Bug in installer appears to not correctly escape password
09:16 paul      (joshua : i'll take care of any bugzilla changes that are assigned to me. I let you deal with all others)
09:17 kados     paul: sound good :-0
09:17 kados     Genji: use the tinyurl
09:17 kados     Genji: http://tinyurl.com/bvnnw
09:17 kados     Genji: does that work for you?
09:17 Genji     the tinyurl does not.
09:17 kados     strange
09:17 kados     ok ... sorry then
09:18 kados     984: Bug in installer appears to not correctly escape password
09:18 kados     this is assigned to MJ
09:18 kados     so we'll move to next bug
09:18 kados     982: Internal Server Error
09:18 kados     Genji: :-)
09:19 paul      982 is fixes in CVS. I change the bug.
09:19 kados     cool
09:19 kados     981: opac-userdetails.pl crash
09:20 paul      oups, no it's not fixed.
09:20 kados     looks like it comes with a patch
09:20 paul      but i'll take care of it anyway.
09:20 kados     ok ... thanks
09:20 kados     981: opac-userdetails.pl crash
09:20 paul      Genji it's bookbag
09:21 Genji     981 is a nobrainer fix.
09:21 kados     right ... I'll fix it in HEAD
09:21 paul      how do we reach opac-userdetails.pl ?
09:22 Genji     why in HEAD and not 2.2?
09:22 paul      i'll take care of 2.2
09:23 Genji     opac-userdetails.pl will be in opac-cgi directory.
09:23 kados     paul: in a cvs tree it's in koha/opac/opac-userdetails.pl
09:23 paul      I know, i was wondering how to reach it from opac ;-)
09:23 paul      (in my firefox)
09:24 hdl       maybe when getting more details on member
09:24 kados     ahh ;-)
09:24 hdl       when logged
09:24 kados     paul: can you close out bug
09:24 Genji     maybe /cgi-bin/koha/opac-userdetails.pl?bibid=1?
09:24 kados     980 and 978 are owen's so we'll skip them
09:25 kados     976: duplicating a MARC field (with +)
09:25 paul      fixed yesterday
09:26 kados     cool ... could you close it out?
09:26 paul      oups, no
09:26 paul      (it's not a bug, it's an enhancement)
09:26 kados     ok ... so we'll skip it then ;-)
09:26 paul      what i fixed yesterday was : clicking on + duplicate the last field as well as the requested field.
09:26 kados     paul: can you change the status?
09:26 paul      ok, i mark it enh
09:27 paul      done
09:27 kados     great ... so ... moving along ...
09:27 kados     975: serials : renewal of a subscription
09:27 paul      nothing to add, it's a bug, and a non trivial one to solve
09:27 kados     suggestions are creating new biblios?
09:27 paul      (but not a critical ones)
09:28 kados     ok ... so paul is assigned?
09:28 paul      oups, I should be the owner
09:28 kados     (re-assigned?)
09:28 paul      when a subscription is renewed, a suggestion is created.
09:28 kados     971: Incorrect use of term 'keyword' in searching template
09:28 paul      but when the suggestion is ordered, a new biblio is created (that's normal)
09:28 kados     right ...
09:29 paul      so we should keep track that the suggestion comes from a renewal.
09:29 paul      & not create the biblio
09:29 paul      ok, 971
09:29 kados     I think I remember this one
09:29 kados     it's a technical criticism of our use of 'keyword'
09:30 kados     probably justified
09:30 kados     but also probably a 'enhancement' rather than a bug
09:30 paul      (not really a normal bug, but a mior one)
09:30 Genji     this simply a template text adjustment, or is this a code change as well?
09:30 kados     Genji: it depends on how you approach it ;-)
09:30 kados     if we're going to use the term 'keyword' we'd better make sure we know what it means IMO
09:31 kados     otherwise technical librarians may complain that our product doesn't conform to library standards
09:32 kados     right ... so I"ll move this to 'enhancements' and make a short note about the need to check for library standard for 'keyword'
09:32 paul      ok for me
09:32 Genji     think, that the possible technical description of 'keyword' may be facilitated by already, by 'subject'.
09:33 kados     969: Overriding waiting item results in cancelled reserve
09:33 kados     this is a tricky one
09:34 kados     it's the last major reserves/renew bug
09:34 kados     that NPL has found
09:34 kados     I wasn't able to solve it when I looked
09:34 kados     (but I didn't look too hard ;-))
09:34 paul      (as most of reserve & issues code comes from katipo)
09:35 Genji     give me a mo.
09:35 kados     while Genji is looking  ... let's move on
09:35 kados     967: In Katipo templates if acquistions set to normal, the links
09:36 kados     this looks like a katipo-centric bug
09:36 kados     so we'll skip it
09:36 kados     966: Attempting to add a biblio results in warning about possible
09:37 kados     duplicate
09:37 paul      fixed since 2.2.1 i think
09:37 paul      (or 2.2.2, but fixed)
09:37 kados     cool ... so paul can close it ;-)
09:38 paul      reassigning & fixing it myself
09:38 kados     961: Error message, when deleting an authority
09:38 Genji     assign me 969
09:38 paul      it's fixed
09:38 kados     Genji: ok
09:39 kados     Genji: what's your email?
09:39 paul      it was bug in the redirct after deletion
09:39 Genji     waylon at robertson dot net dot nz
09:39 kados     paul: great!
09:39 paul      (however, what about pascale request
09:39 paul      to create a "authority" component ?
09:40 paul      can you create components ? I can't myself
09:40 paul      (or i don't know how to do ;-)
09:40 kados     paul: no ... I think chris has to
09:40 paul      ok, you sent a mail to chris ?
09:41 kados     paul: yep ... actually I'll just do a bug report ;-)
09:41 kados     and make sure I catch chris later on
09:42 kados     958: Field "notes" becomes empty at receipt
09:44 paul      ok, I have to dig the bug. accepting it
09:44 kados     cool ...
09:44 kados     957: Bad calcul of the total in the order line after receipting
09:44 kados     (maybe related?)
09:45 paul      not sure. probably a bug in calculations.
09:45 paul      but i'll try to kill it as well
09:45 kados     great ...
09:45 hdl       But the fact is that it might not be a bug :
09:46 paul      of course, i'm Release Maintainer
09:46 kados     :-)
09:46 hdl       estimated cost : can be when you are provided a bargain
09:46 paul      (note also that i sent this boring stuff to hdl ;-) )
09:46 paul      (hdl : it's a joke :-D )
09:46 kados     953: Request for translation page
09:46 kados     sounds like a good suggestion for the website ... I'll forward it to that group
09:47 paul      ok, not a one for me ;-)
09:47 paul      (do you know joshua bureau.paulpoulain.com/kartouche/ ?)
09:47 paul      (it's for translation to french & italian)
09:48 kados     no ... but looks interesting
09:48 kados     I'll forward that too
09:48 paul      i can set up this tool for any iso8859-1 language
09:48 kados     952: updatedatabase not checking whether table already populated
09:48 kados     sweet
09:49 Genji     okay. found the code to be fixed in circ2.pm
09:49 kados     Genji: for 952?
09:49 paul      (no, 969 probably)
09:49 kados     no ;-)
09:49 kados     Genji: is it difficult to fix?
09:49 Genji     nope.
09:49 Genji     goto line 844 in circ2.pm
09:49 kados     cool ... can you commit a fix to CVS? (are you setup to do this)
09:50 kados     ok I'm at 844
09:51 kados     hey owen ...
09:51 paul      'morning owen
09:51 owen      Hi
09:51 hdl       hi
09:51 kados     owen: 978 and 980 are NPL-specific right? what's the status on those?
09:52 kados     (when you get settled ;-))
09:52 Genji     okay, WinCVS isn't set up for any CVS'ing ... no
09:53 owen      Let me check the status of those...
09:53 kados     Genji: ok ... tell me the fix and I"ll commit it
09:53 kados     in the meantime ...
09:54 kados     952: updatedatabase not checking whether table already populated
09:54 paul      nothing to say on this except :
09:55 paul      IMPORTANT NOTE: error message "Duplicate entry 'X' for key 1" may appear. it
09:55 paul      should not be a real trouble
09:55 paul      1,2003-11-06,2,0,
09:55 paul      2,2003-11-06,4,0,
09:55 paul      2,2003-11-06,,0,
09:55 paul      DBD::mysql::st execute failed: Duplicate entry '2' for key 1 at
09:55 paul      scripts/updater/updatedatabase line 1304.
09:55 Genji     kados: need to get cvs going anyway, so ill take responsiblity for cvsing it.
09:55 kados     Genji: great!
09:55 paul      that is mine, can't be solved & is not really a problem
09:55 kados     Genji: there's a great explaination of how to do it from the Koha project sourceforge page under 'CVS'
09:55 paul      (it's when upgrading from 2.0 & in this case only)
09:56 kados     paul: so it's just a warning -- not really a bug?
09:56 paul      the 2nd one yes.
09:56 paul      the 1st one probably
09:56 paul      i mean :
09:56 paul      DBD::mysql::db do failed: Duplicate entry '1-Library of
09:56 paul      Congress/z3950.loc.gov:7090/voyager///USMARC
09:56 paul      HTTP://LCWEB.LOC.GOV/CGI-BIN/ZGATE?ACTION=INIT&FORM_HOST_PORT=/PROD/WWW/DATA/Z3950/LOCILS.HTML,Z3950/ht...'
09:56 paul      for key 2 at scripts/updater/updatedatabase line 1127.
09:56 paul      I never saw this before
09:56 kados     I've seen it
09:57 kados     with NPL's use of updatedatabase
09:57 kados     but I don't know if it's causing a problem
09:57 kados     (I don't think so)
09:57 paul      probably not, as it's trying to fill again seomthing already filled
09:57 kados     right
09:57 kados     so we'll close it then?
09:58 kados     paul can you close it with a short note?
09:58 owen      Bugs 978 and 980 have already been resolved, so I marked them fixed.
09:58 kados     owen: cool ... thanks!
09:58 kados     951: PDF::API2 mandatory in error
10:00 hdl       should maybe add a choice in installer whether they have PDF::API2
10:00 kados     is this discussing an upgrade from 2.2.1 to 2.2.2?
10:01 hdl       I may cope with it.
10:01 kados     cool ... hdl can you re-assign it to yourself?
10:02 kados     950: Issue limit set to zero
10:02 kados     owen reported this one
10:03 paul      not really critical, even if i accept it
10:03 paul      reassigning it to me & lowering to normal
10:03 kados     cool ... thanks
10:03 kados     949: error when adding an acquisition wihtout budget
10:04 paul      in fact, we should not order books without budgets...
10:04 paul      (& koha don't care about having a <0 budget, so everybody can set up a budget)
10:05 paul      maybe we just need to warn the user if there is no budget set !
10:05 kados     sounds like a good solution
10:05 paul      ok, changing bugzilla
10:05 kados     944: We need to be able to delete a subscription.
10:06 kados     fixed and then reopened?
10:07 paul      mmm... I should query Nathalie once agaion
10:07 paul      seems she want to delete a subscription when she should not.
10:08 kados     ok ... so it's operator error ;-)
10:08 paul      probably. I answer in bugzilla now.
10:08 kados     943: pb accentuations LDAP <=> KOHA
10:09 paul      (on phone)
10:14 paul      ok, back
10:14 Genji     whats the module name and path on the server for koha cvs and koha head?
10:14 paul      (it's a EMN specific problem, closing it)
10:15 kados     Genji: cvs -z3 -d:ext:you@sourceforge.net:/cvsroot/koha co koha
10:15 kados     Genji: (that's HEAD)
10:15 paul      (accepting it, but it's a local problem anyway)
10:15 Genji     and whats cvs.... 2.2.2?
10:15 kados     Genji: cvs -z3 -d:ext:you@sourceforge.net:/cvsroot/koha -r rel_2_2 co koha
10:15 kados     Genji: that's 2.2
10:15 paul      942 is the same.
10:15 paul      (EMN local problem)
10:15 kados     paul: cool ...
10:16 kados     how is everyone on time
10:16 paul      at least 1 hour available
10:16 paul      (5PM here)
10:16 kados     we've been working on bugs for 1:15 ... another 15 minutes ok?
10:17 hdl       ok.
10:17 kados     938: If you delete notice without item it deletes notice linked i
10:18 paul      lowering to minor & accepting it
10:18 kados     ok ...
10:18 kados     936: Accounts system produces untranslatable data
10:19 kados     owen reported this one
10:19 paul      I agree.
10:19 paul      what would be nice would be to have all of those strings
10:19 paul      there are some in borrowers flags iirc
10:19 paul      (adding this to #936)
10:19 kados     cool
10:21 kados     so will you re-assign the bug?
10:21 paul      not sure it's for me ;-)
10:21 kados     ok ... do you have an idea who wrote this originally?
10:21 paul      (even if frenchies are the most borred by this)
10:21 kados     :-)
10:21 paul      (katipo)
10:21 kados     ok ... so I"ll bug chris about it
10:21 paul      (chris is already the owner)
10:22 kados     right ... but he's the default owner of many bugs ;-)
10:22 kados     933: Cancel process results in untemplated dialogue
10:22 paul      (yes, i think I should be often)
10:22 Genji     how do i determine if what i got is the right branch?
10:23 Genji     whats a file that screams rel_2_2?
10:23 paul      (same as 936 imho)
10:23 kados     Genji: you should have two diffferent directories
10:23 kados     on to store HEAD koha
10:23 paul      genji : winCVS should report file version
10:23 kados     and one to store 2.2 koha
10:23 paul      in HEAD, they are X.Y
10:23 paul      in rel_2_2, they are X.Y.Z.T
10:23 kados     better answer ;-)
10:24 kados     paul: ok ... so you'll join 936 and 933 ?
10:24 paul      I think they are at least highly related
10:24 kados     932: default theme is used for 'nohelp.tmpl' even if other templa
10:24 kados     this is a problem I can also verify
10:25 paul      ok, i'll take care of it.
10:25 kados     paul: which 936=933? or 932?
10:25 paul      mmm... i spoke of 932
10:25 kados     cool
10:25 paul      but it seems the problem is that the nohelp is not defined in npl
10:25 paul      let me a seconde
10:25 kados     ok
10:26 kados     Genji: cool ... so make your additions and you should be able to commit them
10:27 paul      mmm... strange... i'll investigate a little if you confirm it's still here kados
10:28 paul      seems it's still here.
10:28 kados     paul: I think it's still here
10:28 kados     926: Many form tags lack method and/or action attributes
10:29 paul      ok, 933 is fixed
10:29 kados     great!
10:30 paul      (a stupid my to redefine a variable already existing)
10:30 kados     paul: fixed in both HEAD and 2.2?
10:30 paul      (nope, but i'll do a synch after releasing 2.2.3)
10:30 kados     great
10:31 paul      I agree with 926, but it's a long term goal
10:31 paul      that should be in 2.4
10:31 kados     can you explain it a bit more to me?
10:31 paul      (and imho, the 2.4 will be called 3.0 ;-) )
10:32 kados     :-)
10:32 paul      in w3c requirements, all <form> should have some parameters explicitly defined
10:32 kados     owen: you reported 926 ... any input?
10:32 kados     right ...
10:32 paul      in 1st versions of html, they were not mandatory, now they are
10:32 paul      so, we should investigate the code & improve HTML
10:33 kados     ok ... so I'm going to assign that to our interface designer: owen ;-)
10:33 paul      another problem : i often use <div id="bloc20"> & there should be only 1 id="bloc20")
10:33 Genji     biblio.pm has version number of 1.115.2.13 in current rel_2_2?
10:33 owen      Yeah... I found it confusing that forms didn't have the action specified.  So the form would be <form> rather than <form action="/cgi-bin/koha/circulation.pl"> for example
10:33 paul      yest Genji
10:33 Genji     then i have it.
10:34 owen      So the main question is, are those empty <form> tags assumed to be sumitting to themselves?
10:34 kados     paul: right ... one id per page ... that is a prob ... can you add that as a note?
10:34 kados     paul: or as another bug report?
10:34 paul      i think it's already somewhere else iirc
10:34 paul      (in another bug)
10:35 kados     ok
10:35 paul      #925 ?
10:35 owen      The issue with ID's is really only a validation issue, rather than a functionality issue
10:35 kados     paul: do you know the answer to owen's question?
10:35 kados     do empty <form>s submit to themselves?
10:36 paul      sorry : yes owen, <form> submits to the same url as where they come from
10:36 kados     cool
10:36 kados     925: Currency search doesn't appear to do anything
10:36 paul      (& method is not post iirc)
10:36 kados     owen: ok will me assigning you to 926?
10:36 owen      Yes
10:36 owen      Yeah, default method is GET.
10:36 paul      (thanks i missed the word ;-) )
10:37 owen      It doesn't seem like the scripts ever distinguish between GET and POST though
10:37 paul      right owen. & that's really something nice, imho
10:38 paul      (although i know some ppl may find this a security issue)
10:38 kados     GET is a security issue ;-)
10:38 owen      Yes.  But it does make for easier coding
10:38 kados     right ... and it keeps the API googleable ;-)
10:38 kados     ok ... so ...
10:38 kados     925: Currency search doesn't appear to do anything
10:38 owen      Yeah, even the delete links ;)
10:38 kados     hehe yep ;-)
10:39 kados     Koha's security is really up to the sys admin
10:40 kados     owen reported 925 as well
10:40 kados     not a very important bug ... but an interesting question ... is
10:40 paul      about 925, not really "normal".
10:40 kados     right
10:40 kados     paul: do you use currency.pl?
10:40 kados     paul: (is it used ever?)
10:40 paul      yes of course !
10:40 kados     paul: (I mean the search box in currency.pl ;-))
10:40 paul      because you need at least 1 currency
10:41 paul      no, because you don't usually have more than 2 or 3 ;-)
10:41 kados     right ... I misspoke ;-)
10:41 paul      (and in France, since euro, we usually have only 1)
10:41 paul      (sometimes english pound or swiss franc)
10:41 paul      (nice to see that the last country using "franc" is not "france" ;-) )
10:41 kados     ok ... so we should ask katipo about this feature? (since I assumed they did it?)
10:42 paul      ok, remove the filter & close the bug is the best solution imho
10:42 paul      no need imho, because even in NZ you don't need a filter
10:42 kados     ok ... but katipo might object
10:42 owen      It's hard to imagine one would have so many currencies you'd need to search for one.
10:42 kados     (if they find it useful for something)
10:42 paul      ok, so add a note to the bug & assign it to katipo
10:43 paul      in fact, i wrote all admin screens a long time ago
10:43 kados     924 is assigned to MJ so we'll skip it
10:43 kados     923: printer config in barcode generator gives error
10:44 kados     (almost done with 900s ;-))
10:44 Genji      a"lso cancel reserve on biblio related to this item" why would this happen?
10:44 paul      sounds we should add a link to the correct API2 package
10:44 paul      because I bet that he has not installed the correct cpan package
10:44 paul      (so many packages with PDF::API2)
10:44 kados     right
10:45 paul      could you take care of it ?
10:45 kados     yep
10:45 paul      (& another question : any mail from emiliano ?)
10:45 Genji     hell?
10:45 Genji     o
10:45 kados     paul: no...I'll bug him again today (4th time)
10:46 paul      (maybe in holiday...)
10:46 kados     919: problems with subfield $0 of unimarc authorities structure
10:46 Genji     "also cancel reserve on biblio related to this item" why would this happen? isn't this a bad idea?
10:47 kados     Genji: is this about 969?
10:47 Genji     ya.
10:47 kados     just a sec
10:47 paul      919 : should be easy to solve testing it the field is ==0 or empty.
10:47 kados     paul: can you do that now?
10:47 kados     ok ...
10:48 kados     Genji: I'm not sure what you're asking
10:48 kados     917: plugins for coded fields in unimarc authorities
10:48 kados     (let's finish 900s today)
10:49 kados     hey slef ...
10:49 slef      hello
10:49 paul      hi slef.
10:49 paul      nothing to add to 917. except it's more an enh than a bug.
10:49 kados     paul: ok ... I'll change it then
10:50 kados     915: opac-MARCdetail.pl incorrectly shows request status
10:50 kados     Genji: where is that comment?
10:50 paul      owen, is 915 fixed according to you ?
10:51 kados     in the meantime
10:51 kados     914: Submit button doesnt work, in parameters changes
10:52 Genji     around line 858.
10:52 Genji     in circ2.pm
10:52 kados     ok
10:52 paul      no idea. Correct assignment for chris ;-)
10:53 kados     right ... ok I'll bug him about it then
10:54 kados     Genji: so you fixed that problem too?
10:54 slef      952: it is a bug. Should check whether the table is populated and use update instead of insert.
10:54 kados     911: Intranet with safari (macintosh browser)
10:55 Genji     yup. im thinking.... so what if i canceled a reserve on one item in a biblio. the original borrower may have reserved an alternative copy, i could wait and give them that one instead.
10:57 kados     slef: about 952: can you fix it?
10:57 kados     slef: (i.e., can I assign it to you? ;-))
10:58 kados     Genji: sounds good ... but I didn't think reserves worked on an item basis
10:58 kados     Genji: I thought they worked on the level of the biblio
10:59 kados     paul and owen: so what would we need to do to fix 915 and who can do it?
11:00 kados     911: Intranet with safari (macintosh browser)
11:00 slef      kados: ok, I'll try. updatedatabase seems undocumented, though.
11:00 kados     (I'm assigning it to owen )
11:00 kados     slef: great ... thanks! (maybe you can document it along the way ;-))
11:01 owen      Don't assign 915 to me--I don't know how to fix it!
11:01 kados     owen: hehe
11:01 slef      "The named query 2.2 and HEAD: all bugs except enhancement requests seems to no longer exist."
11:01 paul      about 915 : owen, did intranet detail.pl work fine ?
11:01 Genji     committed. YAY!
11:01 kados     slef: strange
11:01 slef      what happened? I can't bring the bug list up
11:01 owen      Yeah, I had the same problem kados
11:02 kados     slef: not sure ... could be deleted by a googlebot or something ... not really sure
11:02 slef      911: how is it unusuable?
11:02 owen      paul: it looks like MARCdetail.pl in the intranet has the same problem.
11:03 owen      The reserves button is hidden correctly in detail.pl, but not in MARCdetail.pl
11:03 owen      ..or ISBDdetail.pl
11:04 slef      911: does anyone here use safari or konqueror enough to add info to this bug report?
11:04 kados     I do
11:04 kados     but I haven't had trouble with NPL templates and safari
11:04 kados     and I've not used default templates much
11:04 kados     I can investigate it further
11:05 slef      Cool. Will you assign it to you for now?
11:05 kados     sure
11:05 paul      ok, nothing to add.
11:05 kados     910: repeating a field (+), bring you back to the first page of m
11:05 paul      maybe we can put it on a long term (with GUI rewritting)
11:06 paul      (as librarian interface can be mozilla-ionly)
11:06 paul      (that's not the case for oPAC, of course)
11:06 kados     right ... well the ID group will need to decide that
11:06 paul      910 ; the additionnal comment is fixed.
11:06 paul      (noting it to bugzilla)
11:06 kados     if we want to go the same route that Evergreen has with circ
11:07 kados     900: Unimarc Authorities
11:07 kados     last bug in the 900s ;-)
11:07 slef      910: is it really OK for librarian interface to be mozilla-only?
11:08 owen      I think it's okay for the librarian interface to require a standards-compliant browser
11:08 paul      it's the case for now. so in real life, it should be ok ;-)
11:08 owen      But safari should fall under that classification
11:08 kados     it might also be useful if we want to use a firefox plugin to avoid all the overhead
11:08 kados     the html overhead that is
11:08 paul      you mean XUL writing ?
11:08 kados     Evergreen has gone that route and it's quite impressive
11:08 kados     yep
11:08 paul      (although knowing nothing about XUL...)
11:09 kados     yes ... it would really speed up the intranet
11:09 slef      900: is this an enhancement request?
11:10 paul      yes slef.
11:10 kados     cool ... I'll change the status then
11:10 kados     ok ... we got through the 900s
11:11 kados     thanks everyone!
11:11 Genji     kados: what library do you work with?
11:11 paul      i'll spend some time this week & maybe next week too, to fix some bugs.
11:11 kados     Genji: I'm the sys admin of NPL
11:12 kados     Genji: and the president, technology for LibLime
11:12 kados     let's try to have another meeting in about a week ... we'll get status reports on the 900s and begin working on the 800s
11:13 Genji     kados: cool. well.. ill get my sidebar committed sometime tomorrow. you can put it into NPL so me and rach can test it on real data?
11:13 paul      ok for me, any day, same hour.
11:13 kados     Genji: yep ...
11:13 kados     Genji: I'll put it into LibLime's demos
11:13 kados     paul: cool ... thanks!
11:14 hdl       ok also for me. Next time, i wil have a look at bugs before the meeting. ;)
11:14 kados     hdl: :-)
11:14 Genji     kados LibLime's demo data is real data?
11:16 kados     Genji: yes ;-) opac.liblime.com
11:16 Genji     Anyway. Im off for sleep. back at 9am. its 4am now.
11:16 kados     Genji: it's a reduced set of data from NPL
11:16 Genji     you'll be here then, kados?
11:16 kados     Genji: cool ... have a good nap ;-)
11:16 kados     yep
11:16 Genji     cool.
11:16 kados     cya
11:19 owen      Well, that seemed very productive.
11:19 slef      mmm, sorry for not arriving sooner
11:20 kados     np ... if you'd like to get started on the 800s be my guest ;-)
11:20 kados     indradg didn't show up ... I don't have an email address for him
11:20 kados     slef: do you?
11:23 slef      indradg: I should have, shouldn't I?
11:28 slef      apparently not
11:30 kados     slef: owen had it ... thanks for looking
11:30 slef      924: has anyone actually seen that bug? I couldn't reproduce it.
11:31 kados     I've never had trouble running updatedatabase
11:31 kados     and I've never use the updater ... always do it manually
11:33 slef      tag worksforme, do you think?
11:33 slef      (report in feb, never answered question)
11:33 kados     right
11:33 kados     sounds good
11:34 slef      done