[Koha] koha or mysql 5 bug? fixed;)
Wojciech Zatorski
listy-in at zatorski.net
Wed Feb 8 05:05:26 NZDT 2006
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;)
--
<wojciech at zatorski.net>
tel. +48 509-855-239; GG: 1500861; Skype: zatorski
http://www.Zatorski.Net
--
"Genius always gives its best at first, prudence at last." --
Lavater, J.C.
More information about the Koha
mailing list