Time  Nick   Message
10:39 osmoze :)
10:39 osmoze and a very happy new year
10:39 paul   hello tout seul
10:39 osmoze hello all
07:39 Genji  hmm.. same solution necessary for subjects too.
07:38 paul   yep
07:37 Genji  so.. i have to do without, returning biblionumbers as well then do one query for additionalauthors per biblionumber returned.. eh?
07:34 paul   you can't with left join
07:31 Genji  how do you combine all of the additionalauthors into one line per item rather than the biblio being repeated for every additionalauthor?
07:13 paul   ;-)
07:10 Genji  hmmm.... btw.. im back. Yup! got motivation again. Hope it lasts when i get home.
07:09 Genji  ahh.. cool! yup! get it!
07:08 paul   http://dev.mysql.com/doc/refman/4.1/en/select.html
07:08 paul   http://dev.mysql.com/doc/refman/4.1/en/left-join-optimization.html
07:07 Genji  ..... i remember i had a problem like this a long time ago.
07:06 Genji  ?
07:06 Genji  ... on replaces where/
07:06 Genji  and what does left join ... on mean?
07:06 Genji  left join does what?
07:04 paul   add explain before your SQL query to see how mysql build it !
07:04 paul   the 2nd one may be an index missing one.
07:04 paul   should solve your 1st problem
07:03 paul   select * from biblio left join additionnalauthors on ...
07:03 paul   do you know left join ?
07:03 paul   (was on phone, back)
07:03 Genji  no one awake to answer?
06:57 Genji  so.... how do i get the required fields, in an acceptable time?
06:56 Genji  so the usual = does not work.... ? also.. having a where clause with more than two joins really starts to slow things down...
06:55 Genji  and not all biblios have subtitles...
06:55 Genji  And now.. im stuck with .. how am i going to do this codewise, when not all biblios have additionalauthors?
06:54 Genji  good. hmm. okay. ive got a gui coded up for displaying all the fields in biblio, biblioitems, items, bibliosubtitles, additionalauthors.... designed so the user ticks what they want to appear in a excel export.
06:53 paul   hiya too
06:53 Genji  hiya!
06:53 _hdl_  hi Genji
06:52 paul   zzzzzzzzzz.............
06:52 paul   zzzzzzzzzzzzz.............
06:51 paul   zzzzz..........
06:51 Genji  hello all. any coders about?
22:09 Dan    Chris, hi, happy new year :)
18:51 rach   yep
18:41 kados  rach around?
18:15 owen   I had trouble waking up this morning too
18:01 kados  any katipos awake?
14:30 |hdl|  a branchcode field has been added in version  2.2.4
14:21 |hdl|  owen : seems a bug due to injection of Branches  in budget.
13:25 owen   line 167 and line 69
13:24 paul   which line ?
13:22 owen   DBD::mysql::st execute failed: Unknown column 'branchcode' in 'field list' at /home/oleonard/koha/intranet/cgi-bin/admin/aqbookfund.pl
13:20 owen   Hi.  Could be either one, but I'm leaning towards bug :)
13:20 paul   'morning owen
13:20 paul   ;-)
13:19 paul   too early in the morning or a bug ?