[Koha] Koha 2.2.7 in Mysql 5

[Henri-Damien LAURENT]

arnab a écrit :
> Dear All,
>
> I'm trying to run Koha 2.2.7 using MySql 5.0. I could issue/return books.
> But the problem is regarding searching of books. 
> Error is due to a SQL Script in the file SearchMarc.pm
>
> Extract of the code....
> my $sth;
> if ($sql_where2) {
> $sth = $dbh->prepare("select distinct m1.bibid from
> biblio,biblioitems,marc_biblio,$sql_tables where
> biblio.biblionumber=marc_biblio.biblionumber and
> biblio.biblionumber=biblioitems.biblionumber and m1.bibid=marc_biblio.bibid
> and $sql_where2 and ($sql_where1) order by $orderby $desc_or_asc");
>   
change for
FROM $sql_tables, (biblio JOIN biblioitems USING (biblionumber) ) JOIN
marc_biblio USING (biblionumber)
WHERE m1.bibid=marc_biblio.bibid

may work better.

This is owed to the fact that implicit join are not managed the same in
mysql5.0

HTH
-- 
Henri-Damien LAURENT