Re: [Koha] koha or mysql 5 bug? fixed;)

7 Feb 2006


      Wojciech Zatorski a écrit :
...
bad:
$query="select *,biblio.author,biblio.biblionumber from
                                                        biblio
                                                        left join additionalauthors
                                                        on additionalauthors.biblionumber =biblio.biblionumber
                                                        where
                                                        ((biblio.author like ? or biblio.author like ? or
                                                        additionalauthors.author like ? or additionalauthors.author
                                                        like ?
                                                                )";
good:
$query="select *,biblio.author,biblio.biblionumber from
                                                        biblio
                                                        left join additionalauthors
                                                        on (additionalauthors.biblionumber =biblio.biblionumber)
                                                        where
                                                        ((biblio.author like ? or biblio.author like ? or
                                                        additionalauthors.author like ? or additionalauthors.author
                                                        like ?
                                                                )";
and now mysql 5 supported;)
would have been more helpful if you had given page to bugfix. :)
Thx.
Friendly.
-- 
Henri-Damien LAURENT