Time  Nick     Message
10:59 Genji    eh, bad mistake doing select * from marc_word. Very bad mistake.
10:59 paul     so, marc_word must be filled too.
10:58 Genji    MARCmodbiblio updates subject from old db.
10:57 paul     what did you use to fill marc_subfield_table ?
10:57 paul     are you sure m1.word is filled ?
10:56 paul     should work...
10:56 paul     no
10:56 Genji    ?
10:56 Genji    any ideas/
10:52 Genji    Q : select distinct m1.bibid from biblio,biblioitems,marc_biblio,marc_word as m1 where biblio.biblionumber=marc_biblio.biblionumber and biblio.biblionumber=biblioitems.biblionumber and m1.bibid=marc_biblio.bibid and (m1.word  like 'Magic' and m1.tagsubfield in ('650a')) order by biblio.title at c:/usr/koha200pre2/modules/C4/SearchMarc.pm line 269., referer: http://222-152-212-196.jetstream.xtra.co.nz/cgi-bin/koha/search.marc/search.pl?typ
10:51 paul     Q : select * from ...
10:51 paul     the query is shown in the log
10:51 paul     could you copy here the log ?
10:49 Genji    so, why didn't the search work?
10:49 paul     yep
10:49 Genji    3 says that subjects are entered into marc table, right?
10:47 Genji     and /cgi-bin/koha/MARCdetail.pl?bib=3124 once logged in.
10:47 Genji    http://222-152-212-196.jetstream.xtra.co.nz
10:46 paul     yep
10:46 Genji    okay. paul, you active?
10:43 Genji    okay, marc subjects now working, but still not searching.
10:30 Genji    okay, code done, now testing it on my installation.
10:19 Genji    Understood.
10:19 paul     (& the reverse sub is also available iirc)
10:19 paul     you have find_bibid_from_old_biblionumber to find one from the other
10:19 paul     but $bibid is NOT $bibilionumber
10:19 paul     I agree it's stupid.
10:18 paul     and the bibid that is in marc_* tables
10:18 paul     the biblionumber that is in biblio & biblioitems & items tables
10:18 paul     there are 2 differents "biblionumbers"
10:18 paul     no
10:17 Genji    $bibid is biblionumber right?
10:13 Genji    connection died.
10:07 paul     ok, i wait impatiently for your patch then ;-)
10:06 paul     probably yes
10:04 Genji    '0'){do fix marc biblio table} right?
10:04 Genji    right. Therefore, if(C4::Context->systempreference(MARC) eq
10:03 paul     that's why 3 libraries here in france (customers) uses Koha 2.2.0 without problems
10:03 paul     yep
10:02 Genji    right... hmmm... right. so our problem of bibliosubjects not updating marc, only happens when marc=off, due to the alterations in the MARC editor being capable of saving subjects properly in MARC and bibliosubjects, right?
10:00 paul     (i mean the bibliosubjects table)
10:00 paul     because subjects must be populated also when MARC=ON !
10:00 paul     should not.
10:00 Genji    And modsubject is only used in a MARC=OFF enviroment right?
09:57 paul     HTH
09:57 paul     when MARC=OFF, the only framework that should exist is '' ;-)
09:57 paul     there is a possibility to define more than 1 framework, to enter monographies, serials, old books... with differents fields
09:57 paul     hi, when MARC=ON
09:56 Genji    hi.
09:56 Genji    ah.
09:56 paul     i'm here
09:56 paul     genji
09:56 Genji    okay paul, im going to assume that the $frameworkcode parameter isn't needed.
09:08 Genji    eh, paul, wake up, whats $frameworkcode?
08:48 Genji    ah, paul, i note there is no one koha2marc routine but a whole group of them. I have to only use koha2marcBiblio, correct?
06:50 paul     contains all the tools you could find useful to have unix under windows
06:49 paul     d
06:49 paul     http://www.cygwin.com/ is your frien
06:49 paul     i'll diff & patch myself
06:49 paul     otherwise, send me your files, with a .genji extension
06:48 paul     gnu diff
06:48 Genji    what diff program should i use? im using windows.
06:48 paul     i have no MARC=OFF DB, so I can't test my fixes correctly
06:47 paul     okay
06:45 paul     you want me to do it immediatly ?
06:45 paul     not yet
06:45 Genji    hmm, you committed the newbiblioitem fix?
06:43 paul     yes, with a "diff" (i'll do a "patch")
06:43 Genji    when i do the fix, i email you with the additions, rather than the full file, right?
06:42 paul     good evening/morning
06:42 Genji    hi
06:42 paul     yes ?
06:42 Genji    paul?>
06:33 Genji    l
06:29 Genji    hello paul. im back
05:44 paul     i may have deleted a little bit too generously ;-)
05:44 paul     to answer your question : i delete outdated translations and themes just before releasing (spanish, german, unido,...)
05:44 paul     kados, i wake up (had a good night)
02:36 kados    paulBed when you wake up :-) ... I noticed that the latest release of Koha didn't include the z3950 server ... also, I noticed that instead of having seperate index.htmls in koha/koha-html/opac-html and koha/koha-html/intranet-html dirs there is just one in koha-html dir ... was that by design?
02:06 jferraro quit
18:42 jo       si: are you about
16:30 tim      I need to mess things up faster :)
16:29 tim      Trying to set up a better server for it.
16:28 owen     how's everything in the Koha world for you tim?
16:28 tim      hi owen
16:28 owen     hi rach, hi tim