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

[Henri-Damien LAURENT]

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